Forums

Hi Greyhead!

sorry for the holiday time message.

I am setting up a form as a petition and wanting to save the details to the database.

I have followed your youtube videos, have mijomsql and dont everything including changing every table identifier to a uniq one for the new form.

the problem is that it is just not saving the forms to mysql database. i have cleared cache, again and again, so not sure what to do.

any ideas?

Hi akaentertainment,

Please drag a Debugger action into the On Submit event, then submit the form and post the debug 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

Thanks Bob

i cant seem to get past the setting up the tables bit. it wont save the entire table/form to mysql for some reason. i have set up the form and included it all in the form and rtun the debugger... but wasnt able to assign a table to the form, as it would save my set upped (!) form to mysql.

Data Array
Array
(
    [option] => com_chronoforms5
    [chronoform] => GeorgeMichael
    [event] => submit
    [gm_name] => Rob Manser
    [gm_email] => robmanser@me.com
    [gm_gtuname] => guidetogay
    [gm_message] => testing this part
    [gm_state] => NSW
    [gm_pcode] => 2000
    [g-recaptcha-response] => 03AHJ_Vuv4uPa8g4ckUJET42kJnFyngH9s84OyQyGLfKEyiGkZiTn5727ijCZUtgwAH5LlIAYbh0qKA6buCWrhtsA-c3FIX9bc83jktqCymhe_QRJgtWVa7yuArECANgxr0SncZ3Pv4Qg7KQLVc7piv4f-UbSJLILk3bRqZExLaUfsnMSMEVvupysNDc7uf8VPPP8DFomtNqL6hYPy_W1I8lOtonVcDgbj1-U0WgJPV4nm7bXNTvmwFVPCFdi-8-WO-y4HFSydHZffsQWuLir2KGG52kjYd5A3gLWIK5mXQobiZNJ9_P6_Qx7chKWUJjdUYh75SnlkSjbnczUiNhn5blqvlpIQCn8re1i18pitvC-9OLrn1FHY4g9kn82D8NVtndI2tToNR8Ae7JOzW-i9MwaF3Xe6DaQ3KrklUt5udoCxJfVL2_afwffSbDUb3v3ydKL8tgqzXrBGf3Ke8eSdMsDY2IcWsUnJTqoeAdXkYvoJDjizG4h7D9Hh1td91qbazG-pO_4j9U3mTY3KMmO9jCPMkXYwnz_tp3m5-YBX_WXbQvFf5oiHHT0xLT14ww1PQ0gljZPK60D89k1duqdS5uyA4Ns-_Cif70Z6j9wuIPAfiHLDvlzlJqDyRfa11HKu4-qBXXSzoAs6elBIfU2EZ4g9osAzX5OAHQ2BFdE7Btm76z3nsGYUJEjuJV_BF5z4nZbwMDygN1wLz-S_mSOJq0uJvLdkiMMT-sjNop0SUE_tq1Yy-44VXTfUqf0NjvcHfYexZHr9ZSyWbVFlymjlVp3YBHTXYSW0g9PbOU4r8l_08wd9rU1F5ExOjkj6ACvRKBX-4wuPt32IIDAj_jN2-M7_wErw2ERtVPQni36l9V4qmUwZeEUltrhnK9J0JVHwSOh9cfyhmZeyOZ9ErJ82fqX1gXo8mFtJFrJmIwgBOCUXKnb-ZTDgt9Q0mNxvCPQ6e_SLz4oZ_l3KCx5_fgG8mKgauSNPROuz8A
    [button10] => Submit Signature
    [ip_address] => 1.42.194.153
)
Array
(
)
Errors
Array
(
)
Debug Info
Array
(
    [0] => Array
        (
            [Email] => Array
                (
                    [0] => An email with the details below was sent successfully:
                    [1] => To:petition@guidetogay.com
                    [2] => Subject:George Michael Petition
                    [3] => From name:Guidetogay.com
                    [4] => From email:petition@guidetogay.com
                    [5] => CC:
                    [6] => BCC:
                    [7] => Reply name:Guidetogay.com Petitions
                    [8] => Reply email:petitions@guidetogay.com
                    [9] => Attachments:
                    [10] => Array
                        (
                        )

                    [11] => Body:
<table>
<tr><td>Custom Code</td><td></td></tr>
<tr><td>Name</td><td>Rob Manser</td></tr>
<tr><td>Email Address</td><td>robmanser@me.com</td></tr>
<tr><td>Guidetogay.com Username</td><td>guidetogay</td></tr>
<tr><td>Add your own or different response here</td><td>testing this part</td></tr>
<tr><td>State/Country</td><td>NSW</td></tr>
<tr><td>Your Postcode / Zipcode</td><td>2000</td></tr>
<tr><td>Custom Code</td><td></td></tr>
<tr><td>Enter Code</td><td></td></tr>
</table><br /><br />IP: 1.42.194.153
                )

        )

)

if you need access to my site, happy to give it as my explanations are probably terrible or not in line with proper terminology?!

This is private content

Hi akaentertainment,

There is no table selected in the DB Save action - select the name of the table you created is the action settings and it should work OK.

Bob

PS You also need an Event Loop action in the pink On Fail event of the Check Google NoCaptcha action for that to work correctly.

i havnt finished that module on the actual form yet - as the "create table" system isnt working - a step back.
you know when you select the form your wanting - click on "create table" button up top and then its gives you all the table options which creates the fields in your mysql.

well the mysql isnt getting this data or creating the fields in the database.

i have tried everything.

Hi akaentertainment,

'Create Table' works OK. I've created a table, linked it to the DB Save action and saved a test record.

Bob

thanks Bob

it must be my browser or something cos i cant seem to do it. am working on chrome - do you suggest another?

cheers
Rob

Hi Rob,

Nope, I'm using Chrome too. The table is now created and working.

What exactly is the problem that you see when you try to create a table?

Bob

i set up the table as per the video tutorial, afjusting counts, key names and text field and remove button then save. it just does not save to the database for some reason.

i can the top name (using the standards in your video)

then cf_id plus character count to make sure its slightly more than the name of the table

then message field to TEXT and delete the number

then turn off button

then hit send.

Hi Rob,

Sounds OK - please take and post a screenshot of the settings just before you hit send and I'll see if I can spot anything.

Bob

Did you get this fixed? I am having the same problem, ie: when I click on the 'Save' button to create the table (and using the database tables prefix for my site) I immediately get a screen stating "Not Permitted" ...difficult to know what the cause might be, or where to go next 😟

Hi Pks,

Sounds as if it might be a server security setting, Please try setting site Error Reporting to Maximum temporarily and see if you get a more helpful message. You might also check the server logs.

Bob

Fixed ...by my host company techies.
In case the info is useful for anyone else getting similar problems:-

The error was being caused by a mod_security rule in the server which was interrupting and thus causing the "Not Permitted" error. They had to whitelist the rule for the website in order to fix the issue.

Thanks for the pointer ...and a really useful component.