Resolved
Reported for: Toolset Types 3.4.2
Resolved in: Types 3.4.3
After installing Toolset Types 3.4 you need to run a database update wizard. Sometimes, this update might fail with the following message:
An error has occurred during the upgrade. We have tried to return to the state before the upgrade started.In most cases, you will not find anything outstanding in the server’s PHP log. The only visible error is usually the one logged in the browser console:
/wp-admin/admin-ajax.php:1 Failed to load resource: the server responded with a status of 504 ()This issue happens very rarely. If you encounter it, please contact us and we will get you in direct contact with our developers and help you resolve the issue.
This has happened on our site and we are manually resetting PHP every 20 minutes to keep the site up. This is not a viable long-term option. Please update with workaround ASAP.
Hi there, I have sent you an e-mail last week to understand the issues you’re working more closely. In any case, we’re already working on a number of improvements to the migration process.
On our end, we also ran an “explain” for that recurring database query, and it sorts through 8,652 rows: https://i.getf.ly/6quPzwJA
If you or a database developer is familiar with it, it looks like there’s an opportunity to add an index/key for the “group_id” to help make that query more performant.