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?do=insertpm&pmid=14254
Referrer : http://www.kwas.ca/forum/private.php?do=newpm&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/forumdisplay.php?f=22&page=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]

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.

[Dismounted]

No, that's file space. This is MySQL space. Don't know if your host limits MySQL space so I can't be sure.

[Philster]

ISP advises me the MySQL database limit is currently at 70MB and our database is at 25MB. They have increased my database to 100MB and upped my basic sites storage just as a precaution for N/C. So having a 75MB buffer should eliminate this as a potential cause. Any other suggestions ? Thanks.

Phil.