The Arcive of vBulletin Modifications Site.

bahattab · #1 01-21-2009, 06:57 PM

hi

i am getting an error when i am trying to add this code . can any one fix it for me ?

PHP Code:


			
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `userid` int(10) unsigned NOT NULL auto_increment,
  `usergroupid` smallint(5) unsigned NOT NULL default '0',
  `username` varchar(100) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `styleid` smallint(5) unsigned NOT NULL default '0',
  `parentemail` varchar(50) NOT NULL default '',
  `homepage` varchar(100) NOT NULL default '',
  `icq` varchar(20) NOT NULL default '',
  `aim` varchar(20) NOT NULL default '',
  `yahoo` varchar(32) NOT NULL default '',
  `usertitle` varchar(250) NOT NULL default '',
  `customtitle` smallint(6) NOT NULL default '0',
  `joindate` int(10) unsigned NOT NULL default '0',
  `daysprune` smallint(6) NOT NULL default '0',
  `lastvisit` int(10) unsigned NOT NULL default '0',
  `lastactivity` int(10) unsigned NOT NULL default '0',
  `lastpost` int(10) unsigned NOT NULL default '0',
  `posts` int(10) unsigned NOT NULL default '0',
  `timezoneoffset` varchar(4) NOT NULL default '',
  `pmpopup` smallint(6) NOT NULL default '0',
  `avatarid` smallint(6) NOT NULL default '0',
  `options` int(10) unsigned NOT NULL default '0',
  `birthday` varchar(10) NOT NULL default '0000-00-00',
  `maxposts` smallint(6) NOT NULL default '-1',
  `startofweek` smallint(6) NOT NULL default '1',
  `ipaddress` varchar(15) NOT NULL default '',
  `referrerid` int(10) unsigned NOT NULL default '0',
  `pmtotal` smallint(5) unsigned NOT NULL default '0',
  `pmunread` smallint(5) unsigned NOT NULL default '0',
  `passworddate` date NOT NULL default '0000-00-00',
  `salt` char(3) NOT NULL default '',
  `showvbcode` smallint(5) unsigned NOT NULL default '0',
  `msn` varchar(100) NOT NULL default '',
  `avatarrevision` int(10) unsigned NOT NULL default '0',
  `membergroupids` varchar(250) NOT NULL default '',
  `displaygroupid` smallint(5) unsigned NOT NULL default '0',
  `reputation` int(11) NOT NULL default '10',
  `reputationlevelid` int(10) unsigned NOT NULL default '1',
  `languageid` smallint(5) unsigned NOT NULL default '0',
  `threadedmode` smallint(5) unsigned NOT NULL default '0',
  `emailstamp` int(10) unsigned NOT NULL default '0',
  `autosubscribe` smallint(6) NOT NULL default '-1',
  `birthday_search` date NOT NULL default '0000-00-00',
  `profilepicrevision` int(10) unsigned NOT NULL default '0',
  `showbirthday` smallint(5) unsigned NOT NULL default '2',
  `skype` varchar(32) NOT NULL default '',
  `adminoptions` int(10) unsigned NOT NULL default '0',
  `lastpostid` int(10) unsigned NOT NULL default '0',
  `sigpicrevision` int(10) unsigned NOT NULL default '0',
  `ipoints` int(10) unsigned NOT NULL default '0',
  `infractions` int(10) unsigned NOT NULL default '0',
  `warnings` int(10) unsigned NOT NULL default '0',
  `infractiongroupids` varchar(255) NOT NULL default '',
  `infractiongroupid` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`userid`),
  KEY `usergroupid` (`usergroupid`),
  KEY `username` (`username`),
  KEY `birthday_search` (`birthday_search`),
  KEY `birthday` (`birthday`,`showbirthday`)
) ENGINE=MyISAM AUTO_INCREMENT=36472 DEFAULT CHARSET=latin1;

PHP Code:


			
Error
SQL query: 

CREATE TABLE `user` ( `userid` int(10) unsigned NOT NULL auto_increment, `membergroupids` varchar(250) NOT NULL default '', `displaygroupid` smallint(5) unsigned NOT NULL default '0', `password` varchar(32) NOT NULL default '', `passworddate` date NOT NULL default '0000-00-00', `email` varchar(100) NOT NULL default '', `styleid` smallint(5) unsigned NOT NULL default '0', `parentemail` varchar(50) NOT NULL default '', `homepage` varchar(100) NOT NULL default '', `icq` varchar(20) NOT NULL default '', `aim` varchar(20) NOT NULL default '', `yahoo` varchar(32) NOT NULL default '', `msn` varchar(100) NOT NULL default '', `skype` varchar(32) NOT NULL default '', `showvbcode` smallint(5) unsigned NOT NULL default '0', `showbirthday` smallint(5) unsigned NOT NULL default '2', `usertitle` varchar(250) NOT NULL default '', `customtitle` smallint(6) NOT NULL default '0', `joindate` int(10) unsigned NOT NULL default '0', `daysprune` sm[...] 

MySQL said:  

#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 ')ENGINE=MyISAM DEFAULT CHARSET='latin1'' at line 130

Thanks & Regards

Lynne · #2 01-21-2009, 07:21 PM

What is that from? Perhaps you use a table prefix?

Dismounted · #3 01-22-2009, 02:31 AM

Wait a sec. Why are you dropping your user table, and recreating it?

Before MySQL 4.0.18, you must use "TYPE", after that version, it is "ENGINE".

bahattab · #4 01-22-2009, 05:36 AM

thanks

problem solved