Opened 11 years ago

Closed 11 years ago

# creating ticket causes an OperationalError

Reported by: Owned by: Antti Kaihola Russ Tyndall normal TimingAndEstimationPlugin normal 0.10

### Description

I'm running Trac from trunk, revision 4407 and the timingandestimation plugin revision 1651. Here's the environment:

Python:  	2.4 (#2, Feb 12 2005, 00:29:46) [GCC 3.4.3 (Mandrakelinux 10.2 3.4.3-3mdk)]
Subversion: 	1.1.4
SQLite: 	3.2.2
pysqlite: 	2.0.4


I tried to create a simple ticket with estimated hours 2 and add one hour, and got the OperationalError with the message near "00": syntax error. I'll attach the traceback.

### comment:1 Changed 11 years ago by Russ Tyndall

I grepped for '00' in my source code and also looked at the traceback, and was unable to figure out what was going on.

The only thing I can think of is that maybe your sqlite needs updating.

According to http://trac.edgewall.org/ticket/3669

"sqlite CAST operator breaks things for sqlite<3.2.3)"

As I notice you are below that number, and that I am not experiencing these errors, the best I can say is try an upgrade.

If that doesnt work, please let me know.

### comment:2 Changed 11 years ago by Russ Tyndall

Resolution: → worksforme new → closed

### Modify Ticket

Change Properties