MySQL & FormLoom 4

I’m getting the following error when I try and write anything to my database.

SQLSTATE[HY093]: Invalid parameter number

I know my username, password, database name, and table name are all correct. I’ve tested them using Sequel Pro.

So I mapped out 1 field in Formloom to see if it would save to the database. No luck. The field is set up as a VARCHAR(255).

Any ideas would sure be appreciated. This has been driving me crazy for a few days and I can’t seem to get any help from Formloom.

Hi Paul,
not a real SQL expert myself but I would not name a Header in a database with a blank space as in Middle Initial.
Always healthy to avoid these. If I were you I would rename headers with blank spaces, set the stack up again and give it another try.
I am running three sql databases with Formloom 3 - all good…

HI Tom
Yeah I realize you shouldn’t do that, that’s why I didn’t include the field in the export. I was just trying to export 1 field out and that was first-name to see what the error was. I was still getting the error.

I’d be interested to see how you have your databases set up and how you have Formloom set up. If you want to email me that would be fine so that you don’t have to reveal how your database is setup in the forum.


I have this working in FL4. The database is MariaDB 10.0.38. Basic configuration of FL4 and the database structure shown below.

Proper naming of MySQL columns is essential.

Try removing the spaces and minuses ( use underscore instead ) from your column names.

I fixed everything and it’s all working properly now. Thank you everyone! :grinning:

1 Like

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.