Error: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database cakephp

php cakephp cakephp-3.0
softboxkid picture softboxkid · Jul 3, 2015 · Viewed 9.3k times · Source

enter image description here

I don't know how to solve this problem. The problem happened when I deploy this project to production server using Apache web server. I try to change DocumentRoot on Apache webservers. (CakePHP documentation) but still no luck.

But if I run the project under development server using ./cake server command (http://localhost:8765/) it seems ok. I can create, retrieve, update, delete. No database error

enter image description here

Please help me.

Answer

Igor Greg picture Igor Greg · Jul 20, 2015

This issue is also related to another question about cakePhp 3.x

The error comes from the DebugKit plugin, which is activated in your site, as it's obvious by the screenshot. You need to make the file ROOT/tmp/debug_kit.sqlite, writable.

Related questions

SQLSTATE[HY000] [1045] Access denied for user 'username'@'localhost' using CakePHP

I am new to PHP and CakePHP. I am finding problems while wiring my database using CakePHP. Below is my application configuration. I am on Bitnami WAMP stack 5.4.40-0. I am using CakePHP 3.0.4 to create a web MVC application Entry …

Read More
CakePHP 3 Raw SQL Query

I'm using CakePHP 3, I need to run a raw SQL query on multiple tables. In CakePHP 2, this could be done by using the query() method on any model ( $this->Messages->query("select..") ). I need the method that allows …

Read More
How to join multiple tables using CakePHP 3?

I am using CakePHP 3.x. What I want is to be able to call $this->Categories->find() and then join Topics on Topics.cat_id = Categories.id and then join Posts on Posts.topic_id = Topics.id. I …

Read More