Upgraded from v2.60 to v2.64 last night. Today, have encountered a number of problems.
1. On placing a test order as a customer, once the process payment button gets pushed, we hit this error message:
A critical error has occurred.
The stored procedure 'dbo.Smith_UpdateProductQtyOnHand' doesn't exist.
Looking in to that, not only was that stored procedure missing, but 'dbo.Smith_SA_ListProductNames' was missing as well.
2. We manually added both of those stored procedures to the database. Now when orders get placed, the quantity does update, and the order gets placed, however the customer, when they press the process payment button, gets hit with a Runtime Error.
Am thinking that this is the same issue as one I had before, with the stored procedure for Featured Products wasn't getting written during the upgrade process. Uninstalling and re-installing the module did the trick before, and it's done the trick this time as well - all is working as expected. There's something (still) amiss with the installation script when it's an upgrade situation.