Issue: DB Error Rebuilding Post Cache

Issue Tools
- View Changes

June 13, 2010 8:47 AM

Jella

Regular Member

DB Error Rebuilding Post Cache

I upgraded the Lamp wiki to gold and all went very well except for when you update the 'post cache' via maintenance and get this error, I know we fixed this before (must have been an oversight on the Gold version) but I've tried searching here for that fix and can't find it.

Code:

Database error in vBulletin 3.8.4:

Invalid SQL:

			SELECT postid, post.threadid, forumid, vault_options
				, prefixid
			FROM post AS post, thread AS thread
			WHERE post.threadid = thread.threadid AND
				postid >= 3 AND
				thread.lastpost >= 1275828295
			ORDER BY postid
			LIMIT 1000;

MySQL Error   : Unknown column 'vault_options' in 'field list'
Error Number  : 1054
Request Date  : Sunday, June 13th 2010 @ 08:44:55 AM
Error Date    : Sunday, June 13th 2010 @ 08:44:56 AM
Script        : http://tvlampforum.com/admincp/misc.php?do=buildpostcache
Referrer      : http://tvlampforum.com/admincp/misc.php?do=chooser
IP Address    : 98.229.177.31
Username      : admin
Classname     : vB_Database
MySQL Version : 5.0.90-community

Issue Details

Issue Number 1684

Issue Type Bug

Project VaultWiki 3.x Series

Category Admin Panel

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 3.0.0

Fixed Version 3.0.0

Milestone VaultWiki 3.0.5

Software DependencyvBulletin 3.8

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

June 13, 2010 1:05 PM

pegasus

VaultWiki Team

Fixed in the current ZIP. In vault/admin.php, find:

Code:

forumid, vault_options

Replace with:

Code:

forumid, vopt.options AS vault_options

Find:

Code:

			FROM " . TABLE_PREFIX . "post AS post, " . TABLE_PREFIX . "thread AS thread

Replace with:

Code:

			FROM " . TABLE_PREFIX . "post AS post
			INNER JOIN " . TABLE_PREFIX . "thread AS thread ON (thread.threadid = post.threadid)
			LEFT JOIN " . TABLE_PREFIX . "vault_options AS vopt ON (vopt.contentid = post.postid AND vopt.contenttypeid = " . intval($vault->misc['contenttypes']['post']) . ")

June 13, 2010 1:56 PM

Jella

Regular Member

You mean theres a new zip since early this morning? Thats the version I downloaded and I upgraded with.

Reply
June 13, 2010 4:28 PM

pegasus

VaultWiki Team

No, when I say "fixed in the current ZIP", this was the process:

1. You reported the bug.
2. The fix was posted here for users who already downloaded.
3. The fix was merged into the ZIP of the current release.

Bugs that are "fixed for the next build" don't undergo step 3.

Reply

+ Reply

All times are GMT -4. The time now is 12:27 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: DB Error Rebuilding Post Cache

Issue Tools