Skip Navigation

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

This support ticket is created 4 years, 9 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.

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

Supporter timezone: America/Jamaica (GMT-05:00)

Tagged: 

This topic contains 7 replies, has 2 voices.

Last updated by romanB-3 4 years, 9 months ago.

Assisted by: Shane.

Author
Posts
#1570949

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.

#1571217

Shane
Supporter

Languages: English (English )

Timezone: America/Jamaica (GMT-05:00)

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

#1571227

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.

#1571287

Shane
Supporter

Languages: English (English )

Timezone: America/Jamaica (GMT-05:00)

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

#1571379

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.

#1572063

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

#1572675

Shane
Supporter

Languages: English (English )

Timezone: America/Jamaica (GMT-05:00)

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

#1575917

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