{"id":214,"date":"2010-11-27T14:37:36","date_gmt":"2010-11-27T14:37:36","guid":{"rendered":"https:\/\/greladesign.co\/blog\/?p=214"},"modified":"2011-01-05T23:50:14","modified_gmt":"2011-01-05T23:50:14","slug":"unique-as-column-name-in-sqlite-table-and-sqlerror","status":"publish","type":"post","link":"https:\/\/greladesign.co\/blog\/2010\/11\/27\/unique-as-column-name-in-sqlite-table-and-sqlerror\/","title":{"rendered":"\u2018unique\u2019 as column name in SQLite table and SQLError"},"content":{"rendered":"<p>Hi,<\/p>\n<p>I have just learned that &#8220;unique&#8221; is not a good name for column name when creating table. If you try to use it then you will get following meaningless (at least to me) error:<\/p>\n<p> <code>SQLError: 'Error #3115: SQL Error.', details:'near 'BOOLEAN': syntax error'<\/code><\/p>\n<p>So whenever you will have similar error and at first glimpse everything looks fine then check your column IDs.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, I have just learned that &#8220;unique&#8221; is not a good name for column name when creating table. If you try to use it then you will get following meaningless (at least to me) error: SQLError: &#8216;Error #3115: SQL Error.&#8217;, &hellip; <a href=\"https:\/\/greladesign.co\/blog\/2010\/11\/27\/unique-as-column-name-in-sqlite-table-and-sqlerror\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":""},"categories":[17,47,9,58],"tags":[12,57,51,54],"_links":{"self":[{"href":"https:\/\/greladesign.co\/blog\/wp-json\/wp\/v2\/posts\/214"}],"collection":[{"href":"https:\/\/greladesign.co\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/greladesign.co\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/greladesign.co\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/greladesign.co\/blog\/wp-json\/wp\/v2\/comments?post=214"}],"version-history":[{"count":4,"href":"https:\/\/greladesign.co\/blog\/wp-json\/wp\/v2\/posts\/214\/revisions"}],"predecessor-version":[{"id":237,"href":"https:\/\/greladesign.co\/blog\/wp-json\/wp\/v2\/posts\/214\/revisions\/237"}],"wp:attachment":[{"href":"https:\/\/greladesign.co\/blog\/wp-json\/wp\/v2\/media?parent=214"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/greladesign.co\/blog\/wp-json\/wp\/v2\/categories?post=214"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/greladesign.co\/blog\/wp-json\/wp\/v2\/tags?post=214"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}