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) »
  • DB function failed with error number 2006
Pages: [1]

Author Topic: DB function failed with error number 2006  (Read 3303 times)

asiams

  • Guest
DB function failed with error number 2006
February 25, 2010, 04:48:09 pm
Hello,

As I install, I received the following errors:

-----------------------------------------------------------------------------------

        * コンポーネント インストール: 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, '', 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, '', 1 )

        * 選択したファイルをコピーできません
        * JInstaller::install: コピー失敗: /home/qfyeqo/public_html/bibletoday/tmp/install_4b871882b2218/com_civicrm/civicrm.xml から /home/qfyeqo/public_html/bibletoday/administrator/components/com_civicrm/civicrm.xml
        * コンポーネント インストール: セットアップファイルをコピーできませんでした
        * 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

---------------------------------------------------------------------------


lcdweb

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1620
  • Karma: 116
    • www.lcdservices.biz
  • CiviCRM version: many versions...
  • CMS version: Joomla/Drupal
  • MySQL version: 5.1+
  • PHP version: 5.2+
Re: DB function failed with error number 2006
February 25, 2010, 05:02:54 pm
the MySQL server has gone away message suggests there are issues on your server. if this is running on shared hosting, it is likely the server is overloaded. you can google the error to find some suggested fixes. also try this fix, which helps improve the way Joomla handles db connections: http://remository.com/downloads/support-files/joomla-1.5/database-interfaces/

unfortunately, as it relates to Civi, it means your installation did not complete. if this is a new installation you should be able to uninstall and try to reinstall. if it's an upgrade, hopefully you made a backup because you will likely need to revert and rerun the upgrade script
support CiviCRM through 'make it happen' initiatives!
http://civicrm.org/mih

asiams

  • Guest
Re: DB function failed with error number 2006
February 25, 2010, 05:26:56 pm
Thank you for your quick reply.

I had to update my.cnf file for the requirement. I had restarted mysql, and I have to see what happens.

Question:  Is the installation process checking or using INNODB?

I am using Cpanel with Centos 4.8 i686 standard. Is there any way to upgrade PCRE?

Here is my installed PCRE on my machine:

Quote
# pcretest -C
PCRE version 4.5 01-December-2003
Compiled with
  UTF-8 support
  Newline character is LF
  Internal link size = 2
  POSIX malloc threshold = 10
  Default match limit = 10000000
  Match recursion uses stack

Thank you again.

lcdweb

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1620
  • Karma: 116
    • www.lcdservices.biz
  • CiviCRM version: many versions...
  • CMS version: Joomla/Drupal
  • MySQL version: 5.1+
  • PHP version: 5.2+
Re: DB function failed with error number 2006
February 25, 2010, 05:29:23 pm
yes, civi requires innodb.
support CiviCRM through 'make it happen' initiatives!
http://civicrm.org/mih

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • DB function failed with error number 2006

This forum was archived on 2017-11-26.