help sql error

phpBB SEO Premod for phpBB3 support forum.
This premodded version of phpBB3 includes the three different type of URL rewriting for phpBB3 by phpBB SEO. It comes with several other Search Engine Optimization mods installed.

Moderator: Moderators

help sql error

Postby psilocybin » Thu May 21, 2009 2:28 am

i just installed premodded version
restored my backup of my old forum

set my settings in seo settings..im using mixed

copied and pasted the .htaccess file the seo mod gave me in the seo mod tab

and i get this when i switch on no duplicates..

General Error
SQL ERROR [ mysqli ]

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

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

i inserted the sql entry in phpadmin..but i dont know my proper table values if that has something to do with it
psilocybin
 
Posts: 8
Joined: Thu May 21, 2009 2:25 am

Advertisement

Re: help sql error

Postby psilocybin » Thu May 21, 2009 2:48 am

ok i get this now at the main index page. after running this ALTER TABLE `phpbb_topics` ADD INDEX ( `topic_last_post_id` );

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 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 (t.topic_last_post_id = f.forum_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: 116
CALL: dbal_mysqli->sql_query()

FILE: index.php
LINE: 47
CALL: display_forums()
psilocybin
 
Posts: 8
Joined: Thu May 21, 2009 2:25 am

Re: help sql error

Postby dcz » Mon May 25, 2009 11:17 am

It looks like you are basically running two mods doing the same thing.
You must be using one of the topic title on index mod, already adding the LEFT JOIN on the topic table in function_display.php, just like the no duplicate will.

If so, only the no dupe is useful, since it will do the same and additionally properly rewrite the urls to the last active topics. Just un-install the other one and it will be all good ;)

++
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: 21238
Joined: Fri Apr 28, 2006 9:03 pm

Re: help sql error

Postby psilocybin » Mon May 25, 2009 2:12 pm

Thanks! it was nv last topic
psilocybin
 
Posts: 8
Joined: Thu May 21, 2009 2:25 am

Re: help sql error

Postby psilocybin » Mon May 25, 2009 2:14 pm

Can u suggest a quick reply mod ?
psilocybin
 
Posts: 8
Joined: Thu May 21, 2009 2:25 am

Re: help sql error

Postby dcz » Thu May 28, 2009 11:23 am

I do not use any, but start with looking at the released mods at phpBB.com, there must be one goo to use there ;)

++
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: 21238
Joined: Fri Apr 28, 2006 9:03 pm


Return to phpBB SEO Premod

 


  • Related topics
    Replies
    Views
    Last post

Who is online

Users browsing this forum: No registered users and 13 guests