CiviCRM Community Forums (archive)

I tried enabling the new logging feature under the "Misc. Settings" screen  ( http://mywebsite.com/civicrm/admin/setting/misc ) and got the following error message:

Sorry. A non-recoverable error has occurred.
DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
Error Details
Database Error Code: The used table type doesn't support AUTO_INCREMENT columns, 1164
Additional Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> a515ac9c2796ca0e23adbe92c68fc9fc
    [message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
    [mode] => 16
    [debug_info] => CREATE TABLE `log_civicrm_acl` (
  `id` int(10) unsigned NOT NULL auto_increment COMMENT 'Unique table ID',
  `name` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'ACL Name.',
  `deny` tinyint(4) NOT NULL default '0' COMMENT 'Is this ACL entry Allow  (0) or Deny (1) ?',
  `entity_table` varchar(64) collate utf8_unicode_ci NOT NULL COMMENT 'Table of the object possessing this ACL entry (Contact, Group, or ACL Group)',
  `entity_id` int(10) unsigned default NULL COMMENT 'ID of the object possessing this ACL',
  `operation` enum('All','View','Edit','Create','Delete','Grant','Revoke','Search') collate utf8_unicode_ci NOT NULL COMMENT 'What operation does this ACL entry control?',
  `object_table` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'The table of the object controlled by this ACL entry',
  `object_id` int(10) unsigned default NULL COMMENT 'The ID of the object controlled by this ACL entry',
  `acl_table` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'If this is a grant/revoke entry, what table are we granting?',
  `acl_id` int(10) unsigned default NULL COMMENT 'ID of the ACL or ACL group being granted/revoked',
  `is_active` tinyint(4) default NULL COMMENT 'Is this property active?',


            log_date    TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            log_conn_id INTEGER,
            log_user_id INTEGER,
            log_action  ENUM('Initialization', 'Insert', 'Update', 'Delete')
) ENGINE=ARCHIVE DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci [nativecode=1164 ** The used table type doesn't support AUTO_INCREMENT columns]
    [type] => DB_Error
    [user_info] => CREATE TABLE `log_civicrm_acl` (
  `id` int(10) unsigned NOT NULL auto_increment COMMENT 'Unique table ID',
  `name` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'ACL Name.',
  `deny` tinyint(4) NOT NULL default '0' COMMENT 'Is this ACL entry Allow  (0) or Deny (1) ?',
  `entity_table` varchar(64) collate utf8_unicode_ci NOT NULL COMMENT 'Table of the object possessing this ACL entry (Contact, Group, or ACL Group)',
  `entity_id` int(10) unsigned default NULL COMMENT 'ID of the object possessing this ACL',
  `operation` enum('All','View','Edit','Create','Delete','Grant','Revoke','Search') collate utf8_unicode_ci NOT NULL COMMENT 'What operation does this ACL entry control?',
  `object_table` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'The table of the object controlled by this ACL entry',
  `object_id` int(10) unsigned default NULL COMMENT 'The ID of the object controlled by this ACL entry',
  `acl_table` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'If this is a grant/revoke entry, what table are we granting?',
  `acl_id` int(10) unsigned default NULL COMMENT 'ID of the ACL or ACL group being granted/revoked',
  `is_active` tinyint(4) default NULL COMMENT 'Is this property active?',


            log_date    TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            log_conn_id INTEGER,
            log_user_id INTEGER,
            log_action  ENUM('Initialization', 'Insert', 'Update', 'Delete')
) ENGINE=ARCHIVE DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci [nativecode=1164 ** The used table type doesn't support AUTO_INCREMENT columns]
    [to_string] => [db_error: message="DB Error: a515ac9c2796ca0e23adbe92c68fc9fc" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info="CREATE TABLE `log_civicrm_acl` (
  `id` int(10) unsigned NOT NULL auto_increment COMMENT 'Unique table ID',
  `name` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'ACL Name.',
  `deny` tinyint(4) NOT NULL default '0' COMMENT 'Is this ACL entry Allow  (0) or Deny (1) ?',
  `entity_table` varchar(64) collate utf8_unicode_ci NOT NULL COMMENT 'Table of the object possessing this ACL entry (Contact, Group, or ACL Group)',
  `entity_id` int(10) unsigned default NULL COMMENT 'ID of the object possessing this ACL',
  `operation` enum('All','View','Edit','Create','Delete','Grant','Revoke','Search') collate utf8_unicode_ci NOT NULL COMMENT 'What operation does this ACL entry control?',
  `object_table` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'The table of the object controlled by this ACL entry',
  `object_id` int(10) unsigned default NULL COMMENT 'The ID of the object controlled by this ACL entry',
  `acl_table` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'If this is a grant/revoke entry, what table are we granting?',
  `acl_id` int(10) unsigned default NULL COMMENT 'ID of the ACL or ACL group being granted/revoked',
  `is_active` tinyint(4) default NULL COMMENT 'Is this property active?',


            log_date    TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            log_conn_id INTEGER,
            log_user_id INTEGER,
            log_action  ENUM('Initialization', 'Insert', 'Update', 'Delete')
) ENGINE=ARCHIVE DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci [nativecode=1164 ** The used table type doesn't support AUTO_INCREMENT columns]"]
)


This environment is running under Drupal 6.x and was upgraded from CiviCRM 3.2.3

Is the minimum version of MySQL now version 5.1 or better for this version of CiviCRM? I did not see this mentioned in the release notes, or on the wiki.

Also, how can I view the new logging information in the CiviCRM sandbox for version 3.3