error when upgrade to 1.7.4.0 from ps 1.7.3.0

[TiaNex Shopping]

[ERROR] PHP 1.7.0.0 /* PHP:ps1700_stores(); */

 

SQL 1.7.0.0 1267 in /* Save the new IDs */ UPDATE `ps_tab_transit` tt SET `id_new_tab` = ( SELECT `id_tab` FROM `ps_tab` WHERE CONCAT(`class_name`, COALESCE(`module`, '')) = tt.`key` ): Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

[kratek]

Hey, did you fix this problem? @irder

[TiaNex Shopping]

17 minutes ago, kratek said:

Hey, did you fix this problem? @irder

sorry,i have forgotten how i solve this problem,

 

[kratek]

@irder Have you tried to upgrade on php 7.0?
Maybe should I change it to a higher one?

[TiaNex Shopping]

20 minutes ago, kratek said:

@irder Have you tried to upgrade on php 7.0?
Maybe should I change it to a higher one?

yes,the php version is 7.0.33

[kratek]

@irder maybe will you remember how to solve it?

[TiaNex Shopping]

12 minutes ago, kratek said:

@irder maybe will you remember how to solve it?

maybe you can try to clear the  

content of table  ' ps_tab' , 'ps_tab_lang' 

,and insert new from sql files,  please backup first,

 

Edited April 12, 2019 by irder (see edit history)

[kratek]

@irder thank's it works

[TiaNex Shopping]

On 4/12/2019 at 8:00 PM, kratek said:

@irder thank's it works

you are welcome,

 

[carlossdl]

On 4/15/2019 at 9:27 AM, irder said:

you are welcome,

 

 

On 4/15/2019 at 9:27 AM, irder said:

you are welcome,

 

 

On 4/12/2019 at 12:23 PM, irder said:

maybe you can try to clear the  

content of table  ' ps_tab' , 'ps_tab_lang' 

,and insert new from sql files,  please backup first,

 

Hi @irder and @kratek,

 

I am getting the same error when migrating my prestashop... Could you explain what was the solution? I post my questions here:

1- Clear the contents of tables ps_tab and ps_tab_lang

2- Insert new from sql files -> can you explain where can I get the new records to insert?

 

Thanks!

Carlos.