can not save to database .

Hello
I have problem when I use the db save. I can not be saved in database after submit the form. Create table already，and set the this new table in DB save also.

when I select the Force save - Yes, the data can be recorded, But the only record one , the column ID is 232, when I changed this ID then can continue to record new data (new ID also is 232),

anyone can help？

thank you！

Hello guang125,
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 guang125,

Please see this FAQ

Bob

Hello,


I created form using custome code. I have given all the event actions as required. That is on load i have given render html form event and then on submit i have given db_save, email_notify and thanks message event. But when i test the form after filling all the fields for Contact Us form and press submit button, nothing gets saved. And also no thanks message is getting displayed. I have created the db with the default name guven. Pl help.

http://www.safehandindia.com/orgch/feedbackform.html is the form link.


Thanks,
Pooja

Hi poojah12,

You have the Form Method set to Get in the HTML (Render form) action, please set that back to Post. Then please test the form using the View Form link from the Forms Manager and see if is submits correctly from there.

Bob

Hi,


I did the changes you told. And now its saving in the database. Thank you🙂

But i am not getting the notification via mail. Can you please check and tell what i am missing?

Thanks in advance,
Pooja

Hi poojah12,

This can happen if the From Email address is 'wrong'. Please drag a Debugger action into the On Submit event, then submit the form and post the debug - including the 'dummy emails' results here.

Bob

Hi,

I have tested the form with the debugger. Attaching the error screenshots. Please advice.

Thanks,
Pooja

Hi poojah12,

I see you have a different error message now.

Please check the SMTP settings. Are you using the Joomla! settings or have you set custom settings in ChronoForms?

Please also change the From email address to match the domain name.

Bob

PS Next time, please just copy and paste the Debugger output - it's easier to do and to read than a batch of screenshots.

Hello,

I am used custom html for creating the form. i tested with SMTP, send mail and php mailer as well. I get error in all the three cases. Right now its set to php mailer. Following is the error

Mailer Error: Could not instantiate mail function.
Thank you for contacting us!
[code]Data Array
Array
(
[option] => com_chronoforms5
[chronoform] => ContactUs
[event] => submit
[title] => Mr.
[firstname] => pooja
[lastname] => jjj
[email] => pooja.jojo12@gmail.com
[position] => jii

 => 00
    [phone] => 878789
    [company] => kjjoj
    [companysize] => 3-1000to5000
    [industry] => REAL_ESTATE
    [services] => Quality & TQM
    [Otherneed] => 
    [additionalinfo] => joj
    [howdidyouhear] => Trade/Print_Publications
    [contactus] => Contact Us
    [id] => 7
    [ip_address] => 86.97.37.66
)
Array
(
)
Errors
Array
(
)
Debug Info
Array
(
    [1] => Array
        (
            [DB Save] => Array
                (
                    [Queries] => Array
                        (
                            [0] => INSERT INTO `qc9wd_ContactUs_db` (`title`, `firstname`, `lastname`, `email`, `position`, `code`, `phone`, `company`, `companysize`, `industry`, `services`, `Otherneed`, `additionalinfo`, `howdidyouhear`, `user_id`, `uniq_id`, `created`) values ('Mr.', 'pooja', 'jjj', 'pooja.jojo12@gmail.com', 'jii', '00', '878789', 'kjjoj', '3-1000to5000', 'REAL_ESTATE', 'Quality & TQM', '', 'joj', 'Trade/Print_Publications', '0', 'adfb70b03d95d22c4fa97f90ac56820adefb6b92', '2015-07-07 13:20:55');
                        )

                )

        )

    [2] => Array
        (
            [Email] => Array
                (
                    [0] => An email with the details below could NOT be sent:
                    [1] => To:pooja.jojo12@gmail.com
                    [2] => Subject:contact Us form
                    [3] => From name:Organized feedback form
                    [4] => From email:contact@orgch.com
                    [5] => CC:
                    [6] => BCC:
                    [7] => Reply name:
                    [8] => Reply email:
                    [9] => Attachments:
                    [10] => Array
                        (
                        )

                    [11] => Body:
<div class="form-group gcore-form-row" id="form-row-title"><label for="title" class="control-label gcore-label-left">Title</label>
<div class="gcore-input gcore-display-table" id="fin-title">Mr.</div></div><div class="form-group gcore-form-row" id="form-row-firstname"><label for="firstname" class="control-label gcore-label-left">First Name</label>
<div class="gcore-input gcore-display-table" id="fin-firstname">pooja</div></div><div class="form-group gcore-form-row" id="form-row-lastname"><label for="lastname" class="control-label gcore-label-left">Last Name</label>
<div class="gcore-input gcore-display-table" id="fin-lastname">jjj</div></div><div class="form-group gcore-form-row" id="form-row-email"><label for="email" class="control-label gcore-label-left">Email</label>
<div class="gcore-input gcore-display-table" id="fin-email">pooja.jojo12@gmail.com</div></div><div class="form-group gcore-form-row" id="form-row-position"><label for="position" class="control-label gcore-label-left">Position</label>
<div class="gcore-input gcore-display-table" id="fin-position">jii</div></div><div class="form-group gcore-form-row" id="form-row-multi-6"><div class="gcore-subinput-container" id="fitem-code"><label for="code" class="control-label gcore-label-left">Telephone    <font size="1">Country code</font></label>
<div class="gcore-input pull-left gcore-sub-input gcore-display-table" id="fin-code">00</div></div>
<div class="gcore-subinput-container" id="fitem-phone"><div class="gcore-input pull-left gcore-sub-input gcore-display-table" id="fin-phone">878789</div><font size="1">Example 123-456-7890</font></div></div></br>
<div class="form-group gcore-form-row" id="form-row-company"><label for="company" class="control-label gcore-label-left">Company</label>
<div class="gcore-input gcore-display-table" id="fin-company">kjjoj</div></div>
<div class="form-group gcore-form-row" id="form-row-companysize"><label for="companysize" class="control-label gcore-label-left">Company Size</label>
<div class="gcore-input gcore-display-table" id="fin-companysize">3-1000to5000</div></div><div class="form-group gcore-form-row" id="form-row-industry"><label for="industry" class="control-label gcore-label-left">Industry</label>
<div class="gcore-input gcore-display-table" id="fin-industry">REAL_ESTATE</div></div><div class="form-group gcore-form-row" id="form-row-services"></br>
<div class="gcore-input gcore-display-table" id="fin-services"><div class="gcore-single-column" id="fclmn"><div class="gcore-checkbox-item" id="fitem">Quality & TQM
</div>
<div class="gcore-checkbox-item" id="fitem1">
</div>
<div class="gcore-checkbox-item" id="fitem2">
</div>
<div class="gcore-checkbox-item" id="fitem3">
</div>
<div class="gcore-checkbox-item" id="fitem4">
</div>
<div class="gcore-checkbox-item" id="fitem5">
</div>
<div class="gcore-checkbox-item" id="fitem6">
</div>
<div class="gcore-checkbox-item" id="fitem7">
</div>
<div class="gcore-checkbox-item" id="fitem8">
</div>
<div class="gcore-checkbox-item" id="fitem9">
</div></div></div></div><div class="form-group gcore-form-row" id="form-row-additionalinfo"><label for="additionalinfo" class="control-label gcore-label-left">Please provide any additional information describing your current organization:</label>
<div class="gcore-input gcore-display-table" id="fin-additionalinfo">joj</div></div><div class="form-group gcore-form-row" id="form-row-howdidyouhear"><div class="gcore-input gcore-display-table" id="fin-howdidyouhear">Trade/Print_Publications</div></div><div class="form-group gcore-form-row" id="form-row-contactus"><div class="gcore-input gcore-display-table" id="fin-contactus"></div></div><br /><br />IP: 86.97.37.66
                )

        )

)

Please have a look.

Thanks,
Pooja

Hi poojah12,

Please remove any settings that you have in the ChronoForms Settings | Emails tab. That will make ChronoForms use the Joomla! mailer.

Please check with your web host on the correct settings to use to configure the mailer for Joomla!

Bob

So you mean to say mailer will not work in case of Custom HTML design?

Thanks,
Pooja

Hi Pooja,

I did not say that,

Bob

Mailer Error: Could not instantiate mail function.

Please ask your hosting support why would you receive this error when you send an email!

Regards,
Max

I figured out my mistake. I gave the wrong 'from' email id.

Thanks so much for your immediate responses so far.

Thanks,
Pooja