Forums

Hello,

I have set up a Connectivity connection (edit_staff) where I list the names of staff members. If a member's info needs editing, I click on their last name and bring up a form with their information. This was done using the action update_staff:load in the Front List Actions tab.

In the form that is loaded, I followed the example in the FAQ guide "Connectivity edit with Chronoforms". The only exception was that I had to add a db Read in the onLoad to read the record to load in the form. In the onSubmit action I have a Connection Action. The connection name is "edit_staff" and the connection action is "save".

Now, when I click on a name in the list to edit, the form comes up with the correct data. However, when I make a change and hit submit the browser goes blank. I put a debugger and show stopper in before the connectivity action in the form to see what is being sent. Here is the debugger info:

[attachment=0]editstaff.jpg[/attachment]

I'm afraid I can't figure out what configuration is not correct.

Thanks for your assistance.
Chris

Hello chriso0258,
I'm not a Chrono professional, but after checking your new post, I think that the following links may help:
My form data isn't saving to the database correctly
P.S: I'm just an automated service😉

Sorry, none of calculus00 suggestions seem to apply here.

Hi Chris,

Please see this FAQ to see if thart helps diagnose the problem - which is probably a PHP error of some kind.

Bob

Hello GreyHead, thank you for answering. Here is the error message when error reporting is at max:

"Fatal error: Cannot redeclare class GCore\Models\editreport in /var/www/libraries/cegcore/libs/model.php(141) : eval()'d code on line 4"

Hope this helps.

Hi Chris,

Using CCv5 you don't need neither a "db read" to load data nor a "db save" to save it, that's what CC does, please check the tutorials carefully!

What's causing the error is that one of your "db read" or "db save" is using the same model name used in CC and both of them conflict causing the error!

Regards,
Max

Hello Max and thanks for answering. I made the changes and here is the current configuration of the form.

[attachment=0]ccv5.jpg[/attachment]
[attachment=1]ccv5b.jpg[/attachment]
[attachment=2]ccv5c.jpg[/attachment]

The connection name of the CCv5 connection is edit_staff and the model title is editreport. The menu item brings up the CCv5 connection as a list of staff names. When I click on the last name the "update_staff" form comes up and the staff data is in the form. When I make a change and submit I'm afraid I still get the same error.

Hope this helps.

Chris

Here is the debug data that is being sent to the connection action in the form.

[attachment=0]debug.jpg[/attachment]

Hi Chris,

Please make sure your site cache is disabled, in case the error is cached!

If you still get the same error then please send me a screenshot for your Models setup in the connection!

You have the latest CC update, correct ?

Regards,
Max

Hello Max,
I wasn't sure where in CC5 to find the version so I went ahead and downloaded the latest and installed it. Site cache was disabled. Still have the same problem. Here are some screen shots:

[attachment=0]CC5error1.jpg[/attachment]

[attachment=1]CC5error4.jpg[/attachment]

[attachment=2]CC5error2.jpg[/attachment]

[attachment=3]CC5error3.jpg[/attachment]

Are you testing using the "Front view" link in CC ? if yes then please send me admin login so I can test this issue myself, I have just checked it here and its working fine!

Regards,
Max

Hello Max,

Yes I'm using the front listing. The original site is on a private network so I created a subdomain on my personal site. I'll pm you the login details for the site.

Thanks for your help with this.

Chris

What was the fix? I am having a similar problem without the error. I have a v5 form setup that you see when you click on "edit" on my ccv5 (connectivity v5) listing. I have a connection block setup on my submit action that is linked back to the connectivity task and setup as "save". When I click on the "edit" link in connectivity, I see my form. I make a change on my form and click "Save changes". This fires the submit action, and I get back to my connectivity listing. I get a message that says "Saved Successfully", but no changes are saved. I am running Connectivity RC4 and chronoforms v5 RC6. Any thoughts? Thank you!

Erik

Hi luxhodge,

Do you have the same fatal error reported by Chris earlier in this topic ? the fix applied only to that, if this is the case then you will need a patch file.

Regards,
Max

Do you get a new blank record saved in the database instead of updating the existing one ? if this is the case then you don't have a field for the primary key in your form!

Hey Max!

I should have been more specific. I am not getting an error, so the patch is not the issue. I don't get a new record either. Nothing happens in the database, but it still says the save was successful.

Erik

Hi Erik,

So no new record and existing one is not updated ? are you sure ?

Do you have a hidden field in the form with the primary key name and value ?

Regards,
Max

Hey!

Yes. No new entry in my table and no updated entry. I went back and looked at your tutorial on editing a record with ccV5. I changed my hidden field(see attached screenshot). Now I get this error: 0 - SQL=UPDATE `bnmt6_chronoforms_data_test` AS `myModelID` SET WHERE `cf_id` = '1';. The thing that bothers me here is that the SET field is empty. I thought this would show something like SET `myFieldthatChanged` = '4' or something like that. It doesn't look like it is trying to do that. The hidden field is a stock hidden field entry that I dragged over and tried to configure like the one in your example here http://www.chronoengine.com/faqs/72-ccv5/5208-connectivity-edit-with-chronoforms.html. Any ideas you have would be great. Thanks!

Erik

And here is the image I was going to attach in the post above. 😶

Please try to clear the "Field value" box in your hidden element settings, this is a wrong value anyway!

Moreover, what's the model name you have in your connection ?

Regards,
Max

Thanks for your patience Max!

I cleared the field value value box (what should that be?). I get the same error. My model name matches in my connectivity model field. I just put a generic one for my post.

Thanks again!

Erik

Hi Erik,

Please try to add a debugger then a "show stopper" before the "connection action" and then test the form, it should then print the data to be saved, please make sure that the data is formatted correctly under the model name ?

Also, do you have any fields names under the "Fields" box in the model setup ?

How many fields does your table have ? did you make any changes using phpmyadmin ?

Regards,
Max

Hello!

I get the same error like Chris. Can you share the fix please?

Thanks

Hi deindja,

Please provide more info and better start a new topic with your own configuration details!

Regards,
Max

Thanks for the reply, but it is ok now. It was probably some bug, because I deleted the connection, the form and the table, did them exactly the same again and it is working now.

Hello Max

I have exactly the same problem as "chriso0258."
I created two DB: "jobs" & "tasks".
I created 2 Form: "job-edit" & "task edit"
DB & ​​Form for "jobs" are working properly.
For cons, the "task edit" form does not work. No integration is not in the "tasks" DB. It's been two days and I check again, I also tried to change the name of the DB ... nothing seems to work.
I also purged the cache ...

I saw that "chriso0258" received a FIX for this to work. I have to maybe also needed.

Here is my error code:

Fatal error: Can not redeclare class gcore \ Models \ tasks in /home/example/domains/example.com/public_html/libraries/cegcore/libs/model.php(142): eval () 'd code on line 4

Thank you for your help.

kind regards

Gilles

Hi Gilles,

Do you have a "db save" or "db read" in the form connected to the connection ? if yes then please remove them because normally you don't need that!

Regards,
Max

You may also try installing the latest Chronoforms v5 over your and check if this helps!