Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Duplicate
-
3.2.9
-
None
-
None
Description
Following error is displayed when using the "view more smileys" link (also happens on phpbb.com):
SQL ERROR [ mysqli ]
|
|
|
Unknown column 's.min_smiley_order' in 'order clause' [1054]
|
|
|
SQL
|
|
|
SELECT s.smiley_url, MIN(s.emotion) AS emotion, MIN(s.code) AS code, s.smiley_width, s.smiley_height, MIN(s.smiley_order) AS min_smiley_order FROM (uhm_smilies s) GROUP BY s.smiley_url, s.smiley_width, s.smiley_height ORDER BY s.min_smiley_order LIMIT 50
|
|
|
BACKTRACE
|
|
|
FILE: (not given by php)
|
LINE: (not given by php)
|
CALL: msg_handler()
|
|
|
FILE: [ROOT]/phpbb/db/driver/driver.php
|
LINE: 997
|
CALL: trigger_error()
|
|
|
FILE: [ROOT]/phpbb/db/driver/mysqli.php
|
LINE: 196
|
CALL: phpbb\db\driver\driver->sql_error()
|
|
|
FILE: [ROOT]/phpbb/db/driver/mysql_base.php
|
LINE: 45
|
CALL: phpbb\db\driver\mysqli->sql_query()
|
|
|
FILE: [ROOT]/phpbb/db/driver/driver.php
|
LINE: 270
|
CALL: phpbb\db\driver\mysql_base->_sql_query_limit()
|
|
|
FILE: [ROOT]/phpbb/db/driver/factory.php
|
LINE: 321
|
CALL: phpbb\db\driver\driver->sql_query_limit()
|
|
|
FILE: [ROOT]/includes/functions_posting.php
|
LINE: 157
|
CALL: phpbb\db\driver\factory->sql_query_limit()
|
|
|
FILE: [ROOT]/posting.php
|
LINE: 184
|
CALL: generate_smilies()
|
Caused by this commit: https://github.com/phpbb/phpbb/commit/6cab639d8e9fb476e1bf14c3075de980beb78c73
The column reference of "s.min_smiley_order" should not have the "s." table reference.
Attachments
Issue Links
- duplicates
-
-
- Closed
-