Issue: Unknown column 'filedata' in 'field list'

Issue Tools
- View Changes

March 17, 2016 6:07 PM

Alfa1

Distinguished Member

Unknown column 'filedata' in 'field list'

Code:

Step 13
Importing wiki pages
An exception occurred: Mysqli prepare error: Unknown column 'filedata' in 'field list' in library/Zend/Db/Statement/Mysqli.php on line 77
1.	Zend_Db_Statement_Mysqli->_prepare() in library/Zend/Db/Statement.php at line 115
2.	Zend_Db_Statement->__construct() in library/Zend/Db/Adapter/Mysqli.php at line 381
3.	Zend_Db_Adapter_Mysqli->prepare() in library/Zend/Db/Adapter/Abstract.php at line 478
4.	Zend_Db_Adapter_Abstract->query() in library/Zend/Db/Adapter/Abstract.php at line 574
5.	Zend_Db_Adapter_Abstract->insert() in library/XenForo/DataWriter.php at line 1638
6.	XenForo_DataWriter->_insert() in library/XenForo/DataWriter.php at line 1627
7.	XenForo_DataWriter->_save() in library/vw/XenForo/DataWriter.php at line 341
8.	vw_XenForo_DataWriter->_save() in library/XenForo/DataWriter.php at line 1419
9.	XenForo_DataWriter->save() in vault/core/controller/dm/xf.php at line 408
10.	vw_DM_Controller_XF->save() in vault/core/controller/dm/attach/file/vw.php at line 894
11.	vw_DM_Attach_File_Controller->create_thumbnails() in vault/core/controller/dm/attach/file/vw.php at line388
12.	vw_DM_Attach_File_Controller->post_save_each() in library/vw/XenForo/DataWriter.php at line 466
13.	vw_XenForo_DataWriter->_postSave() in library/XenForo/DataWriter.php at line 1423
14.	XenForo_DataWriter->save() in vault/core/controller/dm/xf.php at line 408
15.	vw_DM_Controller_XF->save() in vault/core/controller/import/handle/vw3/attach/vw.php at line 624
16.	vw_Import_Handle_VW3_Attach_Controller->create_attachment() invault/core/controller/import/handle/vw3/attach/vw.php at line 149
17.	vw_Import_Handle_VW3_Attach_Controller->do_item_attachments() invault/core/controller/import/handle/vw3/page/vw.php at line 689
18.	vw_Import_Handle_VW3_Page_Controller->add_page() invault/core/controller/import/handle/vw3/page/vw.php at line 437
19.	vw_Import_Handle_VW3_Page_Controller->do_page() invault/core/controller/import/handle/vw3/page/vw.php at line 218
20.	vw_Import_Handle_VW3_Page_Controller->do_pages() in vault/core/controller/import/steps/vw3/vw.phpat line 275
21.	vw_Import_Steps_VW3_Controller->{closure}() in vault/core/controller/progress/steps/vw.php at line 76
22.	vw_Progress_Steps_Controller->call() in vault/core/controller/progress/steps/vw.php at line 49
23.	vw_Progress_Steps_Controller->execute() in vault/core/controller/progress/vw.php at line 92
24.	vw_Progress_Controller->exec_script() in vault/core/controller/progress/vw.php at line 74
25.	vw_Progress_Controller->execute() in vault/core/controller/cp/progress/vw.php at line 34
26.	vw_CP_Progress_Controller->process() in vault/core/controller/cp/impex/vw.php at line 108
27.	vw_CP_ImpEx_Controller->import() in vault/core/controller/cp/impex/vw.php at line 33
28.	vw_CP_ImpEx_Controller->execute() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 118
29.	vw_XenForo_ControllerAdmin_Wiki->actionIndex() in library/XenForo/FrontController.php at line 351
30.	XenForo_FrontController->dispatch() in library/XenForo/FrontController.php at line 134
31.	XenForo_FrontController->run() in admin.php at line 13

Issue Details

Issue Number 4592

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 9:46 AM

pegasus

VaultWiki Team

In vault/core/controller/dm/attach/thumb/vw.php, find:

Code:

$this->instance->set_valid_field('filedata', 'BINARY', 'NO', 'verify_filedata');

Replace with:

Code:

		if ($this->storage == 'db')
		{
			$this->instance->set_valid_field('filedata', 'BINARY', 'NO', 'verify_filedata');
		}

+ Reply

All times are GMT -4. The time now is 7:29 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: Unknown column 'filedata' in 'field list'

Issue Tools