Edit History

On 11/19/2024 at 3:07 PM, ipaelo said:

HI,

 

I am trying to update a 1.6.1.24 to 8.2.  I have a problem when the script find a NULL.  I have downloaded latest version of copydata.

Column 'color' cannot be null

MySQL error 1048: Column 'color' cannot be null
Generated by URL '/Backoffice/herramientas/copy_shopdata.php'
with Query 'INSERT INTO `ps_8`.`ps_attribute` (`id_attribute`,`id_attribute_group`,`color`,`position`) VALUES ('51','10',NULL,'42')'

May someone help me, please?

It works for me: NULL is automatically converted into an empty string. It looks like your database has stricter settings. Maybe it is a Mysql vs. MariaDB difference.

Edit: There is now a new version of the package that you can download

On 11/19/2024 at 3:07 PM, ipaelo said:

HI,

 

I am trying to update a 1.6.1.24 to 8.2.  I have a problem when the script find a NULL.  I have downloaded latest version of copydata.

Column 'color' cannot be null

MySQL error 1048: Column 'color' cannot be null
Generated by URL '/Backoffice/herramientas/copy_shopdata.php'
with Query 'INSERT INTO `ps_8`.`ps_attribute` (`id_attribute`,`id_attribute_group`,`color`,`position`) VALUES ('51','10',NULL,'42')'

May someone help me, please?

It works for me: NULL is automatically converted into an empty string. It looks like your database has stricter settings. Maybe it is a Mysql vs. MariaDB difference. Anyway, I have built a version that handles this kind of cases. Can you try it?

copy_shopdata_functions.inc.zip