Login to Your Account


Login using your Facebook account

Join the Mercury Community

Click on all the boats to prove you're human.


Recent Thread Activity

Suggestions
3 Posts - 329 d 22 h 53 min
Editor used on messages.... change to new one
1 Posts - 389 d 3 h 22 min
Event module ideas / suggestions
1 Posts - 405 d 49 min
ampersand is allowed in username creation, then causes problems...
1 Posts - 409 d 3 h 30 min
duplicate user accounts were created on FTR
2 Posts - 664 d 22 h 31 min
main photo > upload proble > too big, caused error
2 Posts - 664 d 22 h 32 min
content too long on CMS pages
2 Posts - 799 d 3 h 32 min
CMS file name - needs error checking
2 Posts - 799 d 3 h 32 min
auto category image
2 Posts - 864 d 7 h 51 min
change the phrase "you have no friends" to something not so negative
1 Posts - 870 d 2 h 10 min
Group Forums Error on first post
1 Posts - 871 d 12 h 15 min
can't reply to thread more than once or if it's not your turn....
4 Posts - 871 d 12 h 17 min
start new post - needs error checking
2 Posts - 878 d 10 h 40 min
Suggestions
3 Posts - 926 d 7 h 29 min
internal messaging needs editor
5 Posts - 926 d 7 h 38 min
Approve Friend Error
2 Posts - 926 d 7 h 41 min
friend approval process needs checking.....
2 Posts - 926 d 7 h 44 min
problem with link
1 Posts - 935 d 1 h 57 min
Comments
2 Posts - 963 d 5 h 18 min
CAPTCHA updates
3 Posts - 982 d 12 h 56 min
Forums : friends Thread: Approve Friend Error started October 14, 2009, 4:54 am (Not Following)

petemaster5000
MESSAGE
OCT 14 2009 4:10 AM

Jessi got this error when approving a friend req.  it only happened with one out of 7 she approved.  i'm guessing it's because the other person already added her as a friend.

might be worth you looking into.

 

 

http://www.friendsthatride.com/friends/action?FriendRequestId=230&approve=1

Invalid query:
Cannot add or update a child row: a foreign key constraint fails (`friendsthatride/Friends`, CONSTRAINT `fk_Friends_Logins1` FOREIGN KEY (`FriendLoginId`) REFERENCES `Logins` (`LoginId`) ON DELETE NO ACTION ON UPDATE NO ACTION)

Whole query:
insert into Friends (LoginId, FriendLoginId, AddedDateTime) VALUES (3, 0, now())

 


 dan
MESSAGE
NOV 4 2009 6:11 AM

not sure what 's going on there.  it shows a FriendLoginId of 0.  Can you check your code to see how that is possible?  Do you have an override on this piece.  If you are getting to this link from an area that is using the FriendLoginId in another capacity like showing their user stamp then it's probably just an output issue.  If not then I'll have to dig more.