Log in

View Full Version : vBulletin Error - Error Number : 1036 Table 'vb_datastore' is read only


smooth-c
02-14-2009, 07:17 AM
Database error in vBulletin 3.8.0:

Invalid SQL:

REPLACE INTO vb_datastore
(title, data, unserialize)
VALUES
('birthdaycache', 'a:4:{s:4:\"day1\";s:10:\"2009-02-13\";s:4:\"day2\";s:10:\"2009-02-14\";s:6:\"users1\";a:2:{i:0;a:3:{s:6:\"userid\";s:4:\"1169\";s:8:\"username\";s:11:\"avant_garde\";s:3:\"age\";N;}i:1;a:3:{s:6:\"userid\";s:4:\"1040\";s:8:\"username\";s:5:\"Astlo\";s:3:\"age\";i:19;}}s:6:\"users2\";a:0:{}}', 1);

MySQL Error : Table 'vb_datastore' is read only

Request Date : Saturday, February 14th 2009 @ 09:09:30 AM
Error Date : Saturday, February 14th 2009 @ 09:09:31 AM
Script : http://www.maximum-jackson.com/discussion/index.php
Referrer :
IP Address : xxxxxxxxxx
Username : smooth-c
Classname : vB_Database
MySQL Version : 5.0.67-log

Marco van Herwaarden
02-14-2009, 10:51 AM
Do you get this error all the time, or was it a 1 time only error? If only once, it could be related to maintenance by your host (backup???).

Are you using MyIsam or InnoDB for this table?
Do you get similar errors on other tables?
Dd you do any maintenance on the database, or moved to a new server?
Do you store the datastore cache in the filesystem?