Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Help! User password is missing.

Nov 2, 2001, 8:23 PM
romulus
Novice (5 posts)
Nov 2, 2001, 8:23 PM
Post #1 of 4
Views: 1477
Shortcut
Quote Reply
Help! User password is missing.
I upgraded from links2 to linksql2 and i thought everyone got a password but everyone has blank passwords.

How can i fix this problem? I have nearly 7500 users and can't do it manually Frown

Nov 3, 2001, 7:39 AM
Stealth
Veteran (17240 posts)
Stealth's avatar
Nov 3, 2001, 7:39 AM
Post #2 of 4
Views: 1417
Shortcut
Quote Reply
Re: [romulus] Help! User password is missing. In reply to
Use the following SQL Statement in the SQL Monitor (after selecting the Users table):

Quote:

UPDATE Users
SET Password = RAND(Password)


This will assign an unique password to all your users. They will have to "look-up" their password by using the Password Lookup script...then they can modify their user account to edit their password.
========================================
Buh Bye!

Cheers,
Me
Nov 3, 2001, 5:50 PM
romulus
Novice (5 posts)
Nov 3, 2001, 5:50 PM
Post #3 of 4
Views: 1396
Shortcut
Quote Reply
Re: [Chewbaca] Help! User password is missing. In reply to
Thanks! Sly
Nov 3, 2001, 5:52 PM
Stealth
Veteran (17240 posts)
Stealth's avatar
Nov 3, 2001, 5:52 PM
Post #4 of 4
Views: 1388
Shortcut
Quote Reply
Re: [romulus] Help! User password is missing. In reply to
You're welcome.
========================================
Buh Bye!

Cheers,
Me