Issue: Error with Book Namesspace

Issue Tools
- View Changes

July 18, 2010 12:59 PM

Big-k

New Member

Error with Book Namesspace

I tried to create a new book, got this.

Code:

Database error in vBulletin 4.0.4:

Invalid SQL:

			SELECT topper.*, chapter.threadid, chapter.title,
				chapter.prefixid, chapter.forumid
				, 1 AS marking
				, art.languageid
			FROM vb4_vault_chapter AS topper
			LEFT JOIN vb4_thread AS chapter ON (topper.threadid = chapter.threadid)
			
			LEFT JOIN vb4_vault_article AS art ON (art.threadid = chapter.threadid)
			WHERE topper.bookid IN (56010)
			ORDER BY topper.chapternumber;

MySQL Error   : Unknown column 'art.languageid' in 'field list'
Error Number  : 1054
Request Date  : Sunday, July 18th 2010 @ 01:18:32 PM
Error Date    : Sunday, July 18th 2010 @ 01:18:32 PM

MySQL Version : 5.0.91-community

Issue Details

Issue Number 1806

Issue Type Bug

Project VaultWiki 3.x Series

Category Books / Chapters

Status Fixed

Priority 4 - Warnings / Script Errors

Affected Version 3.0.1

Fixed Version 3.0.2

Milestone VaultWiki 3.0.5

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

July 18, 2010 1:04 PM

Big-k

New Member

deleted

Reply

July 18, 2010 1:28 PM

pegasus

VaultWiki Team

Fixed for the next build. In vault/factory/book.php, find and delete:

Code:

		$hook_fields = ', art.languageid';

		if (!$dbmarking)
		{
			$hook_joins = "LEFT JOIN " . TABLE_PREFIX . "vault_article AS art ON (art.threadid = chapter.threadid)";
		}

+ Reply

All times are GMT -4. The time now is 11:52 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: Error with Book Namesspace

Issue Tools