Issue: MySQL Error : Unknown column 'contentid' in 'field list'

Issue Tools
- View Changes

December 20, 2010 9:52 AM

Alfa1

Distinguished Member

MySQL Error : Unknown column 'contentid' in 'field list'

Im getting lots of errors like this one, for wiki edits:

Code:

Database error in vBulletin 3.8.6:

Invalid SQL:

                                UPDATE vb4_attachment
                                SET contentid = 370742,
                                        posthash = ''
                                WHERE posthash = 'invalid posthash'
        AND dateline > 1292776071;

MySQL Error   : Unknown column 'contentid' in 'field list'
Error Number  : 1054
Request Date  : Sunday, December 19th 2010 @ 05:28:44 PM
Error Date    : Sunday, December 19th 2010 @ 05:28:44 PM
Script        :  /forum/showwiki.php?title=Forum_posting_functionality&do=edit&section=25
Referrer      :  /forum/showwiki.php?title=Forum_posting_functionality
IP Address    : xxx
Username      : xxx
Classname     : vB_Database
MySQL Version :

Issue Details

Issue Number 2165

Issue Type Bug

Project VaultWiki 3.x Series

Category Editing / Posting Articles

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 3.0.8

Fixed Version 3.0.9

Milestone (none)

Software DependencyvBulletin 3.8

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

December 20, 2010 1:26 PM

pegasus

VaultWiki Team

Fixed and build number incremented. In vault/dm/article.php, find:

Code:

			$where = $this->sql_attachment_where();

			$this->dbobject->query_write("
				UPDATE " . TABLE_PREFIX . "attachment
				SET contentid = $postid,

Replace with:

Code:

			$where = $this->sql_attachment_where();

			if (VAULT_40X_COMPAT)
			{
				$contentid = 'contentid';
			}
			else
			{
				$contentid = 'postid';
			}

			$this->dbobject->query_write("
				UPDATE " . TABLE_PREFIX . "attachment
				SET $contentid = $postid,

December 20, 2010 1:55 PM

Alfa1

Distinguished Member

Thanks

Reply

+ Reply

All times are GMT -4. The time now is 5:48 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: MySQL Error : Unknown column 'contentid' in 'field list'

Issue Tools