How to configure prestashop site from server to localhost?

[newbie_prestashop]

Hello 

 

I am trying to configure(set) Prestashp site from server to localhost. follws prcedure as,

 

1. download all files from server using ftp and export db from live site.

2. copy all files in my localhost directory (localhost/psc_testone)

3. Create db as "psc_testone" and import the database using the phpMyAdmin. 

4. Using PHPMyAdmin and go to the table "ps_configuration" and change 2 line PS_SHOP_DOMAIN and PS_SHOP_DOMAIN_SSL to localhost.

5. In table "ps_shop_url" and change DOMAIN and DOMAIN_SSL  to localhost and physical_uri to /project folder/

6. Updating config settings: config/settings.inc.php and change database name user .

 

after all of this prestashop site not accesible..showing blank site. 

 

how can i set it? is anything missing?

[Bill Dalton]

Can you get to back-office? If you can then try deleting all cache files in,

 

prestashop\cache\smarty\compile

prestashop\cache\smarty\cache

prestashop\themes\your-theme\cache 

[El Patron]

try turning on errors to see what the issue is (blank page)

 

http://www.prestashop.com/forums/topic/224525-how-to-turn-on-error-reporting-for-debug-information/

[newbie_prestashop]

try turning on errors to see what the issue is (blank page)

 

http://www.prestashop.com/forums/topic/224525-how-to-turn-on-error-reporting-for-debug-information/

Download all project files from server using ftp....there is some file related to facebook is failed during download .....ie modules/facebookpsconnect/conf/comman.conf.php is missing not able to download that file ..and also back-office module section not working .

 

If i don't want facebookpsconnect module then from where can i delete that module..my modules not working at back-office..

Edited February 25, 2014 by nileshsonu (see edit history)

[El Patron]

Hi you can delete the module from modules folder using ftp.  (first back it up) and  let's see if that gets you a little farther.

[newbie_prestashop]

Hi you can delete the module from modules folder using ftp.  (first back it up) and  let's see if that gets you a little farther.

I have delete facebookpsconnect dir from module ..back-office is working fine but my front is showing error related to db. like,,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 'AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` ' at line 6