竹貓星球

代碼: 選擇全部

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()

代碼: 選擇全部

      $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);