Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jun 2006
Posts: 685
Addict
OP Offline
Addict
Joined: Jun 2006
Posts: 685
In my log files I'm getting a bunch of these errors every day -

[ERROR][Fri, Oct 16 2009 19:21:06 -0400] [] [] Script: E:\forums\scripts\showflat.inc.php - Line: 194
select POST_ID
from ubbt7_IMPORT_MAP
where OLD_POST_ID = 22844187
and SITE_ID = 1
- Table 'ubbt7.ubbt7_import_map' doesn't exist

I know a while back you guys recommended I take out the import map table since it was so huge and no longer necessary. Is there a way to handle these errors now?


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 57,000 members / 800,000 posts
Joined: Jun 2006
Posts: 9,242
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,242
Quick fix would just be to comment out that block of code. It starts at line 149 of showflat.inc.php with this comment:

// This bit specifically handles redirects from old imports

It ends at line 198 with:

// ENd of import redirect code

Joined: Feb 2007
Posts: 1,287
Likes: 1
Veteran
Online Tapedshut
Veteran
Joined: Feb 2007
Posts: 1,287
Likes: 1
I had let the SQL there but deleted all the contents of the import map file aka entries.

Joined: Jun 2006
Posts: 685
Addict
OP Offline
Addict
Joined: Jun 2006
Posts: 685
I'm reviving this thread - as you can see way back before 2009 I deleted the import map table. It means every single time I have to update the forums I have to re-edit this code to take care of it.

What if I just re-created this table empty? Would that solve this problem? Or would an empty table still be an issue?


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 57,000 members / 800,000 posts
Joined: Jun 2006
Posts: 15,966
Likes: 38
UBB.threads Developer
Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 15,966
Likes: 38
You should never drop a database table; you should have simply erased its contents.


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: Jun 2006
Posts: 685
Addict
OP Offline
Addict
Joined: Jun 2006
Posts: 685
Jeez Louise smile. That's a bit scolding sounding. As I explained, I was told to drop that table:

Lisa Told to Drop the Table by SirDude and Rick

If Rick had thought it was a bad idea he would have spoken up, he was right there in the conversation smile.


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 57,000 members / 800,000 posts
Joined: Jun 2006
Posts: 685
Addict
OP Offline
Addict
Joined: Jun 2006
Posts: 685
Hey wait Gizmo isn't this you right in that thread saying:

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

when you say "dropped it completely" after SirDude told me to drop that table weren't you saying you also dropped it?


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 57,000 members / 800,000 posts
Joined: Jun 2006
Posts: 15,966
Likes: 38
UBB.threads Developer
Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 15,966
Likes: 38
Dropped the data from the table. As for the import map, 10 years later its worthless data that is taking up database space.

I see them advising dropping the table, however there are portions of the code that check that table; it should not be removed, it should be emptied.


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: Jun 2006
Posts: 685
Addict
OP Offline
Addict
Joined: Jun 2006
Posts: 685
I hear that you recommend an empty table. So does that mean I can look at the install script, see how the table should be defined, and create an empty one? And I will then be set?


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 57,000 members / 800,000 posts
Joined: Jun 2006
Posts: 15,966
Likes: 38
UBB.threads Developer
Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 15,966
Likes: 38
Well, yeah; the script assumes that the import_map table exists in several places in the showflat.inc.php script (and it needs to exist in its original form, as the cells need to have the correct names):
Code
CREATE TABLE IF NOT EXISTS `ubbt_IMPORT_MAP` (
  `SITE_ID` int(9) unsigned NOT NULL DEFAULT '1',
  `POST_ID` int(9) unsigned NOT NULL DEFAULT '0',
  `OLD_TOPIC_ID` int(9) unsigned NOT NULL DEFAULT '0',
  `OLD_POST_ID` int(9) unsigned NOT NULL DEFAULT '0',
  `OLD_FORUM_ID` int(9) unsigned NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER TABLE `ubbt_IMPORT_MAP`
  ADD KEY `site_ndx` (`SITE_ID`),
  ADD KEY `old_forum_ndx` (`OLD_FORUM_ID`),
  ADD KEY `old_topic_ndx` (`OLD_TOPIC_ID`),
  ADD KEY `old_post_ndx` (`OLD_POST_ID`);


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!

Link Copied to Clipboard
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
What triggers page view numbers
by Morgan - 09/21/2020 10:31 AM
Forum Permissions Question
by FREAK - 09/20/2020 2:13 PM
Moving UBBthreads Between Servers
by DennyP - 09/19/2020 7:55 PM
Member Log In/Password Issues
by FREAK - 09/19/2020 12:13 PM
[FIXED for 7.7.5] Broken CP Link
by JAISP - 09/17/2020 3:22 PM
Who's Online Now
1 members (1 invisible), 54 guests, and 36 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 20200921)