DC 1054 error, and error in 'Product Restrictions' section

Yes, all DB settings are identical.

isaiah36:

Nope, same error from a freshly generated GV.

You've posted a few errors. Which one are you getting now?

During checkout, neither DC nor GV code is being accepted, the subtotal is not changing to reflect the discount. At first, I was trying to get the admin part to work, to make sure I was doing the setup right. Now I am testing the user side of the DC/GV thing. I am having my daughter test it in parallel using a different user account than mine.

"The Gift Certificate number 26c8fade63bb15b may be invalid or has already been redeemed."

This one is the code generated after patching of SQL. I have searched the forum for the issue.

I did a full 'Overwrite' based FTP of the /includes and /[custom_admin] directories, using the most recent 1.3.9 fileset, but with plugin modifications added in by WinMerge, and then manually fine tuned for proper overrides - eureka! Now, on the checkout page I see an '(Available Balance: $30.00)' right under the Gift Certificates amount field, the $30 being the correct sum of the 3 test certificates I sent myself. I put in an amount only, did not bother filling in the redemption code again, leaving that field blank, and sure enough, the order total adjusted correctly. Problem solved, by fresh upload of all files!

I have one word for you, Dr. Byte - THANK YOU! This has become a textbook case of "Why we do upgrades the recommended way?" Never again will I do an automated update by Cpanel. It does not save time, it costs more time to fix issues.

Glad you got it sorted out :)