Issue: Issue with importing VW3 data to VW4 on VB4.2.2

Issue Tools
- View Changes

February 15, 2015 8:15 PM
carancho

New Member
Issue with importing VW3 data to VW4 on VB4.2.2

Received SQL error when doing Content>Import/Export to import VW3 data to VW4

Hello, I upgraded to VW4 and followed upgrade guide for VW3 users. When performing import from VW3, the import page gets tuck at Step 19. When clicking Manual Mode link I find the following SQL error for "Importing chapter organization":

Code:

Database error in vBulletin 4.2.2: Invalid SQL: SELECT pageid FROM `vw_chapter` WHERE `pageid` IN () LIMIT 0; MySQL 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 Error Number : 1064

Thanks in advance!

Issue Details

Issue Number 4213

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 DependencyvBulletin 4.x

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

February 15, 2015 10:20 PM
pegasus

VaultWiki Team
This error occurs when all of the chapters being imported in this batch are pages that were not successfully imported (as pages) by an earlier step. This can happen either if the pages could not be imported, if the corresponding pages were actually ALL redirects, or if the original source pages were deleted and the chapter records were meaningless.

Fixed in the next release. In vault/core/controller/import/handle/vw3/chapter/vw.php, find:

Code:

$pagemap = $this->get_import_threadids(array_keys($chapterlist));

After it, add:

Code:

if (empty($pagemap)) return vw_DB::get($this->from)->func()->num_rows($chapters);
Reply

February 17, 2015 1:46 AM

carancho

New Member

Thanks for the quick reply! I updated vw.php as directed and was able to complete the import process. Unfortunately the wiki pages came up unpopulated with our pages originally created in VW3. We ran the import process again and now have seen this error:

Code:

Step 21

Could not find phrase 'vw_importing_social_groups'.
Invalid argument supplied for foreach()
vw_CP_Progress_View->handle_php_error() in vault/core/model/db/mysql/vw.php at line 466
vw_DB_MySQL_Model->like() in vault/core/controller/import/handle/base/vw.php at line 184
vw_Import_Handle_Base_Controller->get_user_map() in vault/core/controller/import/handle/vw3/group/vw.php at line 149
vw_Import_Handle_VW3_Group_Controller->do_groups() in vault/core/controller/import/steps/vw3/vw.php at line 448
vw_Import_Steps_VW3_Controller->{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 vault/helper/vb/global.php at line 62
require_once() in admincp/wiki_cp.php at line 24

Database error in vBulletin 4.2.2:

Invalid SQL:
REPLACE INTO `vw_import` (`sourceid`, `targetid`, `name`, `hash`)  VALUES (9,,'group','22b820d8ca3fe0ef3883ad26e405c49d');

MySQL 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 ''group','22b820d8ca3fe0ef3883ad26e405c49d')' at line 1
Error Number  : 1064
Request Date  : Monday, February 16th 2015 @ 08:10:20 AM
Error Date    : Monday, February 16th 2015 @ 08:10:20 AM
Script        : [url]http://XXXXX.com/admincp/wiki_cp.php?panel=impex&do=import&manual=1[/url]
Referrer      : [url]http://XXXXX.com/admincp/wiki_cp.php?panel=impex&do=import[/url]
IP Address    : XXXXX
Username      : Airwolf
Classname     : vB_Database
MySQL Version : 5.5.40-cll

What do you think?

February 17, 2015 10:14 AM

pegasus

VaultWiki Team

There is not a simple fix for the above error, and it doesn't explain why your first import had empty results. Please submit a free Import Service here and we'll take care of the rest: https://www.vaultwiki.org/members/?d...e&productid=20

Reply
February 19, 2015 3:00 AM

carancho

New Member

Thank you! I submitted the ticket as directed. We appreciate the awesome support!

Reply

+ Reply

All times are GMT -4. The time now is 10:37 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: Issue with importing VW3 data to VW4 on VB4.2.2

Issue Tools