Unable to insert data

[MrTomSawyer]

Is there an existing issue for this?

• [X] I have searched the existing issues

Current behavior

I use an 'insert' method but get this:

'Code: 62. DB::Exception: Syntax error: failed at position 1 ('{'): {"id":1,"type":"test","from":"123","body":"test","params":"test","httpCode":123}. Expected one of: Query, Query with output, EXPLAIN, SELECT query, possibly with UNION, list of union elements, SELECT query, subquery, possibly with UNION, SELECT subquery, SELECT query, WITH, SELECT, SHOW CREATE QUOTA query, SHOW CREATE, SHOW [TEMPORARY] TABLES|DATABASES|CLUSTERS|CLUSTER 'name' [[NOT] [I]LIKE 'str'] [LIMIT expr], SHOW, EXISTS or SHOW CREATE query, EXISTS, DESCRIBE query, DESCRIBE, DESC, SHOW PROCESSLIST query, SHOW PROCESSLIST, CREATE TABLE or ATTACH TABLE query, CREATE, ATTACH, REPLACE, CREATE DATABASE query, CREATE VIEW query, CREATE DICTIONARY, CREATE LIVE VIEW query, CREATE WINDOW VIEW query, ALTER query, ALTER TABLE, ALTER LIVE VIEW, ALTER DATABASE, RENAME query, RENAME TABLE, EXCHANGE TABLES, RENAME DICTIONARY, EXCHANGE DICTIONARIES, RENAME DATABASE, DROP query, DROP, DETACH, TRUNCATE, CHECK TABLE, KILL QUERY query, KILL, OPTIMIZE query, OPTIMIZE TABLE, WATCH query, WATCH, SHOW ACCESS query, SHOW ACCESS, ShowAccessEntitiesQuery, SHOW GRANTS query, SHOW GRANTS, SHOW PRIVILEGES query, SHOW PRIVILEGES, INSERT query, INSERT INTO, USE query, USE, SET ROLE or SET DEFAULT ROLE query, SET ROLE DEFAULT, SET ROLE, SET DEFAULT ROLE, SET query, SET, SYSTEM query, SYSTEM, CREATE USER or ALTER USER query, ALTER USER, CREATE USER, CREATE ROLE or ALTER ROLE query, ALTER ROLE, CREATE ROLE, CREATE QUOTA or ALTER QUOTA query, ALTER QUOTA, CREATE QUOTA, CREATE ROW POLICY or ALTER ROW POLICY query, ALTER POLICY, ALTER ROW POLICY, CREATE POLICY, CREATE ROW POLICY, CREATE SETTINGS PROFILE or ALTER SETTINGS PROFILE query, ALTER SETTINGS PROFILE, ALTER PROFILE, CREATE SETTINGS PROFILE, CREATE PROFILE, CREATE FUNCTION query, DROP FUNCTION query, DROP access entity query, GRANT or REVOKE query, REVOKE, GRANT, EXTERNAL DDL query, EXTERNAL DDL FROM, BACKUP or RESTORE query, BACKUP, RESTORE. (SYNTAX_ERROR) (version 22.1.3.7 (official build))'

I have attached a link to my sandbox project where the issue can be seen. As the project is a sandbox I apologize for some little dirty mess in there

Minimum reproduction code

https://github.com/MrTomSawyer/message-publisher/blob/master/src/app.service.ts

Steps to reproduce

1. Create a docker clickhouse container: docker run -d --name clickhouse-server -e CLICKHOUSE_USER=guest -e CLICKHOUSE_PASSWORD=guest -p 8123:8123 yandex/clickhouse-server

2. Clone and start my project

3. Go to postman and hit GET localhost:3001/click

Expected behavior

I expect data to be inserted into clickhouse with no errors

Package version

latest

NestJS version

9.0.0

Node.js version

18.15.0

In which operating systems have you tested?

• [ ] macOS
• [X] Windows
• [ ] Linux

Other

No response

[kenvals]

Faced the same problem. Requires decision

[EricThompson-PeopleReign]

I ran into the same thing. Looked into it and found this: https://github.com/depyronick/clickhouse-client/issues/24

[depyronick]

should be fixed with 2.0.2

@EricThompson-PeopleReign @kenvals @MrTomSawyer

please check and close the issue if it fixes the issue

[depyronick]

closing due to inactivity, feel free to reopen if still occurs