CiviCRM Community Forums (archive)

Hi - I'm installing CiviCRM on Joomla and getting the following error after the install:

CiviCRM has been successfully installed.
Installation: Succesful

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: DB Error: syntax error

Someone else posted this error before (on the joomla website), but I never saw a response on how to fix.

Any ideas would be helpful!

When I go to the component in the admin panel, the page is blank.

If i had to take a random guess, I suspect its the mysql version. Considering tgull had the same issue on the same version, I'm pretty sure its the mysql version

I'd advice you to upgrade mysql to a newer 5.0 version. CiviCRM v1.7 no longer support mysql-4.0. Future version of civicrm will also be dropping support for mysql 4.1

lobo

hello! i'm getting the same error as mndonx.  i'm running php 4.4.4 and i downloaded the package which seemed to indicate it was for joomla using php4 (civicrm-1.7.beta.9327-joomla-php4.zip).  so, am i really stuck until my host upgrades to php5?

thx!