Hello all,

I am having some troubles with trying to add a mod that will show the most recent topic title on the index page of my forum. I have tried two different mods that will do this and see the same error with both. I am using the pre-modded version of phpbb 3.5 offered on this site. So far I only have two other mods installed (phpbb gallery and arcade), neither of which have any changes on the functions_display.php file. Since the error only shows if/when that file is modified, I'm guessing that there might be a conflict with the phpbb SEO mod and I'm hoping someone can help me. Here is the error:

Code: Select all

SQL ERROR [ mysql4 ]

Not unique table/alias: 't' [1066]

SQL

SELECT f.*, ft.mark_time, t.topic_id, t.topic_title, t.topic_id, t.topic_title, t.topic_replies, t.topic_replies_real, t.topic_status, t.topic_type, t.topic_moved_id, t.topic_url FROM (phpbb_forums f) LEFT JOIN phpbb_forums_track ft ON (ft.user_id = 53 AND ft.forum_id = f.forum_id) LEFT JOIN phpbb_topics t ON (f.forum_last_post_id = t.topic_last_post_id) LEFT JOIN phpbb_topics t ON (t.topic_last_post_id = f.forum_last_post_id) ORDER BY f.left_id

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/functions_display.php
LINE: 115
CALL: dbal_mysql->sql_query()

FILE: index.php
LINE: 59
CALL: display_forums()

Any ideas on how I can fix this issue?

It looks like you're trying to use the last topic title on index mod (adding topic title's to last post link on index) with the no duplicate mod, and this is not possible because both mods will do the same thing (hence the double LEFTJOIN issue on topic table in functions_display.php), except the no dupe will additionally add a link to the topic itself and that it is compatible with our url rewriting mods.
So you don't need the last topic mod any more, just uninstall it

++