PDA

View Full Version : Table 'postindex' is read only


MichaelApproved
09-01-2009, 07:28 AM
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
09-01-2009, 07:36 AM
No if it works again then there is nothing more to do.