I've created a custom table as per your training guides have added the DB save action into submit, selected the table, saved form - then run the form, but no record is output to the mySQL table. When I use Show Data there are no results.
Any ideas?
I'm using Joomla 1.5 plus Chronoforms V4 R3.0
[attachment=2]mySQLtable.jpg[/attachment]
No comments huh? .. well here are some supporting pics - I REALLY can't see what I'm doing wrong.
Hi TonyGib ,
Everything in the images looks OK (though a bit hard to read).
What is in the DB Save action configuration?
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 may need to switch to the Advanced Wizard to do this; if you want to continue to use the Easy Wizard please make a copy of your form first and add the Debugger action to the copy.
Bob
thanks for coming back 😀 Here area few pics - first the DB Save action config,second, the events page showing the Debugger, then I load the form/page concerned.
Complete the form, click Submit and the form takes me to Home (not the redirect address) 😟
Seems crazy to me!
Notes: I am using a different table name to the form name but that should be okay (I think). Also, on the site I changed the table prefix from jos to heb (after I had created a first table or 2) - could this have confused Chronoforms?
Hi TonyGib,
Still all looks fine except that the data array being returned is far too short.
By all means email or PM me the site URL and a SuperAdmin login and I'll take a quick look.
Bob
Bob hi
Trust you got the links I sent - perhaps you would change your pw when you get in to aviod any probs :o
Hi TonyGib,
You had the Form Mode set to Get instead of the default Post. I've changed that back and added a Handle Arrays action and it (the copy form at the end of your list) is saving to the Database OK.
Bob
Bob - many, many thanks! 😀 You have no idea how many hours I've wasted, looking for this.
The 'get' was me, trying out session data and didn't clear it (dum-dum!) 😶
The 'handle array' I didn't know about - but now is obvious .. again 😶 Is there somewhere that I can read up on these actions? (got the book).
Please enjoy a beer or two or three with me
Hi Tony,
No problem. There aren't any complete docs :-( There are my videos over on YouTube, a few tutorials here and a bunch of forum posts. (Use the Chronosearch to search them - it's better then the from search). I'm gradually scraping some docs together but time is scarce right now :-(
Bob