{"id":315,"date":"2008-11-19T20:29:07","date_gmt":"2008-11-19T19:29:07","guid":{"rendered":"http:\/\/www.malcolmhardie.com\/weblogs\/angus\/?p=315"},"modified":"2025-02-01T03:04:15","modified_gmt":"2025-02-01T03:04:15","slug":"zend-framework-quickstart-and-sqlite","status":"publish","type":"post","link":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/2008\/11\/19\/zend-framework-quickstart-and-sqlite\/","title":{"rendered":"Zend framework Quickstart and SQLite"},"content":{"rendered":"<p>I was building the Zend Framework quick start tutorial example but I kept getting the following error:<\/p>\n<p><span>Message: <strong class=\"highlight\">SQLSTATE<\/strong>[<strong class=\"highlight\">HY000<\/strong>]: <strong class=\"highlight\">General<\/strong> <strong class=\"highlight\">error<\/strong>: <strong class=\"highlight\">14<\/strong> <strong class=\"highlight\">unable<\/strong> <strong class=\"highlight\">to<\/strong> <strong class=\"highlight\">open<\/strong> <strong class=\"highlight\">database<\/strong> <strong class=\"highlight\">file<\/strong><\/span><\/p>\n<p>This was despite the fact that I had correct privileges on the database file.<\/p>\n<p>However it turns out you seem to need write and execute privileges for Apache on the directory that contains your sqlite database (not just the database file itself).<\/p>\n<p>I added them to the containing directory and everything seems to work now. \ud83d\ude42<\/p>\n<p>[<a href=\"http:\/\/www.nabble.com\/ZF-quickstart-not-working--td20383454.html\">Link<\/a>] (Nabble.com and the original source of this solution)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I was building the Zend Framework quick start tutorial example but I kept getting the following error: Message: SQLSTATE[HY000]: General error: 14 unable to open database file This was despite the fact that I had correct privileges on the database file. However it turns out you seem to need write and execute privileges for Apache [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[58,73],"class_list":["post-315","post","type-post","status-publish","format-standard","hentry","category-general","tag-php","tag-zend-framework"],"_links":{"self":[{"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/posts\/315","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/comments?post=315"}],"version-history":[{"count":1,"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/posts\/315\/revisions"}],"predecessor-version":[{"id":1414,"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/posts\/315\/revisions\/1414"}],"wp:attachment":[{"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/media?parent=315"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/categories?post=315"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/tags?post=315"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}