Discuz!官方免费开源建站系统

 找回密码
 立即注册

QQ登录

只需一步,快速开始

搜索

[疑难] 山姆3.3版农场数据库导入出错?请高手看看

[复制链接]
yulifeng 发表于 2010-3-24 12:00:10 | 显示全部楼层 |阅读模式
UCHome模板
适用版本: UCHome 2.0
语言编码: GBK简体 
风格转换者:
山姆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谁能帮我个想决办法,最好详细些的,谢谢!
 楼主| yulifeng 发表于 2010-3-24 12:01:27 | 显示全部楼层
急等中,有高手回复吗?
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

手机版|小黑屋|Discuz! 官方站 ( 皖ICP备16010102号 )star

GMT+8, 2024-11-17 12:33 , Processed in 0.043961 second(s), 4 queries , Gzip On, Redis On.

Powered by Discuz! X3.4

Copyright © 2001-2023, Tencent Cloud.

快速回复 返回顶部 返回列表