![]() |
How can I mass activate users awaiting for email confirmation directly in database?
Somehow, the database shows 153. The group shows 110 and when I mass sent emails to that group, 92 went out. So I would like to make a query into useractivation and activate everybody and start from scratch. |
run this query:
UPDATE set usergroupid=2 WHERE usergroupid=3 that will change everybody who's waiting for email confimation and set them as a regular user. |
oh no... it doesn't work! I get an error in phpmyadmin:
MySQL said: You have an error in your SQL syntax near 'set usergroupid=2 WHERE usergroupid=3' at line 1 when I type that in!! OK... that is because it needs to read UPDATE **user**, which is left out in the post above. :) |
doh! how can i be so careless....
UPDATE user SET usergroupid=2 WHERE usergroupid=3 |
All times are GMT. The time now is 12:35 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|