Issue: Bug on Import from v 3.0.19 to 4

Issue Tools
- View Changes

November 16, 2018 5:04 PM

popit

Junior Member

Bug on Import from v 3.0.19 to 4

Bug on Import from v 3.0.19 to 4

mysqli_query(): (42S22/1054): Unknown column 'itemid' in 'field list'

#0: vw_CP_Progress_View->handle_php_error()
#1: mysqli_query() in [path]/includes/class_core.php at line 1386
#2: vB_Database_MySQLi->execute_query() in [path]/includes/class_core.php at line 446
#3: vB_Database->query_write() in [path]/vault/core/controller/db/vb3.php at line 269
#4: vw_DB_Controller_vB3->query_write() in [path]/vault/core/model/db/mysql/vw.php at line 1125
#5: vw_DB_MySQL_Model->shutdown_or_run() in [path]/vault/core/model/db/mysql/vw.php at line 874
#6: vw_DB_MySQL_Model->insert() in [path]/vault/core/controller/import/handle/vw3/area/vw.php at line 1189
#7: vw_Import_Handle_VW3_Area_Controller->add_area() in [path]/vault/core/controller/import/handle/vw3/area/vw.php at line 1009
#8: vw_Import_Handle_VW3_Area_Controller->do_area_namespace() in [path]/vault/core/controller/import/handle/vw3/area/vw.php at line 740
#9: vw_Import_Handle_VW3_Area_Controller->do_namespace() in [path]/vault/core/controller/import/handle/vw3/area/vw.php at line 96
#10: vw_Import_Handle_VW3_Area_Controller->do_namespaces() in [path]/vault/core/controller/import/steps/vw3/vw.php at line 127
#11: vw_Import_Steps_VW3_Controller->{closure}() in [path]/vault/core/controller/progress/steps/vw.php at line 83
#12: vw_Progress_Steps_Controller->call() in [path]/vault/core/controller/progress/steps/vw.php at line 53
#13: vw_Progress_Steps_Controller->execute() in [path]/vault/core/controller/progress/vw.php at line 92
#14: vw_Progress_Controller->exec_script() in [path]/vault/core/controller/progress/vw.php at line 74
#15: vw_Progress_Controller->execute() in [path]/vault/core/controller/cp/progress/vw.php at line 37
#16: vw_CP_Progress_Controller->process() in [path]/vault/core/controller/cp/impex/vw.php at line 339
#17: vw_CP_ImpEx_Controller->import() in [path]/vault/core/controller/cp/impex/vw.php at line 53
#18: vw_CP_ImpEx_Controller->execute() in [path]/vault/helper/vb/global.php at line 64
#19: require_once() in [path]/admincp/wiki_cp.php at line 24

Issue Details

Issue Number 5534

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.24

Fixed Version 4.0.25

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)

November 16, 2018 5:25 PM
pegasus

VaultWiki Team
This VW3 import step needs to be updated to reflect a database change. In vault/core/controller/import/handle/vw3/area/vw.php, find:

Code:

'itemid' => $areaid, 'itemtypeid' => vw_Hard_Core::model('Node')->id('Area'),

Replace with:

Code:

'injectid' => $areaid, 'injecttypeid' => vw_Hard_Core::model('Node')->id('Area'),
Reply
November 16, 2018 5:32 PM

popit

Junior Member

Now stuck here

Step 8
Creating empty landing pages

mysqli_query(): (42000/1064): 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 'AS `forumid` FROM `vb_vw_area` `a` LEFT JOIN `vb_vw_import` `i` ON ( = 3 AND =' at line 1

Reply

November 16, 2018 5:54 PM

pegasus

VaultWiki Team

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

Code:

		$prep = vw_DB::get()->query()->prepare(array(
			'a' => array(
				'table' => 'vw_area',
				'fields' => array(
					'title' => '',
					'areaid' => '',
					'pageid' => ''
				)
			),
			'i' => array(
				'targetid' => '',
				'sourceid' => '',
				'importid' => '',
				'name' => ''
			)
		));

Replace with:

Code:

		$prep = vw_DB::get()->query()->prepare(array(
			'a' => array(
				'table' => 'vw_area',
				'alias' => 'a',
				'fields' => array(
					'title' => '',
					'areaid' => '',
					'pageid' => ''
				)
			),
			'i' => array(
				'table' => 'vw_import',
				'alias' => 'i',
				'fields' => array(
					'targetid' => '',
					'sourceid' => '',
					'importid' => '',
					'name' => ''
				)
			)
		));

If you get another one, please feel free to submit a ticket in the members area and we will finish the upgrade for no additional charge.

November 16, 2018 6:21 PM

popit

Junior Member

Unfortunately dies here

Step 13

Importing wiki permissions

Importing wiki pages

Importing wiki pages
Importing wiki pages

mysqli_query(): Couldn't fetch mysqli

#0: vw_CP_Progress_View->handle_php_error()
#1: mysqli_query() in [path]/includes/class_core.php at line 1386
#2: vB_Database_MySQLi->execute_query() in [path]/includes/class_core.php at line 505
#3: vB_Database->query_first() in [path]/vault/core/controller/db/vb3.php at line 325
#4: vw_DB_Controller_vB3->query_first() in [path]/vault/core/model/db/mysql/vw.php at line 27
#5: vw_DB_MySQL_Model->select() in [path]/vault/core/controller/dm/attach/file/vw.php at line 93
#6: vw_DM_Attach_File_Controller->verify_filetypeid() in [path]/vault/core/controller/dm/attach/file/vb3.php at line 36
#7: vw_DM_Attach_File_Controller_vB3->verify_filetypeid() in [path]/includes/class_dm.php at line 491
#8: vB_DataManager->verify() in [path]/includes/class_dm.php at line 341
#9: vB_DataManager->set() in [path]/vault/core/controller/dm/vb3.php at line 259
#10: vw_DM_Controller_vB3->set() in [path]/vault/core/controller/import/handle/vw3/attach/vw.php at line 765
#11: vw_Import_Handle_VW3_Attach_Controller->create_attachment() in [path]/vault/core/controller/import/handle/vw3/attach/vw.php at line 147
#12: vw_Import_Handle_VW3_Attach_Controller->do_item_attachments() in [path]/vault/core/controller/import/handle/vw3/page/vw.php at line 970
#13: vw_Import_Handle_VW3_Page_Controller->add_page() in [path]/vault/core/controller/import/handle/vw3/page/vw.php at line 547
#14: vw_Import_Handle_VW3_Page_Controller->do_page() in [path]/vault/core/controller/import/handle/vw3/page/vw.php at line 254
#15: vw_Import_Handle_VW3_Page_Controller->do_pages() in [path]/vault/core/controller/import/steps/vw3/vw.php at line 262
#16: vw_Import_Steps_VW3_Controller->{closure}() in [path]/vault/core/controller/progress/steps/vw.php at line 83
#17: vw_Progress_Steps_Controller->call() in [path]/vault/core/controller/progress/steps/vw.php at line 53
#18: vw_Progress_Steps_Controller->execute() in [path]/vault/core/controller/progress/vw.php at line 92
#19: vw_Progress_Controller->exec_script() in [path]/vault/core/controller/progress/vw.php at line 74
#20: vw_Progress_Controller->execute() in [path]/vault/core/controller/cp/progress/vw.php at line 37
#21: vw_CP_Progress_Controller->process() in [path]/vault/core/controller/cp/impex/vw.php at line 339
#22: vw_CP_ImpEx_Controller->import() in [path]/vault/core/controller/cp/impex/vw.php at line 53
#23: vw_CP_ImpEx_Controller->execute() in [path]/vault/helper/vb/global.php at line 64
#24: require_once() in [path]/admincp/wiki_cp.php at line 24

now at 33% stopped

Reply
November 17, 2018 4:02 PM

popit

Junior Member

ok added ticket yesterday still waiting in line

Reply

+ Reply

All times are GMT -4. The time now is 7:25 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: Bug on Import from v 3.0.19 to 4

Issue Tools