{"id":889,"date":"2022-08-30T15:08:52","date_gmt":"2022-08-30T15:08:52","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2013\/11\/09\/zend-framework-tutorial-i-keep-getting-sql-error-unknown-database-collection-of-common-programming-errors\/"},"modified":"2022-08-30T15:08:52","modified_gmt":"2022-08-30T15:08:52","slug":"zend-framework-tutorial-i-keep-getting-sql-error-unknown-database-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2022\/08\/30\/zend-framework-tutorial-i-keep-getting-sql-error-unknown-database-collection-of-common-programming-errors\/","title":{"rendered":"Zend Framework tutorial &#8211; I keep getting sql error-Unknown database-Collection of common programming errors"},"content":{"rendered":"<p>Have another look at the quick start, you&#8217;re using the wrong adapter<\/p>\n<pre><code>resources.db.adapter = \"PDO_SQLITE\"\nresources.db.params.dbname = APPLICATION_PATH.\"\/..\/data\/db\/guestbook.db\"\n<\/code><\/pre>\n<p>APPLICATION_PATH is set in the index.php file in the \/public directory<\/p>\n<p>Edit :<\/p>\n<p>As you&#8217;ve pointed out that you&#8217;re using MySQL then the adapter is correct and the dbname is wrong. Have a look what the database you are using is called and change config. It&#8217;s currently looking for a database in your file system not in your MySQL database.<\/p>\n<p id=\"rop\"><small>Originally posted 2013-11-09 22:54:56. <\/small><\/p>","protected":false},"excerpt":{"rendered":"<p>Have another look at the quick start, you&#8217;re using the wrong adapter resources.db.adapter = &#8220;PDO_SQLITE&#8221; resources.db.params.dbname = APPLICATION_PATH.&#8221;\/..\/data\/db\/guestbook.db&#8221; APPLICATION_PATH is set in the index.php file in the \/public directory Edit : As you&#8217;ve pointed out that you&#8217;re using MySQL then the adapter is correct and the dbname is wrong. Have a look what the database [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,8],"tags":[],"class_list":["post-889","post","type-post","status-publish","format-standard","hentry","category-uncategorized","category-zend-framework"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/889","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=889"}],"version-history":[{"count":1,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/889\/revisions"}],"predecessor-version":[{"id":8887,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/889\/revisions\/8887"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=889"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=889"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=889"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}