| |
| |
|
|
|
|
| |
|
| |
|
| :: |
| Author |
Message |
ForgotenDynasty
Joined: 26 Jun 2008
Posts: 11
|
|
| Back to top |
|
 |
|
|
SeO
Administrateur - Site Admin
Joined: 15 Mar 2006
Posts: 3477
|
 Posted: Wed Jul 02, 2008 7:10 am Post subject: Re: MySQL error |
|
|
Hum interesting, the same Join is performed twice.
So make sure that a) you do not have this :
| Code: | // 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';
$sql_array['LEFT_JOIN'][] = array(
'FROM' => array(TOPICS_TABLE => 't'),
'ON' => "t.topic_last_post_id = f.forum_last_post_id"
);
}
// www.phpBB-SEO.com SEO TOOLKIT END -> no dupe |
Twice in includes/functions_display.php
and b) that you did not install a mod that would add the topic titles on index (the no dupe does it already). |
_________________
phpBB SEO || SEO Forum || Forum Référencement
GYM Sitemap & RSS for phpBB3 has been released ! || GYM Sitemap & RSS for phpBB3 est disponible ! |
|
| Back to top |
|
|
ForgotenDynasty
Joined: 26 Jun 2008
Posts: 11
|
| Posted: Wed Jul 02, 2008 5:07 pm Post subject: Re: MySQL error |
|
|
:/ i did install the topics on index mod
but that was only because i get 404 every time i activate no dubs |
|
|
| Back to top |
|
|
SeO
Administrateur - Site Admin
Joined: 15 Mar 2006
Posts: 3477
|
| Posted: Wed Jul 02, 2008 8:38 pm Post subject: Re: MySQL error |
|
|
There should be nor relation between the no dupe and the 404, 404 most likely means that you did not properly generate and implement your .htaccess.
The no dupe is so far more efficient than the topic on index mod, because it adds the proper INDEX on the topic table which makes the SQL query a lot faster on big boards. |
_________________
phpBB SEO || SEO Forum || Forum Référencement
GYM Sitemap & RSS for phpBB3 has been released ! || GYM Sitemap & RSS for phpBB3 est disponible ! |
|
| Back to top |
|
|
|
| Navigation |
Similar Topics |
|
|
|
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
