Skip Navigation

[Resolved] 504 error when updating custom post types from Tooolset

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

This topic contains 12 replies, has 2 voices.

Last updated by Waqar 5 months, 1 week ago.

Assigned support staff: Waqar.

Author
Posts
#1572059

When we update a custom post type made with Toolset the post page does not refresh and gives instead an error 504 like you see in the screenshot

#1572123

Hi, is this the support ticket that is now open?

#1572127

Waqar
Supporter

Languages: English (English )

Timezone: Asia/Karachi (GMT+05:00)

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

#1578251

Hi to all, do you have any update to this ticket?
Thanks

Franco

#1578685

Waqar
Supporter

Languages: English (English )

Timezone: Asia/Karachi (GMT+05:00)

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

#1578691

Hi,
you can do the duplication of the website, you can now log-in with the credentials I sent you .
Please let me know if you succeed.
Thanks.
Franco

#1580561

Any update on this please?

#1580795

Waqar
Supporter

Languages: English (English )

Timezone: Asia/Karachi (GMT+05:00)

Hi Franco,

Thank you for restoring the admin access and for your permission.

Your website's database and the files are huge, but I was finally able to create and download a duplicator package, after tweaking some file and database filters.

I'll be performing some tests with this package on my test server and will let you know how it goes.

Thank you for your patience.

regards,
Waqar

#1584747

Hi Waqar good morning, kindly let us know as soon as you heve some updates on this issue.
We need to give to the client some news about that.

Thanks

Franco

#1585059

Waqar
Supporter

Languages: English (English )

Timezone: Asia/Karachi (GMT+05:00)

Hi Franco,

Thanks for checking in.

I'm still working on some tests around this and will share my detailed findings with you, by the end of day today.

regards,
Waqar

#1586643

Waqar
Supporter

Languages: English (English )

Timezone: Asia/Karachi (GMT+05:00)

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

#1588001

Hi Waqar,
thanks for your reply, I have 2 questions:
1) regarding your sentence "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." does the 3 tables belong to Toolset implementation? When does Toolset creates a new database table? And also, the high number of records does apply to specific table or content?
Could you list what can be the plugins to be used to clean up the database from unnececssary tables or records to improve the performance?

2) the line "set_time_limit(480);" in the wp-config.php file can be placed everywhere in the file?

Thanks

Franco

#1588703

Waqar
Supporter

Languages: English (English )

Timezone: Asia/Karachi (GMT+05:00)

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