|
Joined: Jun 2006
Posts: 693
Addict
|
Addict
Joined: Jun 2006
Posts: 693 |
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?
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
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,294 Likes: 2
Veteran
|
Veteran
Joined: Feb 2007
Posts: 1,294 Likes: 2 |
I had let the SQL there but deleted all the contents of the import map file aka entries.
|
|
|
|
Joined: Jun 2006
Posts: 693
Addict
|
Addict
Joined: Jun 2006
Posts: 693 |
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?
|
|
|
|
Joined: Jun 2006
Posts: 16,292 Likes: 116
|
Joined: Jun 2006
Posts: 16,292 Likes: 116 |
You should never drop a database table; you should have simply erased its contents.
|
|
|
|
Joined: Jun 2006
Posts: 693
Addict
|
Addict
Joined: Jun 2006
Posts: 693 |
Jeez Louise . 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 RickIf Rick had thought it was a bad idea he would have spoken up, he was right there in the conversation .
|
|
|
|
Joined: Jun 2006
Posts: 693
Addict
|
Addict
Joined: Jun 2006
Posts: 693 |
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?
|
|
|
|
Joined: Jun 2006
Posts: 16,292 Likes: 116
|
Joined: Jun 2006
Posts: 16,292 Likes: 116 |
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.
|
|
|
|
Joined: Jun 2006
Posts: 693
Addict
|
Addict
Joined: Jun 2006
Posts: 693 |
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?
|
|
|
|
Joined: Jun 2006
Posts: 16,292 Likes: 116
|
Joined: Jun 2006
Posts: 16,292 Likes: 116 |
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): 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`);
|
|
|
0 members (),
396
guests, and
110
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|