CiviCRM Community Forums (archive)

excellent advice, and extremely detailed. i actually believed i may be able to get civicrm to work. however i keep encountering problems, i dont know how all you guys put up with being defeated over and over again.
this is my error.

Cannot execute CREATE TABLE civicrm_cache ( id int unsigned NOT NULL AUTO_INCREMENT , group_name varchar(32) NOT NULL COMMENT 'group name for cache element, useful in cleaning cache elements', path varchar(64) 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(100) , path(100) ) , 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

when i refresh the page civicrm is part of my components menu but when i click on it i get this error.

Warning: include_once(civicrm.settings.php) [function.include-once]: failed to open stream: No such file or directory in W:\www\Joomla\administrator\components\com_civicrm\admin.civicrm.php on line 13

Warning: include_once() [function.include]: Failed opening 'civicrm.settings.php' for inclusion (include_path='.;/usr/local/PHP/includes;/usr/local/PHP/pear;/home/admin/www/plugins/pear/PEAR') in W:\www\Joomla\administrator\components\com_civicrm\admin.civicrm.php on line 13

Warning: require_once(PEAR.php) [function.require-once]: failed to open stream: No such file or directory in W:\www\Joomla\administrator\components\com_civicrm\admin.civicrm.php on line 15

Fatal error: require_once() [function.require]: Failed opening required 'PEAR.php' (include_path='.;/usr/local/PHP/includes;/usr/local/PHP/pear;/home/admin/www/plugins/pear/PEAR') in W:\www\Joomla\administrator\components\com_civicrm\admin.civicrm.php on line 15

i am assuming its because the tables were not installed correctly. but i dont know what to do anymore.