山姆你好,看到你发的3.3版农场插件,很漂亮!先感谢谢你提供这么好的东东!我下了之后,按你的说明操作,到了导入数据库文的时候,uchome_plug_newfarm文件导入出错,提示为:
CREATE TABLE `uchome_plug_newfarm` (
`uid` mediumint( 8 ) unsigned NOT NULL default '0', `username` varchar( 20 ) NOT NULL , `farmlandstatus` text NOT NULL , `animal` text NOT NULL , `taskid` int( 2 ) NOT NULL default '1', `charm` int( 10 ) NOT NULL default '0', `money` int( 10 ) NOT NULL default '0', `fb` int( 10 ) NOT NULL default '0', `exp` int( 10 ) NOT NULL default '0', `mc_exp` int( 10 ) NOT NULL default '0', `reclaim` smallint( 2 ) NOT NULL default '6', `package` text NOT NULL , `mc_package` text NOT NULL , `fertilizer` text NOT NULL , `decorative` text NOT NULL , `fruit` text NOT NULL , `dog` text NOT NULL , `nosegay` text NOT NULL , `message` text NOT NULL , `mc_taskid` int( 2 ) NOT NULL default '0', `wenzi` text NOT NULL , `bad` int( 10 ) NOT NULL default '0', `mc_chat` text NOT NULL , `repertory` text NOT NULL , `parade` text NOT NULL , `dabian` tinyint( 3 ) NOT NULL default '0', `badtime` int( 11 ) NOT NULL default '0', `sfeedleft` int( 10 ) NOT NULL default '0', `levelup` int( 10 ) NOT NULL default '200', `activity` int( 2 ) NOT NULL default '0', PRIMARY KEY ( `uid` )
) ENGINE = MYISAM DEFAULT CHARSET = gbk;
MySQL 返回:
#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 'CREATE TABLE `uchome_plug_newfarm` (
`uid` mediumint(8) unsigned NOT NULL ' at line 1
另外其他三个数据库导入正常,
在主页点击农场按钮出现错误提示:
MySQL Error
Message: MySQL Query Error
SQL: SELECT uid FROM uchome_plug_newfarm where uid=1
Error: Table 'sqlyulifengsql.uchome_plug_newfarm' doesn't exist
Errno.: 1146
我的站点是:www.LB26.com能帮我想个想决办法吗,谢谢! |