Good day everyone, i dont know where is false that i cannot show infos in DB in my tempelate. (i explain that i want to insert my csv.file to DB and then show Infos from DB) [{"id":"68a0a347.56efbc","type":"tab","label":"Flow 6","disabled":false,"info":""},{"id":"7ba892f.dae406c","type":"debug","…

The error says that you are trying to add a record to a table with a value for a field that is defined as UNIQUE with the same value as one already in the database. I would expect the error to tell you which field that is. If you then look at the data you are trying to insert you should be able to…

How were you able to create a table using your create statement??? TXT is NOT a valid sqlite data type.

Hi Colin, tnx for your Replay. Yes, it is a Continuation of previous thread , i wrote in new topic because i could not write in previous Topic. Yes correct. i understand the meanning of error but i didnt set Primary key and this Error is comming from TIME column of my csv file. Column Time has no…

[image] zenofmud: How were you able to create a table using your create statement??? TXT is NOT a valid sqlite data type. Hi zenofmud, my csvfile out put is utf8. According to " Datatypes In SQLite " i can use txt datatype.

[image] Samira05: i can use txt datatype. Where in there does it mention TXT? It does describe TEXT type.

[image] Samira05: i edited txt and wrote TEXT but i got same error. Did you delete and recreate the table? Show us the schema for the table. If you don't know how to do that, this link shows how. Practical SQLite Commands That You Don't Want To Miss

Please add the following node to your flow and connect it to your sqlite node: [{"id":"d33d8a9.eb8f2f8","type":"inject","z":"68a0a347.56efbc","name":"display CREATE","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"SELECT sql FROM sql…

i do it . aber before that please say me , how can i see my database by cmd. i installed Sqlite3 and run cmd but when i want to see database , that dont show. it mean my DB is not build up.

If you want to use CLI to look at the database, I suggest you take an sqlite tutorial. There are many on the internet and I'm sure you can google some and find them. Meanwhile, it should take you less than 5 minutes to do what I've asked you do so we can see how you created your database and hopefu…

Node-RED

Node-RED Forum

SQLite Error: UNIQUE constraint failed

General

Samira05 6 April 2021 13:13 7

do you mean my error is here? i have set my data and time as text because i got with INT another errors and i saw in some Tutorials that they used TXT.
i edited txt and wrote TEXT but i got same error.

Topic		Replies	Views
Insert csv. file to SQLite General	18	1309	18 March 2021
SQLITE CONSTRAINT Error General	4	944	7 July 2020
Inserting unique entries into SqlLite db from CSV file General	4	730	25 September 2019
"Error: SQLITE_ERROR: no such column: undefined" General	18	4961	7 April 2020
Insert into SQlite database? General	13	4424	11 May 2020

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

SQLite Error: UNIQUE constraint failed

Related topics