Forms DB not working and emails not working

Hello!

I have 5 forms setup on my new site, I have setup Chronoforms dozens of times with no problems. I have table created for each form and enabled then selected DB table in setup of each form. I have my email enabled and set to email me at my gmail account.

askITquestion on home page - adds record to DB but doesn't sent email
website form http://www.sesi-va.com/index.php/services/web-services - doesn't add to DB table nor send email
hosting form http://www.sesi-va.com/index.php/services/managed-hosting - doesn't add to DB table nor send email
repair form http://www.sesi-va.com/index.php/services/repair-installation-services - doesn't add to DB table nor send email
meetus form http://www.sesi-va.com/index.php/contact - adds record to DB but doesn't sent email

The first 4 forms are in module positions sidebar-a, sidebar-a, sidebar-a, sidebar-b respectfully, and the last is inserted int a article using plugin code.

Tried using the debug tool. it came back with an error that said "array( )"

Not sure what else to try...Please advise.

Thanks!
Amanda

Hi Amanda,

Do the forms work correctly if you use the View Form link or Test Form icon from the Forms Manager?

If they do, please try setting Relative URL to No in the HTML (Render Form) action.

I suspect that the forms where the DB Save runs but the email isn't sent may have a second problem too.

Bob

YES!😀 I can now see all entries in the databases created for each form. Still no email.

If they do, please try setting Relative URL to No in the HTML (Render Form) action.

^^^^^^I couldn't find this setting. Where can I find the HTML Action ? Using the Simple Form feature

Thoughts on the second problem at play here

Many thanks
Amanda

Can only see in DB when testing form still no dice for the forms on the website itself. Just to clarify my excitement.

Hi Amanda,

Switch to the Non-Simple wizard and you'll see the HTML (Render form) action on the Setup tab.

Bob

Great! Now the DB is populating but I am still not getting emails...could something be wrong with hosting server??

Hi Amanda,

Please drag a Debugger action into the On Submit event, 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

I didn't get an email, below is the results in browser from debugger.

Data Array

Array
(
    [chronoform] => askaITquestion
    [event] => submit
    [option] => com_chronoforms5
    [Itemid] => 
    [name] => Amanda Jackson
    [email] => jacksonak@sesi-va.com
    [question] => DEBUGGER TESTING
    [captcha] => 
    [submit] => Submit
    [id] => 6
    [ip_address] => 98.166.128.86
)

Array
(
)

Errors

Array
(
)

Debug Info

Array
(
    [11] => Array
        (
            [DB Save] => Array
                (
                    [Queries] => Array
                        (
                            [0] => INSERT INTO `gn3po_chronoengine_chronoforms_datatable_askaITquestion` (`name`, `email`, `question`, `user_id`, `created`) values ('Amanda Jackson', 'jacksonak@sesi-va.com', 'DEBUGGER TESTING', '0', '2014-09-09 17:02:42');
                        )

                )

        )

    [0] => Array
        (
            [Email] => Array
                (
                    [0] => An email with the details below was sent successfully:
                    [1] => To:oysterchic@gmail.com
                    [2] => Subject:
                    [3] => From name:
                    [4] => From email:
                    [5] => CC:
                    [6] => BCC:
                    [7] => Reply name:
                    [8] => Reply email:
                    [9] => Attachments:
                    [10] => Body:
<table>
<tr><td>A</td><td></td></tr>
<tr><td>Name</td><td>Amanda Jackson</td></tr>
<tr><td>Email</td><td>jacksonak@sesi-va.com</td></tr>
<tr><td>Question?</td><td>DEBUGGER TESTING</td></tr>
</table><br /><br />IP: 98.166.128.86
                )

        )

    [1] => Array
        (
            [Email] => Array
                (
                    [0] => An email with the details below was sent successfully:
                    [1] => To:oysterchic@gmail.com
                    [2] => Subject:Ask IT Question Web Form
                    [3] => From name:
                    [4] => From email:
                    [5] => CC:
                    [6] => BCC:
                    [7] => Reply name:
                    [8] => Reply email:
                    [9] => Attachments:
                    [10] => Body:
<table>
<tr><td>A</td><td></td></tr>
<tr><td>Name</td><td>Amanda Jackson</td></tr>
<tr><td>Email</td><td>jacksonak@sesi-va.com</td></tr>
<tr><td>Question?</td><td>DEBUGGER TESTING</td></tr>
</table><br /><br />IP: 98.166.128.86
                )

        )

)

HI Amanda,

Please set the From Email and From Name in the Email action. For the From Email use an address that matches the site domain e.g. info@my_domain.com

Bob

This is what I have had it at, from info@sesi-va.com and going to my gmail account oysterchic@gmail.com
Just for clarification,you want me to have them both be the same?
[attachment=0]email.png[/attachment]

Made both from and to email the same. Still no email and below is the debugger code.

Data Array

Array
(
    [chronoform] => askaITquestion
    [event] => submit
    [option] => com_chronoforms5
    [Itemid] => 
    [name] => Amanda Jackson
    [email] => oysterchic@gmail.com
    [question] => DEBUGGER TESTING
    [captcha] => 
    [submit] => Submit
    [id] => 8
    [ip_address] => 98.166.128.86
)

Array
(
)

Errors

Array
(
)

Debug Info

Array
(
    [11] => Array
        (
            [DB Save] => Array
                (
                    [Queries] => Array
                        (
                            [0] => INSERT INTO `gn3po_chronoengine_chronoforms_datatable_askaITquestion` (`name`, `email`, `question`, `user_id`, `created`) values ('Amanda Jackson', 'oysterchic@gmail.com', 'DEBUGGER TESTING', '0', '2014-09-09 18:03:48');
                        )

                )

        )

    [0] => Array
        (
            [Email] => Array
                (
                    [0] => An email with the details below was sent successfully:
                    [1] => To:oysterchic@gmail.com
                    [2] => Subject:
                    [3] => From name:
                    [4] => From email:
                    [5] => CC:
                    [6] => BCC:
                    [7] => Reply name:
                    [8] => Reply email:
                    [9] => Attachments:
                    [10] => Body:
<table>
<tr><td>A</td><td></td></tr>
<tr><td>Name</td><td>Amanda Jackson</td></tr>
<tr><td>Email</td><td>oysterchic@gmail.com</td></tr>
<tr><td>Question?</td><td>DEBUGGER TESTING</td></tr>
</table><br /><br />IP: 98.166.128.86
                )

        )

    [1] => Array
        (
            [Email] => Array
                (
                    [0] => An email with the details below was sent successfully:
                    [1] => To:info@sesi-va.com
                    [2] => Subject:Ask IT Question Web Form
                    [3] => From name:
                    [4] => From email:
                    [5] => CC:
                    [6] => BCC:
                    [7] => Reply name:
                    [8] => Reply email:
                    [9] => Attachments:
                    [10] => Body:
<table>
<tr><td>A</td><td></td></tr>
<tr><td>Name</td><td>Amanda Jackson</td></tr>
<tr><td>Email</td><td>oysterchic@gmail.com</td></tr>
<tr><td>Question?</td><td>DEBUGGER TESTING</td></tr>
</table><br /><br />IP: 98.166.128.86
                )

        )

)

Hi Amanda,

Please check the Debug output the From Email is still empty :-(

                    [2] => Subject:Ask IT Question Web Form
                    [3] => From name:
                    [4] => From email:

Do not use the same From and To email addresses - GMail will automatically drop emails where they are the same.

Bob

I have done as asked and still doesn't work. I am thinking its server???

Data Array

Array
(
    [chronoform] => askaITquestion
    [event] => submit
    [option] => com_chronoforms5
    [Itemid] => 
    [name] => Amanda Jackson
    [email] => jacksonak@sesi-va.com
    [question] => TEST
    [captcha] => 
    [submit] => Submit
    [id] => 9
    [ip_address] => 98.166.128.86
)

Array
(
)

Errors

Array
(
)

Debug Info

Array
(
    [11] => Array
        (
            [DB Save] => Array
                (
                    [Queries] => Array
                        (
                            [0] => INSERT INTO `gn3po_chronoengine_chronoforms_datatable_askaITquestion` (`name`, `email`, `question`, `user_id`, `created`) values ('Amanda Jackson', 'jacksonak@sesi-va.com', 'TEST', '0', '2014-09-11 15:54:46');
                        )

                )

        )

    [0] => Array
        (
            [Email] => Array
                (
                    [0] => An email with the details below was sent successfully:
                    [1] => To:oysterchic@gmail.com
                    [2] => Subject:
                    [3] => From name:
                    [4] => From email:
                    [5] => CC:
                    [6] => BCC:
                    [7] => Reply name:
                    [8] => Reply email:
                    [9] => Attachments:
                    [10] => Body:
<table>
<tr><td>A</td><td></td></tr>
<tr><td>Name</td><td>Amanda Jackson</td></tr>
<tr><td>Email</td><td>jacksonak@sesi-va.com</td></tr>
<tr><td>Question?</td><td>TEST</td></tr>
</table><br /><br />IP: 98.166.128.86
                )

        )

    [1] => Array
        (
            [Email] => Array
                (
                    [0] => An email with the details below was sent successfully:
                    [1] => To:oysterchic@gmail.com
                    [2] => Subject:Ask IT Question Web Form
                    [3] => From name:webmaster
                    [4] => From email:info@sesi-va.com
                    [5] => CC:
                    [6] => BCC:
                    [7] => Reply name:
                    [8] => Reply email:
                    [9] => Attachments:
                    [10] => Body:
<table>
<tr><td>A</td><td></td></tr>
<tr><td>Name</td><td>Amanda Jackson</td></tr>
<tr><td>Email</td><td>jacksonak@sesi-va.com</td></tr>
<tr><td>Question?</td><td>TEST</td></tr>
</table><br /><br />IP: 98.166.128.86
                )

        )

)

Hi Amanda,

Possibly it's a server problem. I'm not quite sure how that works in CFv5. In most cases it seems to work fine with the default settings but I have seen Max post that if you are using SMTP on the site then you may need to add the SMTP settings in the ChronoForms Settings page.

Bob

We use PHP Mail not SMTP...I may switch one of the form to ChronoForms V4 just to see if i can get that to work. I have another site with a form that works using ChronoForms V4 but it is on a different server.

If you can think of anything else that would help, I would appreciate. I will post my results from switching.

thanks

Hi Amanda,

You can install CFv4 alongside CFv5 - all you need to test is a minimum form: a Submit button, a Show HTML action in the On Load event and Email and Debugger actions in the On Submit event.

Bob