Our board is a mybb 1.4.3 and it was converted into that from a phpBB 2.x board, the conversion worked great minus a few minor things.
One is all the users brought in from phpbb show online as hidden (the the * next to their names) i know for fact not every one of the 1200 users were hidden. is there a way to turn that flag off on all the users easily?!!?
Try running this in PHPMyAdmin, or whatever database manager you have:
UPDATE 'mybb_users' SET 'invisible' = '0' WHERE 'invisible' = '1'
That's untested but should work. Make sure the mybb_ bit is the same as your own table prefix.
tried it and this is what i get back in phpmyadmin:
Error
SQL query:
UPDATE 'mybb_users' SET 'invisible' = '0' WHERE 'invisible' = '1'
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''mybb_users' SET 'invisible' = '0' WHERE 'invisible' = '1'' at line 1
OKAY GOT IT! just need the '0' and '1' to have no quotes.
thanks!
You guys rock fast responses!!!!!
Oops, I made a slight typing error. Should have been:
UPDATE `mybb_users` SET `invisible` = '0' WHERE `invisible` = '1'
I used ' instead of `.
Anyway, glad it works
