Unique key is actually not unique in t_wbt.csv

scrollmapper / bible_databases

Bible versions and cross-reference databases.

994 stars 347 forks source link

Unique key is actually not unique in t_wbt.csv #13

Closed mhuijser closed 6 years ago

mhuijser commented 7 years ago

Hello,

Thanks for sharing these versions with us, i'm glad they're available this way.

Unfortunately i had a SQL Violations importing t_wbt.csv in my application. The unique verse-id '23064001' doesn't seem to be unique at all ;-)

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '23064001' for key 'PRIMARY'

Kind regards,

Mark Huijser

danielpaul commented 6 years ago

There seems to be a few duplicate IDs for WBT version. In the CSV version atleast. Had to manually fix entries as I imported them to my application.

scrollmapper commented 6 years ago

I'll keep this open until I fix it.

Airistotal commented 6 years ago

I've fixed this and have created a pull request with said fix.

scrollmapper commented 6 years ago

Thank you. Hopefully soon I can do some more work on these databases. Airistotal thank you very much for your contribution and may God bless you for it.