Form data not saving to DB using ChronoForms_V3.1_RC4.11

Hi guys, I REALLY like your products, I've used ChronoForms a while back for an email form, now trying it out to create a document library, but hitting a hiccup...🤨

Joomla 1.5.10. Running on WAMP server / localhost.

I can submit the form just fine, not using email since this is to submit documents to the database to then search against on our intranet site.

Used the form (with one file upload) set to store to the db table created using ChronoForms. The table seems to have been built just fine, the Debug shows all success, the file even uploads to the server as expected, however, none of the data from the form gets added to the table?

From the forum research, I do have cf_id in the table as well as check0. And the DB Connection is set up for the form pointing to the table that ChronoForms created for the form.

I tried adding some javascript that I found that Bob had posted in the forum for the onSubmit after for what sounded like the same problem, but it didn't work...

Any insight into fixing this?

Here is the Debug Info:
[color=#4040FF] 1. Form passed first SPAM check OK
2. Form passed the submissions limit (if enabled) OK
3. Form passed the Image verification (if enabled) OK
4. Form passed the server side validation (if enabled) OK
5. $_POST Array: Array ( [text_1] => Monkeys and Sea Slugs 2 [text_2] => Master Chronicle [text_3] => Dr. Rambo Calhound [select_5] => 2007 [text_6] => [url=http://www.google.com]http://www.google.com[/url] [check0] => Array ( [0] => Yes ) [check1] => Array ( [0] => Yes ) [text_12] => trsjnes5trdydr udfhb b [text_13] => [check2] => Array ( [0] => Neuro [1] => Psychiatric [2] => ICU [3] => Dietary [4] => Technology ) [hidden_14] => dummy [71077fe0eefd7bd6875f5705b720250d] => 1 )
6. $_FILES Array: Array ( [file_4] => Array ( [name] => 5 Saving data to the database.pdf [type] => application/pdf [tmp_name] => C:\wamp\tmp\php9E.tmp [error] => 0 [size] => 345070 ) )
7. C:\wamp\www\connect\components\com_chronocontact\uploads\CHRONO_KHCDocsSubmit\20090415093018_5Savingdatatothedatabase.pdf has been uploaded OK
8. Form passed the plugins step (if enabled) OK
9. Debug End
10.
Redirect link set, click to test:
http://connect/latest-news[/color]

Thanks guys,
Jonathon

Hi demo38,

Took me a while to find this. You have the Autogenerated code set to run 'Before Emails' but this will only execute if 'Email the results ?' is set to Yes in the General Tab (I know it's not logical but . . . )

Switch the Autogenerated code to After Email and it saves OK.

Bob

PS I also changed the name of the form to remove the capitals but I don't think that this is the problem.

Thanks for the fast reply!

I had just recreated the form from scratch again and you are correct, leaving that option at After works.

Just noticed another thing. If I change the path for the file uploads to something other than default, the form submits to the database, but doesn't upload the file. If I then copy / past the suggested default back in, then it works fine. i noticed this with the first form as well?

Thanks again, on to ChronoConnectivity! I assure you another purchase as soon as I prove to them this will work.

Thanks,
J

Hi demo38,

I think I saw that Max posted yesterday that he'd found a bug in the file upload and woudl fix it.

Bob

Hi,

Just noticed another thing. If I change the path for the file uploads to something other than default, the form submits to the database, but doesn't upload the file. If I then copy / past the suggested default back in, then it works fine. i noticed this with the first form as well?

if the new path is writable it should work, check that the path string is well formatted and doesn't miss anything ?

Regards,
Max

The path was fine. When first accessing that tab window, it said that it wasn't writable (the default path), so i entered a custom path, applied, then it said writable, but would upload the files to the ORIGINAL default directory anyways, not my custom path. At that point, I switched back to the default path and it stayed writable. 🤨

Thanks,
J

I'm not sure but please retry with RC4.2 this weekend!

Regards,
Max

I'm not sure but please retry with RC4.2 this weekend!

Regards,
Max

Hi Max, is RC4.2 out somewhere? I only see RC4.11 (which I'm using now) available?

I would be HAPPY to try out a new release as I'm sure that you've squashed some things that I'm working against??? (fingers crossed!)

Thanks!
-J

Hi Jonathon,

No release yet, the weekends only just beginning here. I do know that Max is working on it.

Bob

Hi Jonathon,

It will be out tomorrow or later today!

Cheers
Max

Hi Max,

I'll keep an eye out, looking forward to trying it out!

Thanks,
J

Hi!

I have correctly configured my form to store the information in a database.
But when I press SUBMIT button, the screen turns white and nothing happens.

I receive the e-mail result correctly, but nothing is stored in my database.

¿Any suggestions?

Thank you in advance!!

Marina

Hi Marina,

Hard to say from the info here but most likely you have a dash, space or some other special character in one of your form input / database column names.

You can also set Error Reporting temporarily to Maximum in the Site Global Configuration. This hopefully will show an error message in place of the blank page.

Bob

Hi Bob!

Thanks for your answer.

I've got this error:

Parse error: syntax error, unexpected '$', expecting T_VARIABLE in .../components/com_chronocontact/chronocontact.php(53) : eval()'d code on line 12
You are not allowed to access this URL

Is this useful?

Thank you,

Marina

Here are some other errors:

Thank you!


Parse error: syntax error, unexpected '$', expecting T_VARIABLE in /.../components/com_chronocontact/chronocontact.php(53) : eval()'d code on line 12

Fatal error: Call to a member function bind() on a non-object in .../components/com_chronocontact/libraries/customcode.php(71) : eval()'d code on line 13

The second error is in this line:

if($type == 'autogenerated'){
if($MyForm->formparams('savedataorder') == $emailevent){
if ( !empty($MyForm->formrow->autogenerated) ) {
eval( "?>".$MyForm->formrow->autogenerated );
}
}
}

Hi Marina,

All of that points to a problem with an input or column name. Please check if any start with a number, have spaces, dashes, or other special characters in them other than a-z,A-Z,0-9 or _

Bob

I see that some columns start with numbers!

I will try again now.

Thanks a lot!

Marina

It worked!

Thanks a lot

I had the same problem. I used "-" instead of "_".
I was playing around for days till my friend showed the underscore solution to me. Never use dash in field name! God bless the team for this component! It is amazing.