Issue: Incorrect index name

Issue Tools
- View Changes

August 10, 2013 9:10 PM

Alfa1

Distinguished Member

Incorrect index name

Upon installing VW4 beta 4 on XF 1.2, I am getting this error:

Code:

An exception occurred: Mysqli statement execute error : Incorrect index name '' in /public_html/test4/library/Zend/Db/Statement/Mysqli.php on line 214

    Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    Zend_Db_Adapter_Abstract->query() in /public_html/test4/vault/core/controller/db/xf.php at line 121
    vw_DB_Controller_XF->query_write() in /public_html/test4/vault/core/controller/dbalter/vw.php at line 273
    vw_DBalter_Instance->execute_query() in /public_html/test4/vault/core/controller/dbalter/mysql/vw.php at line 131
    vw_DBalter_MySQL_Controller->create_table() in /public_html/test4/vault/core/controller/install/db/create/vw.php at line 58
    vw_Install_DB_Create_Controller->execute() in /public_html/test4/vault/core/controller/install/full/steps/vw.php at line 31
    {closure}() in /public_html/test4/vault/core/controller/progress/vw.php at line 80
    vw_Progress_Controller->call() in /public_html/test4/vault/core/controller/cp/progress/vw.php at line 39
    vw_CP_Progress_Controller->process() in /public_html/test4/vault/core/controller/cp/install/vw.php at line 143
    vw_CP_Install_Controller->install() in /public_html/test4/vault/core/controller/cp/install/vw.php at line 74
    vw_CP_Install_Controller->execute() in /public_html/test4/vault/cp/global.php at line 72
    require_once() in /public_html/test4/vault/install/index.php at line 40


array(3) {
  ["url"] => string(74) "/test4/vault/install/index.php?step=1&nostyle=1"
  ["_GET"] => array(2) {
    ["step"] => string(1) "1"
    ["nostyle"] => string(1) "1"
  }
  ["_POST"] => array(4) {
    ["step"] => string(1) "1"
    ["nostyle"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["do"] => string(1) "1"
  }
}

Issue Details

Issue Number 3288

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.0 Beta 4

Fixed Version 4.0.0 Beta 5

Milestone VaultWiki 4 Beta X

Software DependencyAny

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

August 10, 2013 9:24 PM

pegasus

VaultWiki Team

This occurs when creating the database tables. The name of the table being created should be directly above this error. Knowing the name of the table will make finding the problem much easier. Thanks.

Reply
August 10, 2013 9:28 PM
pegasus

VaultWiki Team
The issue occurs on fresh installations against vBulletin 3 and XenForo (vBulletin 4 has its own tag storage).

Fixed in the current ZIP. In vault/core/controller/dbalter/mysql/vw.php, find:

Code:

if (!isset($indexinfo['type'])) { $indexinfo['type'] = ''; }

Add after:

Code:

if ($indexinfo['name'] === null AND $indexinfo['type'] != 'PRIMARY') { $indexinfo['name'] = reset($indexinfo['fields']); }

Then hit Refresh and click "Continue" on the installer.
Reply
August 11, 2013 7:51 AM

Alfa1

Distinguished Member

Thanks. That fixes it until the next error occurs. See other report.

Reply

+ Reply

All times are GMT -4. The time now is 11: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: Incorrect index name

Issue Tools