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!

Yes, it does say changed in version 2.0.

Thanks for your reply. Here is the requested code: </table> <input type="hidden" id="rowCount" value="<?php echo $rows ?>" /> <table border="0" cellspacing="1" cellpadding="3" class="mainTable" width="100%" style="border-top: none;"> <tr> <td class="tdText"><input type="hidden" name="currentRowCount" value="<?php echo $rows; ?>" /> <?php echo $lang['admin_common']['add'];?> <input type="text" name="prodRowsAdd" id="prodRowsAdd" value="1" size="2" style="text-align: center;" class="textbox" /> <input type="submit" name="prodRowsSubmit" value="Product Rows" class="submit" onclick="return addRows('productList', 'prodRowsAdd')" /> </td> <!-- start mod: Coupon Enhancements - http://cubecart.expandingbrain.com --> <!--Some php goes code is here for the third party coupon module. Not sure if you wanted to see that or not.--> <!-- end mod: Coupon Enhancements - by Estelle --> <td width="150" align="center"><input name="subtotal" id="subtotal" type="text" class="textbox" style="text-align:right;" value="<?php echo $orderSum[0]['subtotal']; ?>" size="7" /> </td> </tr> <tr> <td rowspan="4">&nbsp;</td> <td align="right" class="tdText"><?php echo $lang['admin']['orders_discount']; ?></td> <td width="150" align="center"><input name="discount" id="discount" type="text" class="textbox" style="text-align:right;" value="<?php echo $orderSum[0]['discount']; ?>" size="7" /></td> </tr> <tr> <td align="right" class="tdText"><?php echo $lang['admin']['orders_shipping']; ?></td> <td width="150" align="center"><input name="total_ship" type="text" class="textbox" style="text-align:right;" value="<?php echo $orderSum[0]['total_ship']; ?>" size="7" /></td> </tr>

Hello, I'm having a weird issue that I just noticed happening today. After a customer completes a checkout and I view the packing slip to print, instead of showing Subtotal, Discount, Shipping, Total Tax, and Grand Total like it was, it is showing Discount, Discount, Shipping, Total Tax, and Grand Total. Discount appears twice. The first has the subtotal number and the second one actually shows the discounted amount like it should. I've checked to see if it appears this way for undiscounted products as well as discounted products and it does. I have attached a photo to show what I am talking about. I am using Cubecart 4.3.3. I have a third-party coupon plugin from Estelle's Mods. However, I don't believe that is the problem because I have been using it for over a year and didn't have this problem. Any suggestions? Thanks in advance!

Hello, My company has been using CubeCart 4.3.3 for a while now with now problems. Just recently, USPS updated their APIs for the shipping module and I have been having a heck of a time trying to get that to function correctly. I have followed some of the threads posted here on updating the APIs, and I'm sure I can figure it out if I work with it, but in all honesty, we should probably just go ahead and make the upgrade to CubeCart 5. There are a few reasons why we haven't made the switch yet, and most of it is due to the fact that I would have to put other projects on hold to do it myself. I am thinking about paying the upgrade fee and then paying the fee to have a developer do the upgrade for me, but I have a few questions I would like to know. I read that some third party modules might not work correctly after an upgrade. We really have only one third party module, which is a coupon code module that we purchased from Estelle's Mod Store. We have a lot of coupon codes and it would be a pain to have to go add the mod coding back to the source code and reenter every coupon code that we have. This is really my main concern because I do not have time to do this and I would rather just keep version 4 than have to put my current projects on hold. Does anybody know if this would carry over into the upgrade and function properly? As I stated above, I was having difficulty getting the new USPS shipping API to work correctly with version 4. If I upgrade to version 5 and pay to have a developer do the upgrade for me, will this fee include getting the new USPS shipping API to work correctly? If not, is there an extra fee I can pay to have this done? Thanks in advance for your help!

Awesome! This worked! Thank you bsmither for your expertise and for helping me resolve this issue quickly. Glad it wasn't something too extensive to fix. The way it just suddenly started doing that made me think that some coding had been updated or changed somewhere and CubeCart wasn't reacting well to it. Thanks again!

Hi all, I am getting a very odd security warning when trying to access items in our online store at www.pacworks.biz. Here is the message that I am getting when trying to click on different menu items: Security Warning Parsed array keys can not contain illegal characters! Script execution has been halted. It may be possible to fix this error by deleting your browsers cookies and refresh this page. This message just randomly started appearing. I did a search trying to figure out a solution to this problem and it seems like people are saying that it is a problem with some PHP coding. The odd thing is that we have not changed any of the code, nor installed any third party plugins in at least 6 months and our store has been running fine. I also haven't changed any of the store settings in the CubeCart dash board. I know CSS and HTML, but I am not a PHP programmer, so I am not sure what to look for to fix this problem. Here is some info that may help diagnose my problem: I am using CubeCart 4.3.3 I have tested on multiple web browsers and got the same error message Thanks in advance for any help!