Posts Tagged 1062 – Duplicate entry ’2147483647′ for key 1
Error 1062 – Duplicate entry ’2147483647′ for key 1
Posted by Alex Costa in Easy Tips, Open Source, Web Programming on July 10th, 2009
CRE Loaded was giving me the error 1062 – Duplicate entry ’2147483647′ for key 1 – when trying to add a new product. Cause: for some unexplained reason the auto_increment ID field on Table “products” has gone up to 2147483647 which is apparently the maximum number of rows permitted in an INT column. Fix: Go [...]




