Drupal "The connection was reset"
Common Drupal problem when working localy with a remote dumped db
I'm working on this blog on a local computer at home. I usualy modify the design and activate couple of modules to see how they perform before putting them live. Every day i am using a fresh MySQL database dump from my hosting provider GoDaddy, because i want to make sure i'm working with the latest data possible.
Localy my Drupal is configured to work without any optimizations.
However, on the remote production server i have it configured with the following 'Performance' options at admin/settings/performance:
- Caching mode: Normal
- Page compression: Enabled
- Block cache: Enabled
- Optimize CSS files: Enabled
- Optimize JavaScript files: Enabled
What happened is that i dumped the live database on my local server and i got 'The connection was reset' in my browser when accessing http://ghita.org.local/
How to solve the problem
I used phpMyAdmin to browse to my database. Locate the `variable` table, then look for the following variable names: cache, page_compression, block_cache, preprocess_css, preprocess_js and reset them:
#reset the cache configuration UPDATE `variable` SET `value` = 's:0:"";' WHERE `name` = 'cache' LIMIT 1; UPDATE `variable` SET `value` = 's:0:"";' WHERE `name` = 'page_compression' LIMIT 1; UPDATE `variable` SET `value` = 's:0:"";' WHERE `name` = 'block_cache' LIMIT 1; UPDATE `variable` SET `value` = 's:0:"";' WHERE `name` = 'preprocess_css' LIMIT 1; UPDATE `variable` SET `value` = 's:0:"";' WHERE `name` = 'preprocess_js' LIMIT 1; #empty the cache tables (main ones) TRUNCATE `cache`; TRUNCATE `cache_block`; TRUNCATE `cache_content`;
After issuing this commands my local site started working.
Comments
Great article.
It worked great.
How can i find that variables????pls help me..i don't know how to use the program
After many unsuccessful attempts with other techniques, this did the trick. Thanks so much.
thanks man! worked great!
Fixed it! Thanks!
Excellent!
However, could you please explain what was happening?
This is what I current have in the "variable" table
cache s:1:"1";
page_compression s:1:"1";
block_cache s:1:"1";
preprocess_css s:1:"0";
preprocess_js s:1:"0";
Why is this generating a "connection was reset" message? What's wrong with this?
Thanks for your insight! :)
Hi ch_masson,
For the moment i can only reproduce this on Windows, and i cannot find anything in the Apache or PHP logs. I think it's a memory allocation problem.
Also take a look at http://drupal.org/node/752592
What theme are you using?
Thanks, really helped me.
Hey! Thanks for the hint! I've already lost a couple of days trying to solve this problem. By the way ... I love Drupal but sometimes .... I don't :).
Too many particular detalis ....
Anyway ... it s the best CMS ever!
Merci inca o data si spor la treaba!
I feel for you man. It takes some time to get "the Drupal way". You can shorten the path by checking out the videos at http://store.lullabot.com/. Spor!
Thanks man ...... it saved my time :)
This worked like a charm. I recovered from "connection reset" in no time, after finding this article. Great work!! People like you make drupal a great CMS. Thanks ver much.
-Saurabh
Thanks a bunch! Was ready to jump out the window when I found this... :)
Thanks a lot. It worked. I wasted lot of time on it.
thanks.. this was a solution for me as well...
It worked for me too..thanx
Like so many others here I was ready to [can't repeat that here] after 2 days of trying to get virtual hosts to work on Win7. Had no idea the problem would be lurking in the database!
Thanks much for sharing this info!
Michael Keara
@useradvocate
Hi,
I am unable to get this done as I am using durpal 7 and I think this was done for durpal 6.
I am using fatcow servers and their tech have given up on my problem saying its my isp and application issue not theirs.
I was hoping u can give pointers for d7 too.
Cheers,
Vishal
This is excellent. Thank you very much!!!
Post new comment