Quote:
Originally Posted by Antivirus
MySQL Error : Duplicate entry '1-0' for key 2
Error Number : 1062
Because (when giving reputation for feedback), the post id is entered as '0'.
I know that I could change the type of the index from unique to normal and my problem would likely go away, however it's likely that would screw up some of the default functionality of vbulletin, wouldn't it?
Does anyone have an idea of how to work around this issue? it's been stumping me for the entire day... 
|
It would screw up the functionality, vb uses an insert ignore statement for reputation entries, which means new rows which violate the unique condition do not get entered.
There is no work around with the schema you are using. I suggest creating an entirely new table for your feedback reputation
08-20-2007, 06:27 AM
Threaded Mode