close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Checkout errors

Thread began 4/17/2013 3:13 pm by Linda | Last modified 5/09/2013 9:23 am by Linda | 2864 views | 46 replies |

Linda

Checkout errors

after entering the customer information and selecting checkout I get the following error:


Warning: mysql_pconnect() [function.mysql-pconnect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/30/10773130/html/Connections/MySQL_Spooky.php on line 9

Fatal error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/30/10773130/html/Connections/MySQL_Spooky.php on line 9

it seems like it is pointing to the wrong connection, i.e. my local host not my web host. But I am not sure which file is making the call.

My shipping charges are all messed up too. Checkout wizard wont let me change them.

Sign in to reply to this post

Jason ByrnesWebAssist

you need to edit the Connections/MySQL_Spooky.php file with the correct details to connect to the remote mysql server.

Sign in to reply to this post

Linda

wizard checkout

instead of altering that file. There is a correct SQL file that it should be pointing too. not sure why it is pointing this one but couldn't I change the link in the calling program? If so, what file is it?

Sign in to reply to this post

Jason ByrnesWebAssist

no, you should not change the link to the connection file, that will change the names of the variables being created for the connection and cause the code to break.

you should edit the connection file that is being used to connect to the Remote MySQL Server.

Sign in to reply to this post

Linda

Checkout errors

ok, I renamed the correct connection file to the one it was looking for and now I get UspsCom::DoAuth. I looked at the other forums on this error. I have the production site for USPS and access.
(http://production.shippingapis.com/shippingai.dll)

I don't get an error code or anything further just the above?? what now?

Sign in to reply to this post

Jason ByrnesWebAssist

On the bindings panel, expand the binding group for USPS and add the Full Request and Full Response bindings to the failure page. Post back a link to the site once those bindings are in place so i can test the transaction to see the request and response details.

Sign in to reply to this post

Linda

ok I think I got it.

This is the error I got:
UspsCom::DoAuth API=RateV4&XML=PARCEL7911010REGULARTrue 80040b1a Authorization failure. Perhaps username and/or password is incorrect. UspsCom::DoAuth

One thing that has always bothered me is that the checkout wizard never asked for a password, I do enter the username they sent me but...

Sign in to reply to this post

Jason ByrnesWebAssist

Only a User ID is required for the USPS Rate Lookup service. Double check that you have the correct User ID entered in the USPS Server behavior on the confirm page, if you have the correct user id entered, you should contact USPS support to determine why the rate lookup server is rejecting your request.

Sign in to reply to this post

Linda

getting closer

Sign in to reply to this post

Jason ByrnesWebAssist

Re running the checkout wizard will only duplicate code.

If you need to re run the checkout wizard, you should delete the existing checkout pages first, in your pages i see 5 instances of the shipping behavior.

delete the existing checkout pages, the run the checkout wizard again to recreate fresh versions.

if you need to make changes after running the checkout wizard, you should edit the server behaviors on the pages rather than re running the wizard.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...