#1 WordPress forum plugin created by gVectors Team

wpForo – WordPress Forum Plugin
  • Home
  • Forum
  • Migrate to wpForo
  • Addons
  • Addons Demo
  • Documentation

Forum

Home | Forum

wpDiscuz - WordPress Comment Plugin
  • Forums
  • Members
  • Recent Posts
Forums
Main Support Forums
How-to and Troubles...
Topic pages disappe...
 
Share:
Share
Tweet
Share
Notifications
Clear all

[Solved] Topic pages disappeared

Page 1 / 2 Next
    Last Post
RSS

antonM
Posts: 131
 antonM
Topic starter
March 29, 2019 1:19 pm
(@antonm)
Estimable Member
Joined: 5 years ago

Hi guys!

@robert, after last update topic's pages disappeared in Q&A layout. You can check this problem in this topic on my forum. How to quickly resolve this issue? My users can't navigate in big topics.

Topic Tags
pagination issue
39 Replies
Sofy
Posts: 4057
Sofy - Facebook Sofy - Twitter
 Sofy
Admin
March 29, 2019 1:32 pm
(@sofy)
Support Team
Joined: 4 years ago

Hi @antonm,

Please navigate to Dashboard > Forums > Settings > Feature admin page, make sure the HTML Cache is disabled.  Then navigate to Dashboard > Forums > Dashboard admin page, click on [Delete all caches] button. If you use some other cache plugins, delete those plugins caches as well and press CTRL+F5 (twice) on the current page. 

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.

5 Replies
antonM
 antonM
(@antonm)
Joined: 5 years ago

Estimable Member
Posts: 131
March 29, 2019 1:45 pm
Reply toSofySofy

Hi Sofy,

I disabled and deleted all caches. I have updated the database. I don't use any custom template. Pressed Ctrl+F5 several times. Nothing changed 🙁

Specified topic has 55 answers, but I see only first 10. No topic navigation.

Sofy
 Sofy
Admin
(@sofy)
Joined: 4 years ago

Support Team
Posts: 4057
Sofy - Facebook Sofy - Twitter
March 29, 2019 1:53 pm
Reply toantonMantonM
Sofy

@antonm,

Could you please send admin login details to info[at]gvectors.com email address to allow us to check it. 

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.

antonM
 antonM
(@antonm)
Joined: 5 years ago

Estimable Member
Posts: 131
March 29, 2019 3:39 pm
Reply toSofySofy
antonM
Sofy

I assume, that the problem related to new DB structure.
I examined SQL queries and found that for example this one:

SELECT count(*)
FROM `prefix_wpforo_posts`
WHERE `prefix_wpforo_posts`.`topicid` = 385
AND `prefix_wpforo_posts`.`parentid` = 0

returns 0. If I delete this argument

AND `prefix_wpforo_posts`.`parentid` = 0

the query returns 56 (right value).

After forum update I fixed all database issues.

Other count queries also return 0 counts.

2019-03-29-17_36_29-Window.png
Robert
 Robert
Admin
(@robert)
Joined: 6 years ago

Support Team
Posts: 8968
Robert - Twitter
March 31, 2019 8:28 am
Reply toantonMantonM
Sofy
antonM
Sofy

Don't delete any argument. In such case, just insert new indexes. use Hosting cPanel > phpMyAdmin > WP Database > SQL Tab and execute these SQLs:

ALTER TABLE `wp_wpforo_posts` ADD INDEX `topicid_parentid`( `parentid`, `topicid`);
ALTER TABLE `wp_wpforo_posts` ADD INDEX `topicid_parentid_guest` ( `parentid`, `topicid`, `status`, `private`);

Make sure the red marked wp_ prefix is correct for your database/

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.

antonM
 antonM
(@antonm)
Joined: 5 years ago

Estimable Member
Posts: 131
March 31, 2019 10:30 am
Reply toRobertRobert
antonM
Sofy
antonM
Sofy

Hi Robert,

all these manipulations were made in phpMyAdmin, not in the wpForo code.

So, don't worry. All works properly.

Robert liked
antonM
Posts: 131
 antonM
Topic starter
March 29, 2019 5:34 pm
(@antonm)
Estimable Member
Joined: 5 years ago

It seems I found the solution. Hope it will help other people.

Yes, this was a database problem. If you have access to phpMyAdmin then login to it.

  • Select all tables of your WP installation.
  • Choose in tables actions - Check tables.
  • Select all tables of your WP installation again.
  • Choose in tables actions - Optimize tables.

Now the problem has gone!

20 Replies
Sofy
 Sofy
Admin
(@sofy)
Joined: 4 years ago

Support Team
Posts: 4057
Sofy - Facebook Sofy - Twitter
March 30, 2019 12:06 pm
Reply toantonMantonM

Thank you @antonm!

I really appreciate you taking a time and share this information!

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.

antonM liked
nando4
 nando4
(@nando4)
Joined: 5 years ago

Estimable Member
Posts: 111
nando4 - Skype
April 11, 2019 1:05 pm
Reply toantonMantonM

This fix worked until a new topic/post is made whereby the pagination disappears again. Have reverted back to the class-posts.php mod as shown at:

https://wpforo.com/community/how-to-and-troubleshooting-2/guest-login-topic-pagination-missing-for-extended-layout/

antonM liked
antonM
 antonM
(@antonm)
Joined: 5 years ago

Estimable Member
Posts: 131
April 11, 2019 1:09 pm
Reply tonando4nando4
antonM

nando4, I confirm this.

Please, use Robert's solution that showed above. Create an additional index for wpforo_posts table. It works perfectly.

nando4 liked
antonM
 antonM
(@antonm)
Joined: 5 years ago

Estimable Member
Posts: 131
April 11, 2019 1:11 pm
Reply tonando4nando4
antonM

Don't forget to change the prefix to that is used in your database.

nando4 liked
nando4
 nando4
(@nando4)
Joined: 5 years ago

Estimable Member
Posts: 111
nando4 - Skype
April 11, 2019 2:41 pm
Reply toantonMantonM
nando4
antonM

@antonM, that indeed got topic pagination back that is maintained even after new posts are added to the DB. thank you so much. 

nando4
 nando4
(@nando4)
Joined: 5 years ago

Estimable Member
Posts: 111
nando4 - Skype
April 11, 2019 2:59 pm
Reply tonando4nando4
antonM
nando4
antonM

Spoke too soon. A new topic reply will once again kill topic pagination until the same cpanel SQL command as below is applied. Have to go back to my class-posts.php fix.

ALTER TABLE `prefix_wpforo_posts` ADD INDEX( `parentid`, `topicid`);
antonM
 antonM
(@antonm)
Joined: 5 years ago

Estimable Member
Posts: 131
April 11, 2019 4:27 pm
Reply tonando4nando4
nando4
antonM
nando4
antonM

nando4, this solution is still working for me.

Don't forget to change the prefix according to your WP installation.

ALTER TABLE `prefix_wpforo_posts` ADD INDEX( `parentid`, `topicid`);
nando4
 nando4
(@nando4)
Joined: 5 years ago

Estimable Member
Posts: 111
nando4 - Skype
April 11, 2019 4:42 pm
Reply toantonMantonM
nando4
nando4
antonM
antonM

Yes, did that. It fixes topic pagination until a topic has a new post in it and then it's back to permanently disappearing.

So I've altered class-posts.php to not do a private=0 status lookup that's causing items_count=0 to be returned. Not elegant, but it works.

antonM liked
antonM
 antonM
(@antonm)
Joined: 5 years ago

Estimable Member
Posts: 131
April 11, 2019 4:49 pm
Reply tonando4nando4
antonM
nando4
nando4
antonM

I hope @robert will take a look at this problem again. But I think this is a DB problem.

This post was modified 3 years ago 2 times by antonM
antonM
 antonM
(@antonm)
Joined: 5 years ago

Estimable Member
Posts: 131
April 11, 2019 4:51 pm
Reply tonando4nando4
antonM
nando4
nando4
antonM

Do you delete all caches? Try to disable all caches, clear them and check pagination again.

nando4
 nando4
(@nando4)
Joined: 5 years ago

Estimable Member
Posts: 111
nando4 - Skype
April 12, 2019 3:28 am
Reply toantonMantonM
nando4
antonM
nando4
antonM

Yes, deleted/disabled cache. Makes no difference.

antonM
 antonM
(@antonm)
Joined: 5 years ago

Estimable Member
Posts: 131
April 20, 2019 11:00 pm
Reply tonando4nando4
antonM
nando4
antonM
antonM

Hi @nando4. I confirm that the problem still exists, but it is irregular. In some topics, pagination works well, in some topics it works only for registered users and doesn't work for guests, but after tables optimization, it begins to work for guests. Something strange...

@robert, please, pay attention to this problem again.

antonM
 antonM
(@antonm)
Joined: 5 years ago

Estimable Member
Posts: 131
April 22, 2019 6:12 pm
Reply toantonMantonM
nando4
antonM
nando4
antonM

@nando4, could you please write your solution.

What changes did you make in file class-posts.php?

Thanks.

nando4
 nando4
(@nando4)
Joined: 5 years ago

Estimable Member
Posts: 111
nando4 - Skype
April 22, 2019 9:55 pm
Reply toantonMantonM
antonM
nando4
antonM
antonM
Posted by: antonM

@nando4, could you please write your solution.

What changes did you make in file class-posts.php?

Thanks.

 

Add comments like shown in class-posts.php. The side effect is any private posts will now be public:

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

/////Check Unapproved Post Access////////////////////////////

 

antonM liked
antonM
 antonM
(@antonm)
Joined: 5 years ago

Estimable Member
Posts: 131
April 23, 2019 11:16 am
Reply tonando4nando4
antonM
antonM
nando4
antonM

Thank you nando4. I tried your solution, but on my server, it not works. Unfortunately 🙁

I added double index again as Robert (@robert) wrote, but currently, pagination works only for registered users (i don't use a custom template). For guests, it doesn't work. I disabled and cleared all caches but no result. My tables are InnoDB.

On all other pages of the site, pagination works well. The problem with pagination only appears with wpForo and not in each release. So, I assume that this is actually a wpForo core problem otherwise I would have a pagination problem with all other site's pages.

Check this topic of my forum. It has 37 answers and no pagination. This kills my website traffic 🙁

Robert
 Robert
Admin
(@robert)
Joined: 6 years ago

Support Team
Posts: 8968
Robert - Twitter
April 23, 2019 3:23 pm
Reply toantonMantonM
nando4
antonM
antonM
antonM

I'd also recommend increase the memory limit of your WordPress. Then navigate to Dashboard  > Forums > Dashboard and click on [Rebuild Threads] button. It may take a long time to do that. Once its done, click on [Delete all caches] button, then delete website caches and check it again as guest.

Also, please let me know, have you changed this forum layout recently?

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.

antonM
 antonM
(@antonm)
Joined: 5 years ago

Estimable Member
Posts: 131
April 23, 2019 4:37 pm
Reply toRobertRobert
antonM
nando4
antonM
antonM

Hi Robert. I made all manipulations and no result for guests. I just made some minor modifications such as adding Google ads or similar not related to pagination. I also tried without any caches and the results are the same.

wpforo_data.png
Robert
 Robert
Admin
(@robert)
Joined: 6 years ago

Support Team
Posts: 8968
Robert - Twitter
April 22, 2019 7:07 pm
Reply toantonMantonM
nando4
antonM
nando4
antonM

As i said this is the MySQL server specific cache issue and should be fixed with double indexes. The table optimization doesn't matter. Also, make sure you use InnoDB tables.

If you have a double indexes, then all other rare cases are only related to website or forum cache, they are site cache issues and are not related to wpForo core.

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.

nando4
 nando4
(@nando4)
Joined: 5 years ago

Estimable Member
Posts: 111
nando4 - Skype
April 22, 2019 9:57 pm
Reply toRobertRobert
antonM
nando4
antonM
antonM

Yes, we have Light Speed cache active. Disabling it isn't an option so the workaround posted above works for us.

Anonymous20
 Anonymous20
(@anonymous20)
Joined: 6 years ago

Noble Member
Posts: 1602
April 23, 2019 6:14 am
Reply tonando4nando4
Robert
antonM
nando4
antonM
Posted by: nando4

Yes, we have Light Speed cache active. Disabling it isn't an option so the workaround posted above works for us.

Litespeed doesn't work well with wpForo. At least exclude wpForo page.

Robert
Posts: 8968
Robert - Twitter
 Robert
Admin
April 24, 2019 11:12 am
(@robert)
Support Team
Joined: 6 years ago

@antonm, @nando4 and @anonymous20,

We found this is not wpForo issue. This is a bug of MySQL 5.6 version.To show pagination it should count the total number of posts, but count(*) on InnoDB tables sometimes returns 0. This bug was reported to MySQL community on 11 Apr 2016. You can see the discussion here: https://bugs.mysql.com/bug.php?id=81031   

So the solution is contacting to hosting support and asking them to update MySQL Server to 5.7 version. Or try to change wp_wpforo_posts table to MyISAM engine (not recommended).

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.

nando4 and antonM liked
2 Replies
antonM
 antonM
(@antonm)
Joined: 5 years ago

Estimable Member
Posts: 131
April 26, 2019 8:34 am
Reply toRobertRobert

@robert, my hosting provider said that it can not update MySQL to 5.7 on shared hosting. It updated 5.6 to the latest version but the result is the same. Another strange thing that the pagination works well for registered users and it worked well in previous releases both for registered and guests 🙁

Robert
 Robert
Admin
(@robert)
Joined: 6 years ago

Support Team
Posts: 8968
Robert - Twitter
April 27, 2019 1:36 pm
Reply toantonMantonM
Robert

Don't forget the last time delete woForo cache in Dashboard > Forums > Dashboard admin page. Delete that cache in your website and hosting if you have, then last time optimize wpForo tables in database. And check using other browsers or delete browser cache.

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.

nando4
Posts: 111
nando4 - Skype
 nando4
April 25, 2019 7:34 am
(@nando4)
Estimable Member
Joined: 5 years ago

@robert , have upgraded from mySQL 5.6 to 5.7. After 12 hrs of operation, the topic pagination has remained. So tentatively appears to have solved the problem.

Robert liked
Page 1 / 2 Next
  All forum topics
  Previous Topic
Next Topic  
Related Topics
  • Topic Pagination Disappears On Threaded Layout - Update Database and Plugin Conflict Report
    3 years ago
  • guest login topic pagination missing for extended layout
    3 years ago
Topic Tags:  pagination issue (4),

Forum Search

Join Us!

Download wpForo plugin
on WordPress.org

wpForo Addons

wpforo-private-messages wpforo-advanced-attachments-128x128 wpforo-embeds-128x128 wpForo User Custom Fields addon wpForo – Blog Cross Posting addon wpForo Ads Manager wpForo – WooCommerce Memberships Integration wpForo Emoticons wpForo – Tenor GIFs Integration
View all Addons »

Recent Topics

  • purchase of add on and it says payment pending

    By ReddBeard, 11 hours ago

  • Costume text and image on every forum

    By Vijiki, 1 day ago

  • Forum topics and pages not indexing

    By Vijiki, 2 days ago

  • Can't send confirmation email from topics when suscribe for new topic

    By gilbau, 2 days ago

  • Can't add shortcodes to wpForo

    By avorai, 2 days ago

  • New Feature H1 title for tags

    By annushka, 2 days ago

Topic Tags

  • translation49
  • css49
  • plugin conflict48
  • seo45
  • new features44
  • buddypress42
  • ultimate member40
  • avatar40
  • forum40
  • moderation38
  • login38
  • registration36
  • threaded layout35
  • cache33
  • editor32
  • menu32
  • shortcode31
  • spam29
  • phrases28
  • forum accesses28
View all tags (2163)

Recent Posts

  • RE: Costume text and image on every forum

    @vijiki There is no wpForo2 for the moment. Also forget...

    By dimalifragis, 9 hours ago

  • RE: Can't add shortcodes to wpForo

    @avorai So, SAC.PHP is crashing and it is wpForo the ca...

    By dimalifragis, 9 hours ago

  • RE: purchase of add on and it says payment pending

    Hi @reddbeard, Please move this topic to gVectors Sup...

    By Robert, 11 hours ago

  • RE: Show Likers with their avatar

    @fawp ok, thanks for trying to help

    By Tutrix, 23 hours ago

  • RE: Can't send confirmation email from topics when suscribe for new topic

    @gilbau, wpForo uses WordPress wp_mail() function. wp...

    By Robert, 2 days ago

  • RE: Forum topics and pages not indexing

    So all is ok from wpForo site. I have nothing to add he...

    By Robert, 2 days ago

  • RE: Can users be in multiple forums?

    @monimair, wpForo has secondary usergroups function so...

    By Chris, 2 days ago

Share:
Share
Tweet
Share
  Forum Statistics
20 Forums
9,756 Topics
49.5 K Posts
4 Online
43.6 K Members

Latest Post: Costume text and image on every forum Our newest member: stephanyjacobse Recent Posts Unread Posts Tags

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo | Copyright © 2016-2022 gVectors Team
Copyright Registration Service - Click here for more information or to register work
wpForo is Registered with the IP Rights Office
Copyright Registration Service

Ref: 4477265538
  • Home
  • Forum
  • Migrate to wpForo
  • Addons
  • Addons Demo
  • Documentation