Pagination on Permalink editor tab not working

Hi Alex,

could you tell me what version of plugin do you use + PHP version installed on your server?

Best Regards,
Maciej

Hi Maciey!

Permalink Manager 0.4.4 and php 7.0.4.

Hi Alex,

please download 0.4.5 version from here (it is not released yet, so please remove old plugin copy and upload it manually) and send me the logs generated with debug_editor_sql as $_GET parameter, eg.:

…/wp-admin/tools.php?page=permalink-manager.php&paged=2&debug_editor_sql=1
…/wp-admin/tools.php?page=permalink-manager.php&paged=1&debug_editor_sql=1

Hi Maciey!

Here it is.
…/wp-admin/tools.php?page=permalink-manager.php&paged=2&debug_editor_sql=1:

SELECT * FROM wp_posts WHERE post_status IN (‘publish’) AND post_type IN (‘post’, ‘page’, ‘attachment’) ORDER BY ID desc LIMIT 10 OFFSET 10

Offset: 10
Page: 2
Per page: 10
Total: 35

…/wp-admin/tools.php?page=permalink-manager.php&paged=1&debug_editor_sql=1:
SELECT * FROM wp_posts WHERE post_status IN (‘publish’) AND post_type IN (‘post’, ‘page’, ‘attachment’) ORDER BY ID desc LIMIT 10 OFFSET 0

Offset: 0
Page: 1
Per page: 10
Total: 35

By the way, after clicking the next page, the page reloaded but &paged=1 remains in the url wihtout changing.

Hi Alex,

according to SQL formulas you generated, it looks like they are correct. Do you have any database cache plugins installed in your WP?

Best Regards,
Maciej

Hi Maciey!

Nope, I don’t. But I tested it on the clean WP installation and pagination works. Tried to changed the theme to the native one, didn’t help. It seems the problem is on my side, perhaps because of some plugin. But all others have no any issues.

Thanks anyway. Will try to find out what’s wrong.

Hi Alex,

no problem, do you host the problematic WP installation on localhost?

Best Regards,
Maciej

Yes, both are local. I think, I’ll mark the topic as resolved. If I figure out the problem later I share it here.

Thanks, Maciej.

Hey Alex,

I think that the problem might be related to MySQL configuration (query_cache variable). Maybe this would help:
https://dev.mysql.com/doc/refman/5.7/en/query-cache.html
https://www.techiecorner.com/45/turn-on-mysql-query-cache-to-speed-up-mysql-query-performance/
https://stackoverflow.com/questions/26571004/how-do-i-turn-on-query-cache-on-a-windows-xampp-server

Best Regards,
Maciej