Forums

Saves to Database only first time

bahakh 23 Jan, 2016
I have been using ChronoForms for long time, I never had this issue.

I have a page with two forms, sending an email and saving to database (See attached screenshot).

When I test, it creates the first record, and I display in Chronoconnectivity as well. If you go back to that page and try to submit another entry, it sends the email, and shows the message but doesn't save in Database. If I go to database and delete the record it works for one entry again.

I tried the following:
1. Turned "Force Save" on
2. Turned "Save under Model ID" on
3. I deleted the forms and tables and created them again.
4. I disabled second form on the page

Nothing solved this issue. Please help
GreyHead 24 Jan, 2016
Hi bahakh,

Please drag a Debugger action into the On Submit event, then submit the form and post the debug results here. That should work if you are using the form alone to create a new record.

Bob
bahakh 25 Jan, 2016
Data Array
Array
(
    [chronoform] => kairosdocument
    [event] => submit
    [Itemid] => 158
    [option] => com_content
    [view] => article
    [id] => 50
    [docFullName] => John Smith
    [docEmail] => bahakh@gmail.com
    [docCountry] => United States
    [docSupporter] => International
    [docGetPublic] => 1
    [docStayInformed] => 1
    [docSubmit] => Submit
    [displaypledges] => 
    [ccname] => displaypledges
    [fltr] => Array
        (
        )

    [Chronoconnectivity] => Array
        (
        )

)
Array
(
)

Errors
Array
(
)

Debug Info
Array
(
)
bahakh 25 Jan, 2016
The previous one is when the Debugger was the first action on Submit, and the following is when it was last:
Data Array
Array
(
    [chronoform] => kairosdocument
    [event] => submit
    [Itemid] => 158
    [option] => com_content
    [view] => article
    [id] => 50
    [docFullName] => Mary Smith
    [docEmail] => bahakh@gmail.com
    [docCountry] => United States
    [docSupporter] => Local
    [docGetPublic] => 1
    [docStayInformed] => 1
    [docSubmit] => Submit
    [displaypledges] => 
    [ccname] => displaypledges
    [fltr] => Array
        (
        )

    [Chronoconnectivity] => Array
        (
        )

    [ip_address] => 217.66.231.198
)
Array
(
)
Errors
Array
(
)
Debug Info
Array
(
    [1] => Array
        (
            [DB Save] => Array
                (
                    [Queries] => Array
                        (
                        )

                )

        )

    [2] => Array
        (
            [Email] => Array
                (
                    [0] => An email with the details below was sent successfully:
                    [1] => To:bahakh@gmail.com
                    [2] => Subject:Kairos Document
                    [3] => From name:Kairos Palestine
                    [4] => From email:advocacy@kairospalestine.ps
                    [5] => CC:
                    [6] => BCC:
                    [7] => Reply name:
                    [8] => Reply email:
                    [9] => Attachments:
                    [10] => Array
                        (
                        )

                    [11] => Body:
<table>
<tr><td>Full Name</td><td>Mary Smith</td></tr>
<tr><td>Email</td><td>bahakh@gmail.com</td></tr>
<tr><td>Country</td><td>United States</td></tr>
<tr><td>Supporter</td><td>Local</td></tr>
<tr><td>Get Public</td><td>1</td></tr>
<tr><td>Stay Informed</td><td>1</td></tr>
</table><br /><br />IP: 217.66.231.198
                )

        )

)
GreyHead 25 Jan, 2016
Hi bahakh,

As you can see the DB Save query is empty :-(

Im not clear where the ChronoConnectivity entry is coming from - are you calling the form from a CC 'edit ' link?

Bob
bahakh 25 Jan, 2016
Can I send you a private message with all the details ?
bahakh 26 Jan, 2016
I sent you a PM with some details, but basically, I think you need to look at the last debugger info, but what I have at the page are 3 Items, 2 Forms, and 1 ChronoConnectivity module to display the data that is saved from the first form where I have the debugger on.

In the PM I gave you the link if you can have a look at it. Please help as my client is getting hard on me about this.
GreyHead 26 Jan, 2016
Answer
1 Likes
Hi bahakh,

Please see this FAQ - I think that the problem - or a part of it - may be the article id that is being set.

Also please check that the Model ID is not set in the DB Save as your form data is not using one.

Bob
bahakh 26 Jan, 2016
Thanks Bob, the ID is what was causing the issue. I really appreciate your help.
This topic is locked and no more replies can be posted.