execute SQL bug?
 

Hi,
I have a problem when i try to "Execute SQL Query"

Its for my "vbookie" mod were i need to reset the cash for my users.

I enter: UPDATE user SET vbookie_cash=500 and press excecute

The outcome says:
I really dont know how to fix this or even understand what it mean.

Anyone ?

You probably have a table prefix and you need to add that in front of "user" in the query.

You should be asking questions regarding modifications in the modification thread.

yes, i tried to vb3_user
And the outcome was: Affected Rows: 16 (0.0263s)

So i guess the excetuting was done right?

I would guess so, if there were affected rows. If you are able to view the database, you could always check. Or, you'll find out when you try to use the mod whether or not you did it correctly.

If the affected rows count is more than 0, then it should be OK. You can verify this by looking at the table through phpMyAdmin, etc.

16 rows was affected i think it said... but now i got problems with the DB.. but it dont say what type of errors.. just "Database error" 2 out of 3 trys to enter site i get that anoying error.

Are there a way i can do something about this? - can i re-update the software VB ?

View the page source to get the full SQL error.

how can i do this?

Rogt click on the error page and select View Source.

okay,
here is the error.. can anyone se whats wrong?