PHPMYADMIN: Can't seem to run a simple SQL query on database. ERROR501
I recently updated my phpmyadmin from 4.0 to 4.4 and sometimes it redirects me to the older version of phpmyadmin, while I've already deleted that version through the cpanel filemanager. Also I can't seem to run a simple SQL query to create a table in database. PhpMyAdmin keeps giving me an error notification:
Error in Processing Request
Error code: 501
Error text: Not Implemented
with SQL query:
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`email` varchar(300) NOT NULL UNIQUE,
`verification_code` varchar(300) NOT NULL UNIQUE,
`verified` enum('0','1') NOT NULL DEFAULT '0',
`created` datetime NOT NULL,
`modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=134;
There seem to be no other option for me to create databases on mysql. It would be wonderful if someone can assist me in solving this issue. Thank you!
Kind Regards,
Nathalia Morgana
Error in Processing Request
Error code: 501
Error text: Not Implemented
with SQL query:
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`email` varchar(300) NOT NULL UNIQUE,
`verification_code` varchar(300) NOT NULL UNIQUE,
`verified` enum('0','1') NOT NULL DEFAULT '0',
`created` datetime NOT NULL,
`modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=134;
There seem to be no other option for me to create databases on mysql. It would be wonderful if someone can assist me in solving this issue. Thank you!
Kind Regards,
Nathalia Morgana
