vendredi 4 septembre 2015

unable to insert json data to sqlite3 db table

I am trying to insert a json data into sqlite3 db table and getting an error:

Error: near line 1: unrecognized token: "1d"

this is the query:

update dashboard set data='{"annotations":{"list":[]},"editable":true,"hideControls":false,"id":30,"nav":[{"collapse":false,"enable":true,"notice":false,"now":false,"refresh_intervals":["5s","10s","30s","1m","5m","15m","30m","1h","2h","1d"],"status":"Stable","time_options":["5m","15m","1h","6h","12h","24h","2d","7d","30d"],"type":"timepicker"}]}' where where title='TEMPLATE';

Any ideas what be causing this?

Aucun commentaire:

Enregistrer un commentaire