How can i disable read only option?
When I enter my site, there is problem with database connection: Error displaying the error page: Application Instantiation Error: The MySQL server is running with the --read-only option so it cannot execute this statement...
I checked conf file in Joomla directory. Everything is OK. And i ca'nt do nothing in phpMyAdmin.
Please help. How to disable Read Only option for Mysql Server ?
The same thing happened to the site I manage a day ago, but resolved itself after a few hours. It has happened again now.
I checked in mysqladmin and the server setting for 'read only' is showing up as 'on'.
Hopefully it will resolve itself again, but I would like to know why this happened and how to stop it.
The server I am on is 220.127.116.11 Are you on the same server?
Just been chatting to GoDaddy support. Looks other people have been reporting the problem since the 9th. They are working on it. No ETA.
I have just chatted with Godaddy support team. They answered that: ‘As per the error that were getting here, we currently have an ongoing issue about MySQL database. Our team is working on it now to fix the issue‘.
I am having the same issue...
"SQLSTATE[HY000]: General error: 1290 The MySQL server is running with the --read-only option so it cannot execute this statement"
Was working fine at 8:30 EST Friday Nov 11
Now receiving this error 7:00 EST Sat Nov 12
Also not impressed.
Also checked and Read Only variable set to ON
I will contact GoDaddy.
I have 6-7 sites in this server.
What did I do?
Opened new database.
Copied from SQL my database, witch I backed up 1 months ago (I can't backup current DB).
Edited configuration file of site.
Site is working...
But some of my sites still dead
Oh, I get it.
Creating a new database automatically chose a different server without asking!
I am trying your trick now. Thanks for the tip.