Bug 53220 – phpmyadmin tries to create an auto_increment field wich defaults to `0`

• Status: RESOLVED UPSTREAM
• Product: Gentoo Linux

[Description John Nilsson 2004-06-07 07:18:06 UTC]

2.5.6-r1_create.sql contains the following

CREATE TABLE IF NOT EXISTS `PMA_bookmark` (
        `id` int(11) DEFAULT `0` NOT NULL auto_increment,
        `dbase` varchar(255) NOT NULL,
        `user` varchar(255) NOT NULL,
        `label` varchar(255) NOT NULL,
        `query` text NOT NULL,
        PRIMARY KEY (id)
        ) TYPE=MyISAM COMMENT='Bookmarks';

This fails on mysql-4.1.2-alpha as `0` is invalid. Changing this to NULL should have the intended result and actually work.

Reproducible: Always
Steps to Reproduce:
1.emerge mysql-4.1.2-alpha (ebuild from bug #34600)
2.emerge phpmyadmin
3.mysql -u root -p < /usr/share/webapps/phpmyadmin/2.5.6-r1/sqlscripts/mysql/2.5.6-r1_create.sql


Actual Results:  
ERROR 1067 at line 18: Invalid default value for 'id'

[Comment 1 Robin Johnson 2004-06-07 11:00:41 UTC]

as one of the upstream authors of phpMyAdmin,
we know about it, and have announced it on our webpage.
http://sourceforge.net/forum/forum.php?forum_id=380660

when we send out our next release of phpMyAdmin, it will be in Gentoo post-haste.
As the Mysql guy for gentoo, i'll probably hold back on putting 4.1.2 into the tree until phpmyadmin has a release out that works with it properly (the cvs snapshot is more of a hack at the moment).

[Comment 2 Tom Payne (RETIRED) 2004-06-27 04:37:37 UTC]

I've edited the mysql-setup file for 2.5.6 and 2.5.7 to reflect this change.