Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error during GEDCOM Import #4698

Closed
webtrees-pesz opened this issue Dec 30, 2022 · 3 comments
Closed

Error during GEDCOM Import #4698

webtrees-pesz opened this issue Dec 30, 2022 · 3 comments

Comments

@webtrees-pesz
Copy link

I get following Error:

SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF0\x9F\x87\xAB\xF0\x9F...' for column 'chunk_data' at row 1 (SQL: insert into wt_gedcom_chunk (gedcom_id, chunk_data) values (1, 0 @I5138@ INDI
1 NAME Elisabeth /GALLINGER/
2 SOUR @S75@
3 OBJE @M4024@
2 SOUR @s273@
3 OBJE @m4169@
1 SEX F
....

How to find out the wrong character?

In Notepad ++ everything looks fine.

image

@fisharebest
Copy link
Owner

This will be a 4-byte UTF8 sequence. Typically an emoji.

Already reported as #2950

I hope to fix this in 2.2.0

How to find out the wrong character?

It could be a flag?

@webtrees-pesz
Copy link
Author

How to find out, which record or better which line is affected?
When I delete the mentioned record, then the error will start with the next one.

@webtrees-pesz
Copy link
Author

I found it with the help of GEDCOM Validator from Chronoplex.

image

image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants