CMS Made Simple Forums

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

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

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

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

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