CiviCRM Community Forums (archive)

Hi,

I'm receiving a very peculiar error installing the latest alpha build.  A bit about my server first:

PHP Version: 5.25
Joomla Version: Joomla! 1.5.3 Production/Stable
Mysql version: 5.0.51a

After unpacking to the directory, per instructions on http://wiki.civicrm.org/confluence/display/CRMDOC/Install+2.1+for+Joomla, I hit an error screen outside Joomla with the following text:

Cannot execute CREATE TABLE civicrm_cache ( id int unsigned NOT NULL AUTO_INCREMENT , group_name varchar(255) NOT NULL COMMENT 'group name for cache element, useful in cleaning cache elements', path varchar(255) COMMENT 'Unique path name for cache element', data text COMMENT 'data associated with this path', component_id int unsigned COMMENT 'Component that this menu item belongs to', created_date datetime COMMENT 'When was the cache item created', expired_date datetime COMMENT 'When should the cache item expire' , PRIMARY KEY ( id ) , UNIQUE INDEX UI_group_path( group_name , path ) , CONSTRAINT FK_civicrm_cache_component_id FOREIGN KEY (component_id) REFERENCES civicrm_component(id) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci: DB Error: unknown error
I ran the create table query directly in PhpMyAdmin to get an idea of the error code from MySql:

Error

SQL query:

CREATE TABLE civicrm_cache(
id int unsigned NOT NULL AUTO_INCREMENT ,
group_name varchar( 255 ) NOT NULL COMMENT 'group name for cache element, useful in cleaning cache elements',
path varchar( 255 ) COMMENT 'Unique path name for cache element',
DATA text COMMENT 'data associated with this path',
component_id int unsigned COMMENT 'Component that this menu item belongs to',
created_date datetime COMMENT 'When was the cache item created',
expired_date datetime COMMENT 'When should the cache item expire',
PRIMARY KEY ( id ) ,
UNIQUE INDEX UI_group_path( group_name, path ) ,
CONSTRAINT FK_civicrm_cache_component_id FOREIGN KEY ( component_id ) REFERENCES civicrm_component( id )
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci

MySQL said: Documentation
#1071 - Specified key was too long; max key length is 1000 bytes
When I take out this line, the query runs just fine:

UNIQUE INDEX UI_group_path( group_name , path )
This leads me to believe that the utf8 limitation. I recommend changing the table creation script to (per: http://bugs.mysql.com/bug.php?id=6604):

UNIQUE INDEX UI_group_path( group_name(100), path(100) ) ,
This will index the first 100 'characters', which may be a limitation on the path, but should suffice on the group name.

I got the exact same problem...

My environment is:
 
PHP Version 5.2.6
Joomla Version: Joomla! 1.5.6 Production/Stable
Mysql version: 5.0.51a-community

I am on a shared host environment nptech's sql solution eliminated the error.

After creating the table with phpMyAdmin I went back to the administrator Components>>CivicCRM>>Home and I got this error:
Warning: include_once(civicrm.settings.php) [function.include-once]: failed to open stream: No such file or directory in /home/xxxx/public_html/administrator/components/com_civicrm/admin.civicrm.php on line 14

Warning: include_once() [function.include]: Failed opening 'civicrm.settings.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/xxxx/public_html/administrator/components/com_civicrm/admin.civicrm.php on line 14

Warning: require_once(CRM/Core/Config.php) [function.require-once]: failed to open stream: No such file or directory in /home/xxxx/public_html/administrator/components/com_civicrm/admin.civicrm.php on line 18

Fatal error: require_once() [function.require]: Failed opening required 'CRM/Core/Config.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/xxxx/public_html/administrator/components/com_civicrm/admin.civicrm.php on line 18
I searched the forum and it might be an installation error... any ideas??