search

oaregithub / oare_sql

1 stars 0 forks source link

discourse issues with TC 3 91 #40

Closed Gertrudius closed 5 months ago

Gertrudius commented 1 year ago

https://oare.byu.edu/epigraphies/fee00b3b-fb3b-cb1b-b361-8dcc6b3183a8

seems to be some significant issues with the discourse, both in display and in the data that I'll have to track down.

The spreadsheet for that is sheet2 in: https://docs.google.com/spreadsheets/d/1B7ohIVGcenC9kxzyUZkgQr33SOFUvDVhv__kEnb590Y/edit?usp=sharing

Gertrudius commented 1 year ago

It looks like this stems from virtually all of the discourse units having a single phrase as its ultimate ancestor (uuid = 34373212-0508-42d6-8a20-90a2ce371352). This is clearly erroneous, and I think it must be a result of an error in one of the discourse cleanup sweeps I've done over the years, trying to fix the problem in issue #7.

Gertrudius commented 1 year ago

Also, it looks like two translations are applied from field one on a sentence, and one on a phrase.

SELECT FROM field WHERE reference_uuid IN (SELECT uuid FROM text_discourse WHERE text_uuid = "fee00b3b-fb3b-cb1b-b361-8dcc6b3183a8" ORDER BY obj_in_text); SELECT FROM text_discourse WHERE uuid IN ("43573da1-ca1f-4dfc-83ef-ddf9281c36c9","7a05b4a2-ab9d-4ae1-8a9a-9ee937b53b8c");

Gertrudius commented 5 months ago

I have cleaned up the discourse issues for this text.