search

kadowa / papyri

Heidelberg Papyri database administration and catalog interface
1 stars 0 forks source link

[Dem] SQL import warnings #6

Closed kadowa closed 8 years ago

kadowa commented 8 years ago 
mysql> show warnings;
+---------+------+----------------------------------------------------------------------+
| Level   | Code | Message                                                              |
+---------+------+----------------------------------------------------------------------+
| Warning | 1366 | Incorrect integer value: 'IVv.Chr.' for column 'j1hig' at row 16     |
| Warning | 1366 | Incorrect integer value: 'IVv.Chr.' for column 'j1hig' at row 17     |
| Warning | 1366 | Incorrect integer value: 'IIv.Chr.' for column 'j1hig' at row 40     |
| Warning | 1366 | Incorrect integer value: 'III-IIv.Chr.' for column 'j1hig' at row 65 |
| Warning | 1366 | Incorrect integer value: 'III-IIv.Chr.' for column 'j1hig' at row 83 |
| Warning | 1366 | Incorrect integer value: 'III-IIv.Chr.' for column 'j1hig' at row 84 |
| Warning | 1366 | Incorrect integer value: 'III-IIv.Chr.' for column 'j1hig' at row 85 |
| Warning | 1366 | Incorrect integer value: 'Iv.Chr.' for column 'j1hig' at row 159     |
| Warning | 1366 | Incorrect integer value: 'Iv.Chr.' for column 'j1hig' at row 463     |
| Warning | 1366 | Incorrect integer value: 'II' for column 'j1hig' at row 506          |
| Warning | 1366 | Incorrect integer value: 'IIv.Chr.' for column 'j1hig' at row 507    |
| Warning | 1366 | Incorrect integer value: 'IIv.Chr.' for column 'j1hig' at row 562    |
| Warning | 1366 | Incorrect integer value: 'IIv.Chr.' for column 'j1hig' at row 575    |
| Warning | 1366 | Incorrect integer value: 'IIv.Chr.' for column 'j1hig' at row 576    |
| Warning | 1366 | Incorrect integer value: 'IIv.Chr.' for column 'j1hig' at row 581    |
| Warning | 1366 | Incorrect integer value: 'IIv.Chr.' for column 'j1hig' at row 582    |
| Warning | 1366 | Incorrect integer value: 'IIv.Chr.' for column 'j1hig' at row 585    |
| Warning | 1366 | Incorrect integer value: 'IIv.Chr.' for column 'j1hig' at row 630    |
| Warning | 1366 | Incorrect integer value: 'II' for column 'j1hig' at row 654          |
| Warning | 1366 | Incorrect integer value: 'I' for column 'j1hig' at row 697           |
| Warning | 1366 | Incorrect integer value: 'IIv.Chr.' for column 'j1hig' at row 700    |
+---------+------+----------------------------------------------------------------------+

This looks pretty strange – centuries in the Hijri year field. Any idea why this seems to have happened regularly, @jcowey?

jcowey commented 8 years ago

You should not be readings values into any Hijri year fields in Demotic. Hijri fields are only for Arabic.

jcowey commented 8 years ago

In row 27 of the spreadsheet https://docs.google.com/spreadsheets/d/17qnWXpWJO4SBa6ThtPl6CInnoE3ulcWxwTUmc3yX65c/edit#gid=781725049&vpid=A1 there are no fields with such as J2Hig etc.

kadowa commented 8 years ago

You are right, that was my mistake. I used the Arabic field transformations on the Demotic data.