You have an error in your SQL syntax

  • Andreas 2013

    (@andreas-2013)


    4 years, 7 months ago

    Hello,
    I’ve just installed the plugin to test it out with my existing custom fields.
    Unfortunately I get the following error message, when I enable the button “ACF:Fields in Custom Table” within a custom field:
    “ACF: Fields in Custom Table error: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 ‘alter longtext NULL, thumbnail varchar(255) NULL, vollbild varchar(255) NUL…’ at line 8”

    What does this mean? Thank you very much for your help!
    Andreas

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter Andreas 2013

    (@andreas-2013)

    4 years, 6 months ago

    Is there someone, who could help me? Thanks in advance!

    Thread Starter Andreas 2013

    (@andreas-2013)

    4 years, 6 months ago

    Sorry, I didn’t know, that I had to create the table first. I’ve created a new table now, which I specified in the settings. But after that, all existing custom field values are empty and there is still an error message:
    WordPress-database-error: [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 ‘alter FROM my_table WHERE post_id = 24063’ at line 1]

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘You have an error in your SQL syntax’ is closed to new replies.