| ICQ UIN Bug [message #11804] |
Thu, 17 July 2003 19:01  |
ctbk
Messages: 142
Registered: April 2002
Location: Milan, Italy
Karma: 0
|
Senior Member |
|
|
I don't know if it was due to the 2.3.8 -> 2.5.0 upgrade, but a lot (over 7.000) of users did have their ICQ UIN set to 0.
To those users was impossible to login: the pass was accepted without errors, they were redirected to the homepage but they remained Anonymous.
update prefix_users set icq = NULL where icq = 0
solved the problem.
~
~
:wq
[Updated on: Thu, 17 July 2003 19:01] Report message to a moderator |
|
|
|
| Re: ICQ UIN Bug [message #11806 is a reply to message #11804] |
Thu, 17 July 2003 19:08  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Wow that's unsual icq uin is not even used during the login process and I am pretty sure I have a bunch of forums that were upgraded that have users with icq uin set to 0 and have no login problems. I will check this, but the fix sounds very strange.
FUDforum Core Developer
|
|
|
|
| Re: ICQ UIN Bug [message #11821 is a reply to message #11806] |
Fri, 18 July 2003 11:42 |
ctbk
Messages: 142
Registered: April 2002
Location: Milan, Italy
Karma: 0
|
Senior Member |
|
|
It wasn't ICQ. Another user reported the same bug.
Here's what I've done:
changed his pw via admin panel, tryed to login, failed.
entered in his profile via admin panel, didn't changed anything, saved.
tryed to login: success.
Here are the user's db entry before and after the update of his profile:
*************************** 1. row ***************************
id: 1879
login: ****
alias: ****
passwd: ********************************
name: ****
email: ************
location: NULL
interests: NULL
occupation: NULL
display_email: N
notify: N
notify_method: EMAIL
ignore_admin: Y
email_messages: Y
pm_messages: Y
avatar: 0
avatar_loc: NULL
avatar_approved: NO
gender: UNSPECIFIED
icq: NULL
aim:
yahoo: NULL
msnm: NULL
jabber: NULL
append_sig: Y
show_sigs: Y
show_avatars: Y
show_im: Y
posts_ppg: 35
time_zone: Italy/Rome
bday: 19741116
join_date: 1004526994
invisible_mode: N
blocked: N
email_conf: Y
conf_key: 0
user_image: NULL
theme: 0
coppa: Y
posted_msg_count: 27
last_visit: 1053390819
referer_id: 0
last_read: 1033199043
custom_status: NULL
sig:
default_view: msg
is_mod: N
level_id: 3
reset_key: 0
u_last_post_id: 742634
home_page:
bio:
cat_collapse_status: 11:0
acc_status: A
custom_color: NULL
affero: NULL
buddy_list: a:2:{i:1915;i:1;i:10725;i:1;}
ignore_list: NULL
group_leader_list: NULL
*************************** 1. row ***************************
id: 1879
login: ****
alias: ****
passwd: ********************************
name: ****
email: ************
location: NULL
interests: NULL
occupation: NULL
display_email: N
notify: N
notify_method: EMAIL
ignore_admin: Y
email_messages: Y
pm_messages: Y
avatar: 0
avatar_loc: NULL
avatar_approved: NO
gender: UNSPECIFIED
icq: NULL
aim: NULL
yahoo: NULL
msnm: NULL
jabber: NULL
append_sig: Y
show_sigs: Y
show_avatars: Y
show_im: Y
posts_ppg: 0
time_zone:
bday: 19741116
join_date: 1004526994
invisible_mode: N
blocked: N
email_conf: Y
conf_key: 0
user_image: NULL
theme: 2
coppa: Y
posted_msg_count: 27
last_visit: 1058527965
referer_id: 0
last_read: 1033199043
custom_status: NULL
sig: NULL
default_view: msg
is_mod: N
level_id: 3
reset_key: 0
u_last_post_id: 742634
home_page: NULL
bio: NULL
cat_collapse_status: 11:0
acc_status: A
custom_color: NULL
affero: NULL
buddy_list: a:2:{i:1915;i:1;i:10725;i:1;}
ignore_list: NULL
group_leader_list: NULL
seven fields have changed:
aim, post_ppg, time_zone, theme, sig, homepage, bio
aim was '' and now is NULL
post_ppg was 35 and now is 0
time_zone was Italy/Rome and now is ''
theme was 0 and now is 2
sig was '' and now is NULL
homepage was '' and now is NULL
bio was '' and now is NULL
I suspect the problem is related to the theme field, but I'm not sure. Will do some test with my own account.
~
~
:wq
[Updated on: Fri, 18 July 2003 11:43] Report message to a moderator |
|
|
|
| Re: ICQ UIN Bug [message #11822 is a reply to message #11804] |
Fri, 18 July 2003 11:58 |
ctbk
Messages: 142
Registered: April 2002
Location: Milan, Italy
Karma: 0
|
Senior Member |
|
|
Tried with my own account: set theme = 0, I couldn't login anymore.
theme = 2, all is fine.
Theme 2 is the only theme enabled in my system, and it's the default one.
I got some problem with the default theme in the upgrade 2.3.8 -> 2.5.0, wich I explained in this topic, but I don't know if that has anything to do with this issue.
~
~
:wq
[Updated on: Fri, 18 July 2003 12:00] Report message to a moderator |
|
|
|
| Re: ICQ UIN Bug [message #11825 is a reply to message #11822] |
Fri, 18 July 2003 13:15 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Invalid theme id can indeed dis-allow logins for a few reasons, mostly because the correct files cannot be fetched. I need to see if theme=0 was a common issue and add a check for it in the upgrade code or possibly even the consistency checker. If you still have access to your 2.3.9RC1 database, see how many, if any users have a theme with an id of 0.
FUDforum Core Developer
|
|
|
|
| Re: ICQ UIN Bug [message #11826 is a reply to message #11825] |
Fri, 18 July 2003 13:19 |
ctbk
Messages: 142
Registered: April 2002
Location: Milan, Italy
Karma: 0
|
Senior Member |
|
|
don't know in the old db, (I've got it somewhere, got to find it) but when i updated the new one, 8.000 lines (users) were changed.
~
~
:wq
|
|
|
|
| Re: ICQ UIN Bug [message #11828 is a reply to message #11826] |
Fri, 18 July 2003 13:26 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
The field breakage sounds like a result of an improper data restore. The upgrade script in MySQL mode does not actually re-create any tables, merely adding/removing fields and indexes, which would not result in field confusion.
FUDforum Core Developer
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]