Hello Peeps

I already enter all of MYSQL information on my Form settings and I also checked the form.cfg.php file to confirm the server name, password, etc are correct. When I try to submit the form I am getting the error below:


Your form could not be submitted for the following reason(s):

Failed to store the data.


This is what I did.

I created a new database and went inside mysqladmin page. I then created a table with 17 fields, the first one is my ID which is my primary and then the other 16 fields wich are 2 date type and 14 varchar fields are the info I want to save on mysql from my form.

Do I need to do anything else or I am missing something?

I see Scott is online so I hope he can see this threat or anybody who can help me.

Thanks in advance!!!!!

What you need to do here is modify the permissions of a folder on your server. Locate the folder called "storage" and adjust the permissions to 755 for that folder and all folders under it and then test your form again.

Ok Scott I did what you told me. check the pic attached

I am still having the same issue. Do you want me to send attach a copy of the form along with some pic of mysql database so you can check them all out.

Thanks man

Typically you should not have to do this, but try 777 as a test and see if that helps. If it does not, open a support ticket and send us the .fb file and the URL to your form and I will see if I notice anything out of the ordinary.

I would try deleting the table from the data base as the form builder will build that for you.

Thank you Eric, yesterday I tried several things and the problem persisted.

WFB is creating the table alright with all the fields but at the same time is giving me the following error:

Your form could not be submitted for the following reason(s):
•Warning: [ err 2/line 268/datasavemysql.cls.php] mysql_get_server_info() [<a href='function.mysql-get-server-info'>function.mysql-get-server-info</a>]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
•Warning: [ err 2/line 268/datasavemysql.cls.php] mysql_get_server_info() [<a href='function.mysql-get-server-info'>function.mysql-get-server-info</a>]: A link to the server could not be established
•Warning: [ err 2/line 268/datasavemysql.cls.php] mysql_get_server_info() [<a href='function.mysql-get-server-info'>function.mysql-get-server-info</a>]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
•Warning: [ err 2/line 268/datasavemysql.cls.php] mysql_get_server_info() [<a href='function.mysql-get-server-info'>function.mysql-get-server-info</a>]: A link to the server could not be established

Attached is a picture of the table after I submit the form. I must admit I do not know where these 3 fields come from because they are not part of my form, so I guess WFB created them.

_flags_
_transactid_
_rowid_ : Primary key

Any idea what I am missing.....

Thanks in advance!!!!

PS: for some reason it did not upload the picture which is 155kb saying the pic needs to be at least 100kb. weird.

Here is the picture. oops I did not read right. the pic was over 100kb.

Thanks for the help

OK guys.

I did not do anything else this morning but now it is working fine. One thing I found.

I dropped my table right, and then I submit a form, the regular error was given but two things happened. 1- the form was sent to the e mail intended, and the record was saved in mysql table, so I decided to click on submit away and !!!! whala !!!!. No error this time.

I went ahead and did not drop the table again but delete the record saved within my DB and try to submit a new form again and !!! Whala !!! No error message ever since.

I have not been able to figure out why it was given that error when the table was created alright along with the record but .... Hey, it is working.........

THANK YOU ERIC FOR YOUR REPLY AND SPECIAL THANK YOU TO SCOTT WHO STAY WITH ME LATE NIGHT TRYING TO SOLVE THE PROBLEM. THESE PEOPLE DESERVE A BREAK TODAY......

but I do also understand that some of us get a little nervous when things are not working and our customers want answers. lol

God Bless you all, and Happy new year.

I saw this behavior on one of my forms using Mysql. Error on first test submit and all the proceeding were fine.

hey Eric man.

I was reading your profile and man I lived 15 years in Grand Rapids MI. lol. I had my own business there as well. Small world.

Peace Out!!!