Issue: import sql error Step 6

Issue Tools
- View Changes

March 12, 2018 12:19 PM

joshtrav

Junior Member

import sql error Step 6

Importing wiki 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 ''postpage',1)' at line 1

Code:

#0: vw_CP_Progress_View->handle_php_error()
#1: mysqli_query() in [path]/includes/class_core.php at line 1394
#2: vB_Database_MySQLi->execute_query() in [path]/includes/class_core.php at line 444
#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 1096
#6: vw_DB_MySQL_Model->replace() in [path]/vault/core/controller/import/handle/base/vw.php at line 107
#7: vw_Import_Handle_Base_Controller->insert_values() in [path]/vault/core/controller/import/handle/base/vw.php at line 144
#8: vw_Import_Handle_Base_Controller->update_import_map() in [path]/vault/core/controller/import/handle/vw3/page/vw.php at line 268
#9: vw_Import_Handle_VW3_Page_Controller->do_pages() in [path]/vault/core/controller/import/handle/vw3/mainpage/vw.php at line 112
#10: vw_Import_Handle_VW3_MainPage_Controller->create_main_pages() in [path]/vault/core/controller/import/handle/vw3/mainpage/vw.php at line 45
#11: vw_Import_Handle_VW3_MainPage_Controller->do_main_pages() in [path]/vault/core/controller/import/steps/vw3/vw.php at line 152
#12: vw_Import_Steps_VW3_Controller->{closure}() in [path]/vault/core/controller/progress/steps/vw.php at line 83
#13: vw_Progress_Steps_Controller->call() in [path]/vault/core/controller/progress/steps/vw.php at line 53
#14: vw_Progress_Steps_Controller->execute() in [path]/vault/core/controller/progress/vw.php at line 92
#15: vw_Progress_Controller->exec_script() in [path]/vault/core/controller/progress/vw.php at line 74
#16: vw_Progress_Controller->execute() in [path]/vault/core/controller/cp/progress/vw.php at line 37
#17: vw_CP_Progress_Controller->process() in [path]/vault/core/controller/cp/impex/vw.php at line 339
#18: vw_CP_ImpEx_Controller->import() in [path]/vault/core/controller/cp/impex/vw.php at line 53
#19: vw_CP_ImpEx_Controller->execute() in [path]/vault/helper/vb/global.php at line 64
#20: require_once() in [path]/AdminCP/wiki_cp.php at line 24

Issue Details

Issue Number 5380

Issue Type Bug

Project VaultWiki 4.x Series

Category Importing

Status Fixed

Priority 4 - Warnings / Script Errors

Affected Version 4.0.21

Fixed Version 4.0.22

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)

March 12, 2018 12:25 PM

pegasus

VaultWiki Team

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

Code:

			$this->importrows['postpage'][] = array(
				'sourceid' => $page['postid'],
				'targetid' => $redirectid
			);

Replace with:

Code:

			$this->importrows['postpage'][] = array(
				'sourceid' => $page['postid'],
				'targetid' => $page['pageid']
			);

Then reload the page (do not re-submit any POST if asked) and try again.

+ Reply

All times are GMT -4. The time now is 3:04 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: import sql error Step 6

Issue Tools