My Sites Have Become "Read Only"

NotSure - January 1, 2009 - 00:47

I may be having the same trouble as this http://drupal.org/node/350565

My web sites have become "read-only." Doing ANYTHING at them which should push some info in the database gives only a page refresh, with no feedback.

I upgraded from various versions of 5 to 5.14, things seemed fine, I dumped all the databases as a backup (numerous times along the process).

Some of the sites I updated to 6.8 and ran in a multisite configuration. Those sites seemed to work fine and the upgrades in Drupal 6 were nice. I try to run as lean sites as possible without any additional modules: KISS.

I had two sites with some modules that have not yet been updated for Drupal 6, so I decided to to a multisite config for them. These two Drupal 5 sites never recovered. I feel certain the databases are not corrupt since I can load them in MAMP and they seem fine. But when everything is set up at my host GoDaddy.com, the sites have become "read-only." I can access the sites, read the content, but when I try to log in, the login page merely refreshes.

So after this pain (and days of trying various things to work), I decided to put one of them in to Drupal 6.8.

At first everything seemed fine. I could log in, and change any settings, all my other Drupal 6.8 sites seemed fine too. I logged out of all but one Drupal 6.8 site and went to bed in the wee hours.

Later, when I got up and tried to access my sites, I found ALL of those sites had become "read-only." Logging in just brought a refresh of the page, no feedback.

The one site I am still logged in to, shows no errors in the /admin/reports/status or /admin/reports/dblog. I am running on Apache, php 4.3.11 and mySQL 5.0.67. My php.ini file sets aside 30MB RAM. There are only two modules in my sites/all/modules folder (cck, and views, most recent versions, and I don't think they are turned on since I don't need them at the moment), and no modules in any of the individual sites modules folders.

Even if I go in to phpMyAdmin and to the sessions table, find my IP and set the User ID as 1, it does give me admin access to the web site, but I am stuck with everything being read only. NONE of my changes stick.

I am suspicious that GoDaddy.com has done something, but I don't know what. They inform me they won't troubleshoot scripting issues, but I do not believe this is directly a Drupal issue as I was completely in control of my 6.8 sites, then a few hours later all of them become read only.

My sites are tiny. All my databases are less than 2 MB. Of course all of this just makes me wish I had the servers in my own space where I was in control of all the variables, but...

Why have all my sites become read-only?

(I have emptied the browser cache incessantly, and tried other browsers, and the outcome is the same. I tried the method described on this page and that didn't work either.)

All help appreciated! TIA

Read only database

myke - January 1, 2009 - 03:10

I had an issue before, similar to this, where the databases became read only..

-Myke

Was caused by doing backups..

myke - January 1, 2009 - 03:21

I should also mention, it happened when I exported the database.. for some reason they didn't get switched back from read only.. The tables were locked.. I had to UNLOCK TABLES to get it to work again...

-Myke

How do I see if the tables

NotSure - January 1, 2009 - 03:53

How do I see if the tables are locked or unlocked? I am looking at my database with phpMyAdmin now.

Try UNLOCK TABLES

myke - January 3, 2009 - 21:38

Try issuing an UNLOCK TABLES command. I'm not sure where phpMyAdmin would tell you the table status, maybe somebody else here can tell you?

-Myke

I'm still not exactly sure

NotSure - January 5, 2009 - 05:19

I'm still not exactly sure what the problem was. I strongly suspect my hosting environment was up to something; stuff beyond my control and so under the hood I could not see it. Basically I called them and asked them to reset it, which they could not do, but instead they cancelled that account. Prorated what I had paid, and set up a new account.

This new account has mysqli (which the old one did not have), and seems to have been beefed up in other ways. So far I'm managing to get one of my sites back online.

Only one of my sites has significant content on it, and I can't say I'm eager to copy/paste 100 posts and set the dates... so I'll be experimenting with how I can get that back online, I'm not sure I trust the db dump from it...

Needless to say this has caused me to read up on and experiment with Open/Net/FreeBSD to see about having my own server which I control the variables, and I tell myself what's going on, and what upgrades I'm performing. :-)

 
 

Drupal is a registered trademark of Dries Buytaert.