The problem during the upgrade to 1.7.0.5

[[email protected]]

Appeared this report:

SQL 1.7.0.5 1064 in ALTER TABLE `ps1704_currency` ALTER COLUMN `name` varchar(64) NOT NULL: 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 'varchar(64) NOT NULL' at line 1

 

It can cause problems? What to remedy?

 

Thank you

Radek Tůma

[coolcrazy]

I get when the update of 17.0.5 an MD5 sum does not match message. to see and update him not

[nadie]

I get when the update of 17.0.5 an MD5 sum does not match message. to see and update him not

 

Hi coolcrazy,

Try the following method:

 

Download Zip Prestashop: https://download.prestashop.com/download/old/prestashop_1.7.0.5.zip

 

Upload "ZIP" in 

/folder_admin/autoupgrade/download/

----

 

In the configuration "Module 1 Clik Upgrade"

 

More Options (Expert Mode) (Attached image)

 

 

Click Channel -> Local Archive (Attached image)

 

 

Sorry for my English,

[bellini13]

 

Appeared this report:

SQL 1.7.0.5 1064 in ALTER TABLE `ps1704_currency` ALTER COLUMN `name` varchar(64) NOT NULL: 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 'varchar(64) NOT NULL' at line 1

 

It can cause problems? What to remedy?

 

Thank you

Radek Tůma

 

Apparently PS developers do not know proper SQL statements, or even bother testing...

 

To fix, you need to edit prestashop\install\upgrade\sql\1.7.0.5.sql file before attempting to upgrade.

ALTER TABLE `ps_currency` CHANGE `name` `name` VARCHAR(64) NOT NULL;

[[email protected]]

Installation was complete but with this error only. I think there is no need to modify the SQL at install package and re-run the entire upgrade. Just run this command in the administration of MySQL (phpAdmin):

 

ALTER TABLE `ps1704_currency` CHANGE `name` `name` VARCHAR(64) NOT NULL;

 

in the administration of MySQL. Correctly?

 

Radek Tůma

Edited February 14, 2017 by [email protected] (see edit history)

[bellini13]

No, I believe if you encountered an error during the database upgrade, then the upgrade stops and you should consider it a failure.

[[email protected]]

He did not stop and release increased to 1.7.0.5, reported the upgrades made with 1 error.

[davidddp]

You can try changing it manually from phpMyAdmin:

 

https://cl.ly/343I1S153A2D

[siciliashop2]

Buongiorno , vorrei aggiornare il mio prestashop 1.7.0.5   ad  1.7.1.0 .

Ho seguito l'indicazione di PrestaShop Legend , ma non riesco ad aggiornare.

----------------------------------------------------------

ARCHIVIO LOCALE

Ramo Disponibile

Name: 1.7.1 stable 

URL: https://www.prestashop.com/download/releases/prestashop_1.7.1.0.zip

MD5 hash: 74b159f239e664f96536857e293c7fc2 

Archivio da usare:

prestashop_1.7.1.0.zip

per aggiornare la versione *

Save in the following directory the archive file of the version you want to upgrade to: /admin/autoupgrade/download/
Click "Save" once the archive is there.
This option will skip the download step.

SALVA

 

Confronto delle versioni

PrestaShop versione originale:
Error Unable to check md5 files

Differences between versions:

-----------------------------------------------------------------------------

HO SEMPRE IL SEGUENTE ERRORE

 

potreste aiutarmi

grazie in anticipo

[ksv]

Hi,

 

I got same errors with my Prestashop upgrade from 1.7.0.5 to 1.7.1.1. Anyone know when Prestashop will fix it?