Previous Thread
Next Thread
Print Thread
Hop To
#211486 05/09/2008 12:46 AM
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 wink However, what is the referer_log table? Do I need all 1 million + rows?


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 58,000 members / 850,000 posts
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?


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 58,000 members / 850,000 posts
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
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?


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 58,000 members / 850,000 posts
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
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 smile Should I back it up for some sort of historical reason before I truncate it?

I suppose I just did of course smile


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 58,000 members / 850,000 posts
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 smile


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 58,000 members / 850,000 posts
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
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 .. smile

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?


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 58,000 members / 850,000 posts
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
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?


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 58,000 members / 850,000 posts
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
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?


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 58,000 members / 850,000 posts
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
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 Code

<?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 smile

Thanks!


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 58,000 members / 850,000 posts
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
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.

laugh

430 forums???!!! eek

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.php

yes 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.


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 58,000 members / 850,000 posts
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
i meant

Quote
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)..

PHP Code
{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..

2c


Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
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.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
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 2c

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.


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 58,000 members / 850,000 posts
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
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...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
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.. smile

to totally ignore any stray urls in /scripts/showflat.inc.php (the new one v7.3)

just do this..

PHP Code
 // This bit specifically handles redirects from old imports
	$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) smile

it basically bashes any strays that make it thru laugh

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.


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 58,000 members / 850,000 posts
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
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 smile

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.


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 58,000 members / 850,000 posts

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Havenofsobriety), 522 guests, and 99 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)