Support ⇒ Upgrades :: Archives ⇒ MySQL gone away :: Archived ⇒ Community Forums ⇒ CPG Dragonfly™ CMS
Forum IndexUpgrades

Archived ⇒ MySQL gone away


OK so I had my install up on a subdomain of dauntless.flippyhosting.com. My hosting plan is set to expire in a month so instead of staying on a shared hosting plan, I just setup a reseller account.

I switched my domain to the the new account so my site is still at dauntless.flippyhosting.com, just on a new server.

My problem is this. I uploaded the files to the new server, imported the database, changed the config to point to the new database. The site worked fine. But as I started to navagate through site more and more database errors are starting to pop up:

includes/db/db.php CMS Warning line 75: On /index.php While executing query "SELECT s.uname, s.module, s.url, u.user_allow_viewonline FROM cms_session AS s LEFT JOIN cms_users AS u ON u.username=s.uname WHERE guest=0 OR guest=2 ORDER BY s.uname" the following error occured: MySQL server has gone away In: /home/dauntles/public_html/blocks/block-User_Info.php on line: 29 CMS Warning line 75: On /index.php While executing query "SELECT uname, module, url FROM cms_session WHERE guest=1 OR guest=3" the following error occured: MySQL server has gone away In: /home/dauntles/public_html/blocks/block-User_Info.php on line: 30 CMS Warning line 75: On /index.php While executing query "SELECT COUNT(*) FROM cms_users WHERE user_regdate>='1198836000'" the following error occured: MySQL server has gone away In: /home/dauntles/public_html/blocks/block-User_Info.php on line: 97 CMS Warning line 75: On /index.php While executing query "SELECT COUNT(*) FROM cms_users WHERE user_regdate<'1198836000' AND user_regdate>='1198749600'" the following error occured: MySQL server has gone away In: /home/dauntles/public_html/blocks/block-User_Info.php on line: 98 CMS Warning line 75: On /index.php While executing query "SELECT username FROM cms_users WHERE user_active = 1 AND user_level > 0 ORDER BY user_id DESC LIMIT 1" the following error occured: MySQL server has gone away In: /home/dauntles/public_html/blocks/block-User_Info.php on line: 99 CMS Warning line 75: On /index.php While executing query "SELECT COUNT(*) FROM cms_users WHERE user_id > 1 AND user_level > 0" the following error occured: MySQL server has gone away In: /home/dauntles/public_html/blocks/block-User_Info.php on line: 100 CMS Warning line 75: On /index.php While executing query "SELECT a.uname, u.user_id FROM cms_session AS a LEFT JOIN cms_users AS u ON u.username = a.uname WHERE guest = 2 ORDER BY a.uname" the following error occured: MySQL server has gone away In: /home/dauntles/public_html/blocks/block-User_Info.php on line: 125 CMS Warning line 75: On /index.php While executing query "SELECT * FROM cms_GEM_settings WHERE gemSetID = '1'" the following error occured: MySQL server has gone away In: /home/dauntles/public_html/blocks/block-GEM_combined.php on line: 42 CMS Warning line 75: On /index.php While executing query "SELECT * FROM cms_GEM_events WHERE gemStartTime BETWEEN '1198853042' AND '1198800000' ORDER BY gemStartTime ASC" the following error occured: MySQL server has gone away In: /home/dauntles/public_html/blocks/block-GEM_combined.php on line: 59 CMS Warning line 75: On /index.php While executing query "SELECT * FROM cms_GEM_events WHERE gemStartTime BETWEEN '1198853042' AND '1199145599' ORDER BY gemStartTime ASC" the following error occured: MySQL server has gone away In: /home/dauntles/public_html/blocks/block-GEM_combined.php on line: 94 CMS Warning line 75: On /index.php While executing query "SELECT title, content, time FROM cms_blocks WHERE bid='13'" the following error occured: MySQL server has gone away In: /home/dauntles/public_html/blocks/block-Guild_Wall_of_Fame.php on line: 83 CMS Warning line 75: On /index.php While executing query "SELECT poll_id, poll_title, voters FROM cms_poll_desc WHERE artid=0 ORDER BY poll_id DESC LIMIT 0,1" the following error occured: MySQL server has gone away In: /home/dauntles/public_html/blocks/block-Survey.php on line: 27 CMS Warning line 75: On /index.php While executing query "SELECT * FROM cms_treas_cfg WHERE subtype = ''" the following error occured: MySQL server has gone away In: /home/dauntles/public_html/blocks/block-Donat_o_Meter.php on line: 25 CMS Warning line 75: On /index.php While executing query "SELECT business, COUNT( settle_amount ) AS count, SUM( settle_amount ) AS gross, SUM( settle_amount - mc_fee ) AS net, DATE_FORMAT( NOW( ) , '%M' ) AS mon, DATE_FORMAT( SUBDATE( DATE_FORMAT( ADDDATE( NOW( ) , INTERVAL 1 MONTH ) , '%Y-%c-1' ) , INTERVAL 1 DAY ) , ' %b %e' ) AS due_by, DATE_FORMAT( NOW( ) , '%b' ) AS mon_short FROM cms_treas_trans WHERE ( payment_date >= DATE_FORMAT( NOW( ) , '%Y-%m-6' ) ) GROUP BY business" the following error occured: MySQL server has gone away In: /home/dauntles/public_html/blocks/block-Donat_o_Meter.php on line: 51 CMS Warning line 75: On /index.php While executing query "SELECT * FROM cms_treas_cfg WHERE name='goal' AND subtype='Dec'" the following error occured: MySQL server has gone away In: /home/dauntles/public_html/blocks/block-Donat_o_Meter.php on line: 66 CMS Warning line 75: On /index.php While executing query "INSERT INTO cms_iptracking (ipusername, date_time, ip_address, hostname, page, ipcode, referer) VALUES ('Anonymous', '1198871027', ' �T/', 'c-24-12-173-84.hsd1.il.comcast.net', '/index.php', '200', '')" the following error occured: MySQL server has gone away In: /home/dauntles/public_html/modules/IP_Tracker/iptracking.inc on line: 68 CMS Warning line 75: On /index.php While executing query "SELECT COUNT(*) FROM cms_iptracking " the following error occured: MySQL server has gone away In: /home/dauntles/public_html/modules/IP_Tracker/iptracking.inc on line: 71

they all end with this MySQL server has gone away but I have no clue what I need to do to fix it or where to go to fix it.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/1.3.39/5.0.45/5.2.5/9.1.2.1


It only happen in you home page, check your center blocks.

.:: I met php the 03 December 2003 :: Unforgettable day! ::.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.6 / PHP 5.6 / DCVS


hmmm that seemed to fixit thanks.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/1.3.39/5.0.45/5.2.5/9.1.2.1


Excellent.

Make sure to read or forums rules, thanks.

.:: I met php the 03 December 2003 :: Unforgettable day! ::.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.6 / PHP 5.6 / DCVS


Nano, I too started seeing this "SQL server has gone away" errors. What should I do regarding the center blocks? I only started seeing this after upgrading to 9.1.2.1.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Devuan ascii / Apache 2.4.2x / MariaDB 10.x / PHP 7.0x / DF 9.8 (updated)


On his case he probably disabled fa faulty block, he answer sure doesn't help others.

On your case, since you are not providing any infos at all I can only give you an URL to MySQL Docs.

.:: I met php the 03 December 2003 :: Unforgettable day! ::.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.6 / PHP 5.6 / DCVS

All times are UTC