Issue: DB Error Importing No Prefixes

Issue Tools
- View Changes

February 9, 2015 7:00 PM

GWTZ

Junior Member

DB Error Importing No Prefixes

Back with more errors, sorry.

With the Wiki installed, now focussed on transferring the VB VaultWiki 4 stuff to the XF 4 one. A few ways into Step 1 gets the following:

Importing page prefixes

Code:

An exception occurred: Database Error: SELECT prefixid,prefixkey FROM `vw_prefix` WHERE `prefixkey` IN () LIMIT 0 Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') LIMIT 0' at line 1 in /home/[REDACTED]/public_html/[REDACTED]/vault/core/controller/db/xf.php on line 136
vw_DB_Controller_XF->throw_error() in vault/core/controller/db/xf.php at line 150
vw_DB_Controller_XF->query_read() in vault/core/model/db/mysql/vw.php at line 29
vw_DB_MySQL_Model->select() in vault/core/controller/import/handle/vw4/prefix/vw.php at line 61
vw_Import_Handle_VW4_Prefix_Controller->do_prefixes() in vault/core/controller/import/steps/vw4/vw.php at line 81
{closure}() in vault/core/controller/progress/vw.php at line 100
vw_Progress_Controller->call() in vault/core/controller/cp/impex/vw.php at line 114
vw_CP_ImpEx_Controller->import() in vault/core/controller/cp/impex/vw.php at line 35
vw_CP_ImpEx_Controller->execute() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 115
vw_XenForo_ControllerAdmin_Wiki->actionIndex() in library/XenForo/FrontController.php at line 347
XenForo_FrontController->dispatch() in library/XenForo/FrontController.php at line 134
XenForo_FrontController->run() in admin.php at line 13

I appreciate this is similar to an error I reported on the previous page and as with that I've gone through all the listed files, with only FrontController.php as an error which I've fixed.

Aside from the SQL stuff mentioned at the top, the only other thing I can think of is I didn't provide a dependency for the VB VW 4 database in the config file.

Issue Details

Issue Number 4185

Issue Type Bug

Project VaultWiki 4.x Series

Category Importing

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.1

Fixed Version 4.0.2

Milestone (none)

Software DependencyAny

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

February 10, 2015 11:59 AM
pegasus

VaultWiki Team
While it doesn't relate to this error, make sure you've set the dependency to 'vB4|vB3', or you'll have problems in later steps.

It seems this error occurs when importing from VW4 if there were no non-special prefixes in the source database. Thus, this step can be skipped in your case.

In vault/core/controller/import/hanlde/vw4/prefix/vw.php, find:

Code:

$settings = $this->get_dependency()->of('Settings')->get(array('vw_special_prefixid'));

Before it, add:

Code:

return 0;
Reply

+ Reply

All times are GMT -4. The time now is 12:45 AM.

This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: DB Error Importing No Prefixes

Issue Tools