CiviCRM Community Forums (archive)

Hello!

While I try to install civcrm 4.2.8 on Drupal 7.10 I ve got the following error (prior to this at check phase everything is green).

DB_Error Object ([error_message_prefix]=> [mode] => 1 [level] =>  1024 => -1 [message] => DB Error: unknown error
=> 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 ,......................

...And a lot of other staff more

Any idea what could be here wrong ?

I would like to install it on a local mashine with a virtual host (I have other drupals with differenet databases)
Mysql 5.6.10
Apache 2.4

Thank you

ps: if I want to add this error message between code tags why does it says Im not allowed to use external links ? o_O

if i had to make a random guess, i suspect it is due to mysql 5.6.10, i dont think anyone has tested civicrm on that version (as yet)

lobo

I see in there

=> DB Error: unknown error [userinfo]

...

=> Array ( [file]
=> C:\www\drupalcrm\sites\all\modules\civicrm\packages\DB.php [line]
=> 968 [function]
=> PEAR_Error [class]
=

...

=> C:\www\drupalcrm\sites\all\modules\civicrm\packages\PEAR.php [line]
=> 564 [function]
=> DB_Error [class]
=> DB_Error [object]
=> DB_Error Object *RECURSION* [type]
=> -> [args]

...

DB Error: unknown error
Unfortunately this is not clear at all. Lobo's idea is valid--it could be your MySQL version. It could also be a Pear issue maybe.

I can't say definitely however what the issue is.

MySQL 5.5.27 definitely works.