Form not saving to DB or redirecting

I'm using Joomla 1.5.23 and Chronoforms 4.0 RC3.4.1.

I created a form which I had working that saved to database then redirected the user. Worked beautifully. Well now I've added to the form because the client wanted to get more data. I'm using tabs and now I've added videos as well.

Once I hit a certain number of items in the wizard view, it wouldn't save any longer, so I had to go in and edit the code in form view to add the additional items. Ok so that worked fine.

But now I've created a new table to save all this new data to, and it's not saving! And it's no longer redirecting! When you click submit it goes to a blank page...can someone give me an idea of what might be wrong??

Here's a link to the form on the test site:
http://tailoredrepublic.com/beta/index.php?option=com_chronoforms&view=form&Itemid=35

Thanks!

Hi ProgrammerJen,

Please see this FAQ

Bob

Thanks Bob, that does help. It seems my issue is that mod_security is set, and it can not be changed because it's a shared host. Is there a work around for this?

Hi ProgrammerJen,

Protest more loudly to your webhost - it's possible that the settings can be changed on a per site basis.

Create the forms on a difference computer and then Backup and Restore them to the live site.

Break the form into separate pages i.e. several smaller forms.

Bob

Host refuses to turn of mod_security and claims that it's not being triggered by the form. The other items listed on that page don't apply as they are not installed. I was able to handcode the remainder of the form so no need to move to another computer to do it, problem is it won't save to the database because it's so large. Can't break it up into smaller forms as that's not what the client wants.
Any other things you might be able to recommend checking that could be causing the issue of it not saving to database?

In the events under on submit, I have two items, the db save and the user redirect. Does the order of these matter? Or will both be executed upon clicking submit?

Ok so I've been doing some further testing. I've put the form on another installation on my personal VPS. This does not limit me in the number of items I add, as mod_security is off on this server. So I can add unlimited fields. And I can save other forms to database, but this one form is still not saving to the database. So there's some other problem its not the limited fields causing the problem for this form. I've checked the FAQs and checked everything that the FAQ on not being able to save to database, and all is correct. I'm stumped at this point.

Have it resolved. It was some custom code I had used to update a user's entry instead of creating a new one every time. It broke something, with it removed, it saves to database. Now I have to figure out how to correctly get it to update someone's entries rather than create a new one.

Hi ProgrammerJen,

The order of actions in an event does matter. If you have the ReDirect before the DB Save then the DB Save will never be executed.

To update an existing entry make sure that the form results, specifically the $form->data array contain a valid entry for the primary key of the record to be updated. Usually the easiest way to do this is to have the key in a hidden input in your form.

Bob