| |
| |
|
|
|
|
| |
|
| |
|
| :: |
| 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 |
|
|
|
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |