phpBB SEO
Boards
Directory  
SEO  
Downloads
  phpBB SEO : Search Engine Optimization, Directory, Forums  
Index
Forums
Annuaire
Référencement
Télécharger
 
  Search Rechercher
    Register
Username :  Password :  Log me on automatically each visit  
S'enregistrer  
 
   
a problem in topic page numbers

 
Post new topic   Reply to topic    phpBB SEO » SEO Forum  » phpBB Forum
::  
Author Message
AmirAbbas
phpBB SEO Team
phpBB SEO Team


Joined: 11 May 2006
Posts: 529
Location: IRAN

a problem in topic page numbersPosted: Fri Sep 29, 2006 6:22 am    Post subject: a problem in topic page numbers

hi

another problem
plesee see this page

http://forum.persia-cms.com/forum-vf22.html

there is a post with this title in this URL

چه سیستمی بهتر است؟

this topic has 20 post
i set to show 10 post in each page
as you can see under this topic there is number 1,2,3
when you click on number 3 you will see this message

هيچ نامه اي براي اين موضوع ارسال نشده است.
that means "there isn,t any post for this topic

this topic must have only 2 page because has only 20 post
Exclamation
i have this problem with few other topics

_________________
چهار گوش - طراحی وب - مجله طراحی وب
Back to top
Visit poster's website
dcz
Administrateur - Site Admin
Administrateur - Site Admin


Joined: 28 Apr 2006
Posts: 15242

a problem in topic page numbersPosted: Fri Sep 29, 2006 8:58 pm    Post subject: Re: a problem in topic page numbers

mmmh, strange, and I don't see how it could be related to mod rewrite as it's ore than link transformation, it's link creation.

Does it occur for all topics, only page three, etc ... this forum of yours only ?

Could be SQL cache, try clearing it ?

What's happening if you set pagination to 15 posts per pages in a topic with 30 posts ?

++

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

Liens Utiles :
Forum référencement || Annuaire référencement || Référencement phpBB || Référencement phpBB3 || Recherche
Back to top
Visit poster's website
gowap
phpBB SEO Team
phpBB SEO Team


Joined: 07 May 2006
Posts: 1008

a problem in topic page numbersPosted: Sun Oct 01, 2006 12:28 am    Post subject: Re: a problem in topic page numbers

I've the same problem on my board but fortunately just with one topic. It's a quite long one (53 pages) and the symptoms are the one you described : a new page number appears and when you click on it, it says there's no page number xx (or when you click on the last topic icon, it says there's no such topic). Very stange. But this has nothing to do with rewriting (i had the problem before i implemented any rewriting solution).

I didn't searched about this issue, after all it's only one topic, and to "solve" it i just make a new post and everything gets ok

_________________
Gravure-News : la communauté francophone de la gravure de CD/DVD et son forum d'entraide.
Back to top
Visit poster's website
gowap
phpBB SEO Team
phpBB SEO Team


Joined: 07 May 2006
Posts: 1008

a problem in topic page numbersPosted: Sun Oct 01, 2006 1:22 am    Post subject: Re: a problem in topic page numbers

Well, i thought it was time to investigate this matter. For sure this has to do with database inconsistency.
So i first looked at the topics table :
Code:

SELECT topic_replies
FROM `phpbb_topics`
WHERE topic_id =2280

This gave me : 1057
Now we check if we have the same data in the phpbb_posts table :

Code:
SELECT *
FROM `phpbb_posts`
WHERE topic_id =2280

This one gave me 1058 results.
So far all is OK : 1058 posts = 1 post (the initial one) and the 1057 replies (as stated in the topics table)

So the inconsistency must be in the post_text table.
the following query checks if there is a post text (in phpbb_posts_text) for every post referenced in phpbb_posts for the specified topic.
If not it will output the post_id which has no entry in posts_text :
Code:
SELECT phpbb_posts.post_id, phpbb_posts_text.post_id
FROM `phpbb_posts`
LEFT JOIN phpbb_posts_text ON phpbb_posts.post_id = phpbb_posts_text.post_id
WHERE topic_id =2280
AND phpbb_posts_text.post_id IS NULL

guess what, the query told me that post_id=75583 had no text defined.
So I kicked the post_id=75583 from the phpbb_posts table and changed the topic_replies to 1056 in phpbb_topics and everything runs smooth now.

By the way, such inconsistencies (and many others) can be checked through the entire database with some MODS. For now i only remember one (good one) : database maintenance ( see http://phpbb.kordowich.net/?pgid=8 ). The only "drawback" (when i tested a long time ago) is that there was no "report only" option. You launch any of the "check xxx" function and changes are applied immediately/automatically without confirmation (but maybe this has changed now). Indeed, the mod is well known and tested, so you can trust it (but always backup first of course Very Happy )

_________________
Gravure-News : la communauté francophone de la gravure de CD/DVD et son forum d'entraide.
Back to top
Visit poster's website
dcz
Administrateur - Site Admin
Administrateur - Site Admin


Joined: 28 Apr 2006
Posts: 15242

a problem in topic page numbersPosted: Mon Oct 02, 2006 10:59 am    Post subject: Re: a problem in topic page numbers

Interesting, thanks for sharing Gowap, I never experienced SQL inconsistency so far but for sure this is the kind of thing that can happen in a phpBB forum's life as well as for any other SQL application I guess.

There are quite some mod to repair phpBB table, one of these days, I'll test them Wink

++

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

Liens Utiles :
Forum référencement || Annuaire référencement || Référencement phpBB || Référencement phpBB3 || Recherche
Back to top
Visit poster's website
AmirAbbas
phpBB SEO Team
phpBB SEO Team


Joined: 11 May 2006
Posts: 529
Location: IRAN

a problem in topic page numbersPosted: Tue Oct 03, 2006 2:31 pm    Post subject: Re: a problem in topic page numbers

thanks gowap
thanks DCZ

i will test it

_________________
چهار گوش - طراحی وب - مجله طراحی وب
Back to top
Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    phpBB SEO » SEO Forum  » phpBB Forum
Page 1 of 1

Navigation Similar Topics

Jump to: