Not writing in DB

[rcolyn]

Hi Thanks for a great product !!

I can't get CKForms to write / Display any data entered in the form from the DB ...

1. I get the form Emails 100% ?
2. "Save Result" = Yes in the Results Tab

Please assist.

Many Thanks
Ralph Colyn

[pedrino]

Hi,
I think it’s because you use as field name, a reserved word of MySQL Database. Change the field name, save and everything was fine.

Try it and tell me.

In the next feature, I will test the field name.

You can find the complete list of MySQL reserved words :

http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html

Thanks

Pierre

[rcolyn]

Hi

I've tried your suggestion on a blank form, and it worked 100% - thanks ...

Would you be so kind as to look at the following list of field names and see if any of them are not allowed ?

Code: Select all

id
created
ipaddress
name
Surname
DOB
address
submit
Gender
Status
prename
tel
fax
email
lead
arrive
depart
car
drivers
prefname
fieldsep5
fieldsep19


Hope you don't mind ...

Thanks
Ralph

[rcolyn]

Hi Pierre

I'm by no means good at PHP or SQL, but I have a thought ...

Instead of trying to filter each field name for SQL reserved words, would it not be possible to use

Code: Select all

base64_decode(

and

Code: Select all

base64_encode(

before and after storing/reading the field name from the SQL Database, this way, SQL wouldn't know about the reserved words ?!

Kind Regards
Ralph

[rjo]

Hello and a big thank you for ckforms!

As a little note: I have the same issue with data not saved.
However, none of the field names is in the reserved names' list.

The fieldnames (and types) are:
courriel (text [text]), envoyer (button), message (textarea), nom (text [text]), objet (select), prenom (text [text]), societe (text [text]), tel (text [text]), titre (text [text])

When I look at the database, a table has been created to store the data, but it only contain two fields ("id" and "created"). I remember from an earlier version of ckforms that data storage started working after manually completing the table structure.
Have a good day

[pedrino]

Hi,
could you backup your CKForms data (see manual) and send me by e-mail to see what's wrong.

Thanks

Pierre