[hurrican]

Hello Everyone,
I was running MySQL v3.23 until yesterday - I Upgraded to 4.1, with the latest PHP and Apache. I want to run a script locally on the server to remove all the users who were imported from my UBB system, and the lastvisit = 0 (b/c they haven't visited since i've upgraded to vb).

Here's the actual query im running minus the connect details:

PHP Code:

DELETE FROM user WHERE lastvisit=0 AND usergroupid=2,3,10,11 


This did not produce an error on 3.23, but it does now, gives me

error 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your mysql server version for the right syntax to use near '3,10,11'

So I read up a little, and put 2 OR 3 OR 10 OR 11, but that just totally deleted my entire USER table ( Good thing I make backup of everything before I start :nervous: )

I have this one to run via cron job (worked before) to remove any users who have not visited in the past 365 days. Now this doesn't work either.

PHP Code:

DELETE FROM user WHERE lastvisit ".(time() - (60 * 60 * 24 * 365))." AND usergroupid=2,3,10,11 


Any help would be greatly appreciated!