CiviCRM Community Forums (archive)

I'm attempting to install CiviCRM 2.27 with Drupal 6.13.

I used this guide:

http://wiki.civicrm.org/confluence/display/CRMDOC/Drupal+Installation+Guide

After encountering the error shown below I have spent over
3 hours searching via Google, on Drupal's Forums and on these
Forums and I haven't seen anyone reporting a similar problem.

I guess that means "I Win!".

Running the check...everything passes.

[I hid some parts of names for security with ****]

CiviCRM Database Details
Does the server exist   OK (localhost)
Are the access credentials correct   OK
MySQL version at least 5.0   OK (MySQL 5.1.36)
Can I access/create the database   OK (Database '****_drupal' exists)
Can I access/create InnoDB tables in the database   OK
Can I create temporary tables in the database   OK
Drupal Database Details
Does the server exist   OK (localhost)
Are the access credentials correct   OK
MySQL version at least 5.0   OK (MySQL 5.1.36)
Can I access/create the database   OK (Database '****_drupal' exists)

Requirements
PHP Configuration
PHP5 installed   OK (PHP version 5.2.10)
MySQL support   OK
Memory allocated (PHP config option 'memory_limit')   OK (128M)
File permissions
Does the webserver know where files are stored?   OK (/srv/www/htdocs/****/sites/all/modules/civicrm/install/)
CRM folder exists   OK
packages folder exists   OK
templates folder exists   OK
js folder exists   OK
api folder exists   OK
i folder exists   OK
sql folder exists   OK
Is the sites/default/files folder writeable?   OK
Is the sites/default folder writeable?   OK

***********************************

This I click on "Check Requirement and Install CiviCRM"
to install and see this lovely meaningless-to-me error:

Installing CiviCRM...

I am now running through the installation steps (this should take a few minutes)

If you receive a fatal error, refresh this page to continue the installation

Building database schema and setup files...

Cannot execute -- * -- * -- * CREATE TABLE civicrm_contact ( id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Contact ID', contact_type enum('Individual', 'Organization', 'Household') COMMENT 'Type of Contact.', contact_sub_type varchar(64) COMMENT 'May be used to over-ride contact view and edit templates.', do_not_email tinyint DEFAULT 0 , do_not_phone tinyint DEFAULT 0 , do_not_mail tinyint DEFAULT 0 , do_not_trade tinyint DEFAULT 0 , is_opt_out tinyint NOT NULL DEFAULT 0 COMMENT 'Has the contact opted out from receiving all bulk email from the organization or site domain?', legal_identifier varchar(32) COMMENT 'May be used for SSN, EIN/TIN, Household ID (census) or other applicable unique legal/government ID.', external_identifier varchar(32) COMMENT 'Unique trusted external ID (generally from a legacy app/datasource). Particularly useful for deduping operations.', sort_name varchar(128) COMMENT 'Name used for sorting different contact types', display_name varchar(128) COMMENT 'Formatted name representing preferred format for display/print/other output.', nick_name varchar(128) COMMENT 'Nick Name.', legal_name varchar(128) COMMENT 'Legal Name.', home_URL varchar(128) COMMENT 'optional "home page" URL for this contact.', image_URL varchar(128) COMMENT 'optional URL for preferred image (photo, logo, etc.) to display for this contact.', preferred_communication_method varchar(255) COMMENT 'What is the preferred mode of communication.', preferred_mail_format enum('Text', 'HTML', 'Both') DEFAULT "Both" COMMENT 'What is the preferred mode of sending an email.', hash varchar(32) COMMENT 'Key for validating requests related to this contact.', api_key varchar(32) COMMENT 'API Key for validating requests related to this contact.', source varchar(255) COMMENT 'where contact come from, e.g. import, donate module insert...', first_name varchar(64) COMMENT 'First Name.', middle_name varchar(64) COMMENT 'Middle Name.', last_name varchar(64) COMMENT 'Last Name.', prefix_id int unsigned COMMENT 'Prefix or Title for name (Ms, Mr...). FK to prefix ID', suffix_id int unsigned COMMENT 'Suffix for name (Jr, Sr...). FK to suffix ID', greeting_type_id int unsigned COMMENT 'FK to civicrm_option_value.id, that has to be valid, registered Greeting type.', custom_greeting varchar(128) COMMENT 'Custom greeting message.', job_title varchar(64) COMMENT 'Job Title', gender_id int unsigned COMMENT 'FK to gender ID', birth_date date COMMENT 'Date of birth', is_deceased tinyint DEFAULT 0 , deceased_date date COMMENT 'Date of deceased', mail_to_household_id int unsigned COMMENT 'OPTIONAL FK to civicrm_contact_household record. If NOT NULL, direct mail communications to household rather than individual location.', household_name varchar(128) COMMENT 'Household Name.', primary_contact_id int unsigned COMMENT 'Optional FK to Primary Contact for this household.', organization_name varchar(128) COMMENT 'Organization Name.', sic_code varchar( 8 ) COMMENT 'Standard Industry Classification Code.', user_unique_id varchar(255) COMMENT 'the OpenID (or OpenID-style http://username.domain/) unique identifier for this contact mainly used for logging in to CiviCRM', employer_id int unsigned COMMENT 'OPTIONAL FK to civicrm_contact record.' , PRIMARY KEY ( id ) , INDEX index_contact_type( contact_type ) , INDEX index_contact_sub_type( contact_sub_type ) , UNIQUE INDEX UI_external_identifier( external_identifier ) , INDEX index_sort_name( sort_name ) , INDEX index_preferred_communication_method( preferred_communication_method ) , INDEX index_hash( hash ) , INDEX index_api_key( api_key ) , INDEX index_first_name( first_name ) , INDEX index_last_name( last_name ) , INDEX UI_prefix( prefix_id ) , INDEX UI_suffix( suffix_id ) , INDEX UI_gender( gender_id ) , INDEX index_household_name( household_name ) , INDEX index_organization_name( organization_name ) , CONSTRAINT FK_civicrm_contact_mail_to_household_id FOREIGN KEY (mail_to_household_id) REFERENCES civicrm_contact(id) ON DELETE SET NULL, CONSTRAINT FK_civicrm_contact_primary_contact_id FOREIGN KEY (primary_contact_id) REFERENCES civicrm_contact(id) ON DELETE SET NULL, CONSTRAINT FK_civicrm_contact_employer_id FOREIGN KEY (employer_id) REFERENCES civicrm_contact(id) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci: DB Error: syntax error

Anyone have any ideas? It appears that it can't create
a table and there's mention at the end of a syntax error. 

The CiviCRM setup is using the same database and credentials
as the Drupal site which was installed today and working fine.

Refreshing the page does nothing.

Thanks

Hi Dave --

Thanks for the reply.

Many (most?) folks using CiviCRM with Drupal put them in separate DB's. You might try the install this way:
- create a separate DB for CiviCRM on your DB server
- reference that DB and it's credentials on the install screen

If your DB user has sufficient permissions (create tables, create temp tables) on the new DB - then this should work fine. Otherwise something else is up

I also tried with separate databases.  Same error appears.
I also tried using the previous (2.2.6) version.  Same error appears.

But I was able to solve the problem.  The error
is thrown because on line 754 in civicrm.mysql:

preferred_mail_format enum('Text', 'HTML', 'Both')   DEFAULT "Both" COMMENT 'What is the preferred mode of sending an email.',

The double quotes fail, because that is not standard SQL
and our shop runs MySQL in SQL Standard Mode. By changing
that to single quotes installation succeeds.

However at the end of the Installation Success page is
a new FATAL error claiming that on Line 99 in Menu.php:
 
$xml = simplexml_load_file( $name );

there is no such function as simplexml_load_file.

Any ideas on that?

Thanks

Thanks for the reply, Donald. 

seems like your version of php is not compiled with the simplexml extension

http://us.php.net/manual/en/book.simplexml.php

lobo

simplexml is enabled:

./configure' '--quiet' '--with-apxs2' '--prefix=/usr' '--sysconfdir=/etc' '--localstatedir=/var' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--with-config-file-path=/etc' '--disable-short-tags' '--with-pcre-regex' '--with-zlib=shared' '--with-crack=shared' '--enable-ctype=shared' '--enable-dba=shared' '--with-gdbm' '--enable-inifile' '--enable-flatfile' '--enable-dom=shared' '--disable-filter' '--with-gd=shared,/usr' '--with-jpeg-dir' '--with-freetype-dir' '--with-gettext=shared' '--enable-hash=shared' '--with-iconv=shared' '--enable-json=shared' '--enable-mbstring=shared' '--with-mcrypt=shared' '--with-mime-magic=shared' '--with-mysql=shared' '--enable-pdo=shared' '--with-pdo-mysql=shared' '--with-pdo-pgsql=shared' '--with-pdo-sqlite=shared' '--with-pgsql=shared' '--enable-posix=shared' '--disable-reflection' '--enable-session=shared' '--enable-simplexml=shared' '--disable-spl' '--with-sqlite=shared' '--enable-sqlite-utf8=shared' '--enable-tokenizer=shared' '--enable-xml=shared' '--enable-xmlreader=shared' '--enable-xmlwriter=shared' '--without-pear'

Hi Donald --

this is an issue with your php install, check:

http://us2.php.net/manual/en/function.simplexml-load-file.php

You might want to run a small script that just calls that function and see if it works etc

lobo

You are correct!  Our admin had the functions related to PHP xml modules commented out.

Your suggestion to write a simple test script was very helpful!

Thank you.