Need to DELETE old safes and lock boxes (NOT set to 0000)

[Bricktop]

Hey guys, I have around 13k items in my object data -

I want to delete abandoned safes and lock boxes from the server (NOT just reset to 0000 - I already do this) 

I have very little knowledge when it comes to SQL's - I tried these but nothing was deleted. Could someone please help?

DELETE FROM `object_data` WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY) AND `Classname` = "VaultStorageLocked" AND `Inventory` <> '[]' AND `Inventory` IS NOT NULL

================================

DELETE FROM `object_data`
WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY)
AND `Classname` IN ('Wooden_shed_DZ','WoodShack_DZ', 'TentStorage', 'TentStorageDomed', 'TentStorageDomed2', 'WoodCrate_DZ', 'GunRack_DZ', 'OutHouse_DZ', 'StorageShed_DZ', 'VaultStorage', 'LockboxStorage')

================================

Thanks,

================================

P.S. Is it safe to delete the contents of the HiveExt.log ? It's over 100k in size.

[Tech_Support]

Are your Sql events turned on?

[Bricktop]

 

On 10/4/2016 at 11:24 PM, Tech_Support said:

Are your Sql events turned on?

yes