-
Bug
-
Resolution: Duplicate
-
None
-
3.0.6
-
None
-
PHP Environment:
Database: MSSQL
I was adding a bunch of new smiles to my board, when I later tested them I got the link to "view more smiles" that fired a popup window. Got a General error which I traced back to a mal-formed SQL statement.
/includes/functions_posting.php Line 90
SQL needs to have the ORDER BY column in the GROUP BY
Here is the fix
GROUP BY smiley_url, smiley_width, smiley_height, smiley_order
- duplicates
-
PHPBB-8929 MS SQL error on view all smilies after 3.0.6 upgrade
- Closed