By NotSure on

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

⋅ Categories: Drupal 4.7.x, Drupal 5.x, Drupal 6.x

Comments

myke’s picture

myke commented

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

-Myke

myke’s picture

myke commented

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

NotSure’s picture

NotSure commented

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

myke’s picture

myke commented

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

NotSure’s picture

NotSure commented

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. :-)

myke’s picture

myke commented

I found a cause for read only sites:

in the .htaccess, under the mod_php5.c section:

<IfModule mod_php5.c>
  php_flag magic_quotes_gpc                 off
  php_flag magic_quotes_sybase              off
  php_flag register_globals                 off
  php_flag session.auto_start               off
  php_value mbstring.http_input             pass
  php_value mbstring.http_output            pass
  php_flag mbstring.encoding_translation    off
  php_value memory_limit				128M
  php_value mail.force_extra_parameters -femail@domain.com
  #php_value error_reporting 2047
  #php_value display_errors off
  php_value upload_max_filesize 10M
  php_value post_max_size 20M
</IfModule>

This is how the section SHOULD appear (I've made some personalizations for debugging and larger file uploads...

If you edit it, and make the mistake of NOT putting on it's own line, as shown below, caused the site to go read only. I could pull up ANY page just fine, but anything that modified the database, would NOT work. I really hope this saves someone else the hours of aggravation it took me to find it years ago! Just check the .htaccess file if you make changes to it.

<IfModule mod_php5.c>
  php_flag magic_quotes_gpc                 off
  php_flag magic_quotes_sybase              off
  php_flag register_globals                 off
  php_flag session.auto_start               off
  php_value mbstring.http_input             pass
  php_value mbstring.http_output            pass
  php_flag mbstring.encoding_translation    off
  php_value memory_limit				128M
  php_value mail.force_extra_parameters -femail@domain.com
  #php_value error_reporting 2047
  #php_value display_errors off
  php_value upload_max_filesize 10M
  php_value post_max_size 20M</IfModule>
ArsRover’s picture

ArsRover commented

Myke, your solution and suggestion is fantastic in it's unpredictability!
Registered specially to THANK YOU!

Had the same problem - the site going Read-Only suddenly. Browsed over discussions, but nothing was right for me. The strange thing in my case is that the site went Read-Only when I was not tweaking it, hours after the last manipulation. I tries database recoveries without success.

Now I rolled back the .htaccess file and everything is fixed!

I had not the problem you describe - on the same line with a parameter, but definitely another one. But now that the issue is localized I can investigate it!

Thanks a lot!
I wonder how you found the bug!

myke’s picture

myke commented

Specifically, this issue is related, in my case, to post_max_size being misread in .htaccess... others might cause similar behavior, but display_errors did not...