comelsacarlos Posted March 14, 2013 Share Posted March 14, 2013 Clear installation 1.5.3.1 import: categories manufacturers products combinations After installing and configuring layered navigation, this not works with products with ID > 2147483647 You can test importing 10 products with ID >2147483647 forcing ID and combinations. Please help me thank you in advance! Carlos Link to comment Share on other sites More sharing options...
vekia Posted March 15, 2013 Share Posted March 15, 2013 its all because maximum integer (INT) value is 2147483647 it is a 2^31 more about numeric types you can read here: http://dev.mysql.com/doc/refman/5.0/en/integer-types.html It is therefore the maximum value for variables declared as int in many programming languages running on popular computers, and the maximum possible score, money etc for many video games. The appearance of the number often reflects an error, overflow condition, or missing value etc. in this case you can use BIGINT not INT col type in your mysql tables related to combinations. Why BIGINT? because minimum value of bigint is -9223372036854775808 and maximum 9223372036854775807 ))) Link to comment Share on other sites More sharing options...
comelsacarlos Posted March 15, 2013 Author Share Posted March 15, 2013 (edited) Thak you!! so, i have to change the type INT to BINGINT in all tables in prestashop? I think is a php error in module block layered navigation?, could be? thanks!! Edited March 15, 2013 by comelsacarlos (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts