Opened 6 years ago

Closed 6 years ago

#1747 closed bug (invalid)

bug: relation description does not show up on profile

Reported by: crumbking Owned by: shevek
Priority: major Milestone: unassigned
Component: BW Profile Keywords: relation
Cc: planetcruiser, jsfan

Description

I confirmed a relation but the description does not show up on the others profile. see: http://www.bewelcome.org/members/rowo

Change History (10)

comment:1 Changed 6 years ago by shevek

Just checked the profile. I see crumbking in the list of 'Close Friends and Family'.

comment:2 Changed 6 years ago by shevek

@crumbking: Can we close this ticket?

comment:3 Changed 6 years ago by crumbking

Yeah but my relation text does not show up so this is still a bug. If I open http://www.bewelcome.org/editmyprofile and "Family and close friends" I see the text I have written for rowo. So there is something wrong.

comment:4 Changed 6 years ago by shevek

  • Cc planetcruiser jsfan added
  • Owner set to shevek
  • Status changed from new to assigned

Added jsfan and planetcruiser in cc: because I need some info from the production DB.

This is how the relations are gathered from the DB:

SELECT
    specialrelations.Id AS id,
    specialrelations.IdRelation AS IdRelation,
    members.Username,
    specialrelations.Type AS Type,
    specialrelations.Comment AS Comment,
    specialrelations.Confirmed AS Confirmed
FROM
    specialrelations,
    members
WHERE
    specialrelations.IdOwner = $this->id  AND
    specialrelations.IdRelation = members.Id AND
    members.Status in ('Active','ActiveHidden','ChoiceInactive') 

Could we fetch that for Rowo? And than please check the result of this query:

SELECT * FROM `memberstrads` WHERE `IdTrad`=".$IdTrad."  order by id asc

where $TdTrad? would be Comment from the first query.

I fear this is just another hickup because of wrong Trad Ids like in #1850.

comment:5 Changed 6 years ago by planetcruiser

sent results to shevek by mail. "Comment" is 0 for crumbking when seen from rowo's side, and a valid id when seen from crumbking's side. maybe rowo simply didn't write a comment for crumbking?

however, relationship "Type" (CloseFriend, SameRoof etc.) is not set neither by crumbking nor by rowo. maybe that has something to do with it?

comment:6 follow-up: Changed 6 years ago by shevek

@planetcruiser: Thanks.

@crumbking: From the SQL result I would be really surprised if you have something in edit profile :-) Could you send the shown text to planetcruiser so that we check the DB for it and figure where that ends up?

comment:7 in reply to: ↑ 6 Changed 6 years ago by planetcruiser

Replying to shevek:

@crumbking: From the SQL result I would be really surprised if you have something in edit profile :-) Could you send the shown text to planetcruiser so that we check the DB for it and figure where that ends up?

actually i interpret the sql results differently. shouldn't rowo be the one with nothing in the edit fields? am i missing something?

comment:8 Changed 6 years ago by shevek

I'd say the same but crumbking still insists. So he's to only one to shed light on this mystery.

Which migtht just bring us right back to #1868 and/or #1649 if Rowo just accepted and wanted to update later on.

Last edited 6 years ago by shevek (previous) (diff)

comment:9 Changed 6 years ago by crumbking

Okay guys my fault!

The text I see in "edit my profile" shows up in MY profile! So rowo did not wrote something about me.

I always mix this up with comments ;-)

So I guess we can close this?

comment:10 Changed 6 years ago by shevek

  • Resolution set to invalid
  • Status changed from assigned to closed

Could you check the one with the verification comments as well :-)

Note: See TracTickets for help on using tickets.