[Resolved] In Debug mode: Error in WordPress DataBase

[Author]

Posts

[convierteproS]

I am having problems in my site an in debug mode appeas this error message from Toolset in most of site pages:

-----------------------------------------------------------------------------------------------

Error in WordPress DataBase: [Table 'db2370483601.wp_dfcdojph2o_toolset_relationships' doesn't exist]
SELECT relationships.id AS id, relationships.slug AS slug, relationships.display_name_plural AS display_name_plural, relationships.display_name_singular AS display_name_singular, relationships.driver AS driver, relationships.parent_domain AS parent_domain, relationships.child_domain AS child_domain, relationships.intermediary_type AS intermediary_type, relationships.ownership AS ownership, relationships.cardinality_parent_max AS cardinality_parent_max, relationships.cardinality_parent_min AS cardinality_parent_min, relationships.cardinality_child_max AS cardinality_child_max, relationships.cardinality_child_min AS cardinality_child_min, relationships.is_distinct AS is_distinct, relationships.scope AS scope, relationships.origin AS origin, relationships.role_name_parent AS role_name_parent, relationships.role_name_child AS role_name_child, relationships.role_name_intermediary AS role_name_intermediary, relationships.role_label_parent_singular AS role_label_parent_singular, relationships.role_label_child_singular AS role_label_child_singular, relationships.role_label_parent_plural AS role_label_parent_plural, relationships.role_label_child_plural AS role_label_child_plural, relationships.needs_legacy_support AS needs_legacy_support, relationships.is_active AS is_active, relationships.autodelete_intermediary AS autodelete_intermediary, relationships.parent_types AS parent_types_set_id, relationships.child_types AS child_types_set_id, GROUP_CONCAT(DISTINCT parent_types_table.type) AS parent_types, GROUP_CONCAT(DISTINCT child_types_table.type) AS child_types FROM wp_dfcdojph2o_toolset_relationships AS relationships JOIN wp_dfcdojph2o_toolset_type_sets AS parent_types_table ON (relationships.parent_types = parent_types_table.set_id ) JOIN wp_dfcdojph2o_toolset_type_sets AS child_types_table ON (relationships.child_types = child_types_table.set_id ) WHERE ( ( relationships.child_domain = 'posts' ) AND ( child_types_table.type = 'post' ) ) AND ( relationships.is_active = 1 ) AND ( ( ( relationships.parent_domain != 'posts' OR parent_types_table.type IN ( 'post', 'page', 'attachment', 'oembed_cache', 'user_request', 'w2dc_listing', 'et_pb_layout', 'project', 'amp_validated_url', 'mec-events', 'mec_calendars', 'modula-gallery', 'omapi', 'testimonials', 'raulabad', 'newsletters' ) ) ) AND ( ( relationships.child_domain != 'posts' OR child_types_table.type IN ( 'post', 'page', 'attachment', 'oembed_cache', 'user_request', 'w2dc_listing', 'et_pb_layout', 'project', 'amp_validated_url', 'mec-events', 'mec_calendars', 'modula-gallery', 'omapi', 'testimonials', 'raulabad', 'newsletters' ) ) ) ) AND ( relationships.origin = 'wizard' ) GROUP BY relationships.id

Error in WordPress DataBase: [Table 'db2370483601.wp_dfcdojph2o_toolset_relationships' doesn't exist]
SELECT relationships.id AS id, relationships.slug AS slug, relationships.display_name_plural AS display_name_plural, relationships.display_name_singular AS display_name_singular, relationships.driver AS driver, relationships.parent_domain AS parent_domain, relationships.child_domain AS child_domain, relationships.intermediary_type AS intermediary_type, relationships.ownership AS ownership, relationships.cardinality_parent_max AS cardinality_parent_max, relationships.cardinality_parent_min AS cardinality_parent_min, relationships.cardinality_child_max AS cardinality_child_max, relationships.cardinality_child_min AS cardinality_child_min, relationships.is_distinct AS is_distinct, relationships.scope AS scope, relationships.origin AS origin, relationships.role_name_parent AS role_name_parent, relationships.role_name_child AS role_name_child, relationships.role_name_intermediary AS role_name_intermediary, relationships.role_label_parent_singular AS role_label_parent_singular, relationships.role_label_child_singular AS role_label_child_singular, relationships.role_label_parent_plural AS role_label_parent_plural, relationships.role_label_child_plural AS role_label_child_plural, relationships.needs_legacy_support AS needs_legacy_support, relationships.is_active AS is_active, relationships.autodelete_intermediary AS autodelete_intermediary, relationships.parent_types AS parent_types_set_id, relationships.child_types AS child_types_set_id, GROUP_CONCAT(DISTINCT parent_types_table.type) AS parent_types, GROUP_CONCAT(DISTINCT child_types_table.type) AS child_types FROM wp_dfcdojph2o_toolset_relationships AS relationships JOIN wp_dfcdojph2o_toolset_type_sets AS parent_types_table ON (relationships.parent_types = parent_types_table.set_id ) JOIN wp_dfcdojph2o_toolset_type_sets AS child_types_table ON (relationships.child_types = child_types_table.set_id ) GROUP BY relationships.id

Error in WordPress DataBase: [Table 'db2370483601.wp_dfcdojph2o_toolset_relationships' doesn't exist]
SELECT relationships.id AS id, relationships.slug AS slug, relationships.display_name_plural AS display_name_plural, relationships.display_name_singular AS display_name_singular, relationships.driver AS driver, relationships.parent_domain AS parent_domain, relationships.child_domain AS child_domain, relationships.intermediary_type AS intermediary_type, relationships.ownership AS ownership, relationships.cardinality_parent_max AS cardinality_parent_max, relationships.cardinality_parent_min AS cardinality_parent_min, relationships.cardinality_child_max AS cardinality_child_max, relationships.cardinality_child_min AS cardinality_child_min, relationships.is_distinct AS is_distinct, relationships.scope AS scope, relationships.origin AS origin, relationships.role_name_parent AS role_name_parent, relationships.role_name_child AS role_name_child, relationships.role_name_intermediary AS role_name_intermediary, relationships.role_label_parent_singular AS role_label_parent_singular, relationships.role_label_child_singular AS role_label_child_singular, relationships.role_label_parent_plural AS role_label_parent_plural, relationships.role_label_child_plural AS role_label_child_plural, relationships.needs_legacy_support AS needs_legacy_support, relationships.is_active AS is_active, relationships.autodelete_intermediary AS autodelete_intermediary, relationships.parent_types AS parent_types_set_id, relationships.child_types AS child_types_set_id, GROUP_CONCAT(DISTINCT parent_types_table.type) AS parent_types, GROUP_CONCAT(DISTINCT child_types_table.type) AS child_types FROM wp_dfcdojph2o_toolset_relationships AS relationships JOIN wp_dfcdojph2o_toolset_type_sets AS parent_types_table ON (relationships.parent_types = parent_types_table.set_id ) JOIN wp_dfcdojph2o_toolset_type_sets AS child_types_table ON (relationships.child_types = child_types_table.set_id ) WHERE ( ( ( relationships.parent_domain = 'posts' ) AND ( parent_types_table.type = 'raulabad' ) ) OR ( ( relationships.child_domain = 'posts' ) AND ( child_types_table.type = 'raulabad' ) ) ) AND ( relationships.is_active = 1 ) AND ( ( ( relationships.parent_domain != 'posts' OR parent_types_table.type IN ( 'post', 'page', 'attachment', 'oembed_cache', 'user_request', 'w2dc_listing', 'project', 'amp_validated_url', 'mec-events', 'mec_calendars', 'modula-gallery', 'omapi', 'testimonials', 'raulabad', 'newsletters' ) ) ) AND ( ( relationships.child_domain != 'posts' OR child_types_table.type IN ( 'post', 'page', 'attachment', 'oembed_cache', 'user_request', 'w2dc_listing', 'project', 'amp_validated_url', 'mec-events', 'mec_calendars', 'modula-gallery', 'omapi', 'testimonials', 'raulabad', 'newsletters' ) ) ) ) AND ( relationships.origin = 'wizard' ) GROUP BY relationships.id

Error in WordPress DataBase: [Table 'db2370483601.wp_dfcdojph2o_toolset_relationships' doesn't exist]
SELECT relationships.id AS id, relationships.slug AS slug, relationships.display_name_plural AS display_name_plural, relationships.display_name_singular AS display_name_singular, relationships.driver AS driver, relationships.parent_domain AS parent_domain, relationships.child_domain AS child_domain, relationships.intermediary_type AS intermediary_type, relationships.ownership AS ownership, relationships.cardinality_parent_max AS cardinality_parent_max, relationships.cardinality_parent_min AS cardinality_parent_min, relationships.cardinality_child_max AS cardinality_child_max, relationships.cardinality_child_min AS cardinality_child_min, relationships.is_distinct AS is_distinct, relationships.scope AS scope, relationships.origin AS origin, relationships.role_name_parent AS role_name_parent, relationships.role_name_child AS role_name_child, relationships.role_name_intermediary AS role_name_intermediary, relationships.role_label_parent_singular AS role_label_parent_singular, relationships.role_label_child_singular AS role_label_child_singular, relationships.role_label_parent_plural AS role_label_parent_plural, relationships.role_label_child_plural AS role_label_child_plural, relationships.needs_legacy_support AS needs_legacy_support, relationships.is_active AS is_active, relationships.autodelete_intermediary AS autodelete_intermediary, relationships.parent_types AS parent_types_set_id, relationships.child_types AS child_types_set_id, GROUP_CONCAT(DISTINCT parent_types_table.type) AS parent_types, GROUP_CONCAT(DISTINCT child_types_table.type) AS child_types FROM wp_dfcdojph2o_toolset_relationships AS relationships JOIN wp_dfcdojph2o_toolset_type_sets AS parent_types_table ON (relationships.parent_types = parent_types_table.set_id ) JOIN wp_dfcdojph2o_toolset_type_sets AS child_types_table ON (relationships.child_types = child_types_table.set_id ) WHERE ( ( ( relationships.parent_domain = 'posts' ) AND ( parent_types_table.type = 'newsletters' ) ) OR ( ( relationships.child_domain = 'posts' ) AND ( child_types_table.type = 'newsletters' ) ) ) AND ( relationships.is_active = 1 ) AND ( ( ( relationships.parent_domain != 'posts' OR parent_types_table.type IN ( 'post', 'page', 'attachment', 'oembed_cache', 'user_request', 'w2dc_listing', 'project', 'amp_validated_url', 'mec-events', 'mec_calendars', 'modula-gallery', 'omapi', 'testimonials', 'raulabad', 'newsletters' ) ) ) AND ( ( relationships.child_domain != 'posts' OR child_types_table.type IN ( 'post', 'page', 'attachment', 'oembed_cache', 'user_request', 'w2dc_listing', 'project', 'amp_validated_url', 'mec-events', 'mec_calendars', 'modula-gallery', 'omapi', 'testimonials', 'raulabad', 'newsletters' ) ) ) ) AND ( relationships.origin = 'wizard' ) GROUP BY relationships.id

-----------------------------------------------------------------------------------------------

Can you please help me ? I hace created 2 simple CPT using Toolset with no relationship... The error is about relationship¿ Can you please help me to fix it ?

[Christian Cox]

Hi, can you try these troubleshooting steps first?
- Temporarily activate a default theme like Twenty Nineteen. Temporarily deactivate all plugins except Types. Make sure your site has the latest version of Types, currently Types 3.3.5.
- Test again. If the problem is resolved, reactivate your theme and other plugins one by one until the problem returns.
- If the problem cannot be resolved, I would like to check your configurations. Please add your website's debug information in your next reply, as explained here: https://toolset.com/faq/provide-debug-information-faster-support/

[convierteproS]

Hello, I followed your steps in Staging Eviroment (theme Twenty Nineteen and deactive all plugins but ToolSet...) and as you can see the same debug error appears:

hidden link

hidden link

Can you please help me ?

[convierteproS]

SORRY!
Password for Staging Enviroment are:
User: 1234567
Passw: 1234567

[Christian Cox]

Okay thank you for the information. Can you tell me a bit more?
- Was this site created from scratch, or did you import data from another site here? If so, how did you import the data?
- Please add your site's debug information so I can check your other configurations: https://toolset.com/faq/provide-debug-information-faster-support/
- Please go to wp-admin > Toolset > Relationships and take a screenshot so I can see the configurations. Include this screenshot in your next reply.

[convierteproS]

1)
The site was created from scratch. I didn´t import data from another site.

2)

DEBUG INFORMATION FROM TOOLSET PLugin

{"core":{"Wordpress":{"Multisite":"No","SiteURL":"http:\/\/marketingrelacional.flywheelstaging.com","HomeURL":"http:\/\/marketingrelacional.flywheelstaging.com","Version":"5.2.3","PermalinkStructure":"\/%category%\/%postname%\/","PostTypes":"post, page, attachment, revision, nav_menu_item, custom_css, customize_changeset, oembed_cache, user_request, wp_block, wp-types-group, wp-types-user-group, wp-types-term-group, raulabad, newsletters","PostSatus":"publish, future, draft, pending, private, trash, auto-draft, inherit, request-pending, request-confirmed, request-failed, request-completed, hidden"},"Server":{"jQueryVersion":"1.12.4-wp","PHPVersion":"7.2.22-1+ubuntu16.04.1+deb.sury.org+1","MySQLVersion":"5.7.14","ServerSoftware":"Flywheel\/5.1.0"},"PHP":{"MemoryLimit":"128M","UploadMax":"500M","PostMax":"500M","TimeLimit":"180","MaxInputVars":"5000"}},"plugins":{"active_plugins":{"types\/wpcf.php":{"Name":"Toolset Types","PluginURI":"https:\/\/toolset.com\/?utm_source=typesplugin\u0026utm_campaign=types\u0026utm_medium=plugins-list-full-version\u0026utm_term=Visit plugin site","Version":"3.3.5","Author":"OnTheGoSystems","AuthorURI":"http:\/\/www.onthegosystems.com","TextDomain":"types","DomainPath":"","Network":false,"Title":"Toolset Types","AuthorName":"OnTheGoSystems"}},"mu_plugins":{"health-check-troubleshooting-mode.php":{"Name":"Health Check Troubleshooting Mode","PluginURI":"","Version":"1.6.0","Description":"Conditionally disabled themes or plugins on your site for a given session, used to rule out conflicts during troubleshooting.","Author":"","AuthorURI":"","TextDomain":"","DomainPath":"","Network":false,"Title":"Health Check Troubleshooting Mode","AuthorName":""},"sso.php":{"Name":"SSO","PluginURI":"","Version":"0.2","Description":"","Author":"Garth Mortensen, Mike Hansen","AuthorURI":"","TextDomain":"","DomainPath":"","Network":false,"Title":"SSO","AuthorName":"Garth Mortensen, Mike Hansen"}},"dropins":{"db-error.php":{"Name":"db-error.php","PluginURI":"","Version":"","Description":"","Author":"","AuthorURI":"","TextDomain":"","DomainPath":"","Network":false,"Title":"","AuthorName":""}}},"theme":{"Name":"Twenty Nineteen","ThemeURI":null,"Author":"\u003Ca href=\u0022https:\/\/es.wordpress.org\/\u0022\u003Eel equipo de WordPress\u003C\/a\u003E","AuthorURI":null,"Template":"twentynineteen","Version":"1.4","TextDomain":null,"DomainPath":null},"extra-debug":{"types":{"add_resized_images_to_library":0,"register_translations_on_import":1,"images_remote":0,"images_remote_cache_time":"36","help_box":"no","hide_standard_custom_fields_metabox":"hide","postmeta_unfiltered_html":"off","usermeta_unfiltered_html":"off"},"installer":{"version":"2.1.0","repositories":{"wpml":{"api-url":"https:\/\/api.wpml.org\/","products":"http:\/\/d2salfytceyqoe.cloudfront.net\/wpml33-products.json","subscription":""},"toolset":{"api-url":"https:\/\/api.toolset.com\/","products":"http:\/\/d7j863fr5jhrr.cloudfront.net\/toolset33-products.json","subscription":{"key":"jyGruDHvUF","data":{"subscription_type":5740,"expires":null,"status":"4"},"registered_by":4,"site_url":"https:\/\/www.marketingrelacional.com"}}},"instances":{"\/www\/wp-content\/plugins\/types\/vendor\/otgs\/installer\/installer.php":{"bootfile":"\/www\/wp-content\/plugins\/types\/vendor\/otgs\/installer\/installer.php","version":"2.1.0","args":{"plugins_install_tab":"1","repositories_include":["toolset","wpml"]},"delegated":true}}}}}

3)
Sending Relationship Screenshoot attached

[Christian Cox]

Okay your memory setting at 128M is a bit low, but I don't know that it would be causing the MySQL error you're seeing. I have seen this on one other site that showed this error until a post relationship was created. Let's try that next. Please click "Agregar nuevo" and create a one-to-many post relationship between Posts and Pages. All the default settings are fine. If the process is successful, the relationships tables should be created for you automatically. If you are unable to create the post relationship, or if the error remains after the relationship is created, please provide login credentials here in the private reply fields. I'll take a closer look.

[Christian Cox]

Okay unfortunately I still don't see anything that would be causing this problem. I uninstalled and reinstalled Types, but that didn't help. A few more things we can try:
- Try to increase WordPress memory to 256M by setting these limits in your wp-config.php file:

define('WP_MEMORY_LIMIT', '256M';
define( 'WP_MAX_MEMORY_LIMIT', '256M' );

- Add a phpinfo.php file so I can see your site's PHP configurations. Instructions here: https://toolset.com/toolset-requirements/
- Create a database dump file from your site so I can download it and see if there are any obvious problems. I will check things like collation and charset, as well as other tables created for Toolset.
- Turn on server logs to see if we can catch any unexpected server-side errors. Flywheel may be able to help you with this. Once the logs are on, visit the relationships page again in wp-admin. Then check the logs for any additional errors.

[convierteproS]

Thank you Christian for your reply and work in my case.

Its not normal that a plugin such as "Toolset" gives problems and even requires more system memory. I have had no other problem with the rest of plugins in my site about memory ...

What I did? I migrated all CPTs created in Toolset to "Custom Post Type UI" plugin, and, "surprise", its working correctly. With no Debug errors and no addicional memory requirements....

Its really a pity that Toolset main competitor works better and lighter....

I loved Toolset but as you can understand my solution is "Custom Post Type UI".

Thank you !

[Shane]

Hello,

As Christian is currently on vacation right now, I will be handling his queue.

It seems that you've managed to resolve the issue by using the Custom post Type UI plugin. Though this is not ideal I'm happy that you're able to progress with your site.

This seems to be a one off issue. Did it started from an update to the plugin or is this site a fresh installation?

Please let me know.
Thanks
Shane