PDA

View Full Version : Import from PHPBB2 all users banned.



Aeons
Fri 3rd Nov '06, 2:29pm
Firstly, i imported my database and all seems good apart from one thing, all my users are banned. The "Import" didn't allow me to Import ban lists and read Failed. is there anyway to mass unban all my users as through PHPmyadmin, the table is none emptyiable(surely not a word :rolleyes:).

Is it worth exporting the table SQL and deleting the table and "re-importing" it so to speak? Would this work? Not new to MySQL but its not my strongest of subjects.

Thanks.

Zachery
Fri 3rd Nov '06, 3:18pm
Did you try deleting the custom usergroup they got imported into?

Jerry
Fri 3rd Nov '06, 3:24pm
Is it worth exporting the table SQL and deleting the table and "re-importing" it so to speak? Would this work? Not new to MySQL but its not my strongest of subjects.

Nope as Zak suggested, best to just delete the usergroup that ImpEx creates as that will move everyone into the Registered usergroup.

Usergroups (http://www.vbulletin.com/docs/html/impex_cleanup)

Aeons
Fri 3rd Nov '06, 4:35pm
Thanks guys!
Helped alot, everthing sorted now i think.
No way to test, but it seems right as they all appear under register user now.