Issue: SQL-Error when open the WikiDomainManager

Issue Tools
- View Changes

February 2, 2009 1:00 AM
Storyteller

Junior Member
SQL-Error when open the WikiDomainManager

Hello,

when i open the WikiDomainManager i get the following SQL-error:

Code:

Invalid SQL: SELECT domainid, title, optionlist, forumlist, namespacelist, styleid FROM vb_3vault_domain; MySQL-Fehler : Table '25702m14551_3.vb_3vault_domain' doesn't exist Fehler-Nr. : 1146

Also the TABs are not shown correct (no TAB-borders) and the TAB-Links didn't work. Can the reason for that the error with the WikiDomainManager?

Greetings
Storyteller

Issue Details

Issue Number 378

Issue Type Bug

Project VaultWiki 3.x Series

Category Domains / Cookies

Status Fixed

Priority 5 - Minor Bugs / Small Tweaks

Affected Version 2.2.0

Fixed Version 2.2.0

Milestone (none)

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

February 2, 2009 1:30 AM

pegasus

VaultWiki Team

In phpmyadmin, or AdminCP -> Maintenance -> Execute SQL Query -> Manual Query, perform the following. Remember to replace {prefix} with your forum's TABLE_PREFIX:

Code:

 CREATE TABLE {prefix}vault_domain(
domainid INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
title VARCHAR( 255 ) NOT NULL DEFAULT '',
optionlist MEDIUMTEXT NOT NULL ,
forumlist TEXT NOT NULL DEFAULT '',
namespacelist TEXT NOT NULL DEFAULT '',
styleid INT( 11 ) NOT NULL DEFAULT '0',
languageid INT( 11 ) NOT NULL DEFAULT '0',
PRIMARY KEY ( domainid ) ,
UNIQUE title( title )
)

Fixed in the current ZIP.

Please post the tabs issue in a separate bug report, or I'll forget to look into it tomorrow.

February 2, 2009 2:07 AM

Storyteller Storyteller is offline

Junior Member

With the Code i get the following error in MySQL:

Code:

Fehler

SQL-Befehl:

CREATE TABLE vb_3vault_domaindomainid INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
title VARCHAR( 255 ) NOT NULL DEFAULT '',
optionlist MEDIUMTEXT NOT NULL DEFAULT 'a:0:{}',
forumlist TEXT NOT NULL DEFAULT '',
namespacelist TEXT NOT NULL DEFAULT '',
styleid INT( 11 ) NOT NULL DEFAULT '',
languageid INT( 11 ) NOT NULL DEFAULT '',
PRIMARY KEY ( domainid ) ,
UNIQUE title( title )

MySQL meldet: Dokumentation
#1064 - 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 'domainid INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
title VARCHAR(255) NOT NULL ' at line 2

Greetings
Storyteller

February 2, 2009 2:08 AM

pegasus

VaultWiki Team

I literally just edited the code. Please try again.

Reply

February 2, 2009 2:25 AM

Storyteller Storyteller is offline

Junior Member

New error:

Code:

 MySQL meldet: Dokumentation
#1101 - BLOB/TEXT column 'optionlist' can't have a default value

February 2, 2009 8:19 AM

pegasus

VaultWiki Team

ZIP updated. I tested the query again. For some reason there was still a very old development version in the install file (which I had just been copy & pasting here). Made some changes to a number of the default values and it works.

If anyone has trouble accessing the domain manager, please use the query below:

Code:

 CREATE TABLE {prefix}vault_domain(
domainid INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
title VARCHAR( 255 ) NOT NULL DEFAULT '',
optionlist MEDIUMTEXT NOT NULL ,
forumlist TEXT NOT NULL DEFAULT '',
namespacelist TEXT NOT NULL DEFAULT '',
styleid INT( 11 ) NOT NULL DEFAULT '0',
languageid INT( 11 ) NOT NULL DEFAULT '0',
PRIMARY KEY ( domainid ) ,
UNIQUE title( title )
)

February 2, 2009 10:01 AM

Storyteller

Junior Member

Thanks pegasus that fixed it!
The tabs issue is also "away", i had to change the vBulletin-setting for "Store CSS Stylesheets as Files?" to "Yes" and now it looks like befor.

Greetings
Storyteller

Reply
February 2, 2009 10:17 AM

pegasus

VaultWiki Team

Interesting. I will create another report for that shortly.

Reply
April 6, 2009 5:17 PM

Mokonzi

Senior Member

Just to let you know I'm still getting this error on 2.2.2.

Will try the fix shortly...

Reply
April 6, 2009 6:27 PM

pegasus

VaultWiki Team

This would only happen in 2.2.2 if you had installed 2.2.0 before the fix was released, and you never applied the fix.

Reply
April 7, 2009 3:08 AM

Mokonzi

Senior Member

The install package I used was 2.2.1 (unstable) on my main site, never 2.2.0.

Reply
April 7, 2009 3:25 AM

pegasus

VaultWiki Team

Were you able to successfully apply the fix?

Reply
April 8, 2009 10:13 AM

Mokonzi

Senior Member

Yeah, all is work great now.

Reply

+ Reply

All times are GMT -4. The time now is 12:08 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 when open the WikiDomainManager

Issue Tools