NV Last Topic Title Not Working

Support for the phpBB3 SEO mods released in the phpBB3 SEO Toolikt forum.

Moderator: Moderators

NV Last Topic Title Not Working

Postby rohansakhale » Fri Mar 18, 2011 10:35 am

Hello,
I have been trying to install this mod,
http://www.phpbb.com/customise/db/mod/last_post_topic_title/


But i get some error which i am not able to debug,

Error:
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()




Problem occuring over here,
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


I am using the latest release of php-seo

Thank you
rohansakhale
 
Posts: 13
Joined: Sat Mar 13, 2010 8:35 am

Advertisement

Re: NV Last Topic Title Not Working

Postby dcz » Fri Mar 18, 2011 8:29 pm

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.
Useful links :
SEO Forum || SEO Directory || SEO phpBB || Search
____________________

Liens Utiles :
Forum référencement || Annuaire référencement || Référencement phpBB || Recherche
dcz
Admin
Admin
 
Posts: 21391
Joined: Fri Apr 28, 2006 9:03 pm

Re: NV Last Topic Title Not Working

Postby rohansakhale » Sat Mar 19, 2011 1:09 am

Oh i see, i used the pre-mod SEO, where can i find changes to be done in style.

I am using all the features given in the pre-mod 3.0.8

I have changed the style from prosilver to similar type of it,
changes i did on it for php-seo mod till now,
edited
overall-header.html
simple-header.html
forum_fn.js
rohansakhale
 
Posts: 13
Joined: Sat Mar 13, 2010 8:35 am

Re: NV Last Topic Title Not Working

Postby dcz » Sat Mar 19, 2011 9:28 am

Useful links :
SEO Forum || SEO Directory || SEO phpBB || Search
____________________

Liens Utiles :
Forum référencement || Annuaire référencement || Référencement phpBB || Recherche
dcz
Admin
Admin
 
Posts: 21391
Joined: Fri Apr 28, 2006 9:03 pm

Re: NV Last Topic Title Not Working

Postby rohansakhale » Sat Mar 19, 2011 9:54 am

Working fine now,

Thanks a lot :D
rohansakhale
 
Posts: 13
Joined: Sat Mar 13, 2010 8:35 am

Re: NV Last Topic Title Not Working

Postby SeLoRe28 » Mon Apr 25, 2011 2:00 pm

I do it all of them but error continuing :(
SeLoRe28
 
Posts: 4
Joined: Mon Apr 11, 2011 8:35 am

Re: NV Last Topic Title Not Working

Postby dcz » Mon Apr 25, 2011 3:57 pm

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.
Useful links :
SEO Forum || SEO Directory || SEO phpBB || Search
____________________

Liens Utiles :
Forum référencement || Annuaire référencement || Référencement phpBB || Recherche
dcz
Admin
Admin
 
Posts: 21391
Joined: Fri Apr 28, 2006 9:03 pm


Return to phpBB SEO MODS

 


  • Related topics
    Replies
    Views
    Last post

Who is online

Users browsing this forum: No registered users and 7 guests