Issue: SQL Error on Previewing a new Book Page

Issue Tools
- View Changes

December 17, 2014 11:54 AM

Ptah

Junior Member

SQL Error on Previewing a new Book Page

Create a new Page on a Book, then Preview = SQL error

On a given Book
Add a new Page
Click "Preview" on the new Page

... results in SQL crash like so

Code:

Invalid SQL:
SELECT displayorder FROM `vw_chapterorder` WHERE pageid =;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Error Number  : 1064

Issue Details

Issue Number 4107

Issue Type Bug

Project VaultWiki 4.x Series

Category Books / Chapters

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.0 RC 5

Fixed Version 4.0.0

Milestone VaultWiki 4.0 Gold

Software DependencyAny

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

December 17, 2014 11:57 AM
pegasus

VaultWiki Team
In vault/core/view/content/chapter/vw.php, find:

Code:

$cache = vw_Hard_Core::model('Block')->get_cached($item['pageid'], 'chapter_nav');

Before it, add:

Code:

if (empty($item['pageid'])) return;
Reply
December 17, 2014 12:05 PM

Ptah

Junior Member

That fixes it.
Thanks!

Reply

+ Reply

All times are GMT -4. The time now is 3:44 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: SQL Error on Previewing a new Book Page

Issue Tools