I forgot my admin password. And I cannot recover it through the email function. I tried to recover it on the database but it is not available either. Can anybody help me on what to do in this regard.

Thanks,
Karina

If you really don't know it anymore you can create a new customer account :

http://yoursite.com/register.php

Then go to your database ; find the encrypted pasword off the new account .

Ctrl C then go to store_config open table , del pasw and Ctrl V

I think Saztar has just posted a mod in the downloads section that will help you recover a lost/forgotten password. I haven't taken a look at what he did there, so don't know how it works, but check it out and see if it's what you need.

how can I modify the password. If I go to store_config, browse, there is no edit function available only for it. Can you explain me how to do it please.

its the admin_pass row under store_config table, however its stored with the MD5 encryprion, so your best to just download and run Sazrat's mod: http://www.cubecart.com/site/forums/index.php?download=94

I tried already with the Sazrat's mod download and run and it didnt work either.

There is an error indicated there- pasted below. Would it be affecting?

What can I do?

Thanks

ERROR: Unclosed quote @ 771
STR: '
SQL: SELECT * FROM `store_config` WHERE `site_email` = 'info@the silvergifts.com' AND `site_country` = 'Australia' AND CONCAT(`site_tax`) = '0.00' AND `site_url` = 'http://www.thesilvergifts.com/store/upload' AND `site_url_ssl` = '' AND `site_name` = 'The Silver Gifts: the perfect gift' AND `site_phone` = '+61 2 93315324' AND `site_fax` = '+61 2 83540831' AND `site_address` = 'PO Box 88
Potts Point
NSW 2011' AND `site_dir` = 'd:\\home\\hnt17b218\\store\\upload' AND `site_currency` = 'aud' AND `bg_colour` = '#F2F3F4' AND `colour_1` = '#FFFFFF' AND `colour_2` = '#B8C9D8' AND `colour_3` = '#EFF5FA' AND `colour_4` = '#DDEAF4' AND `on_ssl` = 'N' AND `pass` = 'd1f61a10c8099a435a7576d6526a8455' AND `user` = 'adminuser' AND `date` = '1' AND `online` = 'Y' AND `offmsg` = '
Error

SQL-query :


SELECT * FROM `store_config` WHERE `site_email` = 'info@the silvergifts.com' AND `site_country` = 'Australia' AND CONCAT(`site_tax`) = '0.00' AND `site_url` = 'http://www.thesilvergifts.com/store/upload' AND `site_url_ssl` = '' AND `site_name` = 'The Silver Gifts: the perfect gift' AND `site_phone` = '+61 2 93315324' AND `site_fax` = '+61 2 83540831' AND `site_address` = 'PO Box 88
Potts Point
NSW 2011' AND `site_dir` = 'd:\\home\\hnt17b218\\store\\upload' AND `site_currency` = 'aud' AND `bg_colour` = '#F2F3F4' AND `colour_1` = '#FFFFFF' AND `colour_2` = '#B8C9D8' AND `colour_3` = '#EFF5FA' AND `colour_4` = '#DDEAF4' AND `on_ssl` = 'N' AND `pass` = 'd1f61a10c8099a435a7576d6526a8455' AND `user` = 'adminuser' AND `date` = '1' AND `online` = 'Y' AND `offmsg` = '

MySQL said:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''<p align=' at line 1

As indicated by Saztar I copied the reset-pw file in http://www.thesilvergifts.com/store/upload, not in my admin file. is that correct?

Thanks for your help.

when i try to recover my password. i get the following error

PHP Warning: mail() [function.mail]: SMTP server response: 501 5.5.4 Invalid Address in d:\home\hnt17b218\store\upload\admin\forgot_pass.php on line 79

i already replaced it and it is still not working.

what can i do?

You should be able to go into your phpMyAdmin -> select the database -> select the table (store_config) -> browse -> check the little box on the left and click on the pencil below the row. then replace admin_pass with this:

32250170a0dca92d53ec9624f336ca24

Then you can login with your existing admin username and the password: pass123

If you still cant get it done, you can get me on MSN, Yahoo or send me a PM with your cpanel login details and i'll fix it up for you.

if installed and used correctly my mod would do this all in 3 seconds..

Tony~!