Board logo

u2u problem
timf - 22/3/04 at 09:09 AM

when i try to reply to a u2u i'm getting this error

Duplicate entry '32767' for key 1

any ideas chris


ChrisW - 22/3/04 at 09:47 AM

Strange... no idea but it sounds like a database problem. Is it still doing it now?

Chris


timf - 22/3/04 at 11:09 AM

yep still doing it


macspeedy - 22/3/04 at 11:59 AM

yep


ned - 22/3/04 at 12:10 PM

yep, me too.


ray.h. - 22/3/04 at 12:20 PM

yes me too.I was getting it yesterday but thought it was me.


ChrisW - 22/3/04 at 01:47 PM

Hmmm... ok I'm getting it too Will investigate!

Chris


ChrisW - 22/3/04 at 01:54 PM

Should be fixed! For those of you that were interested, the primary key for the u2u messages table was stored in as a 'smallint[6]', for which the maximum value is 32767. Changed it to int[6] and all seems well

Chris


timf - 22/3/04 at 03:38 PM

cheers Chris


macspeedy - 22/3/04 at 03:59 PM

ko