cosfox

ռλ

adidas

ÕÒ²»µ½ ENGINE=HEAP DEFAULT CHARSET=latin1

wowotou

dz4Ò²Ò»Ñù£¿

wang2

Discuz! info: MySQL Query Error

User: admin
Time: 2005-12-18 5:19pm
Script: /main.php

SQL: SELECT subject ,message FROM cdb_posts where tid=
Error: 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 '' at line 1
Errno.: 1064

An error report has been dispatched to our administrator.

DeaDenD

ÎÒµÄûÓÐÌáʾʲô´íÎ󣬺Ü˳ÀûµÄ¾Íµ¼ÈëÁË£¬µ«ÊÇÍê³Éºó£¬ÂÛ̳µÄÖÐÎľͱä³ÉÎʺÃÁË

ÇëÎÊ£¬ÕâÊÇʲôԭÒò£¿

ak123321

ÎÒ·¢Ìû×ÓÁË,¿ÉÊÇûÈ˸ø´ð°¸,

http://www.zztx.be/
http://zztx.globalfreeweb.com/
ÓõÄÊÇÒ»¸ö¿Õ¼ä,Ϊʲô»áÕâÑùÄØ
ÏÔʾһ¸öÊÇ2.5Ò»¸öÊÇ4.0  
Ϊʲô»áÕâÑùÄØ?Ôõô½â¾ö°¡

journey99

Discuz! info: MySQL Query Error

User: vivi
Time: 2006-1-1 1:48pm
Script: /admincp.php

SQL: CREATE TABLE `cdb_forums` ( `fid` smallint(6) unsigned NOT NULL auto_increment, `fup` smallint(6) unsigned NOT NULL default '0', `type` enum('group','forum','sub') NOT NULL default 'forum', `name` varchar(255) NOT NULL default '', `cates` varchar(150) NOT NULL default '_ËùÓÐÎÄÕÂ', `status` tinyint(1) NOT NULL default '0', `displayorder` tinyint(3) NOT NULL default '0', `styleid` smallint(6) unsigned NOT NULL default '0', `threads` mediumint(8) unsigned NOT NULL default '0', `posts` mediumint(8) unsigned NOT NULL default '0', `todayposts` mediumint(8) unsigned NOT NULL default '0', `lastpost` varchar(110) NOT NULL default '', `allowsmilies` tinyint(1) NOT NULL default '0', `allowhtml` tinyint(1) NOT NULL default '0', `allowbbcode` tinyint(1) NOT ðhT€ðhT€ '0' è€`allowimgcode` tinyint(1) NOT NULL default '0', `allowblog` tinyint(1) NOT NULL default '0', `allowtrade` tinyint(1) NOT NULL default '0', `alloweditrules` tinyint(1) NOT NULL default '0', `recyclebin` tinyint(1) NOT NULL default '0', `modnewposts` tinyint(1) NOT NULL default '0', `jammer` tinyint(1) NOT NULL default '0', `disablewatermark` tinyint(1) NOT NULL default '0', `inheritedmod` tinyint(1) NOT NULL default '0', `autoclose` smallint(6) NOT NULL default '0', PRIMARY KEY (`fid`), KEY `forum` (`status`,`type`,`displayorder`), KEY `fup` (`fup`)) TYPE=MyISAM AUTO_INCREMENT=34
Error: 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 'ðhT€ðhT€' at line 1
Errno.: 1064

Similar error report has beed dispatched to administrator before.

jingzhongyue_1

´Ómysql 4.1.16->4.0.23µ¼ÈëÊý¾Ý¿âʱ³öÏÖÒÔÏ´íÎó

mysql -u mysql_user -pmysql_password sqldb <backup.sql

ERROR 1064 at line 19: 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 CHARSET=big5' at line 10

ÓÃÒÔÉÏËù˵·½·¨£¬Î´ÄÜÕÒµ½ÄÇЩ±£Áô×Ö£¬Çë½Ì£¬Ó¦ÈçºÎ½â¾ö¡£Ð»Ð»

[ ±¾Ìû×îºóÓÉ jingzhongyue_1 ÓÚ 2006-1-9 16:15 ±à¼­ ]

Á÷´«¶¯

¿´ÁË°ëÌìºÃÏóûÓм¸¸öŪºÃµÄ°¡

e320

ÎÒ°á¼ÒºóÈ«ÊÇÎʺţ¿Ôõô°ì£¿http://jzbbs.be/bbs