Issue 14030
'Member since' column missing some values in participant list
14030
Reporter: feedback bot
Assignee: mdoering
Type: Bug
Summary: 'Member since' column missing some values in participant list
Description: The column showing 'member since' is blank for several Participants.
Priority: Critical
Resolution: Fixed
Status: Resolved
Created: 2013-09-24 11:34:16.495
Updated: 2014-01-20 16:27:40.533
Resolved: 2014-01-20 16:27:40.505
Author: ahahn@gbif.org
Comment: This relates to the IMS information import; need to show at least the year, better the full date, for all participants. Current issue, if I understand correctly, is a data type incompatibility between the two systems
Created: 2013-09-25 17:30:08.006
Updated: 2013-09-25 17:30:08.006
Author: thirsch@gbif.org
Comment: Actually year would be fine, but need to have a value for all participants to avoid confusion
Created: 2013-09-26 19:30:52.906
Updated: 2013-09-26 19:30:52.906
Author: ahahn@gbif.org
Comment: After having been fixed at some point, the issue reappeared at http://www.gbif.org/participation/list: The 2013 values are missing again.
Created: 2013-10-28 12:11:33.994
Updated: 2013-10-28 12:11:33.994
Author: thirsch@gbif.org
Comment: Just to clarify, the missing ones are Chinese Academy of Sciences (2013), the European Environment Agency (2010) and Vertnet (2013).
Created: 2013-10-28 14:04:40.107
Updated: 2013-10-28 14:04:40.107
Author: omeyn@gbif.org
Comment: [~cvizitiu@gbif.org] also interesting for you
Created: 2014-01-20 11:48:47.444
Updated: 2014-01-20 11:48:47.444
Author: mdoering@gbif.org
Created: 2014-01-20 15:32:10.481
Updated: 2014-01-20 15:32:10.481
the live drupal db seems to be fine.
The mapper sql query returns the year correctly too.
{noformat}
mysql> SELECT p.ParticipantID AS imsId, c.ISO2 AS country, n.Name_Full AS title, p.Name_Full AS participantTitle, p.Name_Short AS abbreviation, n.URL AS homepage, p.Name_Full AS participantTitle, p.Member_AsOf AS participantSince, p.PublicDescription AS description, null AS modified, i.Name AS institution, i.Address AS address, i.City AS city, i.ZipCode AS postalCode, i.State AS province, i.Telephone AS phone, i.Email AS email, p.GBIFmembership, null AS Region, p.MOU2012_Date AS MOU2012_Date FROM gbifims_Node n JOIN gbifims_Participant p ON n.ParticipantID = p.ParticipantID LEFT JOIN gbifims_Country c ON p.CountryID = c.CountryID LEFT JOIN gbifims_Institution i ON p.InstitutionID = i.InstitutionID WHERE p.ParticipantID = 361;
+-------+---------+---------+------------------+--------------+----------+------------------+---------------------+---------------------+----------+----------------------------+---------+------+------------+----------+-------+-------+-----------------------------+--------+---------------------+
| imsId | country | title | participantTitle | abbreviation | homepage | participantTitle | participantSince | description | modified | institution | address | city | postalCode | province | phone | email | GBIFmembership | Region | MOU2012_Date |
+-------+---------+---------+------------------+--------------+----------+------------------+---------------------+---------------------+----------+----------------------------+---------+------+------------+----------+-------+-------+-----------------------------+--------+---------------------+
| 361 | NULL | VertNet | VertNet | VertNet | | VertNet | 2013-08-01 12:00:00 | http://vertnet.org/ | NULL | Information not available | | | | | | | Other Associate Participant | NULL | 2013-08-17 12:00:00 |
+-------+---------+---------+------------------+--------------+----------+------------------+---------------------+---------------------+----------+----------------------------+---------+------+------------+----------+-------+-------+-----------------------------+--------+---------------------+
1 row in set (0.00 sec)
{noformat}
But the ws still returns it wrongly, bypassing varnish:
http://jawa.gbif.org:8080/b_registry-ws/node/d205def7-82c3-472a-be4b-31d11dcd51fd