Help Finding This Error

[Philster]

Hi folks, every once in a while I get some e-mails that there have been some database errors. Here is an example. They all look like the message below. Could someone help me look into this and a possible solution please. I have 3 plug ins in use. They are Add On Chat 1.1.0, Guest Tracking 1.13 and Separate Sticky and Normal Threads 1.0.5. Thank you.

Database error in vBulletin 3.6.3:

Invalid SQL:

CREATE TABLE IF NOT EXISTS scwho (
ID INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
USERNAME CHAR(255),
SUBROOM CHAR(255),
HIDDEN INT UNSIGNED,
UID INT UNSIGNED,
ADMIN INT UNSIGNED);

MySQL Error : Can't create table 'scwho' (errno: 13) Error Number : 1005
Date : Saturday, January 13th 2007 @ 10:50:47 PM
Script : http://www.kwas.ca/forum/private.php...tpm&pmid=14254
Referrer : http://www.kwas.ca/forum/private.php...wpm&pmid=14254
IP Address : 70.49.30.73
Username : john
Classname : vb_database

Phil.

[Dismounted]

Does your MySQL user (set in config.php) have create permissions?

[Kirk Y]

Yeah, errno 13 is -- I believe -- a write permissions error.

[Philster]

I have to appolgize, I cannot see MySQL user in my config.php file. Is there a particular string of text I should be looking for ? Thank you for your quick reply.

Phil.

Hi gang, could one of you post exactly what this MySQL user string will look like in my config.php file ? I'd sure like to track this down. Thank you.

Phil.

[Philster]

Hey fella's any further thoughts on this would be appreciated if you have a moment. Thanks a bunch.

Phil.

[Philster]

I'm still getting this error. Could one of you maybe elaborate more on it so I can fix it. Thanks a bunch.

Database error in vBulletin 3.6.3:

Invalid SQL:

CREATE TABLE IF NOT EXISTS scwho (
ID INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
USERNAME CHAR(255),
SUBROOM CHAR(255),
HIDDEN INT UNSIGNED,
UID INT UNSIGNED,
ADMIN INT UNSIGNED);

MySQL Error : Can't create table 'scwho' (errno: 13) Error Number : 1005
Date : Friday, January 19th 2007 @ 10:49:30 PM
Script : http://www.kwas.ca/forum/forumdispla...=11&order=desc
Referrer : http://www.kwas.ca/forum/forumdisplay.php?f=22
IP Address : 64.231.8.172
Username : taiwan_reef223
Classname : vb_database

[paul41598]

If MySQL reports an error number 1005 from a CREATE TABLE statement, and the error message refers to errno 150, table creation failed because a foreign key constraint was not correctly formed

Also check your disk space. Only two things I can think of

[Philster]

Thanks Paul 41598. Please do not take this the wrong way but could you explain this in laymans terms please. Thank you.

Phil.

[MThornback]

What hes saying is that your Database(s) might be pushing the limit of your hosting storage...if for example you had a 100MB limit and the table your trying to put you at 101MB, it wouldn't allow you to create the table your asking it to

[Philster]

Originally Posted by MThornback

What hes saying is that your Database(s) might be pushing the limit of your hosting storage...if for example you had a 100MB limit and the table your trying to put you at 101MB, it wouldn't allow you to create the table your asking it to

Thank you, now that I can fully understand My limit is 500MB file space and I'm only using 65MB, 25MB of which is our forums database. I presume this would not apply to my issue then. Any other thoughts? Thank you for your reply.

Phil.