When I ran all the updates (I upgraded from a D5 site), i noticed that the aid's were not lining up, looks like the auto increment key is missing.


show create table activity;

| activity | CREATE TABLE `activity` (
  `aid` int(11) NOT NULL,
  `module` varchar(50) NOT NULL default '',
  `type` varchar(25) NOT NULL default '',
  `operation` varchar(25) NOT NULL default '',
  `created` int(11) NOT NULL,
  `data` longtext NOT NULL,
  `uid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`aid`),
  KEY `module` (`module`),
  KEY `created` (`created`),
  KEY `aid` (`aid`),
) ENGINE=MyISAM DEFAULT CHARSET=utf8 |

when i run activity_update_6000 i notice that i get the error;

a:4:{s:6:"%error";s:12:"user warning";s:8:"%message";s:231:"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT NULL' at line 1
query: ALTER TABLE activity CHANGE `aid` `Array`  DEFAULT NULL";s:5:"%file";s:64:"website/includes/database.mysql-common.inc";s:5:"%line";i:520;}

Comments

dgtlmoon’s picture

dgtlmoon commented

the update 


function activity_update_6000() {
  $ret = array();
  db_change_field($ret, 'activity', 'aid', array('type' => 'serial', 'not null' => TRUE), array('primary key' => array('aid')));
  return $ret;
}

needs to perform something like;

mysql> ALTER TABLE activity MODIFY aid INT(11) UNSIGNED NOT NULL AUTO_INCREMENT;
sirkitree’s picture

sirkitree commented
Status: Active » Closed (won't fix)

closing. 1.x no longer supported.