Reply to thread

Message

<blockquote data-quote="Simon2910" data-source="post: 476047" data-attributes="member: 89341">First of all, thanks for updating the link to the sql but I got myself a little problem.So when I try to import the sql into my database I get this error:[CODE]C:\Users\Administrator\AppData\Roaming\DBeaverData\drivers\clients\mysql_8\win\mysql.exe -u root --host=localhost --port=3306 hotelTask 'MySQL restore' started at Mon Jan 02 22:38:34 CET 2023ERROR 1366 (22007) at line 372: Incorrect string value: '\xC3\x84\xC3\xA4ni...' for column `hotel`.`catalog_items`.`catalog_name` at row 2807Task 'MySQL restore' finished at Mon Jan 02 22:38:35 CET 20232023-01-02 22:38:35.322 - IO error: Process failed (exit code = 1). See error log.2023-01-02 22:38:35.322 - java.io.IOException: Process failed (exit code = 1). See error log.&nbsp; &nbsp; at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.validateErrorCode(AbstractNativeToolHandler.java:242)&nbsp; &nbsp; at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.executeProcess(AbstractNativeToolHandler.java:223)&nbsp; &nbsp; at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.doExecute(AbstractNativeToolHandler.java:262)&nbsp; &nbsp; at org.jkiss.dbeaver.ext.mysql.tasks.MySQLNativeToolHandler.doExecute(MySQLNativeToolHandler.java:47)&nbsp; &nbsp; at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.lambda$0(AbstractNativeToolHandler.java:83)&nbsp; &nbsp; at org.jkiss.dbeaver.runtime.RunnableContextDelegate.lambda$0(RunnableContextDelegate.java:39)&nbsp; &nbsp; at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)[/CODE]As you can see on the next photo I'm missing a lot of tables since it stops importing I guess.[MEDIA=imgur]JdDGbyz[/MEDIA]Maybe I missed out on something but I don't think so. Is there something wrong with the sql?Thanks in advance.</blockquote>

[QUOTE="Simon2910, post: 476047, member: 89341"] First of all, thanks for updating the link to the sql but I got myself a little problem. So when I try to import the sql into my database I get this error: [CODE]C:\Users\Administrator\AppData\Roaming\DBeaverData\drivers\clients\mysql_8\win\mysql.exe -u root --host=localhost --port=3306 hotel Task 'MySQL restore' started at Mon Jan 02 22:38:34 CET 2023 ERROR 1366 (22007) at line 372: Incorrect string value: '\xC3\x84\xC3\xA4ni...' for column `hotel`.`catalog_items`.`catalog_name` at row 2807 Task 'MySQL restore' finished at Mon Jan 02 22:38:35 CET 2023 2023-01-02 22:38:35.322 - IO error: Process failed (exit code = 1). See error log. 2023-01-02 22:38:35.322 - java.io.IOException: Process failed (exit code = 1). See error log. at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.validateErrorCode(AbstractNativeToolHandler.java:242) at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.executeProcess(AbstractNativeToolHandler.java:223) at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.doExecute(AbstractNativeToolHandler.java:262) at org.jkiss.dbeaver.ext.mysql.tasks.MySQLNativeToolHandler.doExecute(MySQLNativeToolHandler.java:47) at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.lambda$0(AbstractNativeToolHandler.java:83) at org.jkiss.dbeaver.runtime.RunnableContextDelegate.lambda$0(RunnableContextDelegate.java:39) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122) [/CODE] As you can see on the next photo I'm missing a lot of tables since it stops importing I guess. [MEDIA=imgur]JdDGbyz[/MEDIA] Maybe I missed out on something but I don't think so. Is there something wrong with the sql? Thanks in advance. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members