move prestashop form server to localhost (mac)

[pfz]

Hi people,

 

steps:

1-backup database.

2-download all folders.

3-create database in myphpadmin in localhost (MAMP)

4-edit values in settings.

 

and open frontoffice or backoffice, error:

"Invalid loadLanguage() SQL query!"

 

suggestions for resolve.

 

[i2imedia]

Hello,

 

Are you sure you have downloaded all of your files correctly? All it does is check if the language file is there;

 

languages/updateLanguages.sql';

if (!file_exists($file)) Tools::dieObject($file);

if (! .... false) die(Tools::displayError('Invalid loadLanguage() SQL query!'));

 

If there is something wrong with your language files or there simply not there it should give this error.

 

Below my comment is my site where I write articles including one about how to move Prestashop you could try following this article. I think you don't need to chmod if you are working on a local mamp server.

 

Please try and follow my article exactly (except for the chmod) and then tell me your results.

 

Just to be sure your site is working on your current host right? What version of Prestashop are you using?

 

Kind regards,

 

T. Barbillion

[Zapoa Multimédia]

The question is old, but I had the same problem today and maybe it can help.

 

The root of the problem was that the database was not ok. I made a database backup from the admin of the shop, but I think a problem occured during the creation of the backup. Then I didn't really check the database and I created a new one in my localhost from this corrupted one. As you can imagine, the table "ps_lang" and some others were missing, so when I tried to launch the website in my internet browser, I had the error "Invalid loadLanguage() SQL query!".

 

Finaly, to solve the problem, just make a backup of the database from phpMyAdmin (or the database system you use) and not from the admin of prestashop.

 

Cheers