View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000373XMB1Bugspublic2010-04-09 14:572010-12-23 02:02
Reportermiqrogroove Assigned Tomiqrogroove  
PrioritynormalSeveritycrashReproducibilitysometimes
Status closedResolutionfixed 
Target Version1.9.11.10Fixed in Version1.9.11.10 
Summary0000373: Legacy Upgrader Incompatible With MySQL 5.1.8+
DescriptionWhile attempting to upgrade a mature board from version 1.9.8 SP3 to 1.9.11, the upgrader produces the following output when in DEBUG mode:

Changing table schemas to 1.9.11.
MySQL encountered the following error: Multiple primary key defined(errno = 1068)

In the following query: ALTER TABLE `xmb_attachments` ADD PRIMARY KEY (`aid`), ADD INDEX `parentid` (`parentid`), ADD INDEX `uid` (`uid`);
Additional Informationhttp://forums.xmbforum.com/viewthread.php?tid=775627
http://forums.xmbforum.com/viewthread.php?tid=775197
http://bugs.mysql.com/bug.php?id=13883

Raw table structure:

CREATE TABLE `xmb_attachments` (
 `aid` int(10) NOT NULL AUTO_INCREMENT,
 `tid` int(10) NOT NULL DEFAULT '0',
 `pid` int(10) NOT NULL DEFAULT '0',
 `filename` varchar(120) NOT NULL DEFAULT '',
 `filetype` varchar(120) NOT NULL DEFAULT '',
 `filesize` varchar(120) NOT NULL DEFAULT '',
 `attachment` longblob NOT NULL,
 `downloads` int(10) NOT NULL DEFAULT '0',
 PRIMARY KEY (`aid`),
 KEY `tid` (`tid`),
 KEY `pid` (`pid`)
) ENGINE=MyISAM AUTO_INCREMENT=96 DEFAULT CHARSET=latin1


Raw input to createQueryFromDiff:

[09-Apr-2010 19:44:45] array (
  'indices' =>
  array (
    'add' =>
    array (
      0 => 'aid',
      1 => 'parentid',
      2 => 'uid',
    ),
    'drop' =>
    array (
      0 => '',
      1 => 'tid',
    ),
  ),
  'cols' =>
  array (
    'drop' =>
    array (
      0 => 'tid',
    ),
    'add' =>
    array (
      0 => 'img_size',
      1 => 'parentid',
      2 => 'subdir',
      3 => 'uid',
      4 => 'updatetime',
    ),
    'alter' =>
    array (
      0 => 'aid',
    ),
  ),
)


Raw output from createQueryFromDiff:

[09-Apr-2010 19:44:45] array (
  0 => 'ALTER TABLE `xmb_attachments` DROP INDEX `tid`',
  1 => 'ALTER TABLE `xmb_attachments` ADD COLUMN `img_size` varchar(9) NOT NULL AFTER `downloads`, ADD COLUMN `parentid` int(11) NOT NULL default \'0\' AFTER `img_size`, ADD COLUMN `subdir` varchar(15) NOT NULL AFTER `parentid`, ADD COLUMN `uid` int(11) NOT NULL default \'0\' AFTER `subdir`, ADD COLUMN `updatetime` timestamp NOT NULL default CURRENT_TIMESTAMP AFTER `uid`',
  2 => 'ALTER TABLE `xmb_attachments` MODIFY `aid` int(10) NOT NULL auto_increment',
  3 => 'ALTER TABLE `xmb_attachments` DROP COLUMN `tid`',
  4 => 'ALTER TABLE `xmb_attachments` ADD PRIMARY KEY (`aid`), ADD INDEX `parentid` (`parentid`), ADD INDEX `uid` (`uid`)',
)
TagsNo tags attached.
MySQL Version5.1
PHP Version
Web Server
Browser
Flags
Original ReporterSerendipity
SVN Revision2353

Relationships

related to 0000417 closedmiqrogroove Get Rid of the Legacy Upgrader 

Activities

miqrogroove

2010-04-09 16:06

administrator   ~0000238

Last edited: 2010-04-09 16:06

 MySQL output has changed from

"PRIMARY KEY  (`aid`),"


to

"PRIMARY KEY (`aid`),"


It looks like there might also be a couple of missing ksort() calls in the upgrader.

miqrogroove

2010-04-09 16:14

administrator   ~0000239

Tested, broken on 5.1.30 and 5.1.45. Tested, works on 5.0.51.

Issue History

Date Modified Username Field Change
2010-04-09 14:57 miqrogroove New Issue
2010-04-09 14:57 miqrogroove Original Reporter => Serendipity
2010-04-09 16:06 miqrogroove Note Added: 0000238
2010-04-09 16:06 miqrogroove Note Edited: 0000238
2010-04-09 16:07 miqrogroove Status new => assigned
2010-04-09 16:07 miqrogroove Assigned To => miqrogroove
2010-04-09 16:14 miqrogroove MySQL Version => 5.1
2010-04-09 16:14 miqrogroove Note Added: 0000239
2010-04-09 16:18 miqrogroove Summary Reproducible Fatal Error in Legacy Upgrader => Legacy Upgrader Incompatible With MySQL 5.1.8+
2010-04-09 16:18 miqrogroove Additional Information Updated
2010-04-09 17:16 miqrogroove SVN Revision => 2353
2010-04-09 17:16 miqrogroove Status assigned => resolved
2010-04-09 17:16 miqrogroove Fixed in Version => 1.9.11.10
2010-04-09 17:16 miqrogroove Resolution open => fixed
2010-04-09 18:22 miqrogroove Additional Information Updated
2010-12-11 16:38 miqrogroove Status resolved => assigned
2010-12-11 16:39 miqrogroove Status assigned => resolved
2010-12-23 02:02 miqrogroove Status resolved => closed
2011-01-15 04:48 miqrogroove Relationship added related to 0000417