"Incorrect column specifier for column" when duplicated "id"
Database management in a single PHP file
Brought to you by:
jakubvrana
Hey, I was creating a table in MySQL and forgot a coloumn immediately after the "id". I copied it and changed values but insertion failed because of
Incorrect column specifier for column 'status'
Looking at the query it started
CREATE TABLE `users` (
`id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
`status` varchar(15) NOT NULL AUTO_INCREMENT PRIMARY KEY,
what is absolutely senseless but I can't see a way to change it.
Please provide steps to reproduce this. What do you mean by "copied it"?
This is similar to #566.
Hey, I will try to reproduce it this weekend to check wether it is still present in latest version of adminer.
This database (website) is no longer in use, I'll try to find it somewhere in the backups or create a new one.