PDA

View Full Version : Anyone seen this database error before?


BigJohnny
01-12-2007, 02:13 PM
Ya i just got an email about this lastnight, And i dont know why

[QUOTE]
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' smiliecache','bbcodecache','noavatarperms');

MySQL Error : Can't find file: './*********/datastore.frm' (errno: 13)
Error Number : 1017
Date : Thursday, January 11th 2007 @ 09:25:25 PM
Script : http://**********/***/calendar.php?c=1&week=1160870400
Referrer : http://www.google.pl/search?q=vb-fxp&ie=utf-8&oe=utf-8&rls=org.mozilla:pl:official&client=firefox-a
IP Address : ***.***.***.***
Username :
Classname : vb_database
[/CODE]

noppid
01-12-2007, 04:47 PM
Looks like the table is damaged. Try a repair in phpmyadmin or whatever you have handy.

You may want to invetory your backups and or do another first JIC.

blind-eddie
01-12-2007, 08:03 PM
Ok My turn, I just got one also, what does this mean?....

Database error in vBulletin 3.6.4:

Invalid SQL:

INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
VALUES
('33ab7abe21c100db9382aef2c1f329f2', 34, '68.143.186.146', 'ca6480cd20266d9b84b2a8ce25c9f8dd', 1168635816, '/', 0, 0, 1, 0, 0, 0, 0, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.9) Gecko/20061206 Firefox/1.5.0.9', 0, 0);

MySQL Error : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Error Number : 2002
Date : Friday, January 12th 2007 @ 02:03:37 PM
Script : http://outerzone.us/
Referrer :
IP Address : --------------
Username : ---------------
Classname : vb_database


--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.410 / Virus Database: 268.16.10/624 - Release Date: 1/12/2007

Adrian Schneider
01-12-2007, 08:43 PM
Ya i just got an email about this lastnight, And i dont know why


SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' smiliecache','bbcodecache','noavatarperms');

MySQL Error : Can't find file: './*********/datastore.frm' (errno: 13)
Error Number : 1017
Date : Thursday, January 11th 2007 @ 09:25:25 PM
Script : http://**********/***/calendar.php?c=1&week=1160870400
Referrer : http://www.google.pl/search?q=vb-fxp&ie=utf-8&oe=utf-8&rls=org.mozilla:pl:official&client=firefox-a
IP Address : ***.***.***.***
Username :
Classname : vb_database
As noppid said, the table is damaged and you need to repair it.Ok My turn, I just got one also, what does this mean?....

Database error in vBulletin 3.6.4:

Invalid SQL:

INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
VALUES
('33ab7abe21c100db9382aef2c1f329f2', 34, '68.143.186.146', 'ca6480cd20266d9b84b2a8ce25c9f8dd', 1168635816, '/', 0, 0, 1, 0, 0, 0, 0, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.9) Gecko/20061206 Firefox/1.5.0.9', 0, 0);

MySQL Error : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Error Number : 2002
Date : Friday, January 12th 2007 @ 02:03:37 PM
Script : http://outerzone.us/
Referrer :
IP Address : --------------
Username : ---------------
Classname : vb_database


--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.410 / Virus Database: 268.16.10/624 - Release Date: 1/12/2007Kind of unrelated... should create a new thread next time.

The error means PHP cannot connect to MySQL for whatever reason.

(its down, network problems, etc)

Kirk Y
01-12-2007, 10:27 PM
I get BigJohnny's error all the time on our test board, when the MySQL is down.