Issue: SELECT prefixid FROM `vb_vw_prefix` WHERE prefixid = 1;

Issue Tools
- View Changes

March 2, 2016 1:09 PM

Alfa1

Distinguished Member

SELECT prefixid FROM `vb_vw_prefix` WHERE prefixid = 1;

Step 6:
Creating prefix for Special pages

Code:

Database error in vBulletin 3.8.7:

Invalid SQL:
SELECT prefixid FROM `vb_vw_prefix` WHERE prefixid = 1;

MySQL Error   : Table 'xxx.vw_prefix' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, March 2nd 2016 @ 07:07:04 PM
Error Date    : Wednesday, March 2nd 2016 @ 07:07:05 PM
Script        : /vault/install/index.php
Referrer      : /vault/install/index.php
IP Address    : 
Username      : Alfa
Classname     : vB_Database
MySQL Version : 5.6.19-1+deb.sury.org~precise+1-log

Issue Details

Issue Number 4564

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.9

Fixed Version 4.0.9

Milestone (none)

Software DependencyvBulletin 3.x

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

March 2, 2016 1:28 PM

pegasus

VaultWiki Team

In vault/install/lib/db/create/vw.php, find:

Code:

$listing = glob(vw_Hard_Core::get_dir() . '/controller/install/db/create/*', GLOB_ONLYDIR);

Replace with:

Code:

$listing = glob(vw_Hard_Core::get_dir('install') . '/db/create/*', GLOB_ONLYDIR);

Find:

Code:

				$class = $classname = 'Install/DB/Create/' . $li;
				vw_Hard_Core::locate_class('Controller', $class, $file);

Replace with:

Code:

				$class = $classname = 'DB/Create/' . $li;
				vw_Hard_Core::locate_class('Install', $class, $file);

In vault/install/lib/db/alter/vw.php, find:

Code:

$listing = glob(vw_Hard_Core::get_dir() . '/controller/install/db/alter/*', GLOB_ONLYDIR);

Replace with:

Code:

$listing = glob(vw_Hard_Core::get_dir('install') . '/db/alter/*', GLOB_ONLYDIR);

Find:

Code:

				$class = $classname = 'Install/DB/Alter/' . $li;
				$file = '';
				vw_Hard_Core::locate_class('Controller', $class, $file);

Replace with:

Code:

				$class = $classname = 'DB/Alter/' . $li;
				vw_Hard_Core::locate_class('Install', $class, $file);

In vault/install/lib/db/insert/vw.php, find:

Code:

$listing = glob(vw_Hard_Core::get_dir() . '/controller/install/db/insert/*', GLOB_ONLYDIR);

Replace with:

Code:

$listing = glob(vw_Hard_Core::get_dir('install') . '/db/insert/*', GLOB_ONLYDIR);

Find:

Code:

				$class = $classname = 'Install/DB/Insert/' . $li;
				vw_Hard_Core::locate_class('Controller', $class, $file);

Replace with:

Code:

				$class = $classname = 'DB/Insert/' . $li;
				vw_Hard_Core::locate_class('Install', $class, $file);

Run the following query:

Code:

DROP TABLE IF EXISTS vw_upgradelog

Refresh the main installer script and try again.

+ Reply

All times are GMT -4. The time now is 12:25 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: SELECT prefixid FROM `vb_vw_prefix` WHERE prefixid = 1;

Issue Tools