Chronoform does not save into DB

Hi to all.
I have two different behaviors when I use Chronoform created form included into a Joomla article and not.
When I link the article that include the form using the plugin sintax {chronoforms}myformname{/chronoforms} nothing happen, the form data are NOT saved into my DB table.
If I link the form using the Chronoform "Frontend view" mode the form data are correctly saved into the DB.

My DB table has been created by hand using phpMyAdmin, not using "create table" feature (I can't create it from scratch because I have other data).
All fields in my form seems to have the related fields into the DB.
I also have a DB column named "id"[int(11)] as a Primary key.

Any idea regarding this strange behavior?

Thanks and regards
Luca

Hi Luca,

Is the form submitting at all from the article? Does it send emails correctly?

Bob

Hi Bob,
the form article access level is set to Public and all other OnSubmit actions are ok (email sent and congratulation message).
If I create DB table starting from Chronoform all goes well (I can't do this on production because I have to use a different table)

Many thanks
Luca

Hi Luca,

Hmmm . . . By all means email or PM me the site URL, a SuperAdmin login and a note about the forms and tables you are using and I'll take a quick look.

Bob

Hi Bob,
a few minutes ago I solved my problem changing the primary key field name from "id" to "cf_id" and all goes well.
Doing so I need to change also other php standalone script but it's the minor malus.

Thanks & regards
Luca

HI Luca,

You shouldn't need to change it - provided that the matching form input is also called 'id' (and not 'cf_id').

Bob

I'm having the same issue as in the OP.

The database to save the data to is an existing database form a extension (zh GoogleMap)
In the frontend view all data is saved to the table (jos_zhgooglemaps_markers), but when using {chronoforms}myformname{/chronoforms} in an article the data ins't saved. Everything else, like sending email and redirecting to a specific article, is working fine.

Rene

Hi Rene,

I can't think of any reason why the email would be sent but the DB Save doesn't run unless there is an error in the MySQL query.

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

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

Bob

Hello Bob,

This is the result of the debugger:


Data Array:
Array
(
[chronoform] => duurzamekaart
[event] => submit
[Itemid] => 435
[option] => com_content
[view] => article
[id] => 167
[catid] => 114
[title] => Water Drimmelen
[addresstext] => Wagenstraat wagenberg nederland
[description] => testing
[icontype] => gm#dot-green
[mapid] => 2
[actionbyclick] => 1
[zoombyclick] => 100
[baloon] => 1
[published] => 1
[markergroup] => 1
[userprotection] => 1
[streetviewinfowinw] => 400
[streetviewinfowinh] => 250
[params] =>
[input_submit_23] => Zet mij op de kaart
[527f4a76147aa072bbb106216ba4fb5f] => 1
)
Validation Errors:
Array
(
)
Debug Data
email
7
Result
An email has been SENT successfully from (admin) [email]info@duurzaamxxxx.nl[/email] to [email]rene@xxxx.net[/email]
Body
Categorie:* 114
Titel:* Water Drimmelen
Plaats:* Wagenstraat wagenberg nederland
Beschrijving testing
Type van de marker:* gm#dot-green
Hidden #11 2
Hidden #12 1
Hidden #13 100
Hidden #14 1
Hidden #16 1
Hidden #18 1
Hidden #19 1
Hidden #20 400
Hidden #21 250
Hidden #22


Submitted by 94.208.41.33
Attachments
array ( )
redirect_user
redirect_user_target_url: http://www.duurzaamdrimmelen.nl/index.php/de-duurzame-kaart
Redirect URL (click to continue):
http://www.duurzaamdrimmelen.nl/index.php/de-duurzame-kaart
Powered By ChronoForms - ChronoEngine.com

Rene