安装《农场牧场BY--SAM--1231版》出现乱码

完全按照安装说明做的，上一个版面可以安装～～废了一个小时，又要卸载，郁闷....
安装完成后进入home/newfarm.php
MySQL Error
Message: MySQL Query Error
SQL: INSERT INTO uchome_plug_newfarm (uid,farmlandstatus,package,fertilizer,decorative,fruit,dog,nosegay,message,animal,mc_package,mc_log) VALUES(1,'{"farmlandstatus":[{"a":2,"b":6,"f":0,"g":0,"h":1,"i":[],"j":0,"k":16,"l":9,"m":16,"n":"2","o":0,"p":[],"q":1262981003,"r":1251351720,"s":0,"t":0,"u":0},{"a":2,"b":3,"f":1,"g":0,"h":1,"i":[],"j":0,"k":16,"l":9,"m":16,"n":"2","o":0,"p":[],"q":1263002603,"r":1251351725,"s":0,"t":0,"u":0},{"a":2,"b":3,"f":0,"g":0,"h":0,"i":[],"j":0,"k":16,"l":9,"m":16,"n":"2","o":0,"p":[],"q":1263002603,"r":1251351725,"s":0,"t":0,"u":0},{"a":2,"b":3,"f":0,"g":2,"h":1,"i":[],"j":0,"k":16,"l":9,"m":16,"n":"2","o":0,"p":[],"q":1262991803,"r":1251351725,"s":0,"t":0,"u":0},{"a":2,"b":7,"f":0,"g":0,"h":1,"i":[],"j":0,"k":16,"l":9,"m":16,"n":"2","o":0,"p":[],"q":0,"r":1251351725,"s":0,"t":0,"u":0},{"a":2,"b":7,"f":0,"g":0,"h":1,"i":[],"j":0,"k":16,"l":9,"m":16,"n":"2","o":0,"p":[],"q":0,"r":1251351725,"s":0,"t":0,"u":0},{"a":0,"b":0,"f":0,"g":0,"h":1,"i":[],"j":0,"k":0,"l":0,"m":0,"n":"2","o":0,"p":[],"q":0,"r":1251351725,"s":0,"t":0,"u":0},{"a":0,"b":0,"f":0,"g":0,"h":1,"i":[],"j":0,"k":0,"l":0,"m":0,"n":"2","o":0,"p":[],"q":0,"r":1251351725,"s":0,"t":0,"u":0},{"a":0,"b":0,"f":0,"g":0,"h":1,"i":[],"j":0,"k":0,"l":0,"m":0,"n":"2","o":0,"p":[],"q":0,"r":1251351725,"s":0,"t":0,"u":0},{"a":0,"b":0,"f":0,"g":0,"h":1,"i":[],"j":0,"k":0,"l":0,"m":0,"n":"2","o":0,"p":[],"q":0,"r":1251351725,"s":0,"t":0,"u":0},{"a":0,"b":0,"f":0,"g":0,"h":1,"i":[],"j":0,"k":0,"l":0,"m":0,"n":"2","o":0,"p":[],"q":0,"r":1251351725,"s":0,"t":0,"u":0},{"a":0,"b":0,"f":0,"g":0,"h":1,"i":[],"j":0,"k":0,"l":0,"m":0,"n":"2","o":0,"p":[],"q":0,"r":1251351725,"s":0,"t":0,"u":0},{"a":0,"b":0,"f":0,"g":0,"h":1,"i":[],"j":0,"k":0,"l":0,"m":0,"n":"2","o":0,"p":[],"q":0,"r":1251351725,"s":0,"t":0,"u":0},{"a":0,"b":0,"f":0,"g":0,"h":1,"i":[],"j":0,"k":0,"l":0,"m":0,"n":"2","o":0,"p":[],"q":0,"r":1251351725,"s":0,"t":0,"u":0},{"a":0,"b":0,"f":0,"g":0,"h":1,"i":[],"j":0,"k":0,"l":0,"m":0,"n":"2","o":0,"p":[],"q":0,"r":1251351725,"s":0,"t":0,"u":0},{"a":0,"b":0,"f":0,"g":0,"h":1,"i":[],"j":0,"k":0,"l":0,"m":0,"n":"2","o":0,"p":[],"q":0,"r":1251351725,"s":0,"t":0,"u":0},{"a":0,"b":0,"f":0,"g":0,"h":1,"i":[],"j":0,"k":0,"l":0,"m":0,"n":"2","o":0,"p":[],"q":0,"r":1251351725,"s":0,"t":0,"u":0},{"a":0,"b":0,"f":0,"g":0,"h":1,"i":[],"j":0,"k":0,"l":0,"m":0,"n":"2","o":0,"p":[],"q":0,"r":1251351725,"s":0,"t":0,"u":0}]}','{"2":0,"3":0,"4":0,"5":0,"6":0,"7":0,"8":0,"9":0,"10":0,"11":0,"1":0,"14":0,"15":0,"18":0,"19":0,"13":0,"23":0,"26":0,"27":0,"29":0,"31":0,"33":0,"34":0,"35":0,"36":0,"12":0,"16":0,"17":0,"20":0,"101":0,"102":0,"103":0,"104":0,"105":0,"106":0,"107":0,"108":0,"109":0,"110":0,"111":0,"112":0,"113":0,"114":0,"115":0,"116":0,"21":0,"22":0,"117":0,"118":0,"119":0,"120":0,"121":0,"122":0,"123":0,"124":0,"2001":0,"2002":0,"2003":0,"40":0,"24":0,"125":0,"126":0,"127":0,"128":0,"129":0,"130":0,"131":0,"132":0,"25":0}','{"1":0,"2":0,"3":0,"4":0,"5":0,"6":0,"7":0,"8":0,"501":0,"9":0}','{"1":{"1":{"status":1,"validtime":0},"11":{"status":0,"validtime":1},"21":{"status":0,"validtime":1},"31":{"status":0,"validtime":1},"36":{"status":0,"validtime":1},"41":{"status":0,"validtime":1},"46":{"status":0,"validtime":1},"51":{"status":0,"validtime":1},"56":{"status":0,"validtime":1},"61":{"status":0,"validtime":1},"66":{"status":0,"validtime":1},"71":{"status":0,"validtime":1},"76":{"status":0,"validtime":1}},"2":{"2":{"status":1,"validtime":0},"12":{"status":0,"validtime":1},"22":{"status":0,"validtime":1},"32":{"status":0,"validtime":1},"37":{"status":0,"validtime":1},"42":{"status":0,"validtime":1},"47":{"status":0,"validtime":1},"52":{"status":0,"validtime":1},"57":{"status":0,"validtime":1},"62":{"status":0,"validtime":1},"67":{"status":0,"validtime":1},"72":{"status":0,"validtime":1},"77":{"status":0,"validtime":1}},"3":{"3":{"status":1,"validtime":0},"13":{"status":0,"validtime":1},"23":{"status":0,"validtime":1},"33":{"status":0,"validtime":1},"38":{"status":0,"validtime":1},"43":{"status":0,"validtime":1},"48":{"status":0,"validtime":1},"53":{"status":0,"validtime":1},"58":{"status":0,"validtime":1},"63":{"status":0,"validtime":1},"68":{"status":0,"validtime":1},"73":{"status":0,"validtime":1},"78":{"status":0,"validtime":1}},"4":{"4":{"status":1,"validtime":0},"14":{"status":0,"validtime":1},"24":{"status":0,"validtime":1},"34":{"status":0,"validtime":1},"39":{"status":0,"validtime":1},"44":{"status":0,"validtime":1},"49":{"status":0,"validtime":1},"54":{"status":0,"validtime":1},"59":{"status":0,"validtime":1},"64":{"status":0,"validtime":1},"69":{"status":0,"validtime":1},"74":{"status":0,"validtime":1},"79":{"status":0,"validtime":1}}}','{"2":0,"3":0,"4":0,"5":0,"6":0,"7":0,"8":0,"9":0,"10":0,"11":0,"1":0,"14":0,"15":0,"18":0,"19":0,"13":0,"23":0,"26":0,"27":0,"29":0,"31":0,"33":0,"34":0,"35":0,"36":0,"12":0,"16":0,"17":0,"20":0,"101":0,"102":0,"103":0,"104":0,"105":0,"106":0,"107":0,"108":0,"109":0,"110":0,"111":0,"112":0,"113":0,"114":0,"115":0,"116":0,"21":0,"22":0,"117":0,"118":0,"119":0,"120":0,"121":0,"122":0,"123":0,"124":0,"2001":0,"2002":0,"2003":0,"40":0,"24":0,"125":0,"126":0,"127":0,"128":0,"129":0,"130":0,"131":0,"132":0,"25":0}','{"1":{"id":8888,"dogValidTime":1,"status":0,"dogFeedTime":0,"dogUnWorkTime":0},"2":{"id":8889,"dogValidTime":0,"status":0,"dogFeedTime":0,"dogUnWorkTime":0},"3":{"id":8890,"dogValidTime":0,"status":0,"dogFeedTime":0,"dogUnWorkTime":0},"4":{"id":8891,"dogValidTime":0,"status":0,"dogFeedTime":0,"dogUnWorkTime":0},"5":{"id":8892,"dogValidTime":0,"status":0,"dogFeedTime":0,"dogUnWorkTime":0},"6":{"id":8893,"dogValidTime":0,"status":0,"dogFeedTime":0,"dogUnWorkTime":0},"7":{"id":8894,"dogValidTime":0,"status":0,"dogFeedTime":0,"dogUnWorkTime":0},"8":{"id":8895,"dogValidTime":0,"status":0,"dogFeedTime":0,"dogUnWorkTime":0},"9":{"id":8896,"dogValidTime":0,"status":0,"dogFeedTime":0,"dogUnWorkTime":0},"10":{"id":8897,"dogValidTime":0,"status":0,"dogFeedTime":0,"dogUnWorkTime":0},"11":{"id":8898,"dogValidTime":0,"status":0,"dogFeedTime":0,"dogUnWorkTime":0},"12":{"id":8899,"dogValidTime":0,"status":0,"dogFeedTime":0,"dogUnWorkTime":0}}','{"1":0,"2":0,"3":0,"4":0,"5":0,"6":0,"7":0,"8":0,"9":0,"10":0,"11":0,"12":0,"13":0,"14":0,"15":0,"16":0,"17":0,"18":0,"19":0,"20":0,"21":0,"22":0,"23":0,"24":0,"25":0,"26":0,"27":0,"28":0,"29":0,"30":0,"31":0,"32":0,"33":0,"34":0,"35":0,"36":0,"37":0,"38":0,"39":0,"40":0,"41":0,"42":0,"43":0,"44":0,"45":0,"46":0,"47":0,"48":0,"49":0,"50":0,"51":0,"52":0,"53":0,"54":0,"55":0,"56":0,"57":0,"58":0,"59":0,"60":0,"61":0,"62":0,"63":0,"64":0,"65":0,"66":0,"67":0,"68":0,"69":0,"70":0,"71":0,"72":0,"2001":0,"2002":0,"2003":0,"3001":0,"3002":0,"3003":0,"3004":0,"3005":0}','{"a":[],"b":[],"c":[],"d":[],"e":[]}','{"animalfood":20,"animalfeedtime":1263017003,"item1":10111,"item2":10221,"item3":10330,"item4":10441,"animal":[{"buyTime":1244817632,"cId":1002,"postTime":0,"totalCome":0,"tou":""},{"buyTime":0,"cId":0,"postTime":0,"totalCome":0,"tou":""},{"buyTime":0,"cId":0,"postTime":0,"totalCome":0,"tou":""},{"buyTime":0,"cId":0,"postTime":0,"totalCome":0,"tou":""},{"buyTime":0,"cId":0,"postTime":0,"totalCome":0,"tou":""},{"buyTime":0,"cId":0,"postTime":0,"totalCome":0,"tou":""},{"buyTime":0,"cId":0,"postTime":0,"totalCome":0,"tou":""},{"buyTime":0,"cId":0,"postTime":0,"totalCome":0,"tou":""},{"buyTime":0,"cId":0,"postTime":0,"totalCome":0,"tou":""},{"buyTime":0,"cId":0,"postTime":0,"totalCome":0,"tou":""},{"buyTime":0,"cId":0,"postTime":0,"totalCome":0,"tou":""},{"buyTime":0,"cId":0,"postTime":0,"totalCome":0,"tou":""},{"buyTime":0,"cId":0,"postTime":0,"totalCome":0,"tou":""},{"buyTime":0,"cId":0,"postTime":0,"totalCome":0,"tou":""},{"buyTime":0,"cId":0,"postTime":0,"totalCome":0,"tou":""},{"buyTime":0,"cId":0,"postTime":0,"totalCome":0,"tou":""},{"buyTime":0,"cId":0,"postTime":0,"totalCome":0,"tou":""},{"buyTime":0,"cId":0,"postTime":0,"totalCome":0,"tou":""}]}','{"1001":0,"1002":0,"1003":0,"1004":0,"1005":0,"1006":0,"1007":0,"1501":0,"1502":0,"1503":0,"1504":0,"1505":0,"1008":0,"1009":0,"11001":0,"11002":0,"11003":0,"11004":0,"11005":0,"11006":0,"11501":0,"11502":0,"11503":0,"11504":0,"11505":0,"11008":0,"11009":0,"1506":0}','a:2:{s:8:"scrounge";a:0:{}s:4:"help";a:0:{}}')
Error: Unknown column 'mc_log' in 'field list'
Errno.: 1054
Click here to seek help.

把原有的数据库 删除！

重新导入

把所有 农场牧场文件 重新传一下！  

应该可以解决！

回复 2# fweini


    已经试过了，不好使，应该是版本问题，原来11月份的版本就没事......

问题解决了，我还是调用11月份的数据库，看来升级反而没有不升级好～～～
CREATE TABLE `uchome_plug_newfarm` (
  `uid` mediumint(8) 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 '15000',
  `exp` int(10) NOT NULL default '2000',
  `mc_exp` int(10) NOT NULL default '0',
  `fb` int(10) NOT NULL default '50',
  `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',
  `mc_taskid1` int(2) NOT NULL default '0',
  `wenzi` text NOT NULL,
  `bad` int(10) NOT NULL default '0',
  `mc_chat` text NOT NULL,
  `log` text NOT NULL,
  `repertory` text NOT NULL,
  `parade` text NOT NULL,
  `dabian` tinyint(3) unsigned NOT NULL default '0',
  `badtime` int(11) NOT NULL default '0',
  `mc_a` tinyint(3) unsigned NOT NULL default '0',
  `sfeedleft` int(10) NOT NULL default '0',
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
下面是：11月份的同一个表
CREATE TABLE `uchome_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,
  `repertory` text character set utf8 NOT NULL,
  `parade` text character set utf8 NOT NULL,
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

现在的表里没有'mc_log' 这个字段了 应该删除的

1、由于mc_log这个字段是旧日志中使用的，现在对此字段已经无用，已被删除，安装后出错的，打开HOME根目录的newfarm.php文件，查找：
$mc_log = "a:2:{s:8:\"scrounge\";a:0:{}s:4:\"help\";a:0:{}}";
//删除

再找：
,mc_log
//删除

再找：
,'".$mc_log."'
//删除即可