dacsoft — Fri, 28 Nov 2003 03:11:06 +0000

This comes from reading a NULL from a database into a number field. A NULL is not the same as a 0, so it is interpreted as 2147483648.

Busy — Fri, 28 Nov 2003 01:11:12 +0000

I think I've found the problem, I have so many included files and functions it seems I missed a generate id function, since I have 3 diferent pages calling up similar scripts and using the same db table the generate id function was generating an encrypted value (massive number) and inserting it when I was testing the other scripts.

So hopefully this was the problem
also changed the table from int to mediumint

and the ALTER table worked too, thanks druagord

druagord — Thu, 27 Nov 2003 14:21:09 +0000

if you can the easy way to set back the next autoindex to 0 is to use
"TRUNCATE TABLE yourtable" if you have mysql >3.23.32 between 3.23.28 and 3.23.32 use "TRUNCATE yourtable" CAREFUL this will also empty the table

if you can't empty the table you have to use "ALTER TABLE tbl_name AUTO_INCREMENT = 100" replace 100 to whatever value you need