Dz5.0.0回帖机器人0.0.7版发布 原作者:oytktk

!!!!!!!!!!!!!!!!!!!!!!!!!!

升级错误，MySQL 提示: 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 CHARACTER SET gbk COLLATE gbk_chinese_ci' at line 1

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 'ENGINE=MyISAM DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci'


您有一个错误在您的SQL句法。 检查对应于您的MySQL服务器版本为正确的句法于近用途‘ENGINE=MyISAM缺省字符集gbk校对gbk_chinese_ci’的指南


什么问题‘ENGINE=MyISAM缺省字符集gbk校对gbk_chinese_ci’的指南

已经成功安装~非常感谢！

支持发布插件！
鄙视论坛一些乱打击人的人！

升级错误，MySQL 提示: 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 CHARACTER SET gbk COLLATE gbk_chinese_ci' at line 1

[ 本帖最后由 19851021 于 2006-11-3 12:52 编辑 ]

linux系统，安装成功，PHP是4.4.4  ，MYSQL是：4.0.25  ，没有乱码，不过打开macher.php 页面的时候，总提示我“无法通过密码的验证, 无法进行接下来的工作!”

我想，这个错误不是系统的问题吧，是哪里的问题呢？

顶起来，请作者帮忙下

我的服务器环境：

操作系统及 PHP FreeBSD / PHP v4.3.10RC2
MySQL 版本 3.23.58
上传许可 是: file 2M - form 8M
当前数据库尺寸 2.26 M
当前附件尺寸 [ 详情 ]
文件权限检查 [ 检查 ]


用4.0升级数据库会出现如下错误：
升级错误，MySQL 提示: You have an error in your SQL syntax near 'ENGINE=MyISAM' at line 1


用5。0数据库会出现如下错误：


升级错误，MySQL 提示: You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci' at line 1

请问如何解决，谢谢！

我的使用如下代码：
调试成功：

drop table if exists cdb_postmach;

create table cdb_postmach (
  style varchar(20) not null default '',
  sside varchar(254) not null default '',
  cdate int(18) not null default '0',
  value text not null
) TYPE=MyISAM;


insert into cdb_postmach values ('set', '0', 0, 'thison');
insert into cdb_postmach values ('set', '0', 0, 'other');
insert into cdb_postmach values ('set', '18', 0, 'reftime');
insert into cdb_postmach values ('set', '5', 0, 'whatis');
insert into cdb_postmach values ('set', '15', 0, 'usertime');
insert into cdb_postmach values ('set', '0', '0', 'posttid');
insert into cdb_postmach values ('set', '18', 0, 'posttime');
insert into cdb_postmach values ('set', '2', '0', 'moneys');
insert into cdb_postmach values ('set', '3', 0, 'replytime');
insert into cdb_postmach values ('set', '0', 0, 'fids');
insert into cdb_postmach values ('set', '2', 0, 'ext_type');
insert into cdb_postmach values('set', '1', 0, 'closetopic');
insert into cdb_postmach values ('set', '0', 0, 'moderatedstatus');