Discuz! info: MySQL Query Error 
 
User: help99 
Time: 2007-1-16 11:11pm 
Script: /bbs/pet_install.php 
 
SQL: CREATE TABLE IF NOT EXISTS `pet_item` ( 
`id` smallint(5) unsigned NOT NULL auto_increment, 
`itemname` varchar(15) NOT NULL default '', 
`cname` varchar(30) NOT NULL default '', 
`moretxt` mediumtext NOT NULL, 
`selltag` tinyint(1) unsigned NOT NULL default '0', 
`money` int(10) unsigned NOT NULL default '0', 
`pic` varchar(100) NOT NULL, 
`itemtype` tinyint(1) unsigned NOT NULL default '0', 
`requirejob` smallint(4) unsigned NOT NULL default '0', 
`requirelevel` mediumint(6) unsigned NOT NULL default '0', 
`addnum` mediumint(6) unsigned NOT NULL default '0', 
`droptag` tinyint(1) unsigned NOT NULL default '0', 
`droplevel` smallint(6) unsigned NOT NULL default '0', 
`droprange` tinyint(3) unsigned NOT NULL default '100', 
`storagetag` tinyint(1) unsigned NOT NULL default '1', 
PRIMARY KEY (`id`), 
UNIQUE KEY `itemname` (`itemname`) 
) ENGINE=MyISAM DEFAULT CHARSET=gbk; 
Error: 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 'DEFAULT CHARSET=gbk' at line 19 
Errno.: 1064 
 
Similar error report has beed dispatched to administrator before. 
 
 
什么原因 ? |