SQL syntax error

  • Resolved clickharder

    (@clickharder)


    5 years, 8 months ago

    This may be a multi-site only issue or it may possibly affect all versions. I haven’t tested it on a single site version of WordPress.

    I just ran all my updates on WordPress and the plugin so everything is up to date as of this writing.
    Wordpress 5.2.2
    HFCM 1.1.3

    Here is the database error I am getting:
    “You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘IF’ at line 1 ”
    Error Code 1064

    The error is coming from the SQL statement in the main plugin file in the hfcm_options_install() function.

    If I remove that sql statement (the table is already there…) the error goes away.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support 99robotsteam

    (@99robotsteam)

    Hello @clickharder – We will be looking into this. As we have not received any similar tickets & we ourselves have the plugin on a few multi-sites as well as single sites & we have not encountered this problem, we are thinking this is more of an isolated plugin/theme conflict issue – either way, we will do a thorough round of testing to check this out.

    Plugin Support 99robotsteam

    (@99robotsteam)

    Hello @clickharder – We tested this on our end and we were not able to replicate this issue on our multi-site test environments after another round of testing. Therefore we are inclined to think, this might be a plugin/theme conflict on your end. We have not received a reply from you for 3 weeks, therefore we are going ahead and closing this ticket. Please feel free to create a new ticket if you need help with anything.

    Thank you,

    Hey @99robotsteam i can reproduce the problem. It’s on a multisite also.
    I see it in Query Monitor. Here’s a screenshot: https://snpy.in/UZjDFz

    Here you can see the System Info: https://snpy.in/URNBjl

    • This reply was modified 5 years, 5 months ago by Marco.
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘SQL syntax error’ is closed to new replies.