I'm am getting a Database Not Writable Error

Here’s the exact error I’m getting
CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database. The SQL statement executed was: UPDATE ‘ub_migrate_steps’ SET “id”=:yp0, “title”=:yp1, “code”=:yp2, “status”=:yp3, “migrated_data”=:yp4, “descriptions”=:yp5, “sorder”=:yp6 WHERE ‘ub_migrate_steps’.”id”=1

1 answer

Profile photo of ubdev Staff 98310.00 $tone May 22, 2020

Hi Prinston, 
We wonder which migration tool version you’re using. 
If you’re using our old script on Github, the Database of this tool uses the SQLLite file at protected/data/ub_tool.db. That issue occurred because you didn’t enable writeable for this database file. To solve that issue, you can try to chmod 777 for the database file at protected/data/ub_tool.db.
You might also need to check your database user’s permission as well. 
Anyway, both the Lite version at Ubertheme and Github used an outdated codebase that might lead to unexpected issues. Please consider using our newer Pro version for better bug fixes and improvements. 
Ubertheme team


Please login or Register to Submit Answer

Written By