|
Joined: Jun 2006
Posts: 693
Addict
|
Addict
Joined: Jun 2006
Posts: 693 |
I'm running the built in backup routine right now in preparation for going from 7.2.2 to 7.3. It's on row 183,500 and counting. By its name, I'm worrying that it's spending all this time backing up data that was temporary for some past import. Is this a table that's actually used for content? Maybe I'm just thrown off by the name. Looking forward in my SQL administration tool, I see the posts table has 405,870 rows and the referer_log table has 1,073,712 rows. So it is going to take hours to back those up. I understand the posts table is necessary However, what is the referer_log table? Do I need all 1 million + rows?
|
|
|
|
Joined: Jun 2006
Posts: 693
Addict
|
Addict
Joined: Jun 2006
Posts: 693 |
I gave up on the internal backup and am running a straight SQL backup instead, it's far faster, so this will save me a few hours. Hopefully I'm not going to lose certain functionality by doing this? Is the web based one just for people who can't do SQL backups?
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Yes, the web based one is just put in for convenience if there is no other option to do a backup.
|
|
|
|
Joined: Jun 2006
Posts: 693
Addict
|
Addict
Joined: Jun 2006
Posts: 693 |
OK I finished the backup in about 2 minutes rather than 8+ hours by going with the SQL backup, so if other people have access to SQL backup I *highly* recommend going that route!!
That being said, that import maps and referer log table are both huge and if I don't need that data, I'd love to prune the rows out to keep MySQL running quickly. Are those things I need to keep long term?
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
import map is obsolete, if you are running solely on your new 7.3 install..
so you can even DROP the table..
as for referrer table, just TRUNCATE it and all the records will be gonzo *poof*
|
|
|
|
Joined: Jun 2006
Posts: 693
Addict
|
Addict
Joined: Jun 2006
Posts: 693 |
Ok I'll drop import map. For referrer table, what is it for? A million rows seems like a lot Should I back it up for some sort of historical reason before I truncate it? I suppose I just did of course
|
|
|
|
Joined: Jun 2006
Posts: 693
Addict
|
Addict
Joined: Jun 2006
Posts: 693 |
OK I see, it seems to just be a list of where the hits came in to the forum from. I've truncated it! Thanks
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
yeppers -- referrer is just a kinda way for you to check where your incoming connections are.. although it also logs internal links too, when users mouse around the forums .. i use awstats instead and ignore the referrer table totally..
|
|
|
|
Joined: Jun 2006
Posts: 693
Addict
|
Addict
Joined: Jun 2006
Posts: 693 |
OK unfortunately I am now seeing SQL log errors of:
Script: E:\forums\scripts\showflat.inc.php - Line: 194 select POST_ID from ubbt7_IMPORT_MAP where OLD_POST_ID = 22890131 and SITE_ID = 1 - Table 'ubbt7.ubbt7_import_map' doesn't exist
What was it using that table for?
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
it handled redirects from your old site.. there has to be a site_id=1 in the URL for that to even be needed..
by 'old' i mean pre 7.x ..
do you have old urls laying around that still use that format?
|
|
|
|
Joined: Jun 2006
Posts: 693
Addict
|
Addict
Joined: Jun 2006
Posts: 693 |
What would the old URL format look like? I could go digging through my websites to see ... I imagine since we've been around since 1999 that people around the web have been linking to us all that time, so there could easily be external links in ancient formats. What happens to those old links now?
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
the old format was whatever it was for pre 6.5.. i can't remember what it was.. but i believe showflat, showthreaded and postlist.php are in your root dir to handle those incoming 'old style' links..
soo -- you either restore you import map, so those external links from other sites don't die
or contact those site(s) and give them the new link..
basically, someone must have a link to your pre 6.5x (i believe) posts/topics.. and they are linking to what that post or topic was.. the import map takes those links, translates them to your new installation and shows the topic..
|
|
|
|
Joined: Jun 2006
Posts: 693
Addict
|
Addict
Joined: Jun 2006
Posts: 693 |
OK looking on Google it looks like that format was used as recently as 2006. However, I don't feel like maintaining large tables long term in the future to make the links work exactly. There's no way I could track down and get all the sites out there to change their links.
What would code be to put into postlist.php - if that is just a redirect page - to have it simply go to the main new forum? Is that the only page I'd need to change?
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
i believe you'll find 3 files in your root to handle that redirect.. (if you saved them).. by 'root' i man you forum root, where ubbthreads.php and index.php are.. those 3 files would need to be modified to do something like:
<?php
header('Location: http://yourforums.com/path/to/forums/');
?>
then any incoming link in the old style, will redirect to the root of your NEW forums..
|
|
|
|
Joined: Jun 2006
Posts: 693
Addict
|
Addict
Joined: Jun 2006
Posts: 693 |
OK I did that to postlist.php, showflat.php and showthreaded.php. Hopefully that will end the errors going forward. I don't see a need to keep 2+ year old links going to an exact location - people really should update their links, if they care, to the new format. I'm trying to get the new forum as optimized as possible, it's slow enough as it is with the volume Thanks!
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
cool.. i tested out showflat.php and it redirects like it should! great stuff.. btw, i LOVE how you took the categories and added links to the forums on the line underneath!! i think i'll use that idea on some of my forums and make a mod to auto generate those links! excellent work. 430 forums???!!! a new world record, from any forum i've seen :hihi:
|
|
|
|
Joined: Jun 2006
Posts: 693
Addict
|
Addict
Joined: Jun 2006
Posts: 693 |
I'm not sure what you mean - do you mean my main "news post" that we keep on our site homepage? http://forums.bellaonline.com/ubbthreads.phpyes that is very handy for people to scan. The channel list on the left also links directly to a given section of the forum and is another easy way for people to get somewhere. What we used to have up until now is when you would go to the "forum list" page it would ONLY show the channel level summaries - I.e. the Auto Auto Polishing and Detailing | Cars | Motorcycles | RV with those being linked, but without the forum-by-forum breakdown beneath that line. However, I used to do that customization change in templates/default/cfrm.tpl However, cfrm.tpl no longer has that code in it for me to change. So I have to dig through all the files and track down where I'd make that change. Can anybody point me in the right direction? The point is that that postlist page is HUGE right now and really hard to navigate. It's much easier if it's just a list of channels and the forums within each channel. What I would add in is this code, right after the first if - {if $catrow[2].CatId == 7} {section name="cats" loop=$catrow} {$tbopen} <thead> <tr> <td align="left" valign="top" class="category" colspan="5" > <a href="{$config.BASE_URL}/ubbthreads.php?ubb=cfrm&c={$catrow[cats].CatId}">{$catrow[cats].CatTitle}</a> {if $catrow[cats].CatDesc} <br /> <span class="small"> {$catrow[cats].CatDesc}</span> {/if} </td> </tr> </thead> {$tbclose} {/section} {/if} and a few other matching end ifs and such to round it out.
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
i meant Auto Auto Polishing and Detailing | Cars | Motorcycles | RV that idea.. i was going to make those links autogenerated so you wouldn't need any if's.. the forum.tpl would just do something like (just adds 1 line).. {if $type == "cfrm"}
<thead>
<tr>
<th align="left" valign="top" class="category" colspan="5">
<img style="float: right;" id="toggle_cat{$catrow[cats].CATEGORY_ID}" onclick="showHideBlock('cat{$catrow[cats].CATEGORY_ID}');return false;" alt="" src="{$config.BASE_URL}/images/{$style_array.general}/{$catrow[cats].image}" />
<a href="{ubb url="ubb=cfrm&c=`$catrow[cats].CATEGORY_ID`" title=$catrow[cats].CATEGORY_TITLE}">{$catrow[cats].CATEGORY_TITLE}</a>
{if $catrow[cats].CATEGORY_DESCRIPTION}
<div class="small" style="padding-left: 15px;">{$catrow[cats].CATEGORY_DESCRIPTION}</div>
<div class="cats_forum">{$catforums}</div}
{/if}
</th>
</tr>
</thead>
{/if}
and then cfrm.inc.php would generate $catforums markup on the fly, based upon category.. that way, whenever you make changes to your forums (add delete move).. they follow you around..
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
Myself I'm still running my import map, I still get incoming hits from my UBB.C install directories on several sites; though on ugn I've dropped it completely.
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
oh and to answer your other question -- just go to category only display for your cfrm.. i think that's what you are wanting? that's configurable in the cpanel 2nd thought , i tried category only mode and it needs some work to polish it up for my taste
|
|
|
|
Joined: Jun 2006
Posts: 693
Addict
|
Addict
Joined: Jun 2006
Posts: 693 |
Right I think category only changes it for the channel level views too (i.e. if I wanted to show all forums in the 'food and wine' channel). I like the way it looks when you go to "food and wine" and it shows the details of all forums in there. I only want it to collapse on the main listing page.
I'm looking at my SQL log and see a bunch of these -
Script: E:\forums\scripts\showflat.inc.php - Line: 194 select POST_ID from ubbt7_IMPORT_MAP where OLD_POST_ID = 810711 and SITE_ID = 1 - Table 'ubbt7.ubbt7_import_map' doesn't exist
=============
Ideas? Why is that script being called? It's being hit every 10 minutes or so.
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
Well, it looks like someone is coming to your site from your old ubb redirectors; I believe you said that you removed your import map table; which would be why it's throwing an error I think...
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
check your referrer logs for a url with "&site_id=1" in it.. that might give you more info.. to totally ignore any stray urls in /scripts/showflat.inc.php (the new one v7.3) just do this.. $import_number = "";
if ($site_id) {
header('Location: http://yourdomain.com/path/to/forum');
if ($Number && !$topic && !$Forum) {
$query_vars = array($Number,$site_id);
$query = "
....
(1 line added after the if) it basically bashes any strays that make it thru
|
|
|
|
Joined: Jun 2006
Posts: 693
Addict
|
Addict
Joined: Jun 2006
Posts: 693 |
Sirdude - Did you mean the UBB referer table? I just ran a search on it for anything with "site" in the string and really there was nothing related to site_id=1 at all.
Are you sure it would show up in there? For example when I look for "forums" in that same table I don't find any internal references, i.e. it's all external sites.
I'm still thinking this must be a link from within the UBB software, related to all the editors getting errors of "post not found" when they make a new post. But maybe they really are two separate problems.
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
well, if you truly don't care about old threads -- and are willing to just send old style URLs to your forum root, just do the above code change in your new showflat.inc.php
|
|
|
|
Joined: Jun 2006
Posts: 693
Addict
|
Addict
Joined: Jun 2006
Posts: 693 |
Yes, I did that change and it looks like from 15:22 onward I have not seen any new import_map errors. So my import_map situation (at least in terms of seeing log entries) is now resolved.
|
|
|
1 members (Ruben),
1,101
guests, and
206
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|