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.