Author Topic: Post Installation Error (cannot execute -- * -- * -- CREATE TABLE civicrm_countr (Read 1359 times)

rainbowjammer · December 18, 2007, 08:36:32 am

Installed civiCRM with no problems, went to Component | submenu.. and get the following errors on all civiCRM menus:

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.', 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' , PRIMARY KEY ( id ) , UNIQUE INDEX UI_name_iso_code( name , iso_code ) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci: DB Error: unknown error

I have read the forums regarding PHP and mySQL versions and I have this installed on mu local machine with the following versions:

PHP built On: Windows NT 0001-XP99AL 5.1 build 2600
Database Version: 5.0.45-community-nt-log
PHP Version: 5.2.3

Can anyone help?

Regards

Donald Lobo · December 18, 2007, 07:58:04 pm

this has been reported on the mailing list / forums in the past. When we did track it down, the behavior seemed to be different on various mysql versions (this was specifically the case with mysql 4.0.27 (i think)). Kinda surprised its still happening ith 5.0.45 (i'm using the same version on macosx and dont have that problem)

lobo

CiviCRM Community Forums (archive)

News:

Author Topic: Post Installation Error (cannot execute -- * -- * -- CREATE TABLE civicrm_countr (Read 1359 times)

rainbowjammer

Post Installation Error (cannot execute -- * -- * -- CREATE TABLE civicrm_countr

Donald Lobo

Re: Post Installation Error (cannot execute -- * -- * -- CREATE TABLE civicrm_co