When anyone clicks on any of the following: * View unanswered posts • Search Unread • View new posts • View active topics an error page appears with:
Code: Select all
General Error
SQL ERROR [ mysql4 ]
Not unique table/alias: 'p' [1066]
SQL
SELECT t.*, f.forum_id, f.forum_name, f.forum_solve_text, f.forum_solve_color, tt.mark_time, ft.mark_time as f_mark_time, p.post_text AS first_text_hover, pt.post_text AS last_text_hover, p.post_text AS first_text_hover, pt.post_text AS last_text_hover FROM phpbb_topics t LEFT JOIN phpbb_forums f ON (f.forum_id = t.forum_id) LEFT JOIN phpbb_topics_track tt ON (tt.user_id = 53 AND t.topic_id = tt.topic_id) LEFT JOIN phpbb_forums_track ft ON (ft.user_id = 53 AND ft.forum_id = f.forum_id) LEFT JOIN phpbb_posts p ON (p.post_id = t.topic_first_post_id) LEFT JOIN phpbb_posts pt ON (pt.post_id = t.topic_last_post_id) LEFT JOIN phpbb_posts p ON (p.post_id = t.topic_first_post_id) LEFT JOIN phpbb_posts pt ON (pt.post_id = t.topic_last_post_id) WHERE t.topic_id IN ('6145', '5474', '6007', '5478', '5563', '5551', '5608', '4977', '5883', '60', '5039', '3260', '4458', '3781', '6011', '5899', '3559', '5982', '2578', '3019', '5436', '6081', '3894', '2556', '5896') AND (f.forum_id <> 277 OR f.forum_id IS NULL) ORDER BY t.topic_last_post_time DESC
BACKTRACE
FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()
FILE: search.php
LINE: 756
CALL: dbal_mysql->sql_query()
Many thanks,
Vicky x