In table operations, when copying a table to a different database, the operation fails with an SQL error for CREATE TABLE. This happens for some tables, not for all.
Sample structure for reproducing:
CREATE TABLE IF NOT EXISTS `emails` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `email` varchar(150) NOT NULL DEFAULT '', `validated` int(11) NOT NULL DEFAULT '0', `listID` int(11) NOT NULL DEFAULT '0', `date` date NOT NULL DEFAULT '0000-00-00', `letters` varchar(10) NOT NULL DEFAULT 'W', `ip` varchar(40) NOT NULL DEFAULT '', `confcode` varchar(32) NOT NULL DEFAULT '', `conf_ip` varchar(40) NOT NULL DEFAULT '', `conf_ts` bigint(20) NOT NULL DEFAULT '0', `partner` varchar(20) NOT NULL DEFAULT '', `name` varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=1 AUTO_INCREMENT=33743 ;
8cf74b688d882a9545a651498664de912c7fb659 is the first bad commit
commit 8cf74b688d882a9545a651498664de912c7fb659
Author: Viduranga Wijesooriya vpowerrc@gmail.com
Date: Sat Jan 11 02:27:40 2014 +0530
added #1004 Create indexes at the end in SQL export Signed-off-by: Viduranga Wijesooriya <vpowerrc@gmail.com>
:040000 040000 1cb78160ad121cb0177c896df4cfc787c7ecc36d 33366ed9017c8811a8a31b06ed162be300cd3014 M libraries
Hi,
Sorry for the bad commit. I fixed it. Please check https://github.com/phpmyadmin/phpmyadmin/pull/862
Inform me if something breaks again.
Thank you
Last edit: Viduranga Wijesooriya 2014-01-16
Fixed with
https://github.com/phpmyadmin/phpmyadmin/commit/d5a3b01f77c5efbfbb8a8bb328dd9272ff7170c2
https://github.com/phpmyadmin/phpmyadmin/commit/eebcb9c531424d1d314e4d4064c0004688f851b7