I read from a phpBB forum how to fix the user database in mysql. Two things I had to modify from the original (changed to):
1) ip_users 2) user_allow_viewemail
This is the code that worked:
INSERT INTO ip_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_allow_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);
user_website, user_occ, user_from, user_interests, user_sig, user_allow_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);
To clarify. Open your site's main database in phpMyAdmin. Select SQL, then copy the above into the run box, select GO. If no errors given, then it should be good to go.
Original Post
Hello all,
I just recently upgraded to Icy 2.0. While checking things out, I noticed a problem with the registration function. Here are the steps leading up to the error.
- select the register link
- check the box: I specifically agree to these terms
- click 'I agree to these terms'
The next page returns: Sorry, but this username has already been taken.
Following the addresses:
Would not the last address be:
... that is, without the sid ?
I've tried this both in Windows and Linux, producing the same result.
Link to site's registration: http://www.drm-cops.com/profile.php?mode=register
Any help/thoughts we be very much appreciated.
Thank you,
Dan :)