XF 2.2 Errors since deleting DB Table 'hdrcgbwe_xf.import_log_vbulletin5_1'

hdrcweb

hdrcweb

Member
Hi
In my XF DB I had a huge table (66mb) called 'hdrcgbwe_xf.import_log_vbulletin5_1', I assume this was used when importing from vbulletin and was no longer needed, but since I deleted the table I am getting server errors logged in the XF admin panel., the forum seems fine:
The posts these errors point to seem fine.
Do I need this table or how can I stop these errors?
Thanks

Stack trace
SELECT new_id
FROM import_log_vbulletin5_1
WHERE content_type = ?
AND old_id = ?

------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL statement...', 1146, '42S02')
#1 src/XF/Db/Mysqli/Statement.php(41): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1146, '42S02')
#2 src/XF/Db/Mysqli/Statement.php(56): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(152): XF\Db\AbstractAdapter->query('
SELECT new_...', Array)
#5 src/addons/XF301VB/Repository/ImportLookup.php(49): XF\Db\AbstractAdapter->fetchOne('
SELECT new_...', Array)
#6 src/addons/XF301VB/Pub/Controller/Redirect.php(116): XF301VB\Repository\ImportLookup->lookupId('attachment', 0)
#7 src/addons/XF301VB/Pub/Controller/Redirect.php(74): XF301VB\Pub\Controller\Redirect->redirectContent(Object(XF\Mvc\ParameterBag), 'attachment', 'XF:Attachment', 'attachments')
#8 src/XF/Mvc/Dispatcher.php(352): XF301VB\Pub\Controller\Redirect->actionAttachment(Object(XF\Mvc\ParameterBag))
#9 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF301VB:Redirec...', 'Attachment', Object(XF\Mvc\RouteMatch), Object(XF301VB\Pub\Controller\Redirect), NULL)
#10 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF301VB\Pub\Controller\Redirect), NULL)
#11 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#12 src/XF/App.php(2485): XF\Mvc\Dispatcher->run()
#13 src/XF.php(524): XF\App->run()
#14 index.php(20): XF::runApp('XF\\Pub\\App')
#15 {main}

Request state
array(4) {
["url"] => string(43) "/filedata/fetch?filedataid=34806&type=thumb"
["referrer"] => string(64) "https://www.hdrcgb.org/threads/sammy-millers-harley-day.1194167/"
["_GET"] => array(2) {
["filedataid"] => string(5) "34806"
["type"] => string(5) "thumb"
}
["_POST"] => array(0) {
}
}
 
Sort by date Sort by votes
hdrcweb said:
Hi
In my XF DB I had a huge table (66mb) called 'hdrcgbwe_xf.import_log_vbulletin5_1', I assume this was used when importing from vbulletin and was no longer needed, but since I deleted the table I am getting server errors logged in the XF admin panel., the forum seems fine:
The posts these errors point to seem fine.
Do I need this table or how can I stop these errors?
Thanks

Stack trace
SELECT new_id
FROM import_log_vbulletin5_1
WHERE content_type = ?
AND old_id = ?

------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL statement...', 1146, '42S02')
#1 src/XF/Db/Mysqli/Statement.php(41): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1146, '42S02')
#2 src/XF/Db/Mysqli/Statement.php(56): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(152): XF\Db\AbstractAdapter->query('
SELECT new_...', Array)
#5 src/addons/XF301VB/Repository/ImportLookup.php(49): XF\Db\AbstractAdapter->fetchOne('
SELECT new_...', Array)
#6 src/addons/XF301VB/Pub/Controller/Redirect.php(116): XF301VB\Repository\ImportLookup->lookupId('attachment', 0)
#7 src/addons/XF301VB/Pub/Controller/Redirect.php(74): XF301VB\Pub\Controller\Redirect->redirectContent(Object(XF\Mvc\ParameterBag), 'attachment', 'XF:Attachment', 'attachments')
#8 src/XF/Mvc/Dispatcher.php(352): XF301VB\Pub\Controller\Redirect->actionAttachment(Object(XF\Mvc\ParameterBag))
#9 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF301VB:Redirec...', 'Attachment', Object(XF\Mvc\RouteMatch), Object(XF301VB\Pub\Controller\Redirect), NULL)
#10 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF301VB\Pub\Controller\Redirect), NULL)
#11 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#12 src/XF/App.php(2485): XF\Mvc\Dispatcher->run()
#13 src/XF.php(524): XF\App->run()
#14 index.php(20): XF::runApp('XF\\Pub\\App')
#15 {main}

Request state
array(4) {
["url"] => string(43) "/filedata/fetch?filedataid=34806&type=thumb"
["referrer"] => string(64) "https://www.hdrcgb.org/threads/sammy-millers-harley-day.1194167/"
["_GET"] => array(2) {
["filedataid"] => string(5) "34806"
["type"] => string(5) "thumb"
}
["_POST"] => array(0) {
}
}
Click to expand...
Please drop hdrcgbwe_xf.import_log_vbulletin5_1
 
Upvote 0 Downvote
Are you using the XF redirects add-on, or something similar? It looks like that log was probably being accessed on older (imported) threads, to redirect folks to the new thread ID that was created after the import.

If you removed that database, just disable the redirects add-on and that should stop those errors.
 
Upvote 0 Downvote
hdrcweb said:
Thanks
we have the addin: XenForo Redirects for vBulletin 1.1.9
I've disabled it, will this break anything, what do I need to look for?
Click to expand...

No, it shouldn't break anything. That add-on was simply used to redirect people who visited your pre-import links/URLs to the new XF URLs.

The only difference now will be when people visit those old links/URLs, they'll be met with an error saying the requested page couldn't be found.
 
Upvote 0 Downvote
@hdrcweb

You can't remove the table and the redirect add-on without negative consequences. You have effectively started from day 1 with your site's SEO link history with Google, Bing, etc. All previous outside and internal links that helped with page rank are effectively gone. Any person trying to visit via those links, or any search engine following those links, will receive a 404 not found error.

The table can be rebuilt, depending on how you did the import. If this is the case, the site can recover. DM me if you need assistance.
 
Upvote 0 Downvote
MySiteGuy said:
@hdrcweb

You can't remove the table and the redirect add-on without negative consequences. You have effectively started from day 1 with your site's SEO link history with Google, Bing, etc. All previous outside and internal links that helped with page rank are effectively gone. Any person trying to visit via those links, or any search engine following those links, will receive a 404 not found error.

The table can be rebuilt, depending on how you did the import. If this is the case, the site can recover. DM me if you need assistance.
Click to expand...
It's correct
 
Upvote 0 Downvote
You must log in or register to reply here.

Similar threads

New Rogernomics
  • Question Question
XF 2.3 User registration broken since XF 2.3
Replies
2
Views
111
New Rogernomics
New Rogernomics
G
  • Question Question
XF 2.2 Can't post to some nodes, server errors
Replies
1
Views
25
briansol
B
M
  • Question Question
XF 2.2 can you help with these server errors
Replies
14
Views
315
Sim
Sim
Alan_SP
  • Question Question
XF 2.2 Users can't register - server errors
Replies
6
Views
449
Alan_SP
Alan_SP
KensonPlays
  • Solved
MG 2.2 Database Errors with Media Gallery
Replies
5
Views
663
KensonPlays
KensonPlays
Back
Top Bottom