Error loading Modules:MySQL server has gone away

Need help installing Joomla! 1.5? For all Joomla! 1.5 installation issues please use this forum.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Post Reply
charkam
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Fri Jan 02, 2009 8:26 pm

Error loading Modules:MySQL server has gone away

Post by charkam » Fri Jan 02, 2009 8:30 pm

I moved my website (joomla 1.5 based) to a new host and I redeployed it using Joomlapack. The admin area is working fine and the installation was problemless but when I go to the front page, I get the following message about 20 times:
* Error loading Modules:MySQL server has gone away SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 1 OR mm.menuid = 0 ) ORDER BY position, ordering

I re-installed the website and tried various things but cannot get it to work. The config is as follow:
Database Version: 5.0.67-community
Database Collation: utf8_general_ci
PHP Version: 5.2.6
Web Server: Apache/2.0.63 (Unix) mod_ssl/2.0.63 OpenSSL/0.9.8b mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
Web Server to PHP interface: cgi
Joomla! Version: Joomla! 1.5.7 Production/Stable [ Wovusani ] 9-September-2008 23:00 GMT

Anybody got this message already and any idea to solve the problem???

Thanks!

Michela
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Wed Feb 04, 2009 4:56 pm

Re: Error loading Modules:MySQL server has gone away

Post by Michela » Wed Feb 04, 2009 5:03 pm

I have the same problem with joomla 1.5.9, phpbb3 and bridge.

help!!! :( :( :(

mavishay
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Mon Jan 28, 2008 2:43 pm

Re: Error loading Modules:MySQL server has gone away

Post by mavishay » Wed Feb 18, 2009 2:35 pm

Some problem Here :( >:( :-\

Iam using joomla 1.5.9.

on Localhost With Xampp its working fine
on remote sever the problem pops

User avatar
nafl99
Joomla! Apprentice
Joomla! Apprentice
Posts: 16
Joined: Fri Feb 03, 2006 4:51 am

Re: Error loading Modules:MySQL server has gone away

Post by nafl99 » Wed Feb 18, 2009 11:31 pm

I am working on something different; however, when I changed the tmp and the log server path in system configuration I get this error.

I am using Joomla 1.5.9 and Ipower is my host. Php 5.x is my version
The 360 Business Coach.
Free Business plan evaluation. Just create an account!
360agencies.com

vjtemplates
Joomla! Explorer
Joomla! Explorer
Posts: 314
Joined: Sat Dec 27, 2008 6:16 am
Location: LA
Contact:

Re: Error loading Modules:MySQL server has gone away

Post by vjtemplates » Thu Feb 19, 2009 5:25 am

Sounds like database error. From phpMyAdmin check if all the tables exist.
Joomla Templates & VirtueMart Themes

http://www.vjtemplates.com

scripcode
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Fri Jan 23, 2009 9:04 am

Re: Error loading Modules:MySQL server has gone away

Post by scripcode » Wed Apr 01, 2009 4:02 am

I have same problem. My server use MySql lower version than i use in localhost. Can it cause this error?
Thank's

Rusmadi

trecords
Joomla! Apprentice
Joomla! Apprentice
Posts: 20
Joined: Thu Jun 26, 2008 5:32 am

Re: Error loading Modules:MySQL server has gone away

Post by trecords » Wed Apr 08, 2009 10:30 am

I have this error too, but if disable cache it will work but site will slow down much more :(

trecords
Joomla! Apprentice
Joomla! Apprentice
Posts: 20
Joined: Thu Jun 26, 2008 5:32 am

Re: Error loading Modules:MySQL server has gone away

Post by trecords » Sat Apr 11, 2009 2:25 pm

My problem is not solved, please help me :(
It is 3 days my site gives this error and i can`t solve it. Disabling cache help me for a little time and then it is stared again.

SQL error:

Code: Select all

Error loading Modules:MySQL server has gone away SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 1 OR mm.menuid = 0 ) ORDER BY position, ordering
All tables are exist.

php error:

Code: Select all

Notice: Only variable references should be returned by reference in /home/trecords/public_html/libraries/joomla/application/module/helper.php on line 287
Notice: Trying to get property of non-object in /home/trecords/public_html/libraries/joomla/application/module/helper.php on line 92
I realy need help.

deleterios
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Tue Jul 21, 2009 2:03 pm

Re: Error loading Modules:MySQL server has gone away

Post by deleterios » Tue Jul 21, 2009 2:18 pm

I have the same problem :'(

Code: Select all

JDatabaseMySQL::query: 2006 - MySQL server has gone away SQL=SELECT id, title, module, position, content, showtitle, control, params FROM ot_modules AS m LEFT JOIN ot_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 2 AND m.client_id = 0 AND ( mm.menuid = 13 OR mm.menuid = 0 ) ORDER BY position, ordering

Call stack
# 	Function 	Location
1 	JSite->render() 	/home/herbergeur/domains/nom_de_domaine.fr/public_html/joomla/index.php:79
2 	JDocumentHTML->render() 	/home/herbergeur/domains/nom_de_domaine.fr/public_html/joomla/includes/application.php:168
3 	JDocumentHTML->_loadTemplate() 	/home/herbergeur/domains/nom_de_domaine.fr/public_html/joomla/libraries/joomla/document/html/html.php:246
4 	require_once() 	/home/herbergeur/domains/nom_de_domaine.fr/public_html/joomla/libraries/joomla/document/html/html.php:338
5 	include_once() 	/home/herbergeur/domains/nom_de_domaine.fr/public_html/joomla/templates/joomla_template/index.php:13
6 	JDocumentHTML->countModules() 	/home/herbergeur/domains/nom_de_domaine.fr/public_html/joomla/templates/joomla_template/lib/php/yoolayout.php:101
7 	JModuleHelper->getModules() 	/home/herbergeur/domains/nom_de_domaine.fr/public_html/joomla/libraries/joomla/document/html/html.php:272
8 	JModuleHelper->_load() 	/home/herbergeur/domains/nom_de_domaine.fr/public_html/joomla/libraries/joomla/application/module/helper.php:88
9 	JDatabaseMySQL->loadObjectList() 	/home/herbergeur/domains/nom_de_domaine.fr/public_html/joomla/libraries/joomla/application/module/helper.php:285
10 	JDatabaseMySQL->query() 	/home/herbergeur/domains/nom_de_domaine.fr/public_html/joomla/libraries/joomla/database/database/mysql.php:458
11 	JError->raiseError() 	/home/herbergeur/domains/nom_de_domaine.fr/public_html/joomla/libraries/joomla/database/database/mysql.php:231
12 	JError->raise() 	/home/herbergeur/domains/nom_de_domaine.fr/public_html/joomla/libraries/joomla/error/error.php:171
13 	JException->__construct() 	/home/herbergeur/domains/nom_de_domaine.fr/public_html/joomla/libraries/joomla/error/error.php:136

nvdmaas
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Wed Nov 11, 2009 12:48 pm

Re: Error loading Modules:MySQL server has gone away

Post by nvdmaas » Wed Nov 11, 2009 12:50 pm

I had the same problem when transferring from my site on wamp server to an online server. But, when I turned on my cache settings in global configuration, everything is fine!

trecords
Joomla! Apprentice
Joomla! Apprentice
Posts: 20
Joined: Thu Jun 26, 2008 5:32 am

Re: Error loading Modules:MySQL server has gone away

Post by trecords » Wed Nov 11, 2009 1:49 pm

My web server replied me that this error happens because of many articles in my database. Also i published all articles on frontpage and it loads server too much and MySQL can`t load too more database and gives that error. I recommend to unpublish your articles and keep maximum 5000 one.

User avatar
timtecsa
Joomla! Apprentice
Joomla! Apprentice
Posts: 48
Joined: Mon Oct 16, 2006 10:17 am
Location: France
Contact:

Re: Error loading Modules:MySQL server has gone away

Post by timtecsa » Tue Jan 19, 2010 5:59 am

I seem to have similar problem but only when selecting the section with largest content. http://gpm.tecsa.com/index.php?option=c ... Itemid=181

I have tried unpublishing a few hundred of the oldest articles but no change.
Any ideas?
Should I try updating to 1.5.15?

PHP Built on: Linux infong 2.4 #1 SMP Wed Nov 4 21:12:12 UTC 2009 i686 GNU/Linux
Database Version: 5.0.81-log
Database Collation: utf8_general_ci
PHP Version: 5.2.12
Web Server: Apache
Web Server to PHP interface: cgi
Joomla! Version: Joomla! 1.5.14 Stable [ Wojmamni Ama Naiki ] 30-July-2009 23:00 GMT
User Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_8; en-US) AppleWebKit/532.5 (KHTML, like Gecko) Chrome/4.0.249.49 Safari/532.5

Update:

I seem to be over my MySQL server limit on db267678576

Database Name
Used Storage Space
Total Storage Space
Available Storage Space
db267678576 123.7 MB 100 MB -23.7 MB
db297329791 23.53 MB 100 MB 76.47 MB

I guess that will do it. :( With 10,000+ articles the SQL limit is bust. No offers to increase from 1and1 so far.


Post Reply

Return to “Installation 1.5”