My experience in upgrading from 1.1.0.5 to 1.2.5.0

[ultraplano]

Hi,


I'd like to share my experience in upgrading PrestaShop, maybe will help someone.
It's a little technical because it requires executing some of the sql update scripts.


I don't know why, but using the installer (that should do exactly the same I believe) didn't work for me.


Here's what I did:

- Before doing anything, BACKUP!! BACKUP!! BACKUP!!

- Download 1.2.5.0 and extract it to a new dir.

- Copy themes, imgs, settings.inc.php and other modified files to the new dir

- Modify the sql upgrade scripts from install folder replacing PREFIX_ with the prefix you have (default "ps_")

- Apply the sql upgrade scripts in order (from 1.1.0.5.sql to 1.2.5.0.sql) to the database


After this, we will have to add more translations and configurations in the BackOffice since there is new features.


Please don't blame me if it doesn't work or it you messed it up! If you backup, you can always restore it.


I'd like to get some feedback from experienced users to see if I'm doing anything wrong.
Thanks in advance and hope it helped someone!


Regards,

Pedro

[prestauser9]

I followed similar steps two weeks ago, after perusing the forum.
One other thing: you have to rebuild your search index (Back Office->Preferences->Search), or searching won't work.

[ultraplano]

Thanks for the tip!

[Mallee Boy]

Can you help me?

Can you explain what you mean by "- Apply the sql upgrade scripts in order (from 1.1.0.5.sql to 1.2.5.0.sql) to the database"

How do I "apply" these scripts?

[ultraplano]

You have to access the database directly with some software (mysql, phpmyadmin, sqlyog, etc.) to apply the sql scripts... if you don't feel comfortable with it, don't try this because you can screw up the database.

[Mallee Boy]

Thanks,

I have a vague idea of what you mean and have used my database directly from time to time. Once the scripts have been added to the database, do you then run the installer as normal?

[ultraplano]

No, just the steps I've written above. Also, check the second post regarding building search index.

[Mallee Boy]

Sorry to bug you, but do you then delete the installer and change the Admin folder as you normally would? Secondly, are you able then to move the whole thing to the root directory? And third, do i need to put my .htaccess file in before hand, since one does not exist?

I appreciate your help. This has been an unbelievable nightmare for so many people.

[Mallee Boy]

I followed similar steps two weeks ago, after perusing the forum.
One other thing: you have to rebuild your search index (Back Office->Preferences->Search), or searching won't work.

Where in the BO preferences is this search? I cant see it among my options.

[Mallee Boy]

Hi,


I'd like to share my experience in upgrading PrestaShop, maybe will help someone.
It's a little technical because it requires executing some of the sql update scripts.


I don't know why, but using the installer (that should do exactly the same I believe) didn't work for me.


Here's what I did:

- Before doing anything, BACKUP!! BACKUP!! BACKUP!!

- Download 1.2.5.0 and extract it to a new dir.

- Copy themes, imgs, settings.inc.php and other modified files to the new dir

- Modify the sql upgrade scripts from install folder replacing PREFIX_ with the prefix you have (default "ps_")

- Apply the sql upgrade scripts in order (from 1.1.0.5.sql to 1.2.5.0.sql) to the database


After this, we will have to add more translations and configurations in the BackOffice since there is new features.


Please don't blame me if it doesn't work or it you messed it up! If you backup, you can always restore it.


I'd like to get some feedback from experienced users to see if I'm doing anything wrong.
Thanks in advance and hope it helped someone!


Regards,

Pedro

Hi, Did you upload your current database for your new installation before or after applying the upgrade scripts?