Save to Database Problem

Hi!
I have a form in an article that is not saving to database.
When I try the form through the "View Form" it saves.

Here is the debugger info:

Data Array

Array
(
    [chronoform] => bformadores
    [event] => submit
    [Itemid] => 309
    [option] => com_content
    [view] => article
    [id] => 52
    [Nome] => José Silva
    [Telemovel] => 111 111 111
    [Email] => email@email.com
    [Distrito] => sssss
    [Concelho] => ssssss
    [Habilitacoes] => ssssss
    [FormAcadem] => teste
    [CCP] => Sim
    [AreasForm] => 090,146
    [TemasFormacao] => ddedd
    [Newsletter] => Sim
    [captcha] => 
    [Enviar] => Enviar
    [bformadores] => 
    [Curriculum] => 20140716154933_file.pdf
    [subject-bformadores] => Sarrazola, 090,146, teste BF14
    [ip_address] => 
)

Array
(
    [Curriculum] => Array
        (
            [name] => 20140716154933_file.pdf
            [original_name] => file.pdf
            [path] => /home/site/public_html/components/com_chronoforms5/chronoforms/uploads/bformadores/20140716154933_file.pdf
            [size] => 120995
            [link] => /home/site/public_html/components/com_chronoforms5/chronoforms/uploads/bformadores/20140716154933_file.pdf
        )

)

Errors

Array
(
)

Debug Info

Array
(
    [9] => Array
        (
            [Files Upload] => Array
                (
                    [0] => Upload routine started for file upload by : Curriculum
                    [1] => /home/site/public_html/components/com_chronoforms5/chronoforms/uploads/bformadores/20140716154933_file.pdf has been uploaded successfully.
                )

        )

    [16] => Array
        (
            [Email] => Array
                (
                    [0] => An email with the details below was sent successfully:
                    [1] => To:
                    [2] => Subject:Sarrazola, 090,146, teste BF14
                    [3] => From name:
                    [4] => From email:
                    [5] => CC:
                    [6] => BCC:
                    [7] => Reply name:
                    [8] => Reply email:
                    [9] => Attachments:/home/site/public_html/components/com_chronoforms5/chronoforms/uploads/bformadores/20140716154933_file.pdf
                    [10] => Body:


                )

        )

    [0] => Array
        (
            [Email] => Array
                (
                    [0] => An email with the details below was sent successfully:
                    [1] => To:email@email.com
                    [2] => Subject:
                    [3] => From name:
                    [4] => From email:
                    [5] => CC:
                    [6] => BCC:
                    [7] => Reply name:
                    [8] => Reply email:
                    [9] => Attachments:
                    [10] => Body:
<p>O seu registo na <strong>Bolsa de Formadores</strong></p>
                )

        )

    [11] => Array
        (
            [DB Save] => Array
                (
                    [Queries] => Array
                        (
                            [0] => UPDATE `_jos_chronoengine_chronoforms_datatable_bformadores` AS `DATA` SET `Nome` = 'José Silva', `Telemovel` = '111 111 111', `Email` = 'email@email.com', `Distrito` = 'Sarrazola', `Concelho` = 'Frossos', `Habilitacoes` = 'Bacharelato', `FormAcadem` = 'teste', `CCP` = 'Sim', `AreasForm` = '090,146', `TemasFormacao` = 'ddedd', `Newsletter` = 'Sim', `Curriculum` = '20140716154933_file.pdf', `user_id` = '0', `modified` = '2014-07-16 15:49:33' WHERE `id` = '52';
                        )

                )

        )

)

Also, other than the database and the email sent to the form owner, how can I check the submissions made to the form?.


Thank You!

Hello Vizinho,
I'm not a Chrono professional, but after checking your new post, I think that the following links may help:
How do I save form data to a database table?
P.S: I'm just an automated service😉

Hi Vizinho,

I think that the problem is the article id in the page URL. Please check the form using the View or Test Form links from the Forms Manager. If that works then you need either to change the column name from id to say cf_id or to unset the id value before the form save. The code to do that has been posted here a couple of times recently.

Bob

Bob, Hi
and thank you for the reply.

I am sorry for not coming back to you before. (I thought the forum would send me a message when someone replied to the topic and as I did not receive none I thought there was no answer...!)

Back to the topic, I seen some answers pointing to the ID problem. I had changed it to cf_id prior to my post and that did not return results as well.
After more (and a bit more to be honest!) investigation I found in the site a FAQ referring some possible problems with SEF and relative URL. (FAQ: http://www.chronoengine.com/faqs/2571-how-do-i-show-a-form-in-an-article.html). The fact is that I changed the thing to 'No' and all started to work.

I'll leave this info for others than can be facing the same.

Cheers!

This sorted my problem out too!

The DB Save seemed to be doing nothing at all, then following the guide posted by Vizinho fixed it right away, been pulling my hair out and cursing for the last 3 days whilst following the guides and videos with no success!!

Hi,

I think that what is happening is that when the Relative URL is set to Yes, the article ID gets included in the URL. Then one of the things happens, either the form doesn't Submit at all; or the article Id is used and the wrong record is updated :-(

Bob