PDA

View Full Version : Table 'postindex' is read only


MichaelApproved
01 Sep 2009, 08:28
I got a bunch of errors similar to the following

----------------------------
Invalid SQL:

REPLACE INTO postindex
(wordid, postid, score, intitle)
VALUES
(121533, 606303, 1, 0), (123098, 606303, 1, 0);

MySQL Error : Table 'postindex' is read only
Error Number : 1036
---------------------------------

I restarted the mysql instance and everything is working ok.

My question is do i need to do anything to make up for these sql statements not being executed properly? Do I have to run a script to get postindex in sync with the rest of the db?

Marco van Herwaarden
01 Sep 2009, 08:36
No if it works again then there is nothing more to do.