[support] duplicate entry key problem

[Neil Coghlan]

I've been pulling my hair out about this all morning.

I have a problem when uploading a file. When I create a node as the site admin, there's no problems.

when I do it as a member with a lower role, I get this:

user warning: Duplicate entry '142-205' for key 'PRIMARY' query: INSERT INTO upload (fid, nid, vid, list, description, weight) VALUES (205, 142, 142, 1, 'hhhgg.doc', 0) in C:\xampp\htdocs\modules\upload\upload.module on line 411.

one difference is that the lower's role's node is going into moderation, thanks to a Rule I made. Is there some way that is interfering and causing this problem. When I go and look at the upload table in phpmyadmin, I see nothing odd about the entry that would cause this issue.

thanks.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20100521/2f7b2360/attachment.html