lost user passwords! can not reset. URGENT HELP NEEDED

i can not reset the user passwords in the admin user panel. they get can not login

username password error

i tried (as per ticket solution

set user password
UPDATE `Profiles` SET `Salt` = CONV(FLOOR(RAND()*99999999999999), 10, 36) WHERE `ID` = '1' LIMIT 1
UPDATE `Profiles` SET `Password` = SHA1(CONCAT(MD5('yourNewPassword'), `Salt`)) WHERE `ID` = '1' LIMIT 1

but get an error on line 2

my users are getting locked out of the system.

I tried cut and paste of an old password and salt. same thing they can't log in

clearing the caches did no help at all

I need a fix. it is my moderators password that is messing up.

are the users not able to request a forgotten password, and have it mailed to them? not sure why you would be getting an error on the sql statement, nor have you shared what that error was. 

also are you sure the cache is being cleared? at times, using the link on the admin panel is iffy as to whether or not it actually clears the cache. 

the code is from a ticket to fix password errors unfortunately it does not work. i get an error on line 2

the passwords have been manually set through admin

and again through password retireval....

both times i deleted all the files in cache,public_cache and tmp

and all times we tried this the user was unable to log onto the account

even i couldn't from the main server....

something is dreadfully wrong as it should have worked the first time

Those sql queries are from this post.

http://www.boonex.com/forums/topic/Reset-Admin-Password.htm

It is not a ticket. It was posted as a tip.

Try running the queries one at a time. And when changing the values make sure you don't accidentally take out any of the single quotes as that will cause an error.

If password problems still exist after resetting then it's possible that the file member.php is damaged. Try uploading a fresh copy from a dolphin zip file matching your current dolphin version.

See this topic as well.

http://www.boonex.com/forums/?action=goto&my_threads=1#topic/Password-problem-7-0-7-.htm

it was the profiles->role set to 2 for moderators jamming up the passwords for the moderators

switching it back to 1 alloud them to get back on. ergh...

oh well i guess i won't be having moderators till i know how to do it correctly

 http://www.boonex.com/m/multi-admin-access

this mod will allow moderators, and not full admin rights, unless you want them to have such.