WHen I turn VW on, articles and threads give me MYSQL errors

[gosborne]

Hello

WHen I have VaultWiki turned on, if I go to a forum thread or CMS articles, I get an error like this:

Database error in vBulletin 4.0.3:

Invalid SQL:

			SELECT IF(thread.visible = 2, 1, 0) AS isdeleted,
			

			
			post.pagetext AS description,
			thread.*
			
			, article.*, thread.threadid, vbook.top_bookid
			FROM vbthread AS thread
			
			
			
			
			LEFT JOIN vbpost AS post ON(post.postid = thread.firstpostid)
			
			
	LEFT JOIN vbvault_article AS article ON (thread.threadid = article.threadid)
	LEFT JOIN vbvault_book AS vbook ON (vbook.threadid = thread.threadid)
			WHERE thread.threadid = 246333;

MySQL Error   : Unknown column 'vbook.top_bookid' in 'field list'
Error Number  : 1054
Request Date  : Tuesday, May 11th 2010 @ 02:30:22 PM
Error Date    : Tuesday, May 11th 2010 @ 02:30:22 PM
Script        : http://www.basenotes.net/content/412-High-Fibre-Fragrances-(or-How-I-Discovered-Natural-Perfume)
Referrer      : 
IP Address    : 82.26.194.104
Username      : Grant
Classname     : vB_Database
MySQL Version : 5.0.90-community

If I switch VaultWiki off, articles and threads are fine.


Thanks

[pegasus]

This is very odd. That column IS added by both the install and upgrade scripts. If you have table vault_book (and it's not complaining it's missing) then it implies the table was added successfully - columns and all.

You didn't have any problem with Step 1 of the installer?

You can just run this query for now:

ALTER TABLE vbvault_book
ADD COLUMN top_bookid INT(10) UNSIGNED NOT NULL DEFAULT '0',
ADD INDEX top_bookid (top_bookid)