-
Bug
-
Resolution: Duplicate
-
Major
-
None
-
3.0.7-PL1
-
None
-
Linux 1.1.63 2.6.32.7-SE #26 SMP Sat Apr 24 01:56:40 EDT 2010 x86_64
PHP Version 5.2.6
Mysql 5.0.32
When some user opens the "More Emoticons" popup:
Error General
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 phpbb3_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()
- duplicates
-
PHPBB-9122 SQL ERROR when opening external 'view more smiliies' window
- Closed