WordPress.org

Ready to get started?Download WordPress

Forums

Form Manager
[resolved] fatal error upon activation attempt (21 posts)

  1. siriusly
    Member
    Posted 3 years ago #

    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!

  2. hoffcamp
    Member
    Plugin Author

    Posted 3 years ago #

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

  3. siriusly
    Member
    Posted 3 years ago #

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

  4. hoffcamp
    Member
    Plugin Author

    Posted 3 years ago #

    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.

  5. siriusly
    Member
    Posted 3 years ago #

    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... ???

  6. hoffcamp
    Member
    Plugin Author

    Posted 3 years ago #

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

  7. hoffcamp
    Member
    Plugin Author

    Posted 3 years ago #

    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.

  8. areafh
    Member
    Posted 2 years ago #

    I get the same error

  9. hoffcamp
    Member
    Plugin Author

    Posted 2 years ago #

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

  10. areafh
    Member
    Posted 2 years ago #

    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

  11. hoffcamp
    Member
    Plugin Author

    Posted 2 years ago #

    Okay I'll try to track down the problem.

  12. anthonysycamore
    Member
    Posted 2 years ago #

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

  13. anthonysycamore
    Member
    Posted 2 years ago #

    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

  14. hoffcamp
    Member
    Plugin Author

    Posted 2 years ago #

    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.

  15. windrag
    Member
    Posted 2 years ago #

    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

  16. windrag
    Member
    Posted 2 years ago #

    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.

  17. hoffcamp
    Member
    Plugin Author

    Posted 2 years ago #

    That was it. I just posted the update (1.6.33).

  18. siriusly
    Member
    Posted 2 years ago #

    Thanks for all the work on this folks! I will give it a go again.

  19. Anna
    Member
    Posted 2 years ago #

    I get this error in 1.6.33, after updating WordPress to 3.3.2. The exact message I get is:

    Plugin could not be activated because it triggered a fatal error. Table 'educatio_wordpress.wp_fm_data_1' doesn't exist

    I'm guessing it's trying to create a table prefixed by wp_, but my tables aren't prefixed with this. I tried re-updating WordPress and reinstalling the plugin. Any ideas on what else I could try?

  20. hoffcamp
    Member
    Plugin Author

    Posted 2 years ago #

    If you changed the prefix after installing the plugin then you will have to manually rename the tables. This is a huge oversight on my part but unfortunately this bug is deeply ingrained in the plugin.

  21. Anna
    Member
    Posted 2 years ago #

    I was sure I hadn't changed the table prefixes, but actually I installed a security plugin (WSD security) and that did change them after I installed Form Manager. That might be an issue for anyone else using that plugin. Thanks for your response, I'll change the tables manually as you suggest.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic