Hi,

Last month i bought CC WFB after having tested the beauty of generating a good looking:( form
in minutes.

Now I try to save the data to a local Mysql database, simple option at first sight, but after hiting the submit button, nothing happens clearly, and nothing goes to the database.

i double cross checked the mysql params which are corrects, i wrote a simple PHP who use the same parameters as the form to access the database , and it works perfectly.

I tryed to look at all the php files used by WFB, but I get confused with all the junk otions (payment cart and so on...) I found the global architecture very confusing for a novice user like me

so I'm discouraged and about to drop the product, unless I find a simple way to debug it effectively

any help before loosing me ?..

Hi Fouad,
When you say Local do you mean on your own pc through WAMP or something similar?
If not there has to be a simple solution to your problem as I use the form builder for MySql all the time. What is the error you get? Can you share a link?

If you FTP into your server, go into the folder called STORAGE. You may find a PHP log file with some details why it is failing.

thanks for your help,
here is the trace I obtain using xdebug.

oh sorry it is 560 k long too long I fear
perhaps I can send just the end of the file ?

here is the dropbox link for the trace file:
https://dl.dropbox.com/u/23655106/trace.1362662160.xt

Scott: in the folder Storage, there is a correct record of the entries I've made, including the images files
uploaded, so it must be the mysql dialogue part in which I mess up??

All servers are different, but this is what I use if I want to write to MySQL on my OS X box. If I used Godaddy for example, localhost would change to the server name that they define in the MySQL setup.

Also, do not attempt to manually create the table or even write to an existing one. Enter a unique table name not in the database. When you submit the form for the first time, the table will be created and populated.

I finally found an exploitable (and simple!) error log: fb_errorlog in the storage folder
and the line :
13:16:02 +0000: Failed to insert data in from table: [0] 42S22 [1] 1054 [2] Champ '_submitted_' inconnu dans field list

seems to point to your point, the fields I have predifined in the mysql db do not match with what WFB
is trying to send.

so if I understand correctly, I shoul delete the existing (empty) table I've created, and let the form create
it's own one ?

That is correct. Do not make the table.

hourrah; now it's working!
Thank's Scott!

This hint should be Highlighted in the manual, or the FAQ !

well I can go on enjoying WFB!