http://www.phpbb.com/customise/db/mod/last_post_topic_title/

Code: Select all

General Error
SQL ERROR [ mysqli ]

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

SQL

SELECT f.*, ft.mark_time, t.topic_title, t.topic_id, t.topic_last_post_id, 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 = 2 AND ft.forum_id = f.forum_id) LEFT JOIN phpbb_topics t ON (f.forum_last_post_id = t.topic_last_post_id AND t.topic_moved_id = 0) LEFT JOIN phpbb_topics t ON (f.forum_last_post_id = t.topic_last_post_id) ORDER BY f.left_id

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/functions_display.php
LINE: 117
CALL: dbal_mysqli->sql_query()

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

Code: Select all

$sql_array['SELECT'] .= ', fa.user_id';
   }
   if (!class_exists('phpbb_mods_advanced_last_topic_titles'))
   {
      include($phpbb_root_path . 'includes/mods/advanced_last_topic_titles.' . $phpEx);
   }
   phpbb_mods_advanced_last_topic_titles::initialise();
   $sql_array = phpbb_mods_advanced_last_topic_titles::inject_sql($sql_array);
   // www.phpBB-SEO.com SEO TOOLKIT BEGIN -> no dupe
   if (@$phpbb_seo->seo_opt['no_dupe']['on']) {
      $sql_array['SELECT'] .= ', t.topic_id, t.topic_title, t.topic_replies, t.topic_replies_real, t.topic_status, t.topic_type, t.topic_moved_id' . (!empty($phpbb_seo->seo_opt['sql_rewrite']) ? ', t.topic_url ' : ' ');
      $sql_array['LEFT_JOIN'][] = array(
         'FROM'   => array(TOPICS_TABLE => 't'),
         'ON'   => "f.forum_last_post_id = t.topic_last_post_id"
      );
   }
   // www.phpBB-SEO.com SEO TOOLKIT END -> no dupe

overall-header.html
simple-header.html
forum_fn.js

dcz wrote:This is because this mod is doing more or less the same sql as the no duplicate, both cannot work together. The nod dupe will achieve the same purpose as the nv mod (that is display last topic title on forum's index) except it will do it with rewritten urls.