CiviCRM Community Forums (archive)

I always get the following message when i try to run the installation. Anybody knows how to fix this?



Installing CiviCRM...

I am now running through the installation steps (this should take a few minutes)

If you receive a fatal error, refresh this page to continue the installation

Building database schema and setup files...
Cannot execute ********************************************** -- * civicrm_loc_block -- * Define location specific properties -- *******************************************************/ CREATE TABLE civicrm_loc_block ( id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique ID', address_id int unsigned , email_id int unsigned , phone_id int unsigned , im_id int unsigned , address_2_id int unsigned , email_2_id int unsigned , phone_2_id int unsigned , im_2_id int unsigned , PRIMARY KEY ( id ) , CONSTRAINT FK_civicrm_loc_block_address_id FOREIGN KEY (address_id) REFERENCES civicrm_address(id) ON DELETE SET NULL, CONSTRAINT FK_civicrm_loc_block_email_id FOREIGN KEY (email_id) REFERENCES civicrm_email(id) ON DELETE SET NULL, CONSTRAINT FK_civicrm_loc_block_phone_id FOREIGN KEY (phone_id) REFERENCES civicrm_phone(id) ON DELETE SET NULL, CONSTRAINT FK_civicrm_loc_block_im_id FOREIGN KEY (im_id) REFERENCES civicrm_im(id) ON DELETE SET NULL, CONSTRAINT FK_civicrm_loc_block_address_2_id FOREIGN KEY (address_2_id) REFERENCES civicrm_address(id) ON DELETE SET NULL, CONSTRAINT FK_civicrm_loc_block_email_2_id FOREIGN KEY (email_2_id) REFERENCES civicrm_email(id) ON DELETE SET NULL, CONSTRAINT FK_civicrm_loc_block_phone_2_id FOREIGN KEY (phone_2_id) REFERENCES civicrm_phone(id) ON DELETE SET NULL, CONSTRAINT FK_civicrm_loc_block_im_2_id FOREIGN KEY (im_2_id) REFERENCES civicrm_im(id) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci: DB Error: syntax error