Issue: Installation bug

Issue Tools
- View Changes

May 31, 2015 4:11 AM

riemers

New Member

Installation bug

Wrong vw_route, it does not get created

Code:

An exception occurred: Database Error: SELECT itemid,itemtypeid,itemkey,url,stackids,keylength,maxword, titlekey,searchmeta FROM `vw_route` WHERE parentprefixid = 0 Mysqli prepare error: Table 'lz_xenforo.vw_route' doesn't exist in /var/www/vhosts/site1/httpdocs/vault/core/controller/db/xf.php on line 146

It says it created the vw_route, but yet it isn't there, i checked the db.

I created a new topic, since i added this to the other thread, which might not been wise..

Issue Details

Issue Number 4316

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.4

Fixed Version 4.0.4

Milestone (none)

Software DependencyXenForo 1.x

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

June 1, 2015 9:34 AM
riemers

New Member
On my website i clicked on the "Wiki" and i got a "A wiki node with the title Wiki could not be found. Please check the URL and try again or return to the wiki index." so i went to the area manager and renamed the "Wiki Pages" to "Wiki" but then the breadcrumb display 2x in the bar. Anyways, i reverted the change since i don't think that is the correct path to walk. Only when i went back to my forums, i get a new message:

Code:

An exception occurred: Database Error: SELECT updateid FROM `vw_lastupdatecache` WHERE userid = 1 AND `nodeid` IN (2,3,) AND nodetypeid = 1 Mysqli prepare 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 ') AND nodetypeid = 1' at line 1 in /var/www/vhosts/site1/httpdocs/vault/core/controller/db/xf.php on line 146
Reply
June 1, 2015 9:41 AM

pegasus

VaultWiki Team

Ok I will check this

Reply
June 1, 2015 10:32 AM

pegasus

VaultWiki Team

Fixed.

Reply
June 1, 2015 10:42 AM

riemers

New Member

Was that my bad, or code bad? As in, will this not happen again in the future? (as in, if i want to do this in the future, and fix it myself, its handy to know)

Reply
June 1, 2015 12:56 PM

pegasus

VaultWiki Team

It was damage from when the installer didn't finish properly. It should not happen again unless there is other damage.

Reply

+ Reply

All times are GMT -4. The time now is 3:40 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: Installation bug

Issue Tools