form data/ save table

hi,

i'm struggling with the DB settings.
In the table i can not see the field name (see attachment)
Could somebody help me with this issue?

Thanks,

Peter

Hi PeterL,

Please drag a Debugger action into the On Submit event, then submit the form and post the debug results here.

Note: if you are using the Easy Wizard you can turn on Debug on the Others tab.

Bob

Thanks for helping Greyhead!

Data Array:

Array
(
[chronoform] => zzp
[event] => submit
[Itemid] => 124
[option] => com_chronoforms
[view] => form
[Beroep] => webber
[Woonplaats] => Eersel
[Specialisatie] => Web
[Naam] => Peter
[email] => [email]mysite@mysite.com[/email]
[Telefoon] => 06
[chrono_verification] => uA5Dd
[input_submit_8] => Meld aan:
[872a4abc0517baa6a02de8b8bbd7c66e] => 1
)

Validation Errors:

Array
(
)

Debug Data

email
1
Result An email has been SENT successfully from (zzpgilde)info@zzpgilde.nl to [email]info@noordzuidweb.be[/email]
Body
Beroep webber
Woonplaats Eersel
Specialisatie Web
Naam Peter
email [email]mysite@mysite.com[/email]
Telefoon 06
vul code in: uA5Dd


Submitted by 178.85.106.169
Attachments array ( )
Core Captcha
Passed the core captcha check!

Hi PeterL,

I don't see any sign of a DB Save action in the Debugger output?

What I can see is that the input names e.g. Woonplaats are not the same as the column names e.g. input_Woonplaats_2 That would explain why the data isn't saving. The two must be exactly the same for the DB Save to work.

Bob

Hi Greyhea,
so, whats my blind spot...
I made ​​a screenshot of my settings (see attachments)

and the table...

Hi PeterL,

Hmm . . . that's the Create Table command where the names will always match. What are the names in the table you are actually using. Please see this post of yours where there are clearly different names.

Bob

PS The element ID should not have any spaces or special characters in it. Use the Title if you want a description.

thanks,

i have send you a personel message

PeterL

Hi PeterL,

Thanks for the login. I looked as you asked and the records appear to be saving so I guess that you updated the input names to match the table?

Bob

Hi Greyhead,

yes, the data in the table are there.
But now i wonder why i get the mail like follow:

Beroep {Beroep}
Woonplaats {Woonplaats}
Specialisatie {Specialisatie}
Naam {Naam}
email {email}
Telefoon {Telefoon}
vul code in: zTkeQ

PeterL

Hi PeterL,

You've changed the input element names to match the Database column names but haven't updated the Email Template to match.

Bob

hello Bob,

After many hours of experimentation, I am still unable to obtain a working database.
you understand the frustration strikes.
I'm doing something wrong but where?
this way I configure, is that okay?

Hi PeterL,

Stop experimenting with this form for a moment and create a new one with just one Text Box input and a submit button. Give the text input the name naam; in the On Load event add a Show HTML action and in the On Submit action add an Email action, a DB Save action and a DeBugger action.

Give the form a name and save it, create a table using the toolbar icon, you will see that the column is called naam.

Edit the form, connect the DB Save action to the new table; then open the Email action and Click the Generate template action. You should see a template including {naam}. Save the action and the form.

Click the test form icon in the toolbar and test the form. You should see everything working because all the names are the same.

Once you have go this go back and edit your existing form so that the names match up. Depending on what you have changed in experimenting it may be simplest to create a new table (give it a slightly different name and re-connect the DB Save action to it). And regenerate the Email template.

Bob

Hi Bob,

thanks for your patience.
I decided to do a test on another website and their everything worked fine!
So there must be something wrong with the template or joomla installation; i must find out first.
I'll be back!;)

Peter

hi Bob,
the problem is in the template!
I made this template with Artisteer 4
This seems to be a bugy version; i had more problems with it.
i am sorry for bothering you!

PeterL