id_category bug (subtil)

[yguerin]

Dear,

 

Prestashop: 1.6.1.5

ubuntu 14.04

Percona-mysql: 5.5.48

 

Bug: prestashop schema erreor

- some id_category are int(11) and others are INT(10) UNSIGNED

- faulty tables:

-- ps_mapping_code_categories

-- ps_shop

 

Result: unable to forceid during importing the categories file into prestashop

 

Why it is happen: I compute my own numerical id for each categorie and I compute the same for each root (parent) id to be able to link my category tree.

ex: id = 1274667385 => OK

but: id = 3295216051 => error (thank for INT(11))

 

Solution: for those fields from thoses tables change INT(11) for INT(10) UNSIGNED.

 

Thanks to my colleague Eric for helping me to find this bug

 

Ask the QA team to send me a beer, in fact 2, one for me and one form my colleague

I know the QA team will kick the ... of the coder who did not follow the schema/the rule and/or the dba

 

I am able to attach my file if you want.

 

Regards,

 

Yves

 

[musicmaster]

Please report this kind of bugs on the forge (http://forge.prestashop.com/). The Prestashop crew doesn't check this forum.

[yguerin]

Dear,

 

Ok,

 

Regards,

 

Yves