CiviCRM Community Forums (archive)

i have a problem when i am installing CivicCRM

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

 i use Joomla 1.0.12 and my configuartion detalis are:

PHP built On:  Linux kw2.kiwiwebs.co.nz 2.4.32-ow1 #1 SMP Fri Jan 13 09:24:40 NZDT 2006 i686 
Database Version:  4.0.24_Debian-10sarge2-log 
PHP Version:  4.4.7 
Web Server:  Apache/1.3.37 (Unix) PHP/4.4.7 mod_gzip/1.3.26.1a FrontPage/5.0.2.2635 mod_ssl/2.8.28 OpenSSL/0.9.7e 
WebServer to PHP interface:  apache 
Joomla! Version:  Joomla! 1.0.12 Stable [ Sunfire ] 25 December 2006 01:00 UTC 
User Agent:  Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1) 

This is the information on my phpMyAdmin/index.php:

phpMyAdmin - 2.10.0.2

* MySQL client version: 4.1.22

So it seems that I do have 4.1.X or higher (btw- I wouldn't know how to upgrade if I needed to.)

Now what?

Donald,

Now you really left me out to dry.

Could you please give me a hint as to where I should be experimenting?

I hope that this can be done with out having to re-write Joomla from the ground because I wouldn't know where to  to start.

2. Edit the civicrm sql and delete all comments and check to see if this works. This is a manual process, prone to error and not really recommended. Also you will have to repeat the same exercise when you want to upgrade civicrm

lobo

Where do I find the civicrm sql?

2. Edit the civicrm sql and delete all comments and check to see if this works.

Is all coments everything under: DROP TABLE IF EXISTS civicrm_domain;
DROP TABLE IF EXISTS civicrm_custom_option;
DROP TABLE IF EXISTS civicrm_currency;
DROP TABLE IF EXISTS civicrm_country; ?