CiviCRM Community Forums (archive)

Hi People, I am trying to get This working in Joomla for my boss and i managed to install it "succesfully" into Joomla! 1.8 but now I get a long error message that I can make nither head to tail from.

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

Any thoughts on the matter would be greatly appritiated, Thanks.