Re: [phpOpenTracker-general] mysql error: duplicate entry

Jan Prieser <[email protected]> Mon, 5 Dec 2005 14:26:10 +0100
Newsgroups gmane.comp.web.phpopentracker.general
Message-ID <[email protected]>
> i just don't know where to start my further investigations. the
> production system just runs fine.

> any hints on this?

i've found the real problem.
The crc32 hashes on 64bit machines don't fit in the int(10) column in
Database because they tend to be larger than 2^31-1
Statistically are 50% of the values in the wrong range, which explains
my symptoms very well.
I've filed a bug on this issue.

Does anyone have an idea how to solve this?

thanks,
jan