PAC

Definitely not offended. I'm more of a designer and front end developer and I've just now gotten to the point where I'm comfortable enough with those skills to start learning some server side languages. I appreciate the straight forward answer. We have a VPS through HostGator. I haven't had the need to install any tools that were not already provided, so I will definitely check and see if that is permitted. I will also check on the Service Level Agreement. I will try XAMP stack to see if the problem persists. I've experimented with it before, so I'm not totally unfamiliar with it. Thanks for your insights. Now that I know its more of a server issue and not a CubeCart issue, I have a better idea of what to do to solve this issue.

Yes, it happens when I make test purchases and with customer purchases. I thought about the payment processor. We are using Authorize.net. I contacted them to see if there may be anything on their end that may be causing slow processing times, but they were not aware of anything. I'm leaning towards the option that it may be something with the database, but I'm not sure if it is the database itself or something with the PHP code accessing the database. I'm not proficient with MySQL (outside of setting up a database and running the tools provided by the host) or PHP, so please excuse my ignorance. I did run the database check and repair tools, but neither returned any errors.

A couple weeks ago, I posted an issue i was having with customers getting MySQL errors upon checkout. After upgrading MySQL, I was still getting the same issue. I was directed to contact my hosting provider about this error. Apparently, MySQL was timing out before the checkout finished processing. They increased the time before MySQL would time out and that fixed the error, but now it is taking about 45 seconds or so after a customer places an order to process that order and go to the "Thank You" page. This is something that seems to have randomly started happening. Every other page loads quickly. I'm not sure exactly how to tell what is causing the slow processing time in this situation. Has anyone else experienced the same issue or possibly be able to shed some light on this issue? Thanks in advance.

Thanks! I really appreciate your time and help in getting this matter resolved.

I tried a different browser and was able to get in to the admin dashboard. It looks like there is a cookie or something in my Firefox browser that is keeping me from getting in, even though I have cleared the cookies and cache. I will try some other things and see if I can get it to let me in. Got it to let me in. I rebooted my computer and then cleared the cookies and cache again and it let me in. Everything appears to be working as it should.

I tried that and received a Page Not Found. I checked the files on the server to see if there was a similar page somewhere else. I found admin/sources/logout.inc.php. I tried that, but received an Internal Server Error. I also tried clearing browser cookies and cache.

I have installed the latest version of CC4. Everything seems to be working fine on the user end. However, I am unable to login to the admin dashboard. I have tried the old credentials and requested a new password and neither seem to be accepted.

I see. I made a backup of the store and database before upgrading MySQL. We do have a third-party coupon code mod purchased from Expanding Brain (Estelle's Mod Store). We have also made edits to the USPS plugin, which you helped me with about a month or so ago.

Thank you for the link. I did that and the errors went away. I am also able to get back to my dashboard. From what i understand, this isn't a permanent fix to the problem, just a work around to get rid of the errors. Should I proceed with attempting an upgrade? Even though I am in the dashboard, it still appears that the database isn't functioning correctly, but it appears to have acknowledged the upgrade because it is showing MySQL Version 5.6.23. CubeCart Version is 4.3.3 and PHP version is 5.5.30.

Ok. I will try to upgrade to the latest CC4. What would be best way to go about doing the upgrade? I have done it from the admin dashboard in the past, but I am unable to access the admin dashboard.

When I checked my email this morning, I had complaints from customers that they were getting a MySQL Error when attempting to checkout. Upon investigating this issues, I realized that there was a notification in my cpanel stating that the version of MySQL was no longer supported and that I needed to upgrade. I logged into our WHM and used the MySQL upgrade tool. At the end of the upgrade, it stated that the upgrade completed successfully and the database rebuild completed successfully, but now when I try to login to my CubeCart dashboard, I am given error and warning messages and it is not allowing me to access my dashboard. I have attached screenshots for reference (screenshot 01 is at the login screen and screenshot 02 is after I attempt to login). I can provide the MySQL upgrade log file if that will help. Thanks in advance for your help!

Just sent a PM.

I checked prior to posting to see if there was an update, but when I clicked on the section on the USPS website to see current updates to the API, it only showed updates taking place on 10/6/15 and 10/11/15. However, after looking over the link you gave me, I think there are some other updates I missed. The last update I installed was when the Rate V4 update came out. I went to the USPS web tools website and registered to receive the latest API. I received an email confirmation with my ID and password and some links with instructions, but I can't seem to find where to get the API code or files to implement. Am I missing or overlooking something?

Recently, we had a customer from Canada try to place an order on our website, but received a USPS error with no way to complete the checkout using a different shipping method. I have attached a .txt document of the error. We weren't having any issues with Canadian customers placing orders in the past, so this seems to have just suddenly started happening. Any help in resolving this issue would be greatly appreciated. USPS Error.txt

Ok, I think I can figure it out from here. Thanks for pointing me in the right direction!