XF 2.2 XF\Db\Exception: MySQL statement prepare error [1146]: Table 'import_table_name' doesn't exist src/XF/Db/AbstractStatement.php:228

[Robru]

Recently, after the update of XF 2.2.4, I started to see the following errors. How do I fix this?

XF\Db\Exception: MySQL statement prepare error [1146]: Table 'import_table_name' doesn't exist src/XF/Db/AbstractStatement.php:228
Generated by: Unknown account Mar 30, 2021 at 7:27 AM

Stack trace
            SELECT new_id
            FROM import_table_name
            WHERE content_type = ?
            AND old_id = ?
        
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1146, '42S02')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1146, '42S02')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(150): XF\Db\AbstractAdapter->query('
            SELECT new_...', Array)
#5 src/addons/XF301VB/Repository/ImportLookup.php(47): XF\Db\AbstractAdapter->fetchOne('
            SELECT new_...', Array)
#6 src/addons/XF301VB/Pub/Controller/Redirect.php(114): XF301VB\Repository\ImportLookup->lookupId('blog_user', NULL)
#7 src/addons/XF301VB/Pub/Controller/Redirect.php(86): XF301VB\Pub\Controller\Redirect->redirectContent(Object(XF\Mvc\ParameterBag), 'blog_user', 'XF:Node', 'forums')
#8 src/XF/Mvc/Dispatcher.php(350): XF301VB\Pub\Controller\Redirect->actionBlogUser(Object(XF\Mvc\ParameterBag))
#9 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF301VB:Redirec...', 'BlogUser', Object(XF\Mvc\RouteMatch), Object(XF301VB\Pub\Controller\Redirect), NULL)
#10 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF301VB\Pub\Controller\Redirect), NULL)
#11 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#12 src/XF/App.php(2326): XF\Mvc\Dispatcher->run()
#13 src/XF.php(488): XF\App->run()
#14 index.php(20): XF::runApp('XF\\Pub\\App')
#15 {main}

Request state
array(4) {
  ["url"] => string(43) "/community/blogs/schmuel/542-fotoshoot.html"
  ["referrer"] => bool(false)
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}

 

[Robru]

Bump

 

[Robru]

Can anyone tell me how to fix this.

 

[Lawrence]

Can anyone tell me how to fix this.

It's been two months @Mike @Chris D @Brogan @Slavik why haven't any of you took the time to answer this question by a valued licensed member?

Sorry, but I know little about importers, so I really can't help you. But maybe the table name is incorrect? Or maybe blogs can't be imported??

 

[Slavik]

Can anyone tell me how to fix this.

Open your 301config.php file in the server root, it looks like you overwrote the one with your actual config with the default one.

Change the table name in there accordingly.

 

[Chris D]

It's been two months @Mike @Chris D @Brogan @Slavik why haven't any of you took the time to answer this question by a valued licensed member?

We have to prioritise support requested via the ticket system alongside our usual development, moderation and other duties.

We do try and answer questions on the forum but it is by no means possible for us to personally read and respond to every query. Sometimes things will pass under our radar.

If something goes unanswered or it requires the attention of a staff member all they need to do is submit a ticket and it will receive a response

FWIW in this case I’d probably recommend submitting a ticket within 72 hours of posting here without a satisfactory reply but obviously much sooner is welcome if it is a high priority issue.

 

[Robru]

Open your 301config.php file in the server root, it looks like you overwrote the one with your actual config with the default one.

Change the table name in there accordingly.

No changes have been made to this file for many years.

 

[Robru]

We have to prioritise support requested via the ticket system alongside our usual development, moderation and other duties.

We do try and answer questions on the forum but it is by no means possible for us to personally read and respond to every query. Sometimes things will pass under our radar.

If something goes unanswered or it requires the attention of a staff member all they need to do is submit a ticket and it will receive a response

FWIW in this case I’d probably recommend submitting a ticket within 72 hours of posting here without a satisfactory reply but obviously much sooner is welcome if it is a high priority issue.

Thanks for your answer Chris, I will create a ticket.

 

[Mike]

To follow up, this is the "vBulletin import log table" option that needs to be set after the redirection add-on is installed.

 

[Lawrence]

Good to see this has got some action, thanks guys,

PS @Chris D If you know the location of a RADAR and are within X nautical miles of the RADAR you can technically fly under it, however; when you get to that distance, another RADAR located X NM's away is tracking you, so there is no such thing as "flying under the RADAR", .