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 22.214.171.124 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.