I have a lot of bugs on my new website with toolset.
Creating a view or and archive needs to refresh the page in order to finish the process.
Then when I save the archive the say "can't be save".
Also when I save a cusotm field I got this
Erreur de la base de données WordPress : [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 5]
SELECT DISTINCT tt.taxonomy FROM IRCPT_wp_term_taxonomy tt JOIN IRCPT_wp_term_relationships tr ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE tr.object_id IN (82398) AND tt.taxonomy IN ()
Warning: Cannot modify header information - headers already sent by (output started at /home/coro3994/cpt.inter-reseaux.site/wp-includes/wp-db.php:1491) in /home/coro3994/cpt.inter-reseaux.site/wp-includes/pluggable.php on line 1281
Warning: Cannot modify header information - headers already sent by (output started at /home/coro3994/cpt.inter-reseaux.site/wp-includes/wp-db.php:1491) in /home/coro3994/cpt.inter-reseaux.site/wp-includes/pluggable.php on line 1284
Also other bugs...
Hello and thank you for contacting the Toolset support.
The logs provided do not have a stack trace so we can know where exactly the errors are triggered. Please activate PHP debugging to get more info about the error https://wordpress.org/support/article/debugging-in-wordpress/
Can you also tell which pages are triggering these errors? Or what steps do you follow to trigger any of these errors?
On your test site, please check if these errors appear when:
- Only Toolset plugins are activated. It will tell us if there is an interaction issue with another plugin.
- The theme is set to a WordPress default like Twenty Fourteen. It will tell us if there is an interaction issue with your theme.
If the problem disappears, start activating one at the time to track where the incompatibility is produced.
Looking forward to your reply.
Only toolset and wpml plugins are activated.
Also have exact same result with any theme, including Twenty Fifteen.
The DEBUG has always been activated and here is what I get :
- when I try to save a custom fields group :
[02-Apr-2020 14:59:44 UTC] Erreur de la base de données WordPress You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 5 pour la requête SELECT DISTINCT tt.taxonomy
FROM IRCPT_wp_term_taxonomy tt
JOIN IRCPT_wp_term_relationships tr
ON tt.term_taxonomy_id = tr.term_taxonomy_id
WHERE tr.object_id IN (82256) AND tt.taxonomy IN () faite par do_action('load-toolset_page_wpcf-edit'), WP_Hook->do_action, WP_Hook->apply_filters, wpcf_admin_menu_edit_fields_hook, Types_Admin_Edit_Custom_Fields_Group->form, Types_Admin_Edit_Custom_Fields_Group->save, wpcf_admin_fields_save_group, wp_update_post, wp_insert_post, do_action('save_post'), WP_Hook->do_action, WP_Hook->apply_filters, display_tax_sync_message, do_action('wpml_new_duplicated_terms'), WP_Hook->do_action, WP_Hook->apply_filters, new_duplicated_terms_filter, WPML_Term_Hierarchy_Duplication->duplicates_require_sync, WPML_Term_Hierarchy_Duplication->get_need_sync_all_terms
[02-Apr-2020 14:59:44 UTC] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/coro3994/cpt.inter-reseaux.site/wp-includes/wp-db.php:1491) in /home/coro3994/cpt.inter-reseaux.site/wp-includes/pluggable.php on line 1281
[02-Apr-2020 14:59:44 UTC] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/coro3994/cpt.inter-reseaux.site/wp-includes/wp-db.php:1491) in /home/coro3994/cpt.inter-reseaux.site/wp-includes/pluggable.php on line 1284
- when I try to create a new view :
[02-Apr-2020 15:01:57 UTC] Erreur de la base de données WordPress You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 5 pour la requête SELECT DISTINCT tt.taxonomy
FROM IRCPT_wp_term_taxonomy tt
JOIN IRCPT_wp_term_relationships tr
ON tt.term_taxonomy_id = tr.term_taxonomy_id
WHERE tr.object_id IN (87977) AND tt.taxonomy IN () faite par do_action('wp_ajax_wpv_create_view'), WP_Hook->do_action, WP_Hook->apply_filters, Toolset_Ajax->__call, WPV_Ajax_Handler_Create_View->process_call, wpv_create_view, WPV_View::create, WPV_View_Base::create_post, wp_insert_post, do_action('save_post'), WP_Hook->do_action, WP_Hook->apply_filters, display_tax_sync_message, do_action('wpml_new_duplicated_terms'), WP_Hook->do_action, WP_Hook->apply_filters, new_duplicated_terms_filter, WPML_Term_Hierarchy_Duplication->duplicates_require_sync, WPML_Term_Hierarchy_Duplication->get_need_sync_all_terms
I would like to take a copy of your website and debug it locally. We prefer to use the Duplicator plugin to create copies https://wordpress.org/plugins/duplicator/
Please use the filters on Duplicator to exclude uploads folder and reduce the size of the package or allow me temporary access to your website to take it.
Sometimes, Duplicator fails due to some server restrictions, in this case, please provide a database export, themes, and plugins folders.
Your next reply will be private to share download links or credentials safely.
Before creating the Duplicator copy, please create a new administrator user and share its credentials on the next reply, after building the copy you can remove it.
Thank you for the access details. I was able to build a local copy.
It seems that WPML will trigger this error when the default WordPress taxonomies are deactivated. Check this support ticket https://wpml.org/forums/topic/getting-mysql-errors-on-some-pages/
I activated locally both categories and tags taxonomies and the error was not triggered anymore. You can then use a plugin to customize your WP-admin menu and remove tags and categories.
Let me know if this is a viable solution for you.
My issue is resolved now. Thank you!
