CiviCRM Community Forums (archive)

i have this error after installation!!

Cannot execute CREATE TABLE civicrm_currency ( id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Currency Id', name varchar(64) COMMENT 'Currency Name', symbol varchar( 8 ) COMMENT 'Currency Symbol', numeric_code varchar(3) COMMENT 'Numeric currency code', full_name varchar(64) COMMENT 'Full currency name' , PRIMARY KEY ( id ) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci: DB Error: unknown error

please help me... im using CiviCRM 2.0.1 - joomla
This is my System info:

PHP Built on:                     Windows NT PORTENDER2 5.1 build 2600
Database Version:                5.0.45-community-nt-log
Database Collation:                utf8_general_ci
PHP Version:                          5.2.3
Web Server:                          Apache/2.2.4 (Win32) PHP/5.2.3
Web Server to PHP interface:    apache2handler
Joomla! Version:                  Joomla! 1.5.2 Production/Stable [ Woi ] 22-March-2008 22:00 GMT
User Agent:                           Mozilla/5.0 (Windows; U; Windows NT 5.1; es-ES; rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1

thanks
pd:mi english is not so good!! im from Colombia so pleasae apologize to me

thank u for answere me

1.mysql error log dont showme an detail message(or i dont know what is the file... i think is mysql error log)

2.this is what happen when i execute the query in phpmyadmin
Error

consulta SQL:

CREATE TABLE civicrm_currency(
id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Currency Id',
name varchar( 64 ) COMMENT 'Currency Name',
symbol varchar( 8 ) COMMENT 'Currency Symbol',
numeric_code varchar( 3 ) COMMENT 'Numeric currency code',
full_name varchar( 64 ) COMMENT 'Full currency name',
PRIMARY KEY ( id )
) ENGINE = InnoDB

MySQL ha dicho: Documentación
#1289 - The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working

3.i think that the support of innoDB is the problem... but i have edited the my.ini configuration file and put this line: have_innodb=YES
  and  comment this one skip-innodb

i dont know what to do...
the component is already instaled but when im going to open any  option of the componet showme the error (i put the screen of my joomla)

ok man thank u for ur support the component is working fine
but i have a problem now and is this: when i try to procced to unistall a component joomla show me this error
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 19321 bytes) in C:\AppServ\www\crmtenderos\libraries\joomla\utilities\simplexml.php(334) : eval()'d code on line 1

if u can help me i Appreciated