CiviCRM Community Forums (archive)

yet the files are there and readable.

Are they also executable?

When first ran I get a big sql error

Can you post that?

this is the error I get on a clean install first try:

Cannot execute CREATE TABLE civicrm_option_value ( id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option ID', option_group_id int unsigned NOT NULL COMMENT 'Group which this option belongs to.', label varchar(255) NOT NULL COMMENT 'Option string as displayed to users - e.g. the label in an HTML OPTION tag.', value varchar(512) NOT NULL COMMENT 'The actual value stored (as a foreign key) in the data record. Functions which need lookup option_value.title should use civicrm_option_value.option_group_id plus civicrm_option_value.value as the key.', name varchar(255) COMMENT 'Stores a fixed (non-translated) name for this option value. Lookup functions should use the name as the key for the option value row.', grouping varchar(255) COMMENT 'Use to sort and/or set display properties for sub-set(s) of options within an option group. EXAMPLE: Use for college_interest field, to differentiate partners from non-partners.', filter int unsigned COMMENT 'Bitwise logic can be used to create subsets of options within an option_group for different uses.', is_default tinyint DEFAULT 0 COMMENT 'Is this the default option for the group?', weight int unsigned NOT NULL COMMENT 'Controls display sort order.', description text COMMENT 'Optional description.', is_optgroup tinyint DEFAULT 0 COMMENT 'Is this row simply a display header? Expected usage is to render these as OPTGROUP tags within a SELECT field list of options?', is_reserved tinyint DEFAULT 0 COMMENT 'Is this a predefined system object?', is_active tinyint DEFAULT 1 COMMENT 'Is this option active?', component_id int unsigned COMMENT 'Component that this option value belongs/caters to.', domain_id int unsigned COMMENT 'Which Domain is this option value for', visibility_id int unsigned DEFAULT NULL , PRIMARY KEY ( id ) , INDEX index_option_group_id_value( value , option_group_id ) , INDEX index_option_group_id_name( option_group_id , name ) , CONSTRAINT FK_civicrm_option_value_option_group_id FOREIGN KEY (option_group_id) REFERENCES civicrm_option_group(id) ON DELETE CASCADE, CONSTRAINT FK_civicrm_option_value_component_id FOREIGN KEY (component_id) REFERENCES civicrm_component(id) , CONSTRAINT FK_civicrm_option_value_domain_id FOREIGN KEY (domain_id) REFERENCES civicrm_domain(id) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci: DB Error: unknown error

Deleted all tables.   

Now back to Error building admin menus

??

t

> Now back to Error building admin menus

What is the error?

See here: http://forum.civicrm.org/index.php?topic=19721.0