[新手求助]表情符號包使用問題

[小眼仔]

安裝表情符號包http://phpbb-tw.net/phpbb/viewtopic.php?f=141&t=50199
依步驟安裝一切順利
但在使用上 , 點選"顯示更多表情符號"時出現一下狀況

一般性錯誤
SQL ERROR [ mysql4 ]

Invalid use of group function [1111]

SQL

SELECT smiley_url, MIN(emotion) as emotion, MIN(code) AS code, smiley_width, smiley_height FROM phpbb_smilies GROUP BY smiley_url, smiley_width, smiley_height ORDER BY MIN(smiley_order) LIMIT 50

BACKTRACE


FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/db/mysql.php
LINE: 221
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()

FILE: includes/functions_posting.php
LINE: 92
CALL: dbal->sql_query_limit()

FILE: posting.php
LINE: 126
CALL: generate_smilies()

想詢問要如何解決

[心靈捕手]

建議您：
補齊發問格式。
http://phpbb-tw.net/phpbb/viewtopic.php?f=140&t=50455

[小眼仔]

補上
●安裝風格：[推薦] 可愛活潑的動畫 表情圖(可快速安裝)
●錯誤代碼：一般性錯誤

代碼: 選擇全部

SQL ERROR [ mysql4 ]

Invalid use of group function [1111]

SQL

SELECT smiley_url, MIN(emotion) as emotion, MIN(code) AS code, smiley_width, smiley_height FROM phpbb_smilies GROUP BY smiley_url, smiley_width, smiley_height ORDER BY MIN(smiley_order) LIMIT 50

BACKTRACE


FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/db/mysql.php
LINE: 221
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()

FILE: includes/functions_posting.php
LINE: 92
CALL: dbal->sql_query_limit()

FILE: posting.php
LINE: 126
CALL: generate_smilies()

[心靈捕手]

建議您：
提供測試用帳號與密碼。

[小眼仔]

附上測試帳號
帳號 : test
密碼 : 123456

[心靈捕手]

補上
●安裝風格：[推薦] 可愛活潑的動畫 表情圖(可快速安裝)
●錯誤代碼：一般性錯誤

代碼: 選擇全部

SQL ERROR [ mysql4 ]

Invalid use of group function [1111]

SQL

SELECT smiley_url, MIN(emotion) as emotion, MIN(code) AS code, smiley_width, smiley_height FROM phpbb_smilies GROUP BY smiley_url, smiley_width, smiley_height ORDER BY MIN(smiley_order) LIMIT 50

BACKTRACE


FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/db/mysql.php
LINE: 221
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()

FILE: includes/functions_posting.php
LINE: 92
CALL: dbal->sql_query_limit()

FILE: posting.php
LINE: 126
CALL: generate_smilies()

試試以下修改：
--開啟--
includes/functions_posting.php

--找到--

代碼: 選擇全部

      $sql = 'SELECT smiley_url, MIN(emotion) as emotion, MIN(code) AS code, smiley_width, smiley_height
         FROM ' . SMILIES_TABLE . '
         GROUP BY smiley_url, smiley_width, smiley_height
         ORDER BY MIN(smiley_order)';
      $result = $db->sql_query_limit($sql, $config['smilies_per_page'], $start, 3600);

--取代成--

代碼: 選擇全部

        $sql = 'SELECT smiley_url, MIN(emotion) as emotion, MIN(code) AS code, smiley_width, smiley_height, MIN(smiley_order) AS min_smiley_order
            FROM ' . SMILIES_TABLE . '
            GROUP BY smiley_url, smiley_width, smiley_height
            ORDER BY min_smiley_order';
      $result = $db->sql_query_limit($sql, $config['smilies_per_page'], $start, 3600);

--儲存及關閉--

參考連結：
http://www.phpbb.com/community/viewtopi ... #p12638145

[小眼仔]

已完成修正
感謝