Remove Subject from Replies

Not unique table/alias: 't' [1066] - Remove Subject from Replies

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

by cspld » Wed Dec 21, 2016 10:01 am

Greetings,
I have installed this EXT, but I can't get it working :s
When I activate it in the ADM I get this error (on the board index) :

SQL ERROR [ mysqli ]

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

SQL

SELECT f.*, ft.mark_time, t.bestanswer_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_forums_track ft ON (ft.user_id = 2 AND ft.forum_id = f.forum_id) LEFT JOIN phpbb_posts p ON (f.forum_last_post_id = p.post_id) LEFT JOIN phpbb_topics t ON (t.topic_id = p.topic_id) LEFT JOIN phpbb_topics t ON (t.topic_last_post_id = f.forum_last_post_id) ORDER BY f.left_id

BACKTRACE
cspld
Registered User
Posts: 6
Joined: Tue Mar 29, 2016 8:37 pm
Contact:

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

by sakkiotto » Sun Dec 25, 2016 1:46 am

me too..
sakkiotto
Registered User
Posts: 231
Joined: Mon Jun 13, 2005 9:45 pm
Contact:

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

by RMcGirr83 » Sun Dec 25, 2016 12:02 pm

Probably a collision from another extension. What extensions do you have installed?
Appreciate the extensions/mods/support then buy me a beerImage
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
User avatar
RMcGirr83
Former Team Member
Posts: 21608
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

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

by sakkiotto » Mon Dec 26, 2016 12:23 am

a lot... im testing one a one to find the extension guilty :D
sakkiotto
Registered User
Posts: 231
Joined: Mon Jun 13, 2005 9:45 pm
Contact:

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

by Senky » Tue Jan 10, 2017 3:37 pm

Hi sakkiotto,
did you find the culprit? I can fix this by renaming alias to be unique regarding my extension. In fact, I will do this to prevent further errors in future. Thanks for your report, it is very valuable to the quality of the extension!
‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎📝‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎ ‎‏‎‏‏‎ ‎ ‎ ‎🔔 ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎ ‎‎ ‎ ‎ ‎ ‎ ‎ ‎‏‏‎ ‎‏‏‎ ‎ ‎🛠
Forms Extension | Browser & Mobile Notifications Extension | Mixed Content Fixer Extension
Senky
Extension Customisations
Extension Customisations
Posts: 2290
Joined: Thu Apr 30, 2009 8:49 pm
Name: Jakub
Contact:

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

by Leinad4Mind » Mon Jan 16, 2017 4:33 am

Easy...

Open listener.php

FIND:
$sql_ary['LEFT_JOIN'][] = array(

REPLACE WITH:
$sql_ary['INNER_JOIN'][] = array(
Want to access all my portuguese MOD and Extension translations?
Become my Patreon!
phpBB Portugal Translator and Moderator
User avatar
Leinad4Mind
Translator
Posts: 855
Joined: Sun Jun 01, 2008 11:08 pm
Contact:

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

by Leinad4Mind » Tue Feb 07, 2017 4:15 pm

Btw, the culprit extension causing the issue is Topic Icon, almost for sure.
My above fix will work, but it's better to fix from topic icon. Cheers
Want to access all my portuguese MOD and Extension translations?
Become my Patreon!
phpBB Portugal Translator and Moderator
User avatar
Leinad4Mind
Translator
Posts: 855
Joined: Sun Jun 01, 2008 11:08 pm
Contact: