Issue: Mysqli prepare error

Issue Tools
- View Changes

March 18, 2016 1:58 PM

Alfa1

Distinguished Member

Mysqli prepare error

Import from vw3 to xf:

Code:

Step 23
Importing social group members
An exception occurred: Database Error: SELECT `gm`.*,`u`.`username` AS `username`,`g`.`pageid` AS `threadid` FROM `vb4_socialgroupmember` `gm` INNER JOIN `vb4_vault_group` `g` ON (`g`.`groupid` = `gm`.`groupid`) LEFT JOIN `vb4_user` `u` ON (`u`.`userid` = ) ORDER BY `gm`.`dateline` ASC LIMIT 0,500 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 ') ORDER BY `gm`.`dateline` ASC LIMIT 0,500' at line 2 in /vault/core/controller/db/xf.php on line 169
1.	vw_DB_Controller_XF->throw_error() in vault/core/controller/db/xf.php at line 183
2.	vw_DB_Controller_XF->query_read() in vault/core/model/db/mysql/vw.php at line 27
3.	vw_DB_MySQL_Model->select() in vault/core/controller/import/handle/vw3/group/vw.php at line 928
4.	vw_Import_Handle_VW3_Group_Controller->do_group_members() in vault/core/controller/import/steps/vw3/vw.php at line 518
5.	vw_Import_Steps_VW3_Controller->{closure}() in vault/core/controller/progress/steps/vw.php at line 76
6.	vw_Progress_Steps_Controller->call() in vault/core/controller/progress/steps/vw.php at line 49
7.	vw_Progress_Steps_Controller->execute() in vault/core/controller/progress/vw.php at line 92
8.	vw_Progress_Controller->exec_script() in vault/core/controller/progress/vw.php at line 74
9.	vw_Progress_Controller->execute() in vault/core/controller/cp/progress/vw.php at line 34
10.	vw_CP_Progress_Controller->process() in vault/core/controller/cp/impex/vw.php at line 108
11.	vw_CP_ImpEx_Controller->import() in vault/core/controller/cp/impex/vw.php at line 33
12.	vw_CP_ImpEx_Controller->execute() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 118
13.	vw_XenForo_ControllerAdmin_Wiki->actionIndex() in library/XenForo/FrontController.php at line 351
14.	XenForo_FrontController->dispatch() in library/XenForo/FrontController.php at line 134
15.	XenForo_FrontController->run() in admin.php at line 13

Issue Details

Issue Number 4594

Issue Type Bug

Project VaultWiki 4.x Series

Category Importing

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.9

Fixed Version (none)

Milestone (none)

Software DependencyXenForo 1.x

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

March 18, 2016 4:45 PM

pegasus

VaultWiki Team

In vault/core/controller/import/handle/vw3/group/vw.php, find:

Code:

'where' => vw_DB::get($this->from)->query()->eq($prep['u']['fields']['userid'], $prep['gs']['fields']['userid'])

Replace with:

Code:

'where' => vw_DB::get($this->from)->query()->eq($prep['u']['fields']['userid'], $prep['gm']['fields']['userid'])

March 18, 2016 5:17 PM

Alfa1

Distinguished Member

Why is it trying to import group messages? We never used wiki for social groups.

After your fix I run into this one:

Code:

Importing social group discussions

An exception occurred: Call to a member function count() on null in /vault/core/controller/db/xf.php on line 293

    vw_DB_Controller_XF->num_rows() in vault/core/controller/import/handle/vw3/group/vw.php at line 1216
    vw_Import_Handle_VW3_Group_Controller->do_group_discussions() in vault/core/controller/import/steps/vw3/vw.php at line 543
    vw_Import_Steps_VW3_Controller->{closure}() in vault/core/controller/progress/steps/vw.php at line 76
    vw_Progress_Steps_Controller->call() in vault/core/controller/progress/steps/vw.php at line 49
    vw_Progress_Steps_Controller->execute() in vault/core/controller/progress/vw.php at line 92
    vw_Progress_Controller->exec_script() in vault/core/controller/progress/vw.php at line 74
    vw_Progress_Controller->execute() in vault/core/controller/cp/progress/vw.php at line 34
    vw_CP_Progress_Controller->process() in vault/core/controller/cp/impex/vw.php at line 108
    vw_CP_ImpEx_Controller->import() in vault/core/controller/cp/impex/vw.php at line 33
    vw_CP_ImpEx_Controller->execute() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 118
    vw_XenForo_ControllerAdmin_Wiki->actionIndex() in library/XenForo/FrontController.php at line 351
    XenForo_FrontController->dispatch() in library/XenForo/FrontController.php at line 134
    XenForo_FrontController->run() in admin.php at line 13

March 18, 2016 5:25 PM
pegasus

VaultWiki Team
In vault/core/controller/import/handle/vw3/group/vw.php at line 1216:

Code:

if (vw_DB::get($this->from)->func()->num_rows($groups) > 0)

Replace it with:

Code:

if (vw_DB::get($this->from)->func()->num_rows($messages) > 0)

Even though you know you never used wiki for social groups, the importer has to run the queries to ask your wiki if you did.
Reply
March 18, 2016 5:27 PM

Alfa1

Distinguished Member

Same result.

Reply
March 18, 2016 5:28 PM

pegasus

VaultWiki Team

You replaced the one at line 1216, right? There is one at an earlier line that should not be replaced.

Reply
March 18, 2016 5:45 PM

Alfa1

Distinguished Member

My bad. Fixed.

Reply

+ Reply

All times are GMT -4. The time now is 12:20 PM.

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: Mysqli prepare error

Issue Tools