MyBB Community Forums

Full Version: SQLite database locked, brings down forums
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I'm hosting these forums on a VPS: http://arucombatgames.uk.to/

Occasionally when you try to access the site, rather than an instant response you are waiting up to a minute for a response. Eventually, PHP times out and sends back a PHP stack trace (only because I currently have display_errors set to 'on').

Unfortunately, I didn't have error logging for PHP enabled at the time, nor did I think to take a screenshot. However, the essence of the error was this: SQLite database file locked.

From the Admin Dashboard:

MyBB Version: 1.4.4
PHP Version: 5.2.6-2ubuntu4
SQL Engine: SQLite 4

I didn't think SQLite 4 existed! Surely this should say version 3?!

I am going to install a MySQL server and move over to that shortly as I don't want this bug to make my site inaccessible. It's a shame because SQLite is a conveniently small and quick database.
Looks like a hosting problem.
(2008-12-05, 05:59 PM)destroyer Wrote: [ -> ]Looks like a hosting problem.

Such as? I'm running a default installation of Ubuntu Server 8.10 with the latest stable versions of lighttpd and PHP with FastCGI support.
I haven't had problems running MyBB on SQLite. Running Ubuntu 8.10 with apache and php on my dev server
Interesting, I was frequently receiving lock-ups. I have switched to MySQL now.
I have check your site but I didn't found any error.
Probably because this thread is 2 months old so he might have sorted it by now.

Rolleyes