Posts Tagged 1062 – Duplicate entry ’2147483647′ for key 1

Error 1062 – Duplicate entry ’2147483647′ for key 1

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 [...]

, , , ,

No Comments