Welcome Guest Login Register Member List
ExpressionEngine Forums
Advanced Search
Username: Password:
Remember Me? forgot password?
You are here: Forum Home  >  Usage  >  Troubleshooting  >  Thread
   
 
Database locked error!
 
MadMax
Posted: 27 January 2009 02:54 AM   [ Ignore ]  
Newbie
Rank
Total Posts:  1
Joined  2009-01-27

I’ve been using tracks on Dreamhost for the past few months and it was working perfectly. When I went to login the other day, I got this error: “Error 500 Internal Server Error”

I looked at my production.log and the SQLite database is throwing “Error: Database locked”.

Can someone help me unlock the database? Thanks in advance.

Max

Profile
 
Reinier Balt
Posted: 27 January 2009 07:30 PM   [ Ignore ]   [ # 1 ]  
Sr. Member
RankRankRankRank
Total Posts:  580
Joined  2006-10-05

I found this trick which creates a new db from the dump of your current, corrupted db. 
I do not use sqlite, so please make a backup before trying

sqlite3 corrupted.db .dump | sqlite3 recovered.db

Profile
 
   
 
 
‹‹ Flash troubles in stats      Correct LDAP login format for openldap server ››

Powered By ExpressionEngine
Template Design By Sonnenvogel.com
Select a theme:

ExpressionEngine Discussion Forum - Version 2.1.2 (20091002)
Script Executed in 0.0943 seconds

Atom Feed
RSS 2.0