CiviCRM Community Forums (archive)

Hello,
I'm installing (manual install) civicrm-1.7.10272-joomla-php4 on joomla 1.0.13 stable (wampp2 on win xp and on fedora 6, plesk 6).
Moved com_civicrm on httpdocs/sitename and installed from Joomla Admin (install from directory).

Php.ini has been set accordingly to suggestions:
1. memory limit is more than 24M

2. execution time limit is at least 600

3. open basedir disabled

5.  joomla media directory needs is writable.

Always getting the same message after install on both system:

Install Successful

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 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci: DB Error: syntax error

If trying to access civicrm Administration function from Joomla components menu i get:

Warning: main(civicrm.settings.php): failed to open stream: No such file or directory in E:\wampp2\htdocs\TEST\administrator\components\com_civicrm\admin.civicrm.php on line 7

Warning: main(): Failed opening 'civicrm.settings.php' for inclusion (include_path='.;\wampp2\php\pear\') in E:\wampp2\htdocs\TEST\administrator\components\com_civicrm\admin.civicrm.php on line 7

Warning: main(CRM/Core/Config.php): failed to open stream: No such file or directory in E:\wampp2\htdocs\TEST\administrator\components\com_civicrm\admin.civicrm.php on line 11

Fatal error: main(): Failed opening required 'CRM/Core/Config.php' (include_path='.;\wampp2\php\pear\') in E:\wampp2\htdocs\TEST\administrator\components\com_civicrm\admin.civicrm.php on line 11

Can you please provide support or hints please?

Regards

Gianluigi Gerli

hello,

ty for your kind answer.

what i can say is that joomla is set to iso-8859-1 and looking at mysql setting harset is latin1.
BTW is there a way to tell to civicrm to use this setting instead of utf8?

Ty in advance

Gian

ok, ty a lot
gian