Support » Plugin: Form Manager » [Plugin: WordPress Form Manager] fatal error upon activation attempt

  • Resolved siriusly

    (@siriusly)


    Here’s the error I get when attempting the activation:
    “Plugin could not be activated because it triggered a fatal error. 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 ” at line 1″

    Checked with host support, and they say “it’s a plugin problem.”

    Site where I am attempting activation is http://sjohnsoncreative.com

    Suggestions?
    Thanks!

Viewing 15 replies - 1 through 15 (of 20 total)
  • Plugin Author hoffcamp

    (@hoffcamp)

    I’m sorry about that. What version of the plugin, MySQL, and WP are you using? Also who is your host?

    Thread Starter siriusly

    (@siriusly)

    WP: 3.1.3
    Plugin: 1.5.23
    MySQL: 5.1.39 (note updated info–sorry about that)
    Host: DreamHost

    Plugin Author hoffcamp

    (@hoffcamp)

    Okay – I happen to have access to a dreamhost account, so I put a fresh WP 3.1.3 on there, and installed Form Manager 1.5.23 without the error. So my suggestion is to try downloading the plugin again, and if that doesn’t work, try disabling all of your other plugins to see if you can activate it then. If that doesn’t work, try switching to the default WP theme. Other than that I have no idea.

    Thread Starter siriusly

    (@siriusly)

    Thank you for suggestions. Tried all of them and it’s still returning the same fatal error when I activate… so, no plugin conflicts, it’s not in the theme… ???

    Plugin Author hoffcamp

    (@hoffcamp)

    Alright. Can you set up a fresh WP on your server? That would help to narrow it down.

    Plugin Author hoffcamp

    (@hoffcamp)

    Just to avoid confusion, what I mean is you could make a new directory on your server, like ‘/wp-test’, and set up a fresh WP there. If you are willing to go through all of that just to use a plugin, of course.

    I get the same error

    Plugin Author hoffcamp

    (@hoffcamp)

    There should be a technical description of the error. Could you copy and paste it?

    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 ” at line 1

    Plugin Author hoffcamp

    (@hoffcamp)

    Okay I’ll try to track down the problem.

    I also have the same error. Did anyone find the cause/solution?

    I have identified the error in my instance:

    fm_db_class->getCharsetCollation() returns an empty string
    so $charset_collate is empty so
    fm_db_class->fixCollation() fails on

    $q = “ALTER TABLE ".$table." DEFAULT “.$charset_collate;
    $this->query($q);

    I have edited this function to do nothing if $charset_collate is empty

    Plugin Author hoffcamp

    (@hoffcamp)

    Thanks for hunting that down! getCharsetCollation() should never be empty, it should at least be the default collation. I’ll fix that in the next update.

    I’m getting the same error on clicking the Submit button. I wonder if it’s related to an apostrophe not being escaped properly.

    Here’s the full error:

    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 't want to attend any more events',text-4f85198fa8594= '',textarea-4f8519d812′ at line 1`

    WP: 3.3.1
    FM: 1.6.32
    Host: Dreamhost
    MySQL: 5

    Email me privately if you want the link tho the form.

    ryk [at] ebcmp [dot] org

    If it’s helpful, the line in question is a part of a list with checkboxes.

    Updated: I experimented, and yes, this error occurs when there is an apostrophe in a line associated with a list with checkboxes.

Viewing 15 replies - 1 through 15 (of 20 total)
  • The topic ‘[Plugin: WordPress Form Manager] fatal error upon activation attempt’ is closed to new replies.