AI Search
Classic Search
 Search Phrase:
 Search Type:
Advanced search options
 Search in Forums:
 Search in date period:

 Sort Search Results by:

Filter by custom fields

Topic prefix

AI Assistant
Notifications
Clear all

[Closed] guest login topic pagination missing for extended layout

5 Posts
2 Users
1 Reactions
1,913 Views
Posts: 119
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@nando4)
Estimable Member
Joined: 9 years ago
[#8381]

Had topics with no pagination for guest login. Sitemaps were not including these other pages.

Turns out the bug is due to a db call checking private=0 for topic posts and not counting those posts for items_count. The fix was to comment out the following section in class-posts.php

            //else{
//If doesn't have "View Private Posts" access and not Owner, only return public posts
// $wheres[] = " " . $table_as_prefix . "`private` = 0";
//}

 


4 Replies
Sofy
Posts: 5774
 Sofy
Admin
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@sofy)
Support Team
Joined: 8 years ago

Hi @nando4,

This is not wpForo issue it comes from the MySQL version. Please see the description of the issue here:  https://bugs.mysql.com/bug.php?id=81031

Here is the same issue:

https://wpforo.com/community/how-to-and-troubleshooting-2/topic-pages-disappeared/#post-25490


Posts: 119
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@nando4)
Estimable Member
Joined: 9 years ago

@sofy , the cpanel DB check/fix did fix the problem. Thank you.


Posts: 119
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@nando4)
Estimable Member
Joined: 9 years ago

Spoke too soon. The problem persists and the only working workaround is to comment out the offending code in class-posts.php. More details at:

https://wpforo.com/community/how-to-and-troubleshooting-2/topic-pages-disappeared/#post-25853


1 Reply
Sofy
 Sofy
Admin
(@sofy)
Joined: 8 years ago

Support Team
Posts: 5774
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian

Hi @nando4,

This is not wpForo issue it comes from the MySQL version. Please see the description of the issue here:  https://bugs.mysql.com/bug.php?id=81031

I suggest you either update your MySQL version or try solution provided by antonM in this support topic:   https://wpforo.com/community/how-to-and-troubleshooting-2/topic-pages-disappeared/#post-25496


Share: