Opened 4 years ago

Last modified 4 years ago

#1919 new unknown

Some group descriptions can't be updated

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

Description (last modified by sitatara)

At least the Berlin group (id 77) and the Berlin Art, Language, Culture group (id 1117) are affected.

Might be related to #1850 which still needs some cleanup if I recall correctly.


Related ticket: #1958

Change History (5)

comment:1 Changed 4 years ago by shevek

  • Cc planetcruiser jsfan added

@CC: Could you check if the IdDescription? for group 77 and 1117 is used for a profile?

comment:2 Changed 4 years ago by planetcruiser

well, 77 is a curious case indeed. its IdDescription appears 3 times with the same LanguageId? in table memberstrads. that can't be good. ;)

+--------+------------+---------+--------+--------------+---------------------+---------------------+--------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+----------------------+
| id     | IdLanguage | IdOwner | IdTrad | IdTranslator | updated             | created             | Type   | Sentence                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | IdRecord | TableColumn          |
+--------+------------+---------+--------+--------------+---------------------+---------------------+--------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+----------------------+
| 129679 |          0 |     *** | 104412 |          *** | 2009-06-24 00:51:38 | 2009-06-24 00:51:38 | member | Berlin Berlin Berlin!                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |       77 | groups.IdDescription |
| 297376 |          0 |     *** | 104412 |          *** | 2013-01-26 10:34:27 | 2013-01-07 12:20:56 | member | Berlin!<br />Please have a look for sub-groups of the Berlin group in the wiki of the Berlin group.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |       77 | groups.IdDescription |
| 306554 |          0 |   ***** | 104412 |        ***** | 2013-01-25 22:25:29 | 2013-01-25 22:25:29 | member | Berlin Berlin Berlin!<br /><br />BW does not allow sub-groups (for the moment), so we decided to list some of them here (based on number of members). Feel free to search or create your own Berlin-related sub-groups. And please, NO accommodation requests here, use the emergency sub-group for that (also in this list)<br /><br />Berlin Emergency Host<br />http://www.bewelcome.org/groups/590<br /><br />Berlin Art, Language, Culture<br />http://www.bewelcome.org/groups/1117<br /><br />Berlin-Wedding<br />http://www.bewelcome.org/groups/729<br /><br />Berlin Board Games<br />http://www.bewelcome.org/groups/1059<br /><br />Berlin Neuk�lln<br />http://www.bewelcome.org/groups/296 |       77 | groups.IdDescription |
+--------+------------+---------+--------+--------------+---------------------+---------------------+--------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+----------------------+

any idea how this could happen?

for 1117 everything looks normal:

+--------+------------+---------+--------+--------------+---------------------+---------------------+--------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+----------------------+
| id     | IdLanguage | IdOwner | IdTrad | IdTranslator | updated             | created             | Type   | Sentence                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | IdRecord | TableColumn          |
+--------+------------+---------+--------+--------------+---------------------+---------------------+--------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+----------------------+
| 289835 |          0 |   ***** | 251911 |        ***** | 2012-12-26 18:34:15 | 2012-12-26 17:28:25 | member | Many cultural events take place in Berlin, so let's join them together. Or maybe you have good advice about cultural events in Berlin you would like to share? Then this is the place for you here :)<br /><br />There's also a lot of things going on in Berlin that's not in the mainstream media or that is only known about by word of mouth. This is a group for those things.<br />Festivals, concerts, art exhibitions, plays, book releases, movies, anything of interest!<br /><br />Please feel free to join and enjoy the largest art scene in Europe with right now 650+ galleries and art projects, many good museums and interesting people<br /><br /><p>Logo of the group with kind permission of <a href="http://www.flickr.com/photos/berlincat/">Lucky Cat</a>.</p> |     1117 | groups.IdDescription |
+--------+------------+---------+--------+--------------+---------------------+---------------------+--------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+----------------------+

how could i checked if it is used in a profile? the profile has MANY fields. ;)

another query revealed that duplicate entries with the same language id appear every now and then. the output is too verbose to post it here. if anyone feels like modifying the query to only list entries with the same language id, feel free:

select idtrad, count(*), group_concat(idlanguage) from memberstrads group by 1 having count(*) > 1;

comment:3 Changed 4 years ago by shevek

@77: And it just takes the first one I guess.

@1117: As outlined in #1850 we would need to compare all columns with trad ids with the group descriptions.

comment:4 Changed 4 years ago by sitatara

  • Description modified (diff)

I believe this is the same issue as #1958.

comment:5 Changed 4 years ago by sitatara

  • Component changed from unknown to BW Group
Note: See TracTickets for help on using tickets.