Moving shop from live server to localhost

[sergito]

Hi people, i'm working in a new enterprise. It has a working prestashop web platform, and now i want to install it locally. I have the database script creation, obtained with mysqldump. I've replaced all the references to "www.oursite.com" by "my_local_path". Ive created database and configurated Prestashop database user and pass. Everything works ok, i can see prestashop login to control panel, but when prestashop validates my employee user then i get redirected again to login page. I've checked mysql log during the login and i think everything is ok? There are four connections from the correct prestashop database user. I provide the log.

What could be happening? Any help would be grateful

thanks in advance

sql.txt

[MrBaseball34]

Did you go into your Preferences in the admin control panel and set the path to the directory that contained your shop?

We have several and I have them all installed on localhost but in different directories.
For one, I use E:/wamp/www/mechanic, so the PS directory in my Preferences is set to /mechanic/
My documentroot is set to "E:/wamp/www/" in my httpd.conf

Also make sure __PS_BASE_URI__ in your settings.inc.php is set correctly point to your directory:
Here is ours: define('__PS_BASE_URI__', '/mechanic/');

[sergito]

i didn't go to preferences because my login isn't success. When i'm in the relative URL "login.php?redirect=index.php" and put my email and pass, then a get redirected again to "login.php?redirect=index.php". However, my user is correctly validated.

The directories structure of live server are the same as localhost's. Remember, i can see login page tipping "http://localhost/......login.php?redirect=index.php" or tipping "http://localhost/...../admin123". It's supposed that "http://localhost/...../admin123" redirects "http://localhost/......login.php?redirect=index.php", taking a look to login.php script. But i don't understand, in that php code or somewhere else, why i get redirected to "http://localhost/......login.php?redirect=index.php".

[MrBaseball34]

Did you check you .htaccess file to see if there is anything in there that may be causing it to redirect?

[sergito]

well, there aren't any .htaccess into login.php s directory

into the root directory, where "classes", "config" etc are in, there are a .htaccess, but only contains rewriting rules:

# .htaccess automaticaly generated by PrestaShop e-commerce open-source solution
# http://www.prestashop.com - http://www.prestashop.com/forums

# URL rewriting module activation
RewriteEngine on

# URL rewriting rules
RewriteRule ^lang-([a-z]{2})/([0-9]+)\.........
..........

# Catch 404 errors
ErrorDocument 404 /tienda/404.php

and any of them (i think) affects neither "login.php" and "index.php"

thanks for your fast replies

[MrBaseball34]

what version is your shop?

[sergito]

prestashop 1.3.0.3
php-5.2.9
apache_2.2.11
mysql-essential-5.0.77
Windows XP service pack 3

i'll try to put "www.oursite.com" into etc/hosts pointing to localhost, and install original mysql script, but i think i'll achieve the same result.

[svetaines1]

Same problem for me

if I type www.mydomain.com, server redirect me to www.mydomain.com/login.php?redirect=index.php (which is login page to BO).
If I type mydomain.com, everything works fine

[MrBaseball34]

Check your .htaccess file.

[sergito]

ok now i know what is the point of that .htaccess file. Finally we installed prestashop into a subdomain on the remote server. Now we have another problem, which could be related to all of this (i think). The post is at "Configuring & using PrestaShop" forum, and the thread is "Friendly URLs showing not existing products"

[Radu]

sergito try to turn off the friendly urls and then turn it on again. firstly make sure .htaccess is writable by the server

[sergito]

i've tried all of that with no success. In fact, the following url:

http://www.misite.com/1-.html

shows product 1. The following:

http://www.misite.com/2-.html

shows product 2, and son on....


looks like prestashop only have in consideration the id_product, and all the following characters are ignored

[sergito]

and for example, if we have a category with id= 1916, the url:

http://www.misite.com/1916-.html

shows the category page with id=1916

The extension of the file is caught ok, because for example the url:

http://www.misite.com/1916-.hml

shows our shop error page

[Radu]

I understand your problem
I developed a module: http://www.ecommy.com/products/module-prestashop-p-35.html

however that module is comercial, if you have any other questions please let me know.

[sergito]

ok i understand the offer, but i don't understand why mi site has that behaviour

[Radu]

maybe I don't understand your problem so sorry for that offer.

http://www.misite.com/1-.html it is like that in any presta install

am I missing something maybe?

[sergito]

ok in my site, friendly urls doesn't work correctly.

Having a category with id=1916, the following url:

http://www.misite.com/1916-.html

shows products of category 1916. Having a product with id=1, the following url:

http://www.misite.com/1-.html

shows product page with id=1

[Radu]

look here - a random example:
http://www.jolidragon.com/19-recipients'>http://www.jolidragon.com/19-recipients goes to category 19
http://www.jolidragon.com/19- still goes to category 19

this is how default presta is working

for the products:
http://www.jolidragon.com/recipients/270-wine-karafe-carafe-a-vin-klean-kanteen-800ml-inox.html'>http://www.jolidragon.com/recipients/270-wine-karafe-carafe-a-vin-klean-kanteen-800ml-inox.html
or
http://www.jolidragon.com/recipients/270-.html

points to the same product page
-----------

can you explain better on the above example?

[sergito]

then, are you telling me that this behaviour is the standard behaviour of prestashop?

[Radu]

exactly.... that's why I created that module to help my clients I work with avoid indexing issues

[sergito]

wow, then now i understand everything

but in any case, the .htaccess must not be well constructed. With all respect to developers, because i think that prestashop is a good platform, this is a fatal behaviour. Then google will index bad pages, and users may click on:

http://www.misite.com/1-.html

and see product 1

[Radu]

yes... hopefully that will be fixed in the future - and the fix is not impossible as modules like mine prove it.

the problems appear when bad links appear over the internet to your website and google will index it. You may be banned for duplicate content.

however prestashop still remains a good software and there are many websites doing good selling to prove it

[sergito]

yes i think that prestashop is a very good platform and enough for make a good business. Although there are details which suggests that is a relatively young software. I think that the importing process is not very reliable and fast for shops having a big number of products. Actually we have 600 and we are encountering some problems and difficulties.

Very carefully i'm doing changes in the code, but also prestashop lacks of development documentation. A good point is that the code files are well separated and structured i think.

thnaks for your reply

regards

[svetaines1]

Please, someone help me to figure out what should I do.
When I type my domain name with www, Prestashop redirect me to BO control panel http://www.mydomain.com/login.php?redirect=index.php

it is doesn't matter there is htacess file on server or not. Any advice?

[svetaines1]

Still looking for answer:

Why http://www.crystalluna.com/login.php?redirect=index.php, redirecting me to BO control panel.
Is it server configuration problem, o Presta doing something wrong.

As I wrote before, no matter SEO turned on/off or htacess file exist on server or not. Result is same...