Lost user e pass

[ivanisevic82]

Hi! I use WebsiteBaker in a netsons.org hosting service.
So, recently netsons chagend the username...and the user I used when I installed websitebake is not more valid.
Now I am not more able to login in my admin panel...eand I cannot modify the username!

How can I resolve this problem?

Sorry for my english!

Bye!

[kweitzel]

You seem to mix things up a bit ... netsons hosting username has nothing at all to do with your WebsiteBaker installation.

cheers

Klaus

[centran]

I agree that your hosting username has nothing to do with your WebsiteBaker installation.

Can you still view your website? If your entire website isn't working then perhaps when your hosting username changed the database username changed and you where using that username for WebsiteBaker to login into the database with.

Is your entire site not working or just the admin?

[ivanisevic82]

After I modify same option in my database setting (netsons sey to me to do it) my site is viewable again.
So, my site is online perfectly, but I'm not ablo to enter in the admin panel!
I write user e pass and it say that are wrong.
I try to take it with the "forgot you password and user?" and it say that my email is not in database!

I really don't know how to enter in my admin panel again!

Thanks for support!

Bye!

[Ruud]

The help pages have a small section on this.
If you can access your MySQL database through a phpMyAdmin page you could try to use this.

http://help.websitebaker.org/pages/en/faq.php#question_24

Ruud

[ivanisevic82]

Thak you ruud!
Can you help me to find this file?
Where is stored?

Thanks!

[ivanisevic82]

I find the place where execute the SQL statement....

But I have a doubt: I understand that I have to change 'mypass' with my new password and write mi username in "admin".

But I don't understand what I have to write whn it say:

"Adjust prefix_ to the table prefix you have choosen during installation" becouse when I installed WebsiteBaker I leave blank the filed "tabel prefix"

Thank you!

Bye!

PS Maybe I finally done: I write
UPDATE users SET password = md5('mynewpass') WHERE username = "myusername"

And I execute it...after I clear cache and I try, but it didn't work!

How can I do?

What I made wrong?



Is so strange that the database doen't recognize my email!!!

[Ruud]

Does your normal user logon still work?
Can you create new users (using the frontend link on your site)?

It looks to me either you have editted the wrong database (maybe netson changed more than a database username, and forgot to change the phpmyadmin settings), or the database is corrupt, and the admin user cannot be found anymore.

You could try to create a backup (using phpmyadmin export) and install a copy of the site on a local (WAMP/XAMPP) system and try to solve it there.

For the rest.. I'm out of options.

Ruud

[ivanisevic82]

The normal login is the same...it say to me wrong user / pass.
Yes, I created a new user with the fronted link and it login normally.

I'm not able to install a copy of the site on a local (WAMP/XAMPP) system...