Ok, so I accidentally typed DROP TABLE phpbb_user_group instead of phpbb_user_group_TEST and now I've deleted my user_group table and feel kind of silly. Anyway, I've looked up the mysql section in the install.php script and restored the structure of the table.
I'm not so worried about the normal users since I can just re-add their groups through mods and stuff but I just need to reset the guest and administrator 'group' settings manually. I don't know how to manually add these values and I couldn't find an online resource for it, so if someone could please do a screen-dump of the result for this query from any phpbb2 (mysql) install :
SELECT * FROM phpbb_user_group WHERE user_id < 3
that would be much appreciated. Cheers
P.S. For reference to anyone else, the result of that query will give the user_group settings for the guest and admin 'users' (which I have user_id values of -1 and 2 in a standard install I think?)
P.P.S Also, what is the primary key? For some reason this didn't get set when I recreated the table. It's user_id right?
Last edited by ric323
on Sat Jul 12, 2008 12:39 am, edited 1 time in total.
Reason: Topic icon changed