On Wed, 23 Apr 2008 07:53:35 -0700 (PDT), lawpoop@gmail.com wrote:
> On Apr 22, 4:25 pm, "Rik Wasmus" <luiheidsgoe...@hotmail.com> wrote:
>> My first guess (and almost certainly the correct one) is:
>> - the UNIQUE is NOT defined properly, or there are more then 1 UNIQUE keys
>> defined on the same table.
>>
>> My second and final farfetched guess is:
>> - client-id is erroneously defined as float and there are float troubles
>> (in which case not security but mere shame client-id was defined as a
>> float would prevent me from posting the table definition).
>>
>> No more guesses will be made from here on by me. Without a table
>> definition, I leave you to the people with better crystal balls.
>
> Those are good guesses, and I appreciate your assistance. I'm probably
> coming off as smarmy, but I'm just relaying information.
>
> All I asked originally was if
> "Am I getting the error because my UNIQUE key is too long? "
> "Is there a way to actually look at the values for the keys in my
> table? "
>
> If you are choosing to answer more than "No, no", then I appreciate

It's probably more "not in this case from the visible sample, no", but
that doesn't change this instance. Unique keys can get kind of funny
when you're dealing with large objects. But the hash you've chosen
indicates that you've probably intentionally sidestepped that issue.

> your willingness to go the extra mile to help me troubleshoot me
> troubleshoot my problem, and I apologize that I could not provide the
> additional information. It's not my decision to make.

See, now THAT is a fine reason not to share the structure. "Can't, for
internal political reasons. Thanks for your time" is always acceptable,
as are NDAs or even "don't feel like it". The price for those things is
that we can't give much help, and that's usually a pretty small price.
Very few folks here know anything that's not in the doco anyway; we
(collectively) just may be able to cross-corollate faster than one brain
does in a particular instance.

--
Revenge is an integral part of forgiving and forgetting.
-- The BOFH