Author Topic: SQL error : Cannot execute CREATE TABLE civicrm_country (Read 956 times)

fourmi4x · January 06, 2011, 11:46:54 am

Hi, I get this error when I try to install civiCRM :
Cannot execute CREATE TABLE civicrm_country ( id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Country Id', name varchar(64) COMMENT 'Country Name', iso_code char(2) COMMENT 'ISO Code', country_code varchar(4) COMMENT 'National prefix to be used when dialing TO this country.', address_format_id int unsigned COMMENT 'Foreign key to civicrm_address_format.id.', idd_prefix varchar(4) COMMENT 'International direct dialing prefix from within the country TO another country', ndd_prefix varchar(4) COMMENT 'Access prefix to call within a country to a different area', region_id int unsign: DB Error: syntax error

All the "Requirements" are OK, but because of this error I can't get to install it.
I try to install the Version 3.3.1 on Drupal with PHP 5.2.9 and MySQL 5.0.91-community.

I search on the internet but couldn't find any answer : it just seems to be a very old bug... !

Any help truly appreciated !

Hershel · January 06, 2011, 11:49:25 am

Your error is "DB Error: syntax error." My guess is that one of your CiviCRM files was not uploaded properly. Can you try to upload them to your server again? If possible, it's usually better to upload the archive from SourceForge and then unzip it on the server. If not, then via FTP.

fourmi4x · January 06, 2011, 11:51:40 am

Many thanks for your very quick answer !
I will try that and let you know.

CiviCRM Community Forums (archive)

News:

Author Topic: SQL error : Cannot execute CREATE TABLE civicrm_country (Read 956 times)

fourmi4x

SQL error : Cannot execute CREATE TABLE civicrm_country

Hershel

Re: SQL error : Cannot execute CREATE TABLE civicrm_country

fourmi4x

Re: SQL error : Cannot execute CREATE TABLE civicrm_country