database is locked

[midtoad]

I'm using TurboGears 1.0.4.4 with Sqlite. I've installed registration
0.4 and am trying to register a new user. My User and Group classes
in my project are standard, so the NewUserFields in registration are
identical.

When I try to create a new user, after a short delay I receive the
following error:
http://paste.turbogears.org/paste/2371

I'm not doing anything else with the database, e.g. accessing it with
a 3rd-party database manager, nor running the TG shell.

Any ideas as to what could be going on?

thanks
Stewart

[Patrick Lewis]

Do you know what versions of pysqlite and sqlite you have installed?
Or is it just the standard stuff that comes with python 2.5?

Here's mine:

Python 2.5.1 (r251:54869, Apr 18 2007, 22:08:04)
[GCC 4.0.1 (Apple Computer, Inc. build 5367)] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>> sqlite3.version
'2.3.2'
>>> sqlite3.sqlite_version
'3.3.14'

There have been some instances of this before (not really related to
registration) of people experiencing problems with visit and sqlite,
but no real answers other than playing with the installed versions.
(Search the main TurboGears Google for OperationalError: database is
locked).

[midtoad]

On Mar 31, 6:52 pm, Patrick Lewis <patrickhle...@gmail.com> wrote:
> On Mar 30, 11:49 pm, midtoad <midt...@gmail.com> wrote:
>
> >
> Do you know what versions of pysqlite and sqlite you have installed?
> Or is it just the standard stuff that comes with python 2.5?

here's mine:
Python 2.5.2 (r252:60911, Feb 22 2008, 07:57:53)
[GCC 4.0.1 (Apple Computer, Inc. build 5363)] on darwin

Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>> sqlite3.version
'2.3.2'
>>> sqlite3.sqlite_version
'3.3.14'

Not a lot of difference there!

I'll check on the main TG group for that error. Thanks.

S

[midtoad]

I brought up the issue on the TurboGears discussion group but ended up
solving it myself. See here:
http://groups.google.com/group/turbogears/t/ce433246765a1eb6