PDA

View Full Version : mysql error number: 1062


Heaven
10-13-2003, 10:20 AM
Anyone know how I can fix this:

Invalid SQL: UPDATE user SET lastactivity=1066044518,inforum='14' WHERE userid='1'
mysql error: Duplicate entry '14' for key 4

mysql error number: 1062

It seems to only occur in one forum.

Xenon
10-13-2003, 02:21 PM
hmm, inforum shouldn't be a key iirc.

open phpmyadmin, go to usertable and remove the key of inforum column.