Help needed to migrate 1.5.1 from local to server

[davidepanero]

After uploading files, changing settings.inc.php and DB records, when I try to login in BO nothing happens. I have a simple refresh and ask again for user and pass.

 

Hi, I've done the following:

• uploaded file to www.mysite.com/test/myfolder
  
• changed settings.inc.php (_DB_SERVER_,_DB_NAME_,_DB_USER_,_DB_PASSWD_)
  
• added as first line in settings.inc.php define('__PS_BASE_URI__', '/test/myfolder'); because in my file there wasn't that line
  
• manually set table records PS_SHOP_DOMAIN, PS_SHOP_DOMAIN_SSL in table ps_configuration
  

​From BO login form I'm able to retrieve my password, the link works properly and sends me a new password. If I use my old password I get an error, so my new password is correctly been stored in DB.

If I try to open FO I get redirected to my local folder 127.0.0.1/test/myfolder...

 

I really need your help.

Thanks

Edited October 16, 2012 by davidepanero (see edit history)

[mux]

Surely there is something wrong with the configuration or DB. My guess is it's DB problem. Open your DB's sql file with some file editor like notepad++ and search for "127.0.0.1". This may solve your problem

[davidepanero]

Thank you. I will check

[nprashanthlevon]

I too have the same problem which i did not got thisprviously, please help..........

[mux]

have you followed above steps and what error you are facing?

[assisassi]

You need manually set table ps__shop_url

[nprashanthlevon]

just a blank page........and i have gone through the ps__shop_url also, but it was correct only...

 

What i have done is...

 

I have downloaded prestashop newr version in the local xamp server and after doing integration part, i have uploaded the site in to the server , then configured well... still not working.

Edited October 17, 2012 by nprashanthlevon (see edit history)

[cerovic]

Exactly same problem.

 

I ran PS 1.5.1 on localhost . Then I tied to move it to a server and I can not get to BO. When I type wrong email or password, the system shows that there is no such a employ or bad passport.

 

However, when I type correct data, the system just reload the page, so it it impossible to get to BO, even I tied to click to forgot password, then I received new one, then I used it, and the same problem.

 

I successfully did this 20 times with 1.4.X versions and also with 1.5.0.17 two days ago.

 

Is here anybody who successfully moved PS 1.5.1 from localhost to server, or server to server ???

[cerovic]

SOLVED.

MUX were right. I do not know why, but 1.5.1.0 is impossible to move to other serve by old way (just copy and then change PS_SHOP_DOMAIN, PS_SHOP_DOMAIN_SSL either in database or in BO.)

When you want to move 1.5.0.1 you have to:

1. copy files

2. export database

3.change database by Notepad or PSpad or similar program.

4. After that you can import database

5. Upload files

6. DONE

 

NOTE: You have to replace all expansion "localhost" and also "directory name"

For example I replaced:

- localhost - to - mywebsite.com

- /my_directory/ - to - /

(since my PS is in root directory on server)

Edited October 19, 2012 by cerkoxxl (see edit history)

[vynx]

SOLVED.

MUX were right. I do not know why, but 1.5.1.0 is impossible to move to other serve by old way (just copy and they change PS_SHOP_DOMAIN, PS_SHOP_DOMAIN_SSL either in database or in BO.

When you want to move 1.5.0.1 you have to:

1. copy files

2. export database

3.change database by Notepad or PSpad or similar program.

4. After that you can import database

5. DONE

 

NOTE: You have to replace all expansion "localhost" and also "directory name"

For example I replaced:

- localhost - to - mywebsite.com

- /my_directory/ - to - /

(since my PS is in root directory on server)

 

for the step number 3, which file that we need to edit?

also in the note, would you please inform us the file that you change?

[nprashanthlevon]

for the step number 3, which file that we need to edit?

also in the note, would you please inform us the file that you change?

 

After all doing i have got another silly doubt i.e i have the database and files in the same server, why should i change itfrom localhost to the server name?

 

 

What i have known is, it is definitly DB fault

Edited October 18, 2012 by nprashanthlevon (see edit history)

[cerovic]

for the step number 3, which file that we need to edit?

also in the note, would you please inform us the file that you change?

 

So, Step 3 is:

In step 2 you exported database to a file, for example "mydabase.sql".

3.1 - You need to open this file in Notepad or PSpad or similar program. I used PSpad. You can see all data in database.

3.2 -Then press CTRL+H to relapse an expressions.

3.3 - Replace old domain name (in my case it was "localhost") to new domain name (e.g. "mydomain.com")

3.4 - If you did not have you PS root direscory ( in my case - I had my PS in localhost/prestashop/) you need to change this directory to new one (so replace expression "/oldDIR/" to /newDIR/") or if you moving PS to root directory you have to change expression "/oldDIR/" to expression slash ("/"). So the new PS_SHOP_DOMAIN and others link will look like - "mydomain.com/" for root DIR and "mydomain.com/newDIR/" for placing to a directory.

3.5 Save database and import this database.

 

Your FO should run immoderately and sign to BO should not be a problem.

Edited October 19, 2012 by cerkoxxl (see edit history)

[cerovic]

After all doing i have got another silly doubt i.e i have the database and files in the same server, why should i change itfrom localhost to the server name?

 

 

What i have known is, it is definitly DB fault

So you just move PS from sever to same serve and also to same directory? If you change just directory on same server, you have to change databae.

Or form where you move PS and to where???

[nprashanthlevon]

So you just move PS from sever to same serve and also to same directory? If you change just directory on same server, you have to change databae.

Or form where you move PS and to where???

 

What i am suppose to explain is , when i have downloaded the prestashop into my computer, i have installed it in the wamp server, after doing the integration part, i have uploaded the files to my host which the files and the database in the same server. then in the settings.inc file DB_SERVER is as localhost and i just changed Username , password and database name.

 

i have noticed in the database one thing, i have changed the URL to my website.com and then also i am not getting the site as well as backend.. i am getting just a blank page. this has become a major problem...

 

finally i have downloaded theprestashop directly to the hosting server, and craeted a new databse. then it is working...

 

but i want to solve the problem with the help of forum....

[cerovic]

As I mentioned befor, the systém of moving PS you described, worked just on PS 1.4 AND OLDER. In 1.5 you have to folow my previous post.

[timas]

i had the same problem.

 

solution

 

do the same for ps 1.4 and then go to ps_shop_url table and modify the values

 

it worked for me

Edited October 30, 2012 by timas (see edit history)

[alph]

SOLVED.

MUX were right. I do not know why, but 1.5.1.0 is impossible to move to other serve by old way (just copy and then change PS_SHOP_DOMAIN, PS_SHOP_DOMAIN_SSL either in database or in BO.)

When you want to move 1.5.0.1 you have to:

1. copy files

2. export database

3.change database by Notepad or PSpad or similar program.

4. After that you can import database

5. Upload files

6. DONE

 

NOTE: You have to replace all expansion "localhost" and also "directory name"

For example I replaced:

- localhost - to - mywebsite.com

- /my_directory/ - to - /

(since my PS is in root directory on server)

 

need help please,,,

 

how if my PS is not in the root directory on server, i placed it in /my_directory/xxxx ??

and i use subdomain : xxxx.mywebsite.com ....

i have tried but it comes to an internal server error [500]....

Edited October 31, 2012 by alph (see edit history)

[LCSTeam]

need help please,,, how if my PS is not in the root directory on server, i placed it in /my_directory/xxxx ?? and i use subdomain : xxxx.mywebsite.com .... i have tried but it comes to an internal server error [500]....

 

Hi.

I faced the same problem and after much headache, I got the answer. Let us use this site url - store.mywebsite.com/fashion as example.

In ps_shop_url, change the two localhost in domain and domain_ssl to store.mywebsite.com

physical_uri will be /fashion/

In ps_configuration, change both PS_SHOP_DOMAIN and PS_SHOP_DOMAIN_SSL from localhost into store.mywebsite.com

Next, open your settings.inc.php and make this changes -

define('_DB_SERVER_', 'localhost'); //Leave this as localhost, in my case, changing this was the source of my problem. Its different for 1.5//

define('_DB_NAME_', 'xxx');

define('_DB_USER_', 'xxx');

define('_DB_PASSWD_', 'xxx');

 

Replace the xxx with the real data.

 

This should solve your problem. It solved mine and I am just happy to share it!

 

Goodluck!

Edited November 1, 2012 by LCSTeam (see edit history)

[cerovic]

need help please,,,

 

how if my PS is not in the root directory on server, i placed it in /my_directory/xxxx ??

and i use subdomain : xxxx.mywebsite.com ....

i have tried but it comes to an internal server error [500]....

I you web is in xxx.myweb.com/yyy/ than

 

 

Shop domain: xxx.myweb.com

SSL domain: xxx.myweb.com

Base URI: /yyy/

 

Change it in BO in SEOandURLs or in database table ps_configuration searc for PS_SHOP_DOMAIN_SSL, PS_SHOP_DOMAIN and table ps_shop_URL

[PR-MEDiA]

So, Step 3 is:

In step 2 you exported database to a file, for example "mydabase.sql".

3.1 - You need to open this file in Notepad or PSpad or similar program. I used PSpad. You can see all data in database.

3.2 -Then press CTRL+H to relapse an expressions.

3.3 - Replace old domain name (in my case it was "localhost") to new domain name (e.g. "mydomain.com")

3.4 - If you did not have you PS root direscory ( in my case - I had my PS in localhost/prestashop/) you need to change this directory to new one (so replace expression "/oldDIR/" to /newDIR/") or if you moving PS to root directory you have to change expression "/oldDIR/" to expression slash ("/"). So the new PS_SHOP_DOMAIN and others link will look like - "mydomain.com/" for root DIR and "mydomain.com/newDIR/" for placing to a directory.

3.5 Save database and import this database.

 

Your FO should run immoderately and sign to BO should not be a problem.

 

Hi. I'm totally desperate. I did have everything that has been mentioned, but still only get a 500 error.

I have prestashop in root directory. I had modified settings.inc.php, replace all localhosts in sql file, tables PS_SHOP_URL, deleted .htaccess, . I have tried everything and still nothing. Still HTTP 500 (Internal Server Error). - FO/BO.

( PRESTASHOP version 1.5.0.17)

[alph]

Hi.

I faced the same problem and after much headache, I got the answer. Let us use this site url - store.mywebsite.com/fashion as example.

In ps_shop_url, change the two localhost in domain and domain_ssl to store.mywebsite.com

physical_uri will be /fashion/

In ps_configuration, change both PS_SHOP_DOMAIN and PS_SHOP_DOMAIN_SSL from localhost into store.mywebsite.com

Next, open your settings.inc.php and make this changes -

define('_DB_SERVER_', 'localhost'); //Leave this as localhost, in my case, changing this was the source of my problem. Its different for 1.5//

define('_DB_NAME_', 'xxx');

define('_DB_USER_', 'xxx');

define('_DB_PASSWD_', 'xxx');

 

Replace the xxx with the real data.

 

This should solve your problem. It solved mine and I am just happy to share it!

 

Goodluck!

 

 

Thank you for sharing, unfortunately it is not yet solve mine. i got same error[500];

coz i want to use subdomain store.mywebsite.com (without "/fashion").

and I placed my PS in the subfolder "/store" in root (i use root for the main site - mywebsite.com -),,

 

I tell you, I use godaddy; is there are specific subdomain configuration in godady??

this is my subdomain config in godaddy

 

I really need your help, soon

 

Thank You

[LCSTeam]

Thank you for sharing, unfortunately it is not yet solve mine. i got same error[500];

coz i want to use subdomain store.mywebsite.com (without "/fashion").

and I placed my PS in the subfolder "/store" in root (i use root for the main site - mywebsite.com -),,

 

I tell you, I use godaddy; is there are specific subdomain configuration in godady??

this is my subdomain config in godaddy

 

 

I really need your help, soon

 

Thank You

 

Sadly, I am not familiar with godaddy.

 

Try and confirm if your subdomain works without prestashop. Maybe by creating an test.html in the folder "store" and then visiting it by going to store.mywebsite.com/test.html

If it gives an error, the your Prestashop is not the main problem. if it does not, then its the Prestashop.

 

Finally and based on your example, the PHYSICAL URI in the database should be /store/

Edited November 6, 2012 by LCSTeam (see edit history)

[rizvejoarder]

hey,i don,t get PHYSICAL URI? Where i will get?

 

Help me please.

 

thanks

[Visiedo]

Hi. I'm totally desperate. I did have everything that has been mentioned, but still only get a 500 error.

I have prestashop in root directory. I had modified settings.inc.php, replace all localhosts in sql file, tables PS_SHOP_URL, deleted .htaccess, . I have tried everything and still nothing. Still HTTP 500 (Internal Server Error). - FO/BO

 

Same problem here. I followed all the suggested steps and still get an Internal Server Error.

 

I understand that Prestashop is quite a lot based on module contributions from the community, but this kind of things are so basic that I still do not understand how Prestashop neglect including support in the standard release.

[Visiedo]

Looking into the error.log file there is an exception due to incorrect access permissions for the DB user. I am still troubleshooting it. I can access the prestashop DB via phpmyadmin with the same user and password as the one configured at settings.inc.php.

[Franck K.]

SOLVED for me.

 

I tried to migrate my PS 1.5.4 working copy to the production server. I uploaded the files, I imported the DB, I changed DB url values (in ps_configuration and ps_shop_url), but I got a error 500.

 

It was just a stupid little mistake : After the files migration I forgot to reset the directories writing rights. When done : problem solved =D.

[titooooom]

SOLVED for me.

 

I tried to migrate my PS 1.5.4 working copy to the production server. I uploaded the files, I imported the DB, I changed DB url values (in ps_configuration and ps_shop_url), but I got a error 500.

 

It was just a stupid little mistake : After the files migration I forgot to reset the directories writing rights. When done : problem solved =D.

 

Hi

Could you please mention witch directories you have change?

Could you please tell me I you have enter in your database and replace all your www.previous-web.com to the new one?

 

thanks for your help

[benjamin utterback]

Hi

Could you please mention witch directories you have change?

Could you please tell me I you have enter in your database and replace all your www.previous-web.com to the new one?

 

thanks for your help

 

The database tables you need to change are in ps_configuration and ps_shop_url .. you do need to replace it with the current URL. All of this should be tested on a duplicate localhost to test the changes.

 

What is your permission set now?

[surfgimp]

I was in the same situation. Updated the tables to replace 127.0.0.1 with domain and changed db settings in inc file. Removed .htaccess but still had 500 error.

 

Found how to turn on error reporting

 

http://www.prestashop.com/forums/topic/224525-how-to-get-debug-information-for-500-error-or-blank-page/

 

Refreshed page and it was a simple case of wrong permissions on the cache folder. Made those writable and away to go site is back up and running.