-
Bug
-
Resolution: Duplicate
-
None
-
3.0.7-PL1
-
None
-
PHP Environment:
Database:
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 olympus_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()
xxx/posting.php?mode=smilies&f=7 as example, only appears after upgrading to latest version 3.0.7-PL1 (2 of my forums have this error, different themes) (other forum with version 3.0.6 no issues)
- duplicates
-
PHPBB-9114 Recent bug fix for smilies causing problems on older MySQL versions
- Closed
- is duplicated by
-
PHPBB-9584 More Emoticons sql error
- Closed