Thread

Hi there,

I just changed of hosting and for some reasons I can’t login to the control panel. I don’t have access to the website either.

When I try to login to the CP, it says my username isn’t in the database:

- I looked on phpmyadmin and the username exists (I haven’t changed the password either)
- I tried to retrieve the password with “forgot your password” but it says I can’t send email.
- I looked on phpmyadmin the exp_site data and I changed the urls for the themes, captchas and other urls with the new local path.
- I tried to generate a new md5 password directly on mysql.
- I reset my cache/cookie browser.
- I erased the cache folder under system (keeping the index.html) and set it to 777.

I still doesn’t work.

What am I missing? ... really frustrating.

Thanks!
Vincent

Vincent, did you directly manipulate values in the exp_sites table? Do you still have a copy of the unedited version?

Yes I did manipulate the exp_sites directly.
Yes I still have an unedited version.

Note: I didn’t try to install/upgrade a fresh version.

I imported directly the old website files/folders (I have modified files and used specific folders) then I imported the mysql file under phpmyadmin.

Also since the hosting is different, the server paths aren’t the same.

Thanks for your help !
Vincent

Vincent,

Please revert to that old exp_sites file.  The storage method used for these values (serialized arrays) associates a length with each value.  So manually editing the file will cause it to break.

Once reverted, you can follow these instructions to fix your paths.

Let us know how it works out.

Hi Pascal,

I did what you recommended and it worked. Thanks!

I do have one last problem.
I removed the index.php using the exclude method on my old server.

I transferred my old .htaccess:

RewriteEngine on
RewriteCond $1 !^(google54004ce2236f4bc7|backend|css|data|design|flash|images|js|themes|favicon\.ico|robots\.txt|index\.php) [NC]
RewriteRule ^(.*)$ index.php/$1 [L]

The problem is that every link doesn’t work: the url is right on the browser but the page doesn’t change.
If I’m adding the index.php on the url, it works just fine.

http://en.vincentcordel.com/about/
http://en.vincentcordel.com/index.php/about/

Also I’m using the LG Better Meta plugin and I now have an error I didn’t have before. Any ideas why?

Thanks a lot for your help 😊
Vincent

Any ideas?

Vincent, we try to keep to one problem per thread. Can you post the others to the Plugins and HowTo forums? We don’t provide direct support for .htaccess, and plugin authors usually support their own items.