Errno.1064 for Discuz!2.5！！！

请注意，此方法只适用于Discuz! 2.5F或SP1，并不适用于更新的版本


遇到Errno.1064问题的朋友遇到的现象和下面这个类似：

Discuz! info: MySQL Query Error

User: admin
Time: 2005-10-26 4:08pm
Script: /bbs/topicadmin.php    //这个文件大多会是bbs/plugins.php，bbs/post.php等

SQL: UPDATE cdb_members SET postnum=postnum-(1), credit=4137,lastpost='1130314081',money=money- WHERE uid='1'
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 'WHERE uid='1'' at line 1
Errno.: 1064

Similar error report has beed dispatched to administrator before.

解决方法如下：

include/post.php，做以下的修改。。。
找到

1. 
   
2. function updatemember($operator, $uid, $credits, $oprize)
   

复制代码

修改成

1. 
   
2. function updatemember($operator, $uid, $credits, $oprize =0)
   

复制代码

找到

1. 
   
2. $addcredit = $addpost = $newcredit = $newpost =0;
   

复制代码

修改成

1. $addcredit = $addpost = $newcredit = $newpost = $newprize =0;

复制代码

然后在它下面增加

1. $newprize = intval("$oprize");

复制代码

找到

1. $db->query("UPDATE $table_members SET postnum=postnum$operator(1), credit=$newcredit, lastpost='$timestamp',money=money$operator$oprize $groupidadd WHERE uid='$uid'");

复制代码

修改成

1. $db->query("UPDATE $table_members SET postnum=postnum$operator(1), credit=$newcredit,lastpost='$timestamp',money=money$operator$newprize $groupidadd WHERE uid='$uid'");

复制代码

储存，应该就没问题了。
试试看。

我也是找到的

[ 本帖最后由 Illumi 于 2007-8-22 17:02 编辑 ]

这个问题不知道是哪个插件的安装所引起的

顶

Script: /bbs/forumdisplay.php

SQL: SELECT  t.* FROM cdb_threads t USE INDEX(displayorder)
    WHERE t.fid='12'
    ORDER BY t.displayorder DESC, t.lastpost DESC
    LIMIT 0,
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 4
Errno.:  1064

Please check-up your MySQL server and forum scripts, similar errors will not be reported again in recent 24
高人，我这个呢？怎么搞？？

瀏覽其他論壇有出現這個問題嗎？

我现在连index都打不开，就是一片空白
之前先是能进论坛，打不开分论坛，后来整个版面变得很奇怪，之后好了一分钟，就完全打不开了

原帖由 小_卡 于 2005-10-28 20:18 发表
Script: /bbs/forumdisplay.php

SQL: SELECT  t.* FROM cdb_threads t USE INDEX(displayorder)
    WHERE t.fid='12'
    ORDER BY t.displayorder DESC, t.lastpost DESC
    LIMIT 0,
Error:  You hav ...

恭喜你中獎

我覺得你們在出現這類問題的時候。應該先檢查一下。你剛才修改過哪裡。

PHP聯系到數據庫。稍微一個字母。一個符號不對。都會癱瘓的。

所以我建議你先檢查一下。樓豬發的那種方法也許只是針對他個人的論壇出現的錯誤。

1. Discuz! info: MySQL Query Error
   
2. 
   
3. User: 精英世家
   
4. Time: 2006-4-23 2:51am
   
5. Script: /bbs/admincp.php
   
6. 
   
7. SQL: ALTER TABLE cdb_sessions MAX_ROWS=
   
8. 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
   
9. Errno.: 1064
   
10. 
    
11. Similar error report has beed dispatched to administrator before.
    

复制代码

这是什么错误啊?  我就是装这个"[插件] [3月13日更新] 贴子标题后自动显示new [钩子版]"https://discuz.dismall.com/thread-251245-1-4.html 没有装好! 可是我又马上把这个改的文件又复原了啊?怎么还出现了这个问题啊!!!

我怎么没有找到include/post.php

Discuz! info: MySQL Query Error

Time: 2006-11-11 1:00am
Script: /bbs/index.php

SQL: SELECT m.uid AS discuz_uid, m.username AS discuz_user, m.password AS discuz_pw,
m.secques AS discuz_secques, m.adminid, m.groupid, m.groupexpiry, m.extgroupids, m.email, m.timeoffset,
m.tpp, m.ppp, m.posts, m.digestposts, m.oltime, m.pageviews, m.credits, m.extcredits1, m.extcredits2, m.extcredits3, m.extcredits4, m.extcredits5,
m.extcredits6, m.extcredits7, m.extcredits8, m.timeformat, m.dateformat, m.pmsound, m.sigstatus, m.invisible,
m.lastvisit, m.lastactivity, m.lastpost, m.newpm, m.accessmasks/*[ Card Center BY PerfectWorks] add 1/1 START*/,m.cards/*[ Card Center BY PerfectWorks] add 1/1 END*/m.xspacestatus, m.editormode, m.customshow
FROM cdb_members m WHERE uid='58'
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 '.xspacestatus, m.editormode, m.customshow
FROM cdb_members m WHERE uid='58'' at line 5
Errno.: 1064

Similar error report has beed dispatched to administrator before.

我这个怎么办呢?注册时频繁出现,但有时候也不出现...帮帮忙啊