CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • MySQL Errors on Install
Pages: [1] 2

Author Topic: MySQL Errors on Install  (Read 5375 times)

kecker

  • I’m new here
  • *
  • Posts: 28
  • Karma: 1
MySQL Errors on Install
February 10, 2009, 01:00:14 am
First the details for my install:
Joomla  1.5.9
CiviCRM  2.1.4
Apache  2.2.11
Linux  2.6.27
MySQL  5.0.67
PHP  5.2.8

When I attempt to install in Joomla from directory, I get the following error:

Quote
        * Component Install: DB function failed with error number 2006
          MySQL server has gone away SQL=INSERT INTO jos_components VALUES( 0, 'CiviCRM', 'option=com_civicrm', 0, 0, 'option=com_civicrm', 'CiviCRM', 'com_civicrm', 0, 'js/ThemeOffice/component.png', 0, 'task=civicrm/profile\nreset=1\n', 1 )
          SQL =

          INSERT INTO jos_components VALUES( 0, 'CiviCRM', 'option=com_civicrm', 0, 0, 'option=com_civicrm', 'CiviCRM', 'com_civicrm', 0, 'js/ThemeOffice/component.png', 0, 'task=civicrm/profile\nreset=1\n', 1 )

        * Error Loading ModulesMySQL 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 <= 2 AND m.client_id = 1 ORDER BY position, ordering

Some PHP/MySQL values:
Quote
open_basedir   no value
memory_limit   32M
max_execution_time   30
mysql.connect_timeout   60

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: MySQL Errors on Install
February 10, 2009, 01:18:17 am
Quote
* Error Loading ModulesMySQL server has gone away

You get this kind of errors due to server issues.

Kurund
Found this reply helpful? Support CiviCRM

kecker

  • I’m new here
  • *
  • Posts: 28
  • Karma: 1
Re: MySQL Errors on Install
February 10, 2009, 02:38:37 pm
Any idea how to fix/work around said server issues?

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: MySQL Errors on Install
February 10, 2009, 09:43:00 pm
Quote
Any idea how to fix/work around said server issues?

No idea, may be you should check with server support.

Kurund
Found this reply helpful? Support CiviCRM

kecker

  • I’m new here
  • *
  • Posts: 28
  • Karma: 1
Re: MySQL Errors on Install
February 10, 2009, 10:59:30 pm
server support suggested increasing max execution time and memory limit.  I did to the following:

max_execution_time   1000
max_input_nesting_level   64
max_input_time   1000
memory_limit   128M

Still no success.  Same error.

It creates the com_civicrm folder in the components area of the administrator folder but not in the regular components folder.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: MySQL Errors on Install
February 11, 2009, 06:00:48 am

most likely it did not change yoour max execution time. Do a phpinfo( ) and see if the changes took place

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

kecker

  • I’m new here
  • *
  • Posts: 28
  • Karma: 1
Re: MySQL Errors on Install
February 11, 2009, 08:35:34 am
phpinfo is where I got the values I listed above.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: MySQL Errors on Install
February 11, 2009, 08:40:42 am

sorry cant help any more with this one :(

you might want to read: http://www.josephburford.com/2008/06/joomla-error-number-2006-mysql-server-has-gone-away/

and see if the my.cnf suggestion at the end helps

let us know if you manage to resolve it and how

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

kecker

  • I’m new here
  • *
  • Posts: 28
  • Karma: 1
Re: MySQL Errors on Install
February 11, 2009, 11:08:38 am
Will try that....

If that doesn't work, any way to manually install things or anything like that??

Chris Burgess

  • Ask me questions
  • ****
  • Posts: 675
  • Karma: 59
Re: MySQL Errors on Install
February 11, 2009, 11:27:11 am
If CiviCRM doesn't install correctly on your current hosting setup, you might want to ask your provider if they have a specific plan which supports CiviCRM's requirements.

Generally you'll need a shade more RAM than is offered on many shared hosting setups; search the forum for "shared hosting" to see some other discussion of this. (I'm guessing this may apply to you based on the issues you're describing, but it's not a given.)

If your hosting provider aren't able to improve the service you may need to look at some alternative hosting providers, and these links may help.

  • CiviCRM hosting forum on this site
  • CiviCRM hosting provider info in CiviCRM wiki (some listings may be outdated, check with providers)
  • CiviCRM professionals listed on main CiviCRM website
« Last Edit: February 11, 2009, 11:31:09 am by xurizaemon »
@xurizaemon ● www.fuzion.co.nz

kecker

  • I’m new here
  • *
  • Posts: 28
  • Karma: 1
Re: MySQL Errors on Install
February 11, 2009, 11:30:35 am
Well their servers DO meet CiviCRM's published server requirements.  I list mine up above.   I've seen no indication elsewhere that the server I'm already on shouldn't work.

I have an older version of CiviCRM running elsewhere on the same server, it's just the install script that doesn't appear to work.

Chris Burgess

  • Ask me questions
  • ****
  • Posts: 675
  • Karma: 59
Re: MySQL Errors on Install
February 11, 2009, 11:36:09 am
My apologies - I thought the server requirements link would also specify some minimal server configurations for performance, but it doesn't.

While your host do have the correct versions of software, the error message you post

Code: [Select]
MySQL server has gone away

indicates that the connection between the DB server and PHP was dropped. Generally this will happen when the server isn't able to handle the amount of activity of the request, or the DB server is tied up with other requests.

It may not be that CiviCRM's requirements have changed, but rather that the load on your server has gone up since you last installed.

You could try repeating the install when the server is less busy.

Who are you hosting with?
@xurizaemon ● www.fuzion.co.nz

kecker

  • I’m new here
  • *
  • Posts: 28
  • Karma: 1
Re: MySQL Errors on Install
February 11, 2009, 11:44:00 am
Site5 is my current host

http://www.site5.com

I tried getting support from them and they did try for awhile, but have since indicated that they don't see anything wrong from their end and that I should seek support from the developers of the script.  Although they indicated they'd be welcome to suggestions/evidence from the developers on how the problem could be fixed.

Chris Burgess

  • Ask me questions
  • ****
  • Posts: 675
  • Karma: 59
Re: MySQL Errors on Install
February 11, 2009, 12:06:19 pm
I think the my.cnf changes in the link Lobo posted above might work, but there's no guarantee your host will be ready to make changes at the DB level for a single hosted site.

Looks from that page like Joomla begins the install, then goes off to FTP land to place the files. Once that's done it resumes the MySQL installation, and if there are a lot of files then you might see MySQL "go away" before Joomla can get back to work.

So:

1. I seem to remember that there's a way to upload the component via FTP, rather than via Joomla's web interface. Have you tried this? (You may find it's already uploaded after the first attempt.) That might prevent the delay taking place. If it works for you, please post back - it may be a useful addition to the Joomla install docs to know that this workaround exists.

2. You could chase your hosting provider and ask for them to make the my.cnf changes in the link Lobo posted. Because this change might affect all sites on the same shared server, I expect you'll have more chance of achieving (1), so try that first.
@xurizaemon ● www.fuzion.co.nz

kecker

  • I’m new here
  • *
  • Posts: 28
  • Karma: 1
Re: MySQL Errors on Install
February 11, 2009, 12:08:54 pm
By #1 are you referring to uploading the unzipped install to the server and installing from directory??  If so yes, that's what I'm currently trying.

If you're referring to something else, then I'm interested.  I'm just not sure what you're referring to.

But yeah, I'll have to go through that link later tonite and see if I can get that method to work.
Pages: [1] 2
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • MySQL Errors on Install

This forum was archived on 2017-11-26.