jzukerman Posted June 20, 2013 Share Posted June 20, 2013 Hello, I recently upgraded my WHMCS install from ver 4.4.3 to 5.2.5 using the full 5.2.5 download file. Since upgrading, orders cannot be placed through the shopping cart. Items cannot be added, shopping cart is empty. I understand there was a bug in the patch file that caused this, but I didn't use the patch file. I used the full download file. I have a valid WHMCS license purchased through my VPS provider and don't have a support account with WHMCS. Any ideas how to fix this? Thanks, Josh 0 Quote Link to comment Share on other sites More sharing options...
penguin Posted June 20, 2013 Share Posted June 20, 2013 Yes, run all of the differential SQL updates from the install folder of your download - this is an issue that they still haven't fixed... See http://forum.whmcs.com/showthread.php?73707 for a fix 0 Quote Link to comment Share on other sites More sharing options...
jzukerman Posted June 20, 2013 Author Share Posted June 20, 2013 (edited) Okay I read the thread and still am not sure what I need to do. I guess I'll have to wait for support to hopefully join this thread. edit: I looked at the tblconfiguration in PHPMyAdmin and Version is already set to 5.2.5. I looked into the install folder on my local computer (since I already deleted the install folder from my webserver) and saw a bunch of SQL files from version 3 to 5.2.5. I am not sure what I need to do with them. Edited June 20, 2013 by jzukerman 0 Quote Link to comment Share on other sites More sharing options...
penguin Posted June 20, 2013 Share Posted June 20, 2013 The version in the database will be correct, however the database upgrades in between are missed by the upgrade. Just run each of the SQL queries in phpMyAdmin (excluding the version change lines) from your original version to the latest and this should fix your issue. 0 Quote Link to comment Share on other sites More sharing options...
jzukerman Posted June 21, 2013 Author Share Posted June 21, 2013 (edited) The version in the database will be correct, however the database upgrades in between are missed by the upgrade. Just run each of the SQL queries in phpMyAdmin (excluding the version change lines) from your original version to the latest and this should fix your issue. I copy and pasted the upgrade450.sql (presumably the first file to start with since I was on version 4.4.3) into PHPMyAdmin, under the Database that I am using for WHMCS, clicking on SQL section (Run SQL query/queries on database whmcsblahblahblah) without the version line. Got the follow error message: SQL query: ALTER TABLE `tblpromotions` ADD `startdate` DATE NOT NULL AFTER `requiresexisting` ; MySQL said: Documentation #1060 - Duplicate column name 'startdate' I didn't feel comfortable to proceed further. Edited June 21, 2013 by jzukerman 0 Quote Link to comment Share on other sites More sharing options...
jzukerman Posted June 22, 2013 Author Share Posted June 22, 2013 WHMCS Support fixed the issue. "The issue has now been resolved for you by uploading a fresh/updated class.init.php file to /includes/classes/" 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.