MySQL Error when trying to use Books

[Home Alone]

Database error in vBulletin 3.7.0:

Invalid SQL:

		SELECT visible, forumid, thread.threadid, title, open, postuserid, dateline,
			article.protection, thread.namespaceid, MAX(chapternumber) AS chaptercount
		FROM thread AS thread
		LEFT JOIN vault_article AS article ON (article.threadid = thread.threadid)
		LEFT JOIN vault_book AS chapter ON (chapter.bookid = thread.threadid)
		WHERE thread.threadid IN (135151)
			
		GROUP BY thread.threadid
		ORDER BY title ASC
		LIMIT 0,50;

MySQL Error   : Unknown column 'article.protection' in 'field list'
Error Number  : 1054

[pegasus]

Did you upgrade from the Lite version by any chance?

[Home Alone]

Did you upgrade from the Lite version by any chance?

I uninstalled the Lite version, then installed the full version.

[pegasus]

Okay, there is a (suppressed) MySQL error when uninstalling Lite. Simply upgrading avoids this issue.

As a result of the botched uninstall, the vault_article table was not removed, so when it later attempted to create the table on a new install, it failed, and any new columns in that step were not added. I'm going to update the Lite uninstaller at vB.org, but you are going to have to run the following SQL queries on your database:

ALTER TABLE " . TABLE_PREFIX . "vault_link
ADD COLUMN templateusage INT(1) UNSIGNED NOT NULL DEFAULT '0'

ALTER TABLE " . TABLE_PREFIX . "vault_article
ADD COLUMN bookid INT(11) UNSIGNED NOT NULL DEFAULT '0',
ADD COLUMN protection INT(11) UNSIGNED NOT NULL DEFAULT '0',
ADD INDEX bookid (bookid)

Replacing the " . TABLE_PREFIX . " bits to match your setup.