-
Bug
-
Resolution: Resolved
-
Major
-
None
-
3.0.11
-
None
When you have enabled strict SQL checking on the mysql database (ONLY_FULL_GROUP_BY) then you get an db error when you hit the "own posts" button in the forum:
====================================
SQL ERROR [ mysql4 ]
'phpbb3_db.p.post_id' isn't in GROUP BY [1055]
SQL
SELECT DISTINCT SQL_CALC_FOUND_ROWS p.post_id FROM phpbb_topics t, phpbb_posts p WHERE p.poster_id = '2' AND t.topic_id = p.topic_id GROUP BY t.topic_id, t.topic_last_post_time ORDER BY t.topic_last_post_time DESC
BACKTRACE
FILE: [ROOT]/includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()
FILE: [ROOT]/includes/search/fulltext_native.php
LINE: 1009
CALL: dbal_mysql->sql_query()
FILE: [ROOT]/search.php
LINE: 513
CALL: fulltext_native->author_search()
====================================
When you look at the sql statement you can see that it's not valid sql
compared to sql standards.
Best regards
McA
- was obsoleted by solution of
-
PHPBB-14782 Quick Links > Your Posts gives mysql error
- Closed