Update DB Manager Syntax

[FireSmartFox]

Hi,
I am able to perform SELECTs and work with the data.
Just one line after I tried this:

Code: Select all

dbManager.executeUpdate("UPDATE table1 SET time_pulled=NOW() WHERE id= ?", new Object[] {id});

id is a valid int, the row is existing.
I get no error in the logs, but also no update.
I don't find a lot about how to use the Update in the docs.
Is this line in general okay?

[Lapo]

Hi,
are you sure the code is actually executed?
Can you add a trace before and after the DB call to make sure it is?

What version of SFS2X are you using?
Which database do you use?

Also are you sure there are no errors at the Zone initialization with the database? If there's an init error then you might not be able to execute any DB code until you fix that problem first. Check the logs of the SFS2X startup, it lists every Zone being launched.

Thanks