我的问题就在这.
农场无法打开.一直处在加载状态.
点牧场可以正常打开.做任务初始资金却不够买动物的
philchu 发表于 2009-11-2 23:49
装了您的1.0V2版本农场出错,提示如下,帮忙看看怎么解决。感激不尽!~
错误
SQL 查询:
CREATE TABLE `renren_plug_newfarm` (
`uid` mediumint( 8 ) NOT NULL ,
`farmlandstatus` text CHARACTER SET utf8 NOT NULL ,
`animal` text CHARACTER SET utf8 NOT NULL ,
`taskid` int( 2 ) NOT NULL default '1',
`charm` int( 10 ) NOT NULL default '0',
`money` int( 10 ) NOT NULL default '0',
`exp` int( 10 ) NOT NULL default '0',
`mc_exp` int( 10 ) NOT NULL default '0',
`fb` int( 10 ) NOT NULL default '0',
`reclaim` smallint( 2 ) NOT NULL default '6',
`package` text CHARACTER SET utf8 NOT NULL ,
`mc_package` text CHARACTER SET utf8 NOT NULL ,
`fertilizer` text CHARACTER SET utf8 NOT NULL ,
`decorative` text CHARACTER SET utf8 NOT NULL ,
`fruit` text CHARACTER SET utf8 NOT NULL ,
`dog` text CHARACTER SET utf8 NOT NULL ,
`nosegay` text CHARACTER SET utf8 NOT NULL ,
`message` text CHARACTER SET utf8 NOT NULL ,
`mc_taskid` int( 2 ) NOT NULL default '0',
`mc_taskid1` int( 2 ) NOT NULL default '0',
`mc_log` text CHARACTER SET utf8 NOT NULL ,
`farm_log` text CHARACTER SET utf8 NOT NULL ,
`wenzi` text CHARACTER SET utf8 NOT NULL ,
`bad` int( 10 ) NOT NULL default '0',
`mc_chat` text CHARACTER SET utf8 NOT NULL ,
`log` text CHARACTER SET utf8 NOT NULL ,
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 'character set utf8 NOT NULL,
`animal` text character set utf |