SQL help....

[DannyBoy8406]

alright....i posted this somewhere else, but now i realize it should have gone in here.....sorry, I'm new at this and just learning my way around here.....

I installed the "Member Photo Gallery" hack and to post member's photos you have to run an SQL query:

INSERT INTO photogallery VALUES (xxx, 'full-photo-URL', 'thumb-photo-URL', '');


xxx is replaced by the user id of the member.....




what query would you run to change a member's picture or delete it from the table?

When I try to put in a different photo, this is what I get...

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: INSERT INTO photogallery VALUES (5, 'http://www.wb-devotions.com/avatar.php?userid=5&dateline=1060140488', 'http://www.wb-devotions.com/avatar.php?userid=5&dateline=1060140488', '');

mysql error: Duplicate entry '5' for key 1

mysql error number: 1062