I am wanting to add online payments to my existing form. The authorize.net account has been set-up and is configured in settings. What I have is a price associated with each item in a drop down list (select a class). Then I have a multiplier in another drop down (days racing) that has three choices. Two of the choices just multiply by one, the third choice multiplies by two. I THINK I have this done correctly but when I try and test it I get the following error:

SQLSTATE[HY000] [2013] Lost connection to MySQL server at 'reading initial communication packet', system error: 111

Form can be seen here:
http://www.albertabmx.com/forms/ABMXOnl … neReg.html

I haven't yet tied my processor to the authorize.net account and it is in "test" mode. Is this what the problem possibly is, or is it an issue with my form?

The form does populate a mySQL database with the entries and I'm wondering if it's related to that?

Hi Darren,
Looks like you saving to a mysql database. Does the database exist? With the form builder you create only the database. The form builder will create the proper table setup. If the database is there I would double check your database user credentials to make sure their correct and that the database has the proper permissions.

WFB will store info in a database, but (unless I have missed something) the database is just for storing the form input. It is not associated with the ecommerce capabilities of the form.

As far as MySQL is concerned. It may be your server settings. The MySQL forums had a thread where people were getting the same error and had to change their server to 'localhost.' I don't know if that's actually the issue, but it's worth a look. Here's the link to the forum:

http://forums.mysql.com/read.php?52,151 … msg-156258

Hi guys. The database is populating fine in testing and is not related to the e-commerce. This exact form worked before without the e-commerce additions. Now that I added the payments I'm getting the error.

Try disabling MySQL and try again.

Disabling MySQL definitely works, but I need that table populated with the form data. How do I make it work?

No ideas? Something to do with the submit button? Any workaround ideas? It seems to work mostly fine with all "Saving Data" methods unchecked.

However, another thing I noticed in Authorize.net TEST mode the relay response page came back to the form minus the CSS formatting. Is this designed in a way that you still have to come back to the form to click submit after payment or should the relay response just go to a confirmation page?

Hi Darren,
I think this has been happening for a while. I would think CC would fix it because the info should be able to go to the database. Scott may chime in or you could open a support topic and see if they maybe able to squeeze this into the next update. Never hurts to ask.

Eric,

You are the master of the forums, do you have any outside the box ideas? Maybe multiple forms? Perhaps the relay response page the user is sent to after the authorize.net payment is a copy of the first form that has duplicated fields but no payments attached so this time the submit button populates the database? This does run the risk of payments being made but no matching database entries if the user forgets to hit submit again, or the relay fails for whatever reason. Is this doable?

I've seen this before with some online payments where after submitting your payment you are sent back to a form that indicates your order is not complete until the submit button is clicked.

Even better, CC gets it working

I know this would require a fair amount of code hacking. I've looked at it for Paypal because that's what I use for one of my sites but ended up using Paypal buttons and an IPN to process the payment completion. Did you open a support topic?