Previous Thread
Next Thread
Print Thread
Hop To
Log error - import_map doesn't exist #230096 10/16/2009 11:26 PM
Joined: Jun 2006
Posts: 673
BellaOnline Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 673
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
Re: Log error - import_map doesn't exist [Re: BellaOnline] #230101 10/17/2009 10:53 AM
Joined: Jun 2006
Posts: 9,243
Rick Offline
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
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

Re: Log error - import_map doesn't exist [Re: Rick] #230103 10/17/2009 1:43 PM
Joined: Feb 2007
Posts: 1,276
JAISP Offline
Veteran
Offline
Veteran
Joined: Feb 2007
Posts: 1,276
I had let the SQL there but deleted all the contents of the import map file aka entries.

Re: Log error - import_map doesn't exist [Re: BellaOnline] #261494 05/27/2018 11:22 PM
Joined: Jun 2006
Posts: 673
BellaOnline Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 673
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
Re: Log error - import_map doesn't exist [Re: BellaOnline] #261496 05/27/2018 11:29 PM
Joined: Jun 2006
Posts: 15,852
Gizmo Online Tapedshut
UBB.threads Developer
Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 15,852
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.
Need to Upgrade?
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: Log error - import_map doesn't exist [Re: BellaOnline] #261497 05/28/2018 12:12 AM
Joined: Jun 2006
Posts: 673
BellaOnline Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 673
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
Re: Log error - import_map doesn't exist [Re: BellaOnline] #261498 05/28/2018 12:14 AM
Joined: Jun 2006
Posts: 673
BellaOnline Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 673
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
Re: Log error - import_map doesn't exist [Re: BellaOnline] #261499 05/28/2018 12:17 AM
Joined: Jun 2006
Posts: 15,852
Gizmo Online Tapedshut
UBB.threads Developer
Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 15,852
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.
Need to Upgrade?
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: Log error - import_map doesn't exist [Re: BellaOnline] #261500 05/28/2018 9:07 AM
Joined: Jun 2006
Posts: 673
BellaOnline Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 673
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
Re: Log error - import_map doesn't exist [Re: BellaOnline] #261502 05/28/2018 1:35 PM
Joined: Jun 2006
Posts: 15,852
Gizmo Online Tapedshut
UBB.threads Developer
Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 15,852
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.
Need to Upgrade?
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!

Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Mobile app?
by Baldeagle - 12/06/2019 9:32 PM
How do you change Text Line spacing?
by jorb - 11/23/2019 12:14 AM
What happened to FAQ or Forum Help
by Ruben - 11/20/2019 11:58 AM
Search feature encountering an Error message
by jorb - 11/20/2019 12:06 AM
Followed List v7.7.2 Question
by Ruben - 11/12/2019 12:22 PM
Who's Online Now
1 registered members (Gizmo), 57 guests, and 410 spiders.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Snapshot build 20191023)