[Gelöst] 504 error when updating custom post types from Tooolset

Hi,

I've set your next reply as private.

Please share a clone/snapshot for your website, as explained in this guide:
https://toolset.com/faq/provide-supporters-copy-site/

regards,
Waqar

Hi Franco,

Thank you for waiting and I apologize for the delay in getting back on this.

Since it is a live website and the issue only seems to happen on your website, it is important that a clone of the website is tested on a different server.

The username and password that you've shared no longer seem to work, but for a large website, the "uploads" folder can be excluded from the back-up to reduce its size, when using the Duplicator plugin.
( ref: hidden link )

Note: With your permission, I can create and download the duplicator package directly from your website, once you'll share the working username and password.

I've set your next reply as private as well.

regards,
Waqar

Hi Franco,

First, thank you for waiting as this investigation turned out to be more complex than initially anticipated.

Despite testing the website's clone on a couple of different servers, I couldn't see 504 error while updating the posts in the post type "Schede" post type.

It does take a lot of time to update though (close to 2 mins at times), which is understandable due to the extremely large size of the database.

The database not only includes 3 different sets of Tables with different prefixes but even the posts and post meta table of the website consists of unusually high numbers for records.

This explains the 504 timeout error on your website's host, as the "PHP time limit" is set to only "120". You can increase this value by adding the following line in the website's "wp-config.php" file or requesting your hosting support team to do this for you:

set_time_limit(480);

Another thing that I'll recommend is to keep the WordPress, theme and all plugins up-to-date and clean the database from the unnecessary tables and records, to improve the performance.

You can either use third-party plugins for this or hire a professional contractor:
https://toolset.com/contractors/

I hope these points will help and please let me know how it goes.

regards,
Waqar

Hi Franco,

1). If you'll check the phpMyAdmin tool from your hosting provider or check the create new duplicator package screen ( WP Admin -> Duplicator -> Packages -> Create New ), you'll see that there are tables starting from 3 different prefixes:
( screenshot: hidden link )

a). wp_
b). wpfe_
c). wpurban_

Based on the website's "wp-config.php" file only the tables with a prefix "wp_" are in use.

The tables with the other prefixes could be from a different WordPress install in the past which used the same database or from a different backup plugin, but it is highly unlikely that they're in use now or even needed.

Note: The Toolset plugins don't create these tables with the different prefixes.

The large tables are the ones that store comments, posts, post meta, and the Relevanssi plugin's data.
( the Relevanssi plugin is no longer active on the website )

The database cleanup and optimization is a very sensitive and irreversible process, so please proceed with extreme caution and only after making a complete back-up copy.

Here are some useful guides that review the popular plugins for this:
hidden link
hidden link
hidden link

2). You can place that line just above the comment:

/* That's all, stop editing! Happy blogging. */

regards,
Waqar