search

cessda / cessda.cvs.two

Apache License 2.0
0 stars 2 forks source link

Concepts table in the DB contains "null" in URI column #608

Closed pakoselo closed 1 year ago

pakoselo commented 1 year ago

When @Stifo was working on 3 digit system versioning, the system itself wasn't able to generate URI, because of these bugs https://github.com/cessda/cessda.cvs.two/issues/444 and https://github.com/cessda/cessda.cvs.two/issues/484. These bugs were solved, but after the upgrade to 3.0.0, so @Stifo wasn't able to clone the concepts with URIs. We need to solve https://github.com/cessda/cessda.cvs.two/issues/607 and later processed with this one.

Stifo commented 1 year ago

did not find any such concepts:

select * from concept where uri like '%null%'

0 results returned

also there are any null URIs of published concepts:

select * from concept
left join version
on concept.version_id=version.id
where
  concept.uri is null and
  version.status not in ('DRAFT', 'REVIEW');

0 results returned

pakoselo commented 1 year ago

@Stifo @MajaDolinar Probably it was solved by solving additional issues. I am also not able to see them anymore in the DB.