EDIT

bug #8790

Updated by Andreas Müller about 4 years ago

This is how to find them: 

 ~~~ 
 SELECT f.id featureId, deb.DTYPE, deb.id, deb.unit_id, deb.feature_id, f.titleCache, mu.titleCache, mu.id unitId, mu.titleCache unit,    deb.* 
 FROM DescriptionElementBase deb INNER JOIN DefinedTermBase f ON f.id = deb.feature_id 
 LEFT OUTER INNER JOIN DefinedTermBase_MeasurementUnit MN ON MN.feature_id = f.id 
 LEFT OUTER INNER JOIN DefinedTermBase mu ON mu.id = MN.recommendedmeasurementunits_id 
 WHERE deb.DTYPE = 'QuantitativeData' AND deb.unit_id IS NULL AND mu.id IS NOT NULL  
 ORDER BY f.id 
 ~~~ 

 Beside fixing immediately we should also have an update script.

Back