I tried to to move the target users to a new group with this query:
UPDATE user
SET usergroupid = X
AND joindate > UNIX_TIMESTAMP('2007-01-01 00:00:00')
after contacting the vb support team, I have attempted this and it has changed all my usergroup ids on all my users to '0' or '1' and has also locked me completely out of the admincp (because I am no longer in the admins usergroup.
I typed this: -
UPDATE user
SET usergroupid = 9
AND joindate > UNIX_TIMESTAMP('2007-01-01 00:00:00')
What can I do now to get it back - why hasnt this worked?
UPDATE user
SET usergroupid = X
AND joindate > UNIX_TIMESTAMP('2007-01-01 00:00:00')
after contacting the vb support team, I have attempted this and it has changed all my usergroup ids on all my users to '0' or '1' and has also locked me completely out of the admincp (because I am no longer in the admins usergroup.
I typed this: -
UPDATE user
SET usergroupid = 9
AND joindate > UNIX_TIMESTAMP('2007-01-01 00:00:00')
What can I do now to get it back - why hasnt this worked?
Comment