db not saving

I have created two forms, both work fine and email correctly
- however the database saving only works for one? I can't see any conflicts but I am having trouble finding a solution and would appreciate any help

I have attached screen grabs for both forms

thanks in advance

Hi rhyswelsh,

Please drag a Debugger action into the On Submit event for the one that isn't working, then submit the form and post the debug - including the 'dummy emails' results here.

Note: if you are using the Easy Wizard you can turn on Debug on the Others tab in CFv4 or the Setup tab in CFv5.

Bob

PS I'd be inclined to rename your tables to something shorter and easier to read.

Thanks for the quick reply, I have attached
(note I have hidden email address and the website)

Data Array

Array
(
    [chronoform] => demo-basic-contact-captcha
    [event] => submit
    [format] => html
    [Itemid] => 137
    [option] => com_content
    [view] => article
    [id] => 28
    [name] => rhys w
    [email] => ...@gmail.com
    [message] => test
    [phone] => 3432423
    [captcha] => 
    [submit6] => Submit
    [ip_address] => 151.225.82.91
)

Array
(
)

Errors

Array
(
)

Debug Info

Array
(
    [1] => Array
        (
            [Email] => Array
                (
                    [0] => An email with the details below was sent successfully:
                    [1] => To:...@gmail.com
                    [2] => Subject:Website
                    [3] => From name:Website
                    [4] => From email:secretary@whitchurchcardiffgolfclub.com
                    [5] => Reply name:
                    [6] => Reply email:
                    [7] => Attachments:
                    [8] => Body:
<div class="gform-all">
<table class="gform-section">
<tbody>
<tr id="ftr-name" class="gform-line-tr">
<td id="ftd-name" class="gform-line-td"><label class="gform-label-left" for="name">Name</label>
<div id="fin-name" class="gform-input-container gform-input">rhys w</div>
</td>
</tr>
<tr id="ftr-email" class="gform-line-tr">
<td id="ftd-email" class="gform-line-td"><label class="gform-label-left" for="email">Email</label>
<div id="fin-email" class="gform-input-container gform-input">...@gmail.com</div>
</td>
</tr>
<tr id="ftr-phone" class="gform-line-tr">
<td id="ftd-phone" class="gform-line-td"><label class="gform-label-left" for="phone">Phone</label>
<div id="fin-phone" class="gform-input-container gform-input">3432423</div>
</td>
</tr>
<tr id="ftr-message" class="gform-line-tr">
<td id="ftd-message" class="gform-line-td"><label class="gform-label-left" for="message">Message</label>
<div id="fin-message" class="gform-input-container gform-input">test</div>
</td>
</tr>
<tr id="ftr23" class="gform-line-tr">
<td id="ftd22" class="gform-line-td"> </td>
</tr>
<tr id="ftr-submit6" class="gform-line-tr">
<td id="ftd-submit6" class="gform-line-td"> </td>
</tr>
</tbody>
</table>
</div>

Poster's IP address:151.225.82.91
                )

        )

    [3] => Array
        (
            [Email] => Array
                (
                    [0] => An email with the details below was sent successfully:
                    [1] => To:...@gmail.com
                    [2] => Subject:Thank you for contacting us
                    [3] => From name:Website
                    [4] => From email:...@gmail.com
                    [5] => Reply name:
                    [6] => Reply email:
                    [7] => Attachments:
                    [8] => Body:
<div class="gform-all">
<table class="gform-section">
<tbody>
<tr id="ftr-name" class="gform-line-tr">
<td id="ftd-name" class="gform-line-td"><label class="gform-label-left" for="name">Name</label>
<div id="fin-name" class="gform-input-container gform-input">rhys w</div>
</td>
</tr>
<tr id="ftr-email" class="gform-line-tr">
<td id="ftd-email" class="gform-line-td"><label class="gform-label-left" for="email">Email</label>
<div id="fin-email" class="gform-input-container gform-input">...@gmail.com</div>
</td>
</tr>
<tr id="ftr-phone" class="gform-line-tr">
<td id="ftd-phone" class="gform-line-td"><label class="gform-label-left" for="phone">Phone</label>
<div id="fin-phone" class="gform-input-container gform-input">3432423</div>
</td>
</tr>
<tr id="ftr-message" class="gform-line-tr">
<td id="ftd-message" class="gform-line-td"><label class="gform-label-left" for="message">Message</label>
<div id="fin-message" class="gform-input-container gform-input">test</div>
</td>
</tr>
<tr id="ftr23" class="gform-line-tr">
<td id="ftd22" class="gform-line-td"> </td>
</tr>
<tr id="ftr-submit6" class="gform-line-tr">
<td id="ftd-submit6" class="gform-line-td"> </td>
</tr>
</tbody>
</table>
</div>

Poster's IP address:151.225.82.91
                )

        )

)

Hi rhyswelsh,

There's no sign of a DB Save action in the Debugger output. By all means email or PM me the site URL, the form name, and a SuperAdmin login and I'll take a quick look.

Bob

Hi rhyswelsh,

I'm a bit baffled by this, I've made a copy* of the form which is now saving to the database OK, but I'm not sure what I did to make it save. One thing I tried was setting the DB Save action to Enabled No, save the form, then set it to Enabled Yes and re-save. I suggest that you try this, otherwise feel free to re-adapt the copy I made.

Bob

* I removed the Check Captcha and changed both emails to send to me - which they are doing OK.

I also installed MijoSQL to check the DB Table to see if records are being saved - they are, you should probably remove the junk and possibly remove MijoSQL as well when you are done with it.

Have you tried "Delete Cache"?