Home Private Messages Search
CPG Dragonfly™ CMS Dedicated Server & Bandwidth Sponsored by DedicatedNOW
Toggle Content
 
Forums ⇒ Miscellaneous ⇒ Server Chat ⇒ [solved] Error: MySQL server has gone away


[solved] Error: MySQL server has gone away
Talk about good (DedicatedNOW) and bad (AdventureHost) hosts, or any other question about servers and hosting, but no advertising or pricing in any form.
Post new topic    Reply to topic    Printer Friendly Page     Forum Index ⇒  Server Chat

View previous topic :: View next topic  
Author Message
BobCat
Nice poster
Nice poster

Offline Offline
Joined: Apr 03, 2008
Posts: 85
Location: Gold Coast, Australia
PostPosted: Sun Apr 18, 2010 10:42 pm
Post subject: [solved] Error: MySQL server has gone away

Code::
On /Downloads/get=117.html
While executing query "DELETE FROM cms_session WHERE time<1271592286"

the following error occured: MySQL server has gone away

In: /home/xxxx/public_html/includes/classes/session.php on line: 173

I keep getting this error, MySQL server has gone away
Anyone one know what might be causing this?

Only started in last month or so but getting more of them each day.


BobCat's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/Apache2.2.16/MySQL5.0.91/PHP5.2.14/DF9.2.3.3
Back to top
View user's profile Visit poster's website
InspectorClueNo
Heavy poster
Heavy poster

Offline Offline
Joined: Mar 26, 2008
Posts: 211

PostPosted: Mon Apr 19, 2010 12:48 am
Post subject: Re: SQL Error

in cmsinit.php

somewhere, after database and session classes are activated try
PHP:
register_shutdown_function('df_close');

function
df_close() {
global
$SESS, $db;
$SESS->write_close();
$db->sql_close();
}


InspectorClueNo's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
none available
Back to top
View user's profile Visit poster's website
BobCat
Nice poster
Nice poster

Offline Offline
Joined: Apr 03, 2008
Posts: 85
Location: Gold Coast, Australia
PostPosted: Wed Apr 21, 2010 11:04 am
Post subject: Re: SQL Error

Problem solved!

Turns out the Host moved files to another server in which the MySQL had low memory setting
Thanks for the input though.


BobCat's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/Apache2.2.16/MySQL5.0.91/PHP5.2.14/DF9.2.3.3
Back to top
View user's profile Visit poster's website
Display posts from previous:   
Post new topic    Reply to topic    Printer Friendly Page    Forum Index ⇒  Server Chat
Page 1 of 1
All times are GMT



Jump to:  


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum


 
   Toggle Content User Info

Welcome Anonymous

Nickname
Password
(Register)

   Toggle Content Last CVS commits
· Fixed .ico Expires header.
· Removed domain name from cookies so subdomains wont access them anymore.
· CSS and JS, case insensitives.
· CSS and JS, send correct HTTP 1.1 headers and fixed issues where themes and...
· Further security class improvements.
· 301 redirects on LEO changes
· Option to force 3xx http status codes
· Validate googlebot.com and google.com crawlers.
· CCBot
· Rss with etag and atom.

read more...

   Toggle Content Community

Support for DragonflyCMS in a other languages:

Deutsch
Español

   Toggle Content X-links
UltraEdit Browse Happy logo Firefox MySQL PostgreSQL Valid CSS! Valid XHTML 1.0! Unicode Encoded Badge NukeBiz Resources Raven DragonflyCMS Dedicated Now InsideSupport Lampe Berger

You are seeing squares or questionmarks on this page?

All content of this website is copyrighted by the Creative Commons NC-SA
The logos and trademarks used on this site are the property of their respective owners
We are not responsible for comments posted by our users, as they are the property of the poster.
Our server runs on a P3 1.2GHz with 512MB RAM with no accelerators
Support GoPHP5.org
Interactive software released under GNU GPL, Code Credits, Privacy Policy