Previous Thread
Next Thread
Print Thread
Hop To
ubbt7_import_map backup
#211486 05/09/2008 12:46 AM
Joined: Jun 2006
Posts: 686
Addict
OP Offline
Addict
Joined: Jun 2006
Posts: 686
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 - 57,000 members / 800,000 posts
Re: ubbt7_import_map backup
BellaOnline #211487 05/09/2008 12:54 AM
Joined: Jun 2006
Posts: 686
Addict
OP Offline
Addict
Joined: Jun 2006
Posts: 686
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 - 57,000 members / 800,000 posts
Re: ubbt7_import_map backup
BellaOnline #211515 05/09/2008 11:02 AM
Joined: Jun 2006
Posts: 9,243
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
Yes, the web based one is just put in for convenience if there is no other option to do a backup.

Re: ubbt7_import_map backup
Rick #211540 05/09/2008 2:25 PM
Joined: Jun 2006
Posts: 686
Addict
OP Offline
Addict
Joined: Jun 2006
Posts: 686
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 - 57,000 members / 800,000 posts
Re: ubbt7_import_map backup
BellaOnline #211542 05/09/2008 2:27 PM
Joined: Apr 2007
Posts: 3,940
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,940
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*

Re: ubbt7_import_map backup
SD #211555 05/09/2008 2:52 PM
Joined: Jun 2006
Posts: 686
Addict
OP Offline
Addict
Joined: Jun 2006
Posts: 686
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 - 57,000 members / 800,000 posts
Re: ubbt7_import_map backup
BellaOnline #211556 05/09/2008 2:58 PM
Joined: Jun 2006
Posts: 686
Addict
OP Offline
Addict
Joined: Jun 2006
Posts: 686
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 - 57,000 members / 800,000 posts
Re: ubbt7_import_map backup
BellaOnline #211557 05/09/2008 3:00 PM
Joined: Apr 2007
Posts: 3,940
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,940
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..

Re: ubbt7_import_map backup
SD #211575 05/09/2008 3:45 PM
Joined: Jun 2006
Posts: 686
Addict
OP Offline
Addict
Joined: Jun 2006
Posts: 686
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 - 57,000 members / 800,000 posts
Re: ubbt7_import_map backup
BellaOnline #211576 05/09/2008 3:50 PM
Joined: Apr 2007
Posts: 3,940
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,940
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?


Re: ubbt7_import_map backup
SD #211578 05/09/2008 3:56 PM
Joined: Jun 2006
Posts: 686
Addict
OP Offline
Addict
Joined: Jun 2006
Posts: 686
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 - 57,000 members / 800,000 posts
Re: ubbt7_import_map backup
BellaOnline #211579 05/09/2008 4:02 PM
Joined: Apr 2007
Posts: 3,940
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,940
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..

Re: ubbt7_import_map backup
SD #211581 05/09/2008 4:14 PM
Joined: Jun 2006
Posts: 686
Addict
OP Offline
Addict
Joined: Jun 2006
Posts: 686
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 - 57,000 members / 800,000 posts
Re: ubbt7_import_map backup
BellaOnline #211583 05/09/2008 4:21 PM
Joined: Apr 2007
Posts: 3,940
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,940
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..

Re: ubbt7_import_map backup
SD #211584 05/09/2008 4:28 PM
Joined: Jun 2006
Posts: 686
Addict
OP Offline
Addict
Joined: Jun 2006
Posts: 686
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 - 57,000 members / 800,000 posts
Re: ubbt7_import_map backup
BellaOnline #211585 05/09/2008 4:33 PM
Joined: Apr 2007
Posts: 3,940
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,940
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:

Re: ubbt7_import_map backup
SD #211586 05/09/2008 4:46 PM
Joined: Jun 2006
Posts: 686
Addict
OP Offline
Addict
Joined: Jun 2006
Posts: 686
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 - 57,000 members / 800,000 posts
Re: ubbt7_import_map backup
BellaOnline #211589 05/09/2008 4:52 PM
Joined: Apr 2007
Posts: 3,940
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,940
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


Re: ubbt7_import_map backup
SD #211594 05/09/2008 4:59 PM
Joined: Jun 2006
Posts: 15,956
Likes: 31
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,956
Likes: 31
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!
Re: ubbt7_import_map backup
SD #211595 05/09/2008 4:59 PM
Joined: Apr 2007
Posts: 3,940
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,940
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

Re: ubbt7_import_map backup
SD #211661 05/10/2008 2:22 AM
Joined: Jun 2006
Posts: 686
Addict
OP Offline
Addict
Joined: Jun 2006
Posts: 686
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 - 57,000 members / 800,000 posts
Re: ubbt7_import_map backup
BellaOnline #211665 05/10/2008 2:30 AM
Joined: Jun 2006
Posts: 15,956
Likes: 31
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,956
Likes: 31
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!
Re: ubbt7_import_map backup
Gizmo #211666 05/10/2008 2:34 AM
Joined: Apr 2007
Posts: 3,940
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,940
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

Re: ubbt7_import_map backup
SD #211707 05/10/2008 4:29 PM
Joined: Jun 2006
Posts: 686
Addict
OP Offline
Addict
Joined: Jun 2006
Posts: 686
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 - 57,000 members / 800,000 posts
Re: ubbt7_import_map backup
BellaOnline #211710 05/10/2008 4:40 PM
Joined: Apr 2007
Posts: 3,940
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,940
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

Re: ubbt7_import_map backup
SD #211714 05/10/2008 6:19 PM
Joined: Jun 2006
Posts: 686
Addict
OP Offline
Addict
Joined: Jun 2006
Posts: 686
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 - 57,000 members / 800,000 posts

Link Copied to Clipboard
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Disaster!!! Files became empty.. Please advise.
by Morgan - 07/27/2020 2:38 PM
Unable to Update Censor List
by BOTCuser - 07/22/2020 9:15 AM
7.7.4 error on rebuilders
by Ruben - 07/21/2020 3:06 PM
[STOCK] UBB.threads Group Image Pack
by isaac - 07/19/2020 9:03 PM
Who's Online Now
1 members (Ruben), 74 guests, and 93 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 7.7.5
(Snapshot build 20200807)