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)

May 31, 2015 11:10 AM

pegasus

VaultWiki Team

Where do you see this error?

Reply
May 31, 2015 1:22 PM

riemers

New Member

On a fresh installation.. step 8 i believe..

Reply
May 31, 2015 1:26 PM

pegasus

VaultWiki Team

The step numbers are arbitrary... Each step has a description which I would need to know to look into an installation problem.

I have never seen this issue myself. Did the installation create any tables at all?

What is your MySQL version?

Reply

May 31, 2015 1:30 PM

riemers

New Member

It created all tables, Except the vw_route one..

Code:

Step 8

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

p.s. i tried to look for typo's or maybe certain ; or ' closures not present.. but looked fine with my limited knowledge.

May 31, 2015 1:31 PM

riemers

New Member

Also if i rerun it in manual mode.. it actually says again:

Step 1

Creating table: vw_route

So it tries to create it again, only well that fails ;p

Reply
May 31, 2015 1:32 PM
pegasus

VaultWiki Team
In vault/core/controller/install/db/create/route/vw.php, find:

Code:

'name' => 'vw_route',

After it, add:

Code:

'engine' => 'MyISAM',

It is possible you're using an older version of MySQL with a default engine that does not support full-text indexes.
Reply
May 31, 2015 1:35 PM

riemers

New Member

Same error messages still.. do i need to clear some cache out perhaps?

Reply
May 31, 2015 1:39 PM

riemers

New Member

In regards to mysql...

mysql --version
mysql Ver 14.14 Distrib 5.5.40, for debian-linux-gnu (x86_64) using readline 6.2

Reply
May 31, 2015 2:03 PM

pegasus

VaultWiki Team

Yeah 5.5.4 doesn't support InnoDB full-text indexes. After making that change you would have to start the installation over from step 1, you can try going to Manual Mode and specifying ?step=1 in the URL.

I will post an update in a few minutes for the installer to account for this difference in MySQL features.

Reply
May 31, 2015 2:39 PM

riemers

New Member

I did rerun it, also with step 1 option as you suggested, but same error still applies. From which version does it support full index? (if its only a minor version bump i might be able to upgrade)

Reply
May 31, 2015 2:41 PM

pegasus

VaultWiki Team

5.6.4. But if restarting step 1 with this change had no effect, then it might not be this issue. Please fill out a support ticket so we can investigate why the table cannot be created on your site: https://www.vaultwiki.org/members/?d...e&productid=20

Reply
May 31, 2015 2:54 PM

riemers

New Member

Added support request information..

Reply
May 31, 2015 3:07 PM

riemers

New Member

Running on a plesk install, it seems there is support for 5.6, looking into that too now..

Seems that "Preliminary release date for 12.1 is 2015 Q3." 5.6 will have to wait, did manage to bump up the minor version to 5.5.43

Reply
June 1, 2015 8:42 AM

pegasus

VaultWiki Team

Fixed. Also, your installation is complete.

Reply
June 1, 2015 9:20 AM

riemers

New Member

Champ! , Thanks.. still need to upgrade forum itself perhaps, but always a bit sceptical of big changes.. usually wait for higher version bumps unless its a security issue. (in regards to xenforo)

Reply

+ Reply

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

Issue Tools