DannyBoy8406
08-06-2003, 05:34 PM
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
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