SMFHacks.com
** Home Forum Index Hacks Products Login Register Search
Welcome, Guest. Please login or register.
May 24, 2012, 08:49:44 am

Login with username, password and session length
Members
Total Members: 10071
Latest: cdavidson012
Stats
Total Posts: 28687
Total Topics: 4977
Online Today: 59
Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Users: 0
Guests: 50
Total: 50
+ 
|-+ 
| |-+ 
| | |-+ 
| | | |-+ 
0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] Go Down Print
Author Topic: Problems Updating Table  (Read 1103 times)
Senkusha
Newbie
*
Offline Offline

Posts: 13


View Profile WWW
« on: May 01, 2009, 02:31:33 pm »

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:
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!
« Last Edit: May 01, 2009, 02:34:47 pm by Senkusha » Logged

--Senkusha
Visit my anime writing community
Pages: [1] Go Up Print 
« previous next »
Jump to:  

Recent
[Today at 08:02:50 am]

[Today at 04:11:41 am]

[May 21, 2012, 08:54:11 am]

[May 20, 2012, 11:06:52 am]

[May 20, 2012, 05:58:11 am]

[May 19, 2012, 06:16:58 pm]

[May 19, 2012, 05:42:37 pm]

[May 18, 2012, 03:08:38 pm]

[May 17, 2012, 06:07:46 pm]

[May 17, 2012, 02:22:07 pm]
Random Picture
Donate to SMFHacks.com
Help Support the SMFHacks.com mod making.
Powered by SMF 1.1.16 | SMF © 2006-2011, Simple Machines LLC
TinyPortal v0.9.7 © Bloc
SMF and SimpleMachines are registered trademarks of Simple Machines. SMFHacks.com is not affiliated with nor endorsed by Simple Machines.
Page created in 4.747 seconds with 20 queries.