MasterACE14 Posted July 31, 2008 Share Posted July 31, 2008 Hi Guys, I am trying to create a table in PHPMyAdmin, I've created 4 other tables in this database the same way and they all worked. But this query I'm trying to run doesn't want to work, and I have no idea why? Any help is greatly appreciated. Error SQL query: CREATE TABLE `rf_users` ( `id` int( 100 ) unsigned NOT NULL AUTO_INCREMENT , `username` varchar( 50 ) NOT NULL default '', `password` varchar( 50 ) NOT NULL default '', `email` varchar( 100 ) NOT NULL default '', `regdate` datetime NOT NULL default '0000-00-00 00:00:00', `onlinetime` datetime NOT NULL default '0000-00-00 00:00:00', `authlevel` int( 10 ) unsigned NOT NULL default '0', `postcount` int( 100 ) unsigned NOT NULL default '0' PRIMARY KEY ( `id` ) ) TYPE = MYISAM MySQL said: Documentation #1064 - 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 '(`id`) ) TYPE=MyISAM' at line 10 Regards ACE EDIT: after 2 hours, I finally got it. So simple too :S needed a comma after default '0' in post count. Link to comment https://forums.phpfreaks.com/topic/117499-solved-create-table-query-error/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.