Will upgrading fix broken admin access?

[humpy]

Have just setup up a site that was quickly grabbed from another webhost as they were crashing...

Everything is working fine but i just cannot access the cms admin page... Have read all the forums and tried every method suggested ..
eg
mysql> UPDATE ds_users SET password = md5('admin') WHERE user_id = 1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings:

which appears to have worked!!!.. but i still cant get in...

I havent been able to determine the CMS version , but am assuming it isnt the latest version.. Was pondering if upgrading versions may fix this, ? but am assuming an upgrade would feed off existing sdmin l/p in databse and stay the same..

Otherwise, if i do a brand new install of CMS , what may i have to do to ensure the website comes back up again.

I know a bit.. but obviously not enough..
thanks all

[Rolf]

http://docs.cmsmadesimple.org/troublesh ... d-recovery

[humpy]

hi thanks for that..
that was slightly different from the other methods i tried.. but same result , no login.. however i think that command didnt actually change anything? .. as per below, there was no sql reply and only a ->

mysql> update ds_users set password = (select md5(CONCAT(IFNULL((SELECT sitepref_value FROM ds_siteprefs WHERE sitep
ref_name = 'sitemask'),''),'admin'))) where username = 'admin'
->

any other thoughts?
cheers will

[Rolf]

You can always check/change in the database the correct admin name *and* mail address. When these are good, you can use the CMSMS lost password feature at the login screen to reset your pass

[humpy]

looked at database with phpmyadmin,, "admin" name is definitely correct...
had already changed the admin email to mine, and attempted a reset , but no mail shows....

is there a config file i can manually edit to change cmsmailer settings from old server settings to match my server perhaps?

thanks

Will

[velden]

No, it's in database too.
Reset password method should work. If not I guess you have other problems with this installation (too).