Issue: Unknown column 'attachmenttypeid' in 'where clause'

Issue Tools
- View Changes

October 22, 2013 1:39 PM

Alfa1

Distinguished Member

Unknown column 'attachmenttypeid' in 'where clause'

Upon deletion of an attachment type:

Server Error

Code:

Mysqli prepare error: Unknown column 'attachmenttypeid' in 'where clause'
1.	Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
2.	Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
3.	Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
4.	Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 661
5.	Zend_Db_Adapter_Abstract->delete() in XenForo/DataWriter.php at line 1813
6.	XenForo_DataWriter->_delete() in XenForo/DataWriter.php at line 1766
7.	XenForo_DataWriter->delete() in /vault/core/controller/dm/xf.php at line 416
8.	vw_DM_Controller_XF->delete() in /vault/core/controller/cp/attach/vw.php at line 88
9.	vw_CP_Attach_Controller->kill() in /vault/core/controller/cp/attach/vw.php at line 33
10.	vw_CP_Attach_Controller->execute() in vw/XenForo/ControllerAdmin/Wiki.php at line 94
11.	vw_XenForo_ControllerAdmin_Wiki->actionIndex() in XenForo/FrontController.php at line 337
12.	XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
13.	XenForo_FrontController->run() in /admin.php at line 13

Issue Details

Issue Number 3416

Issue Type Bug

Project VaultWiki 4.x Series

Category Attachments

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.0 Beta 6

Fixed Version 4.0.0 Beta 7

Milestone VaultWiki 4 Beta X

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)

October 23, 2013 10:01 AM

pegasus

VaultWiki Team

Fixed. In vault/core/controller/dm/filetype/xf.php, find:

Code:

return 'attachmenttypeid = ' . $this->_db->quote($this->getExisting('attachmenttypeid'));

Replace with:

Code:

return 'filetypeid = ' . $this->_db->quote($this->getExisting('filetypeid'));

+ Reply

All times are GMT -4. The time now is 4:07 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: Unknown column 'attachmenttypeid' in 'where clause'

Issue Tools