#3984 (ok 4.0.5) Cannot insert in this table (PHP < 5.4)

[Marc Delisle]

Reported in the French forum:
https://sourceforge.net/p/phpmyadmin/discussion/Aide/thread/4c36332c/

The insert panel for the following table is not displayed, when running in PHP 5.2 or 5.3, but is displayed in PHP 5.4 or 5.5. I reproduced the problem with MySQL 5.5.31, mysqli, mysqlnd. The same table without any ENUMs columns works fine. Not sure whether it's a PHP or phpMyadmin bug.

CREATE TABLE abonne (
id int(11) NOT NULL AUTO_INCREMENT,
civilite enum('Mr','Mme') COLLATE utf8_unicode_ci DEFAULT NULL,
nom varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
prenom varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
adresse text COLLATE utf8_unicode_ci,
adresse2 text COLLATE utf8_unicode_ci,
dateenvoi datetime NOT NULL,
cp int(11) DEFAULT NULL,
ville varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
mobile varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
email varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
bureau_id int(11) DEFAULT NULL,
jour enum('Lundi','Mardi','Mercredi','Jeudi','Vendredi','Samedi') COLLATE utf8_unicode_ci DEFAULT NULL,
sendsms int(11) NOT NULL DEFAULT '0',
infoscomplementaires text COLLATE utf8_unicode_ci,
ql varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
etat enum('A valider','Validé','Terminé') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'A valider',
user_id int(11) DEFAULT NULL,
datemodification datetime DEFAULT NULL,
campagne_id int(11) DEFAULT NULL,
del tinyint(4) DEFAULT '0',
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

[Marc Delisle]

In column #17, if I remove the accented characters in the ENUM values, the insert panel appears in PHP 5.3.

[Paul Borel]

In phpMyAdmin 3.5.6 it works without problems.

[Marc Delisle]

Fixed with this patch, please confirm:
https://github.com/phpmyadmin/phpmyadmin/commit/178f83f9159dd0ff79464a35905023fe3d508097.patch

[Paul Borel]

Hello,

I confirm that it works....

Thanks.