Connectivity edit with Chronoforms

Hi,

This tutorial is not working. I followed this one step by step to understand what's happened.

https://www.chronoengine.com/faqs/72-ccv5/5208-connectivity-edit-with-chronoforms.html

Field Name : Article[title]
Filed ID : title
Field Name : Article[state]
Filed ID : state
Field Name : Article[hits]
Filed ID : Visits
Field Name : Article[id] --> this one is a hidden field
Filed ID : id

I created the MySQL table from Chronoform.

I gave all the permission in CCv5.

I got this message as showed in the first screenshot joined.
A second screenshot, listing of all "id"s from phpadmin.

I saw that someone said this tutorial "works". Could those users complete this tutorial for other users. I think that it missed some steps or precisions. It will be a good help for the community.

Bertrand

Hello bcouvin,
I'm not a Chrono professional, but after checking your new post, I think that the following links may help:
Connectivity edit with Chronoforms
P.S: I'm just an automated service😉

Hi,
I just came back to the basic. May be the error is there...

Instead of calling connectivity action, I made a db save, with store option to Model ID as "Article". In this use case, I don't use at all Chronoconnectivity.

Add in Submit action, the debugger before db save and after a db save.

Here are the results, before db save:

Data Array
Array
(
    [option] => com_chronoforms5
    [chronoform] => Article
    [event] => submit
    [Article] => Array
        (
            [title] => qwe
            [state] => 1
            [hits] => 123
            [id] => 
        )

    [button5] => Submit
)
Array
(
)
Errors
Array
(
)
Debug Info
Array
(
)

After db save:

Data Array
Array
(
    [option] => com_chronoforms5
    [chronoform] => Article
    [event] => submit
    [Article] => Array
        (
            [title] => qwe
            [state] => 1
            [hits] => 123
            [id] => 
            [Article[id]] => 1
        )

    [button5] => Submit
)
Array
(
)
Errors
Array
(
)
Debug Info
Array
(
    [4] => Array
        (
            [DB Save] => Array
                (
                    [Queries] => Array
                        (
                            [0] => INSERT INTO `kxeq8_chronoengine_chronoforms_datatable_Article` (`user_id`, `uniq_id`, `created`) values ('87', '772c523b915de306f88d069ae1d4b349d5ee7ed8', '2015-11-12 11:14:31');
                        )

                )

        )

)

It does not write at all in the table, when using Model ID.
An idea?

Bertrand

Any news?

Bertrand

Hello all,

Could someone give me a help?
Thanks a lot.

Bertrand

Hi Bertrand,

There's a problem in this part of your data

    [Article] => Array
        (
            [title] => qwe
            [state] => 1
            [hits] => 123
            [id] => 
            [Article[id]] => 1

You'll see that Article.id has no value but Article.Article[id] has - but of course that is not a valid MySQL column name.

I can't see from the data here why the id is in Article.Article[id] though :-(

Bob

Hi Bob,

Thank you for your support.
I saw also that this is a problem. The DB save action added "Article[id]" instead of using "id" .
It is unfortunate that it is an issue, because I really need my form working with different Model IDs.
If someone made this basic use case working, I will really appreciate to know why this use case didnt work for me.

Bertrand

Hi,

When do you get the Connectivity error exactly ?

the [Article[id]] added after the "db save" should not bother you, where do you use that ?

Regards,
Max

Hello Max,

Thank you for taking care of this.

As I got a error message with the use case "Connectivity edit with Chronoforms" (please refer to the first Screenshot showing the error message with this use case with CCv5 --> Error on Article[id]), I came back to the basic in the objective to understand and to track what's happened.

My basic scenario is to disconnect CCv5 and replace CCv5 by a DB save --> Usage of Model ID with DB save, with the same name defined in "Connectivity edit with Chronoforms". I added Debugger before and after DBsave in the Submit action.
In the second screenshot here joined, there is nothing written in MySQL table. This result is normal compare to what debugger gave as information. I got the same error "Error on Article[id]" as with CCv5.

I would like to know if the "Usage of Model ID with DB save" is working?

Bertrand

Hello Bob and Max,

Do you have some news on that?

Bertrand