Hi,
I'm having a problem with MySQL on our webserver. The problem is that I keep getting #1036 errors, 'Table '#sql_xxx' is read only'.
For example:
Error which occured on 10:36:31 AM:
Query:
SELECT * FROM tablename WHERE id = '118' AND status != '3'
Error:
Table '#sql_1564_0' is read only
Error which occured on 10:37:43 AM:
Query:
SELECT * FROM tablename WHERE id = '118' AND status != '3'
Error:
Table '#sql_1564_0' is read only
It seems to me that this error occurs when multiple users are trying to select data from the same table. MySQL tries to use the same temporary table.
Please help :queasy:
