Problems Updating Table

[Senkusha]

Hi, I'm having a rather strange problem.

I am trying to uncheck 'onsale' items.  The interface isn't making the changes.  I tried to execute a query in a terminal:

Code: [Select]

UPDATE smf_store_item SET onsale = '0', saleprice = '0.00' WHERE onsale = '1';

The result claimed there were 33 changes, however, no changes were actually made.

The problem only seems to be with the smf_store_item table. (I've run other queries on other tables just fine).

Does anybody have any suggestions?

Nevermind.  I restarted the mysql service and it seems to be working fine now.

Thanks!