I have a php wizard for an application that does the MySQL insert but it comes back with an error message, and I can't seem to figure out what. Any help is greatly appreciated.
Insert Statement
CREATE TABLE `{dbprefix}permissions` (
`ID` bigint(20) unsigned zerofill NOT NULL AUTO_INCREMENT,
`permKey` varchar(30) NOT NULL,
`permName` varchar(30) NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `permKey` (`permKey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
INSERT INTO `{dbprefix}permissions` VALUES(00000000000000000001, 'delete_groups', 'Delete Groups');
MySQL Error Message:
MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `chm_permissions` VALUES(00000000000000000002, 'create_groups', 'Cre' at line 2