[問題] 幫我看一下是SQL哪裡出問題了?(done)

[黑風凱特]

請問，我在修改版面權限時，出現了下面的文字

代碼: 選擇全部

Could not update auth table

DEBUG MODE

SQL Error : 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 '= 3 WHERE forum_id = 15' at line 1

UPDATE phpbb_forums SET auth_view = 0, auth_read = 0, auth_post = 1, auth_reply = 1, auth_edit = 1, auth_delete = 1, auth_sticky = 3, auth_announce = 3, auth_vote = 1, auth_pollcreate = 1, = 3 WHERE forum_id = 15

Line : 145
File : /home/customer/mani.com.tw/tssimon/phpbb/admin/admin_forumauth.php

我大約知道是SQL出事了，但請問，有人看得出是基本的SQL出問題還是\r

另外加裝的呢?

如果是加裝的MOD影響到...比較好處理一點....我怕是基本的SQL出問題>"<~

請懂的朋友幫我.....>"<

[台灣國際網路資訊]

請問，我在修改版面權限時，出現了下面的文字

代碼: 選擇全部

Could not update auth table

DEBUG MODE

SQL Error : 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 '= 3 WHERE forum_id = 15' at line 1

UPDATE phpbb_forums SET auth_view = 0, auth_read = 0, auth_post = 1, auth_reply = 1, auth_edit = 1, auth_delete = 1, auth_sticky = 3, auth_announce = 3, auth_vote = 1, auth_pollcreate = 1, = 3 WHERE forum_id = 15

Line : 145
File : /home/customer/mani.com.tw/tssimon/phpbb/admin/admin_forumauth.php

我大約知道是SQL出事了，但請問，有人看得出是基本的SQL出問題還是\r

另外加裝的呢?

如果是加裝的MOD影響到...比較好處理一點....我怕是基本的SQL出問題>"<~

請懂的朋友幫我.....>"<

上傳失敗!!你SQL語法可能有誤!!不然!!就是檔案忘記改!!你確定你的Mod是正常的?

[黑風凱特]

那請問這樣有沒有辦法知道是哪類的mod沒裝好嗎?

我的相關資料在簽名檔裡~

謝謝

[台灣國際網路資訊]

那請問這樣有沒有辦法知道是哪類的mod沒裝好嗎?

我的相關資料在簽名檔裡~

謝謝

看錯誤的程式碼好像是風格設定的問題....，你加入網路音樂播放器，你的風格是不是哪裡有改錯呀@_@?

[~倉木麻衣~]

代碼: 選擇全部

UPDATE phpbb_forums SET auth_view = 0, auth_read = 0, auth_post = 1, auth_reply = 1, auth_edit = 1, auth_delete = 1, auth_sticky = 3, auth_announce = 3, auth_vote = 1, auth_pollcreate = 1, [color=red]= 3[/color] WHERE forum_id = 15

看來應該是你的全域公告(global_announcement)安裝過程有問題

[黑風凱特]

對不起....那再請問一下~

是SQL資料庫出錯還是檔案改錯(大約是哪個檔?)~呢?....

>"<~~~

我全域公告裝了很久，一陣子沒動到版面權限~不知道原來裝不完整(只有更改\r

權限會出錯)~~~當時備份忘了留....

能告訴我大約是哪個檔嗎?

代碼: 選擇全部

############################################################## 
## MOD Title:          Global announcement 
## MOD Author:         Niels < ncr@db9.dk > (Niels Chr. R鷣) http://mods.db9.dk 
## MOD Description:    This mod, makes it posible to post global
##                     announcements viewable in all forums.
## MOD Version:        1.2.8
## MOD Compatibility:  2.0.6
## 
## Installation Level: Intermediate
## Installation Time:  15 Minutes (1mn by EasyMOD of Nuttzy)
## Files To Edit:      14
##      [color=red]index.php
##      modcp.php
##      posting.php 
##      search.php 
##      viewforum.php 
##      admin/admin_forumauth.php 
##      admin/admin_ug_auth.php 
##      includes/auth.php
##      includes/constants.php 
##      includes/functions.php
##      language/lang_english/lang_admin.php 
##      language/lang_english/lang_main.php 
##      templates/subSilver/subSilver.cfg 
##      templates/subSilver/viewforum_body.tpl[/color]
##
## Included Files:     3
##      global_announcement_db_update.php
##      root/templates/subSilver/images/folder_global_announce.gif
##      root/templates/subSilver/images/folder_global_announce_new.gif
##
############################################################## 

[~倉木麻衣~]

先檢查這三個檔看看
admin/admin_forumauth.php
admin/admin_ug_auth.php
includes/auth.php

[黑風凱特]

謝謝倉木麻衣>"<~~我成功了~~原來是改admin/admin_ug_auth.php時，

有漏掉兩個地方的空格~