Skip Navigation

[Resolved] Toolset Crashing Database?

This support ticket is created 5 years, 10 months ago. There's a good chance that you are reading advice that it now obsolete.

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.

No supporters are available to work today on Toolset forum. Feel free to create tickets and we will handle it as soon as we are online. Thank you for your understanding.

Sun Mon Tue Wed Thu Fri Sat
- 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 -
- 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 -

Supporter timezone: Asia/Hong_Kong (GMT+08:00)

Tagged: 

This topic contains 3 replies, has 2 voices.

Last updated by Luo Yang 5 years, 10 months ago.

Assisted by: Luo Yang.

Author
Posts
#1176391

My site has crashed 3x in the past month. My host (Cloudways > Digital Ocean) looked up the error logs and said it looks like Toolset is craching my database.

Here's the error, can you help me fix?

[Wed Jan 02 22:14:34.392354 2019] [proxy_fcgi:error] [pid 12561] [client 127.0.0.1:50420] AH01071: Got error 'ption_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`) made by require('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, Toolset_Blocks_CRED_Form->register_block_editor_assets, apply_filters('cred_get_available_forms'), WP_Hook->apply_filters, CRED_Api->__call, CRED_Api_Handler_Get_Available_Forms->process_call, OTGS\\Toolset\\CRED\\Model\\Cache\\Forms\\AForms->generate_transient, OTGS\\Toolset\\CRED\\Model\\Wordpress\\Transient->set_transient, set_transient, add_option\nPHP message: WordPress database error Table 'bddutwkqjh.wp_options' doesn't exist for query SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_cred_transient_published_rel_forms' LIMIT 1 made by require('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, Toolset_Blocks_CRED_Form->register_block_editor_assets, apply_filters('cred_get_available_forms'), WP_Hook->apply_filters, CRED_Api->__call, CRED_Api_Handler_Get_Available_Forms->process_call, OTGS\\Toolset\\CRED\\Model\\Cache\\Forms\\AForms->get_transient, OTGS\\Toolset\\CRED\\Model\\Wordpress\\Transient->get_transient, get_transient, get_option\nPHP message: WordPress database error Table 'bddutwkqjh.wp_options' doesn't exist for query SELECT option_value FROM wp_options WHERE option_name = '_transient_cred_transient_published_rel_forms' LIMIT 1 made by require('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, Toolset_Blocks_CRED_Form->register_block_editor_assets, apply_filters('cred_get_available_forms'), WP_Hook->apply_filters, CRED_Api->__call, CRED_Api_Handler_Get_Available_Forms->process_call, OTGS\\Toolset\\CRED\\Model\\Cache\\Forms\\AForms->get_transient, OTGS\\Toolset\\CRED\\Model\\Wordpress\\Transient->get_transient, get_transient, get_option\nPHP message: WordPress database error Table 'bddutwkqjh.wp_posts' doesn't exist for query SELECT ID, post_title, post_name FROM wp_posts\n\t\t\t\tWHERE post_type = 'cred_rel_form'\n\t\t\t\tAND post_status in ('publish') \n\t\t\t\tORDER BY post_title made by require('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, Toolset_Blocks_CRED_Form->register_block_editor_assets, apply_filters('cred_get_available_forms'), WP_Hook->apply_filters, CRED_Api->__call, CRED_Api_Handler_Get_Available_Forms->process_call, OTGS\\Toolset\\CRED\\Model\\Cache\\Forms\\Association->generate_transient\nPHP message: WordPress database error Table 'bddutwkqjh.wp_options' doesn't exist for query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_timeout_cred_transient_published_rel_forms', '1547072074', 'no') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`) made by require('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, Toolset_Blocks_CRED_Form->register_block_editor_assets, apply_filters('cred_get_available_forms'), WP_Hook->apply_filters, CRED_Api->__call, CRED_Api_Handler_Get_Available_Forms->process_call, OTGS\\Toolset\\CRED\\Model\\Cache\\Forms\\Association->generate_transient, OTGS\\Toolset\\CRED\\Model\\Wordpress\\Transient->set_transient, set_transient, add_option\nPHP message: WordPress database error Table 'bddutwkqjh.wp_options' doesn't exist for query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_cred_transient_published_rel_forms', 'a:0:{}', 'no') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`) made by require('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, Toolset_Blocks_CRED_Form->register_block_editor_assets, apply_filters('cred_get_available_forms'), WP_Hook->apply_filters, CRED_Api->__call, CRED_Api_Handler_Get_Available_Forms->process_call, OTGS\\Toolset\\CRED\\Model\\Cache\\Forms\\Association->generate_transient, OTGS\\Toolset\\CRED\\Model\\Wordpress\\Transient->set_transient, set_transient, add_option\nPHP message: WordPress database error Table 'bddutwkqjh.wp_posts' doesn't exist for query SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'widget-area' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC LIMIT 0, 100 made by require('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, WPDD_Widget_Area_Helper::getInstance, WPDD_Widget_Area_Helper->__construct, WPDD_Widget_Area_Helper->load_registered_sidebars, get_posts, WP_Query->query, WP_Query->get_posts\nPHP message: WordPress database error Table 'bddutwkqjh.wp_posts' doesn't exist for query SELECT ID, post_title, post_name FROM wp_posts\n\t\t\t\tWHERE post_type = 'cred-form'\n\t\t\t\tAND post_status in ('private') \n\t\t\t\tORDER BY post_title made by require('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, Access_Helper::wpcf_access_late_init, Access_Helper::wpcf_access_hooks_collect, apply_filters('types-access-cap'), WP_Hook->apply_filters, OTGS\\Toolset\\CRED\\Controller\\Permissions\\ToolsetAccess->register_access_cred_post_caps, OTGS\\Toolset\\CRED\\Controller\\Permissions\\ToolsetAccess->register_access_cred_caps_by_domain, apply_filters('cred_get_available_forms'), WP_Hook->apply_filters, CRED_Api->__call, CRED_Api_Handler_Get_Available_Forms->process_call, OTGS\\Toolset\\CRED\\Model\\Cache\\Forms\\AForms->generate_transient\nPHP message: WordPress database error Table 'bddutwkqjh.wp_options' doesn't exist for query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_timeout_cred_transient_published_post_forms', '1547072074', 'no') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`) made by require('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, Access_Helper::wpcf_access_late_init, Access_Helper::wpcf_access_hooks_collect, apply_filters('types-access-cap'), WP_Hook->apply_filters, OTGS\\Toolset\\CRED\\Controller\\Permissions\\ToolsetAccess->register_access_cred_post_caps, OTGS\\Toolset\\CRED\\Controller\\Permissions\\ToolsetAccess->register_access_cred_caps_by_domain, apply_filters('cred_get_available_forms'), WP_Hook->apply_filters, CRED_Api->__call, CRED_Api_Handler_Get_Available_Forms->process_call, OTGS\\Toolset\\CRED\\Mod...\nPHP message: WordPress database error Table 'bddutwkqjh.wp_options' doesn't exist for query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_cred_transient_published_post_forms', 'a:2:{s:3:\\"new\\";a:0:{}s:4:\\"edit\\";a:0:{}}', 'no') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`) made by require('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, Access_Helper::wpcf_access_late_init, Access_Helper::wpcf_access_hooks_collect, apply_filters('types-access-cap'), WP_Hook->apply_filters, OTGS\\Toolset\\CRED\\Controller\\Permissions\\ToolsetAccess->register_access_cred_post_caps, OTGS\\Toolset\\CRED\\Controller\\Permissions\\ToolsetAccess->register_access_cred_caps_by_domain, apply_filters('cred_get_available_forms'), WP_Hook->apply_filters, CRED_Api

#1176721

Hello,

According to the debug logs you provided above, there are some database error in your website, for example:

WordPress database error Table 'bddutwkqjh.wp_posts' doesn't exist
...
WordPress database error Table 'bddutwkqjh.wp_options' doesn't exist
...

Those database tables "wp_posts" and "wp_options" are WordPress built-in database tables, see WordPress document:
https://codex.wordpress.org/Database_Description

Please check these:
1) Check your website database "bddutwkqjh", make sure there are above specific tables.
2) If your website database is broken, you might consider to restore your website from a previous backup.

#1181529

When I update Toolset Types, my database crashes.

I use Toolset because I'm a non-coder, I do not know how to fix the issue you have described.

#1181895

Please try these:
1) Ask a database backup file from your webserver provider, you should be able to get backup file before your website is crashed.

2) Restore it again, make sure your website is running correctly

3) Upgrade Types plugin(and other Toolset plugins) to the latest version.

4) If the problem still persists, please provide the database backup file in below private message box, I need to test and debug it in my localhost, thanks