竹貓星球

狂暴戰龍 寫:問題外掛：(The Blog Mod0.2.3)
參考連結：(http://phpbb-tw.net/phpbb/viewtopic.php ... e+Blog+Mod)
使用版本：(phpBB 2.0.17)
網站位置：(http://nicecountry.dyndns.tv/phpbb2/index.php)
外掛安裝列表請參考: (http://nicecountry.dyndns.tv/phpbb2/mods.php)
狀況描述：The Blog Mod只有系統管理員能用,其他會員都不能用\r
錯誤代碼:

代碼: 選擇全部

Couldn't obtain mood data from database

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 'ORDER BY mood_text' at line 4

SELECT * FROM phpbb_weblog_moods WHERE mood_set = ORDER BY mood_text

Line : 794
File : weblog_config.php

試過修復資料表phpbb_weblog_moods了..找不出什麼原因@@請各位大大幫幫忙吧

$sql = "SELECT *
FROM " . WEBLOG_MOODS_TABLE . "
WHERE mood_set = " . $mood_set . "
ORDER BY mood_text";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Couldn't obtain mood data from database", "", __LINE__, __FILE__, $sql);
}

在後台-> 網誌控制台-> 基本組態-> 要求認證

狂暴戰龍 寫:要求認證我選否(應該是預設值吧@@)

測試帳號:抖你
測試密碼:54321

謝謝囉

狂暴戰龍 寫:

代碼: 選擇全部

$sql = "SELECT *
FROM " . WEBLOG_MOODS_TABLE . "
WHERE mood_set = " . $mood_set . "
ORDER BY mood_text";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Couldn't obtain mood data from database", "", __LINE__, __FILE__, $sql);
}
$mood_data = $db->sql_fetchrowset($result);

$i = mt_rand(0,count($mood_data)-1);
$preview_mood = $mood_data[$i]['mood_url'];

以上是788~799行的程式碼\r

謝謝