Gift Certificate issue after upgrade

[Brewhaus]

We recently upgraded from 7.0.2 to 7.0.7, and when a customer today tried to pay with a gift certificate generated in 7.0.2 the payment was declined. I checked, and their gift certificate was reduced by the amount on the order, but the payment showed the error: invalid object ac_Orders.

Can anyone help on this?

[jmestep]

Make sure the owner of the table in the database is dbo. like the others. We had that happen when we got site from a different hoster where the tables were owned by a different owner and had to switch them all to dbo. It was very weird because there were orders being placed OK, but we got that message on some routine.

[Brewhaus]

It is funny that you should mention that, as we found that a few tables (ac_CustomUrls, ac_Kits, ac_Orders, ac_ProductProductTemplates, ac_Redirects) changed to a different owner, and show as being created on 11/20/11 (when the upgrade was done). Is it safe to change them back to dbo? And, if so, could you please remind me how to do so?

Any thoughts on why they would get changed when the upgrade was performed?

[jmestep]

Here is how you can change them:
http://geekswithblogs.net/AskPaula/arch ... 24737.aspx

I don't know why it would have happened with the upgrade- I haven't seen that with upgrades I did.

[Brewhaus]

Thanks, Judy. I will give that a shot.