Upgrade prestashop from Github

[MathiasReker]

Hello,

 

I have done a lot of changes to my files without override, so I can't upgrade by auto upgrade.

 

I use to upgrade manually by GitHub. Now I need a little help, since I don't know much about SQL. I am not sure about the database upgrade.

 

This fix: https://github.com/PrestaShop/PrestaShop/pull/7692/files

 

Do I just run this code in SQL on my database?

SET NAMES 'utf8';

ALTER TABLE `PREFIX_address` CHANGE `company` `company` VARCHAR(255) DEFAULT NULL;

Or should i do this part in an other way?

[musicmaster]

I don't know much about upgrading from Github. But I hope I can give you some ideas.

 

There is a "manual upgrade" that was quite popular for older versions.

 

My tool Copy_shopdata is quite good at copying business data while leaving system settings untouched.

 

However, in essence your question leaves me puzzled about what you want. If you have changed files auto upgrade will still run. The problem is rather that it will replace all those modified files. So you will need to apply your changes again in the new version.

[MathiasReker]

Thanks for your reply.

 

I have done a lot of changes, I have edited hundreds of files. So it is not easy to replace those modified files.

 

I really just want to fix the issue from github. Therefor I want to know if I just have to run the code in SQL on my database and then simply make the changes to classes/Address.php.

 

Hope you understand my question now?

 

Best regards

[musicmaster]

That pull request consist of two relevant things:

 - changing the size of company field in the Address table in the database. I am not sure about the SQL command. I would do it myself in Phpmyadmin

 - A change in the file Address.php. As you have extensive experience changing files that shouldn't be a problem.

 

Those changes in the install directory are irrelevant for you.

[MathiasReker]

Thank you, I understand.

 

If any other read this post, also you have to replace PREFIX_ with your prefix database

[tuk66]

I'm not sure if you are on the right way. There are many upgrade SQL queries, but also many PHP code scripts that act during upgrade. Not to mention that some Smarty variables change through versions.

 

From what version on what do you want to upgrade?