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

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

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

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.

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

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

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

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

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

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.