[Resolved] Every time I save custom fields I got a fatal error

[Author]

Posts

[romanB-3]

Hi,

When I go to hidden link

And then save settings (even if nothing changed), I get 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

I noticed similar bugs in severals places.

thank you.

[Shane]

Hi Roman,

Thank you for getting in touch.

I was able to see the issue.

If you create a new field group does the issue still remain ?

Also if you disable all the non toolset plugins and try to save this field group does the issue still remain ? I would like to ensure that this is not being caused by a plugin conflict.

Thanks,
Shane

[romanB-3]

If you create a new field group does the issue still remain ?
Yes

Also if you disable all the non toolset plugins and try to save this field group does the issue still remain ?
Yes

You have all accesses so you may try by yourself.
Thank you.

[Shane]

Hi Roman,

The issue here is that your MySQL version is below the minimum requirements. Currently you have MySQL Version 5.5.5 however our plugins require at least version 5.6 in order to function correctly.

I would recommend that you contact your host in order for them to provide you with a newer version of MySQL on your server.

Thanks,
Shane

[romanB-3]

I'm not quite sure about this ; I'm using MariaDB 10.3.22
Also I use this very same server with another site with Toolset where I didn't see any of those problems.

[romanB-3]

I've double checked with my host and they say my MariaDB version is similar to MySQL 5.7/5.8

[Shane]

Hi Roman,

Is there a way for them to switch to a newer version of the MariaDB and see if that works ?

What I would do is to perhaps backup the wordpress data and then try to reset the site but this would be a last option if nothing else works.

Given that your site works fine on my localhost then it would be an issue with the database based on the nature of the issue.

Thanks,
Shane

[romanB-3]

Reset the whole site solved the problem.
My issue is resolved now. Thank you!