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 »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • installation crashes with error
Pages: [1] 2

Author Topic: installation crashes with error  (Read 3282 times)

Pauln60

  • I’m new here
  • *
  • Posts: 21
  • Karma: 0
  • CiviCRM version: 4.1
  • CMS version: Drupal 6
  • MySQL version: 14.2
  • PHP version: 5.38
installation crashes with error
January 28, 2015, 12:49:59 pm
I have a virgin Drupal install and I'm adding CiviCRM to it - Drupal installed ok, CiviCRM bombed with this message -
thanks in advance for any ideas (Drupal 7.34, CiviCRM 4.5.5).

Paul N.

==

Initialization Error

Array
(
    [callback] => Array
        (
            
  •  => CRM_Core_Error
    • [1] => simpleHandler
            )

       
Code: [Select]
=> -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => SELECT *,  config_backend 
 FROM civicrm_domain
 
 WHERE (  civicrm_domain.id = 1 ) 
 
 
 
 [nativecode=1146 ** Table 'settle_civicrm.civicrm_domain' doesn't exist]
    [type] => DB_Error
    [user_info] => SELECT *,  config_backend 
 FROM civicrm_domain
 
 WHERE (  civicrm_domain.id = 1 ) 
 
 
 
 [nativecode=1146 ** Table 'settle_civicrm.civicrm_domain' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info="SELECT *,  config_backend 
 FROM civicrm_domain
 
 WHERE (  civicrm_domain.id = 1 ) 
 
 
 
 [nativecode=1146 ** Table 'settle_civicrm.civicrm_domain' doesn't exist]"]
)
[/pre]

jaapjansma

  • I post frequently
  • ***
  • Posts: 247
  • Karma: 9
    • CiviCoop
  • CiviCRM version: 4.4.2
  • CMS version: Drupal 7
  • MySQL version: 5
  • PHP version: 5.4
Re: installation crashes with error
January 29, 2015, 12:50:59 am
Do you install CiviCRM from Drupal? Previous versions of CiviCRM could only by installed outside of Drupal by accessing: http://yoursite/sites/all/modules/civicrm/install

Developer at Edeveloper / CiviCoop

Pauln60

  • I’m new here
  • *
  • Posts: 21
  • Karma: 0
  • CiviCRM version: 4.1
  • CMS version: Drupal 6
  • MySQL version: 14.2
  • PHP version: 5.38
Re: installation crashes with error
January 29, 2015, 06:31:24 am
I installed it within Drupal (i.e., unpacked the files in the sites/all/modules directory and installed as usual from admin/modules).  So when you say  "Previous versions of CiviCRM could only by installed outside of Drupal by accessing: http://yoursite/sites/all/modules/civicrm/install" - I presume you're telling me that installing within Drupal should work for the current version 4.5.5, right?  That's the version I'm using.

Thanks,
Paul

Upperholme

  • Administrator
  • Ask me questions
  • *****
  • Posts: 568
  • Karma: 8
    • MC3
  • CiviCRM version: 4.x
  • CMS version: Drupal 6.x/7.x, Wordpress, Joomla
Re: installation crashes with error
January 29, 2015, 07:21:29 am
I think 4.5.5 is the first version with this facility, so it may be that its not yet cast iron robust. Maybe the best option is to try to install using the old (and tried) method.
Graham Mitchell
http://mc3.coop

Pauln60

  • I’m new here
  • *
  • Posts: 21
  • Karma: 0
  • CiviCRM version: 4.1
  • CMS version: Drupal 6
  • MySQL version: 14.2
  • PHP version: 5.38
Re: installation crashes with error
January 29, 2015, 08:34:05 am
Thanks, I tried that, but still no joy - terminates with the following message:

Sorry but we are not able to provide this at the moment.
DB Error: unknown error

Paul

Upperholme

  • Administrator
  • Ask me questions
  • *****
  • Posts: 568
  • Karma: 8
    • MC3
  • CiviCRM version: 4.x
  • CMS version: Drupal 6.x/7.x, Wordpress, Joomla
Re: installation crashes with error
January 29, 2015, 08:38:38 am
Maybe you still had something in your CiviCRM DB (or the Civi tables in theDrupal DB if sharing one database) left over from the failed earlier attempt.

Empty the Civi DB or of using the Drupal DB for your Civi tables, ensure they have all been removed. Delete your civicrm.settings.php file (in sites/default) and start over.
Graham Mitchell
http://mc3.coop

Pauln60

  • I’m new here
  • *
  • Posts: 21
  • Karma: 0
  • CiviCRM version: 4.1
  • CMS version: Drupal 6
  • MySQL version: 14.2
  • PHP version: 5.38
Re: installation crashes with error
January 29, 2015, 10:51:56 am
I dropped both the drupal and civicrm databases and started from scratch -
same result, unfortunately.

Thanks,
Paul

Upperholme

  • Administrator
  • Ask me questions
  • *****
  • Posts: 568
  • Karma: 8
    • MC3
  • CiviCRM version: 4.x
  • CMS version: Drupal 6.x/7.x, Wordpress, Joomla
Re: installation crashes with error
January 29, 2015, 11:31:15 pm
Then I'm out of ideas. There must be something pretty odd going on or something obvious that's been missed. I've done hundreds, if not thousands, of installs with Drupal and have never had a problem.

I can only suggest that you review the install documentation, clear out your root install directory, delete the databases, and start again from the beginning.
Graham Mitchell
http://mc3.coop

Pauln60

  • I’m new here
  • *
  • Posts: 21
  • Karma: 0
  • CiviCRM version: 4.1
  • CMS version: Drupal 6
  • MySQL version: 14.2
  • PHP version: 5.38
Re: installation crashes with error
January 30, 2015, 05:36:23 am
I've done all that a couple of times - I've noticed the database error message shows up quite a few times in your forums, and the resolution seems nebulous... I think the software has some issues, which I guess you folks have elected to ignore.

Time to move on...

Thanks anyway,
Paul

ayduns

  • I post occasionally
  • **
  • Posts: 64
  • Karma: 6
    • Squiffle Consulting
  • CiviCRM version: 4.5.5
  • CMS version: Drupal 7
Re: installation crashes with error
January 30, 2015, 05:55:12 am
Your first post reports "Table 'settle_civicrm.civicrm_domain' doesn't exist" 

You might want to try looking at the DB directly:
Is that the right DB name?
Does it have other civicrm_* tables?
Does the civicrm_domain table exist?
Are the DB user permissions set correctly? 

Pauln60

  • I’m new here
  • *
  • Posts: 21
  • Karma: 0
  • CiviCRM version: 4.1
  • CMS version: Drupal 6
  • MySQL version: 14.2
  • PHP version: 5.38
Re: installation crashes with error
January 30, 2015, 06:27:57 am
Database name and permissions are all correct - I trashed the original install to make a fresh start, so I don't know if it had a civircm_domain table.  It does now, and appears to be the full complement of tables.

Thanks,
Paul

Upperholme

  • Administrator
  • Ask me questions
  • *****
  • Posts: 568
  • Karma: 8
    • MC3
  • CiviCRM version: 4.x
  • CMS version: Drupal 6.x/7.x, Wordpress, Joomla
Re: installation crashes with error
February 08, 2015, 01:04:20 pm
Just re-readingthis thread - did you ever work out what was causing this issue Pauln60?

I was wondering - looking at your profile (which refers to Drupal 6 and Civi 4.1), whether a) your server environment meets the requirements for 4.5.5 (thats PHP 5.3.10+, MySQL 5.1.x or better, with more detail here: http://wiki.civicrm.org/confluence/display/CRMDOC/Installation+and+Upgrades), and b) if by some mischance you are attempting to install a Drupal 6 version of CiviCRM alongside Drupal 7.

Long shots perhaps, but I'm otherwise at a loss as to what might be giving you the DB error.

Any other clues in your PHP log or in the CivicRM log file at sites/default/files/civicrm/ConfigAndLog ?
Graham Mitchell
http://mc3.coop

Pauln60

  • I’m new here
  • *
  • Posts: 21
  • Karma: 0
  • CiviCRM version: 4.1
  • CMS version: Drupal 6
  • MySQL version: 14.2
  • PHP version: 5.38
Re: installation crashes with error
March 17, 2015, 01:42:46 pm
Here's an example of the error reported in ConfigAndLog... it's complaining about  a wrong column count in mysql.proc ("Expected 20, found 16. The table is probably corrupted").  However, the table has been checked and there's no problem with it.  So it's still a mystery.  (Note that I upgraded to the latest and greatest civicrm-4.5.7-drupal - which I was able to install).

Paul


Mar 06 09:59:13  [info] $backTrace = #0 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/CRM/Core/Error.php(239): CRM_Core_Error::backtrace("backTrac
e", TRUE)
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/packages/DB.php(975): PEAR_Error->PEAR_Error("DB Error: unknown error", -1, 16, (Array:2), "SHOW function status WHERE db = database() AND name = 'civicrm_strip_non_nume...")
#4 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-1, 16, (Array:2), "SHOW function status WHERE db = database() AND name = 'civicrm_strip_non_nume...")
#5 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -1, NULL, NULL, "SHOW function status WHERE db = database() AND name = 'civicrm_strip_non_nume...", "DB_Error", TRUE)
#6 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/packages/DB/mysql.php(899): DB_common->raiseError(-1, NULL, NULL, NULL, "1547 ** Column count of mysql.proc is wrong. Expected 20, found 16. The table...")
#7 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/packages/DB/mysql.php(328): DB_mysql->mysqlRaiseError()
#8 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("SHOW function status WHERE db = database() AND name = 'civicrm_strip_non_nume...")
#9 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/packages/DB/DataObject.php(2442): DB_common->query("SHOW function status WHERE db = database() AND name = 'civicrm_strip_non_nume...")
#10 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/packages/DB/DataObject.php(1634): DB_DataObject->_query("SHOW function status WHERE db = database() AND name = 'civicrm_strip_non_nume...")
#11 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/CRM/Core/DAO.php(325): DB_DataObject->query("SHOW function status WHERE db = database() AND name = 'civicrm_strip_non_nume...")
#12 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/CRM/Core/DAO.php(1116): CRM_Core_DAO->query("SHOW function status WHERE db = database() AND name = 'civicrm_strip_non_nume...", TRUE)
#13 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/CRM/Core/DAO.php(1737): CRM_Core_DAO::executeQuery("SHOW function status WHERE db = database() AND name = 'civicrm_strip_non_nume...")
#14 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/CRM/Core/BAO/Phone.php(79): CRM_Core_DAO::checkSqlFunctionsExist()
#15 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/CRM/Core/BAO/Block.php(379): CRM_Core_BAO_Phone::add((Array:8))
#16 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/CRM/Core/BAO/Location.php(68): CRM_Core_BAO_Block::create("phone", (Array:45), NULL)
#17 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/CRM/Contact/BAO/Contact.php(358): CRM_Core_BAO_Location::create((Array:45), TRUE)
#18 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/CRM/Contact/Form/Contact.php(977): CRM_Contact_BAO_Contact::create((Array:45), TRUE, FALSE, TRUE)
#19 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/CRM/Core/Form.php(328): CRM_Contact_Form_Contact->postProcess()
#20 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/CRM/Core/QuickForm/Action/Upload.php(158): CRM_Core_Form->mainProcess()
#21 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/CRM/Core/QuickForm/Action/Upload.php(129): CRM_Core_QuickForm_Action_Upload->realPerform(Object(CRM_Contact_Form_Contact), "upload")
#22 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Upload->perform(Object(CRM_Contact_Form_Contact), "upload")
#23 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Form_Contact), "upload")
#24 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/CRM/Core/Controller.php(356): HTML_QuickForm_Page->handle("upload")
#25 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/CRM/Utils/Wrapper.php(117): CRM_Core_Controller->run()
#26 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/CRM/Core/Invoke.php(308): CRM_Utils_Wrapper->run("CRM_Contact_Form_Contact", "New Contact", (Array:1))
#27 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/CRM/Core/Invoke.php(79): CRM_Core_Invoke::runItem((Array:13))
#28 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#29 /home/settle/public_html/d7/sites/civicrm.settlementtech.org/modules/civicrm/drupal/civicrm.module(457): CRM_Core_Invoke::invoke((Array:3))
#30 [internal function](): civicrm_invoke("contact", "add")
#31 /home/settle/public_html/d7/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:2))
#32 /home/settle/public_html/d7/index.php(21): menu_execute_active_handler()
#33 {main}

Upperholme

  • Administrator
  • Ask me questions
  • *****
  • Posts: 568
  • Karma: 8
    • MC3
  • CiviCRM version: 4.x
  • CMS version: Drupal 6.x/7.x, Wordpress, Joomla
Re: installation crashes with error
March 17, 2015, 02:11:03 pm
I'll repeat my question. Does your server environment meet the requirements as noted in my previous post? This is not an error that I've ever come across before when doing an installation, so it seems a fair assumption that there's something awry with what you are installing into. The table mysql.proc is in the mysql DB, not in the drupal or civicrm DBs. I'm no MySQL expert, but your profile reads that you are running MySQL version 14.2. I'm not clear what that refers to. As far as I'm aware MySQL is currently up to about 5.x in terms of its version numbering - that rings alarm bells for me.
Graham Mitchell
http://mc3.coop

Pauln60

  • I’m new here
  • *
  • Posts: 21
  • Karma: 0
  • CiviCRM version: 4.1
  • CMS version: Drupal 6
  • MySQL version: 14.2
  • PHP version: 5.38
Re: installation crashes with error
March 18, 2015, 06:43:00 am
Sorry, I thought I'd answered that - it's been a while and I got past the install problem
after a CiviCRM version updgrade... only to encounter database errors in trying to
use it.   So:

> mysql --version
mysql  Ver 14.14 Distrib 5.1.72, for pc-linux-gnu (i686) using readline 5.1

The server requirements don't appear to be an issue.

The very capable server folks have run integrity checks on the 'proc' table
and can find no issues.  We've never encountered a similar problem on any of
the other software we're running.

Paul
Pages: [1] 2
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • installation crashes with error

This forum was archived on 2017-11-26.