#4798 (ok 4.3.13) Missing column when exporting in sql
Bug while exporting as sql a drupal 8 database (structure part), a column is missing in the export. Works fine on phpMyAdmin-4.0.10.9-english and bug at least since phpMyAdmin-4.2.13.2-english. Tested also on phpMyAdmin-4.3.11.1-all-languages and phpMyAdmin-4.4.0-beta1-all-languages and the 4.2.0 embedded in the MAMP project.
On table 'key_value', instead of building this :
--
-- Table structure for table key_value
--
CREATE TABLE IF NOT EXISTS key_value (
collection varchar(128) NOT NULL DEFAULT '' COMMENT 'A named collection of key and value pairs.',
name varchar(128) NOT NULL DEFAULT '' COMMENT 'The key of the key-value pair. As KEY is a SQL reserved keyword, name was chosen instead.',
value longblob NOT NULL COMMENT 'The value.',
PRIMARY KEY (collection,name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Generic key-value storage table. See the state system for…';
...it builds this :
--
-- Table structure for table key_value
--
CREATE TABLE IF NOT EXISTS key_value (
collection varchar(128) NOT NULL DEFAULT '' COMMENT 'A named collection of key and value pairs.'
value longblob NOT NULL COMMENT 'The value.',
PRIMARY KEY (collection,name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Generic key-value storage table. See the state system for…';
-> the 'name' column is missing (and the preceeding comma)
MAMP version 3.0.7.2:
* server: Apache/2.2.29 (Unix) mod_fastcgi/2.4.6 mod_wsgi/3.4 Python/2.7.8 PHP/5.6.2 mod_ssl/2.2.29 OpenSSL/0.9.8zc DAV/2 mod_perl/2.0.8 Perl/v5.20.0
* PHP Version 5.6.2
* Mysql Client API version 5.5.38
Please contact me for more info.
Pull request: https://github.com/phpmyadmin/phpmyadmin/pull/1581