MODS.DB9.DK

[Marit]

My colleague accidently deleted my Anonymous... my guest..... the -1...
I had forgotten to tell her she shouldn't....
But now it's gone and people (who aren't logged in) can't reach my forum... (http://www.kyka.nl/forum/)
How can I fix this??

Please help me??

[duvelske]

kooky i'm helping her already on the phpbb.nl forum. So thnx Do you know the answer? let me know

[Niels]

First of all - how did she/he deleted the user - if this mod allow sutch action, I should update it to prevent this from hapening again. ?

To fix it run these 3 SQL commands:

Code: Select all

INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( -1, 'Anonymous', 0, 0, '', '', '', '', '', '', '', '', 0, NULL, '', '', '', 0, 0, 1, 0, 1, 0, 1, 1, NULL, '', '', 0, '', '', '', 0, 0);


INSERT INTO phpbb_groups (group_id, group_name, group_description, group_single_user) VALUES (1, 'Anonymous', 'Personal User', 1);


INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (1, -1, 0);

you may run these from phpmyadmin or like.

[duvelske]

Thnx niels, but i knew it allready how to answer her question. BUT YOUR THE GREATEST!!