Opened 8 years ago

Closed 8 years ago

#968 closed defect (worksforme)

creating ticket causes an OperationalError

Reported by: akaihola Owned by: bobbysmith007
Priority: normal Component: TimingAndEstimationPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.10


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.

Attachments (1)

ticket_create_operationalerror.traceback (11.1 KB) - added by akaihola 8 years ago.

Download all attachments as: .zip

Change History (3)

Changed 8 years ago by akaihola

comment:1 Changed 8 years ago by bobbysmith007

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

"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 8 years ago by bobbysmith007

  • Resolution set to worksforme
  • Status changed from new to closed

Add Comment

Modify Ticket

as closed .
as The resolution will be set. Next status will be 'closed'.
to The owner will be changed from bobbysmith007. Next status will be 'closed'.
The resolution will be deleted. Next status will be 'reopened'.

E-mail address and user name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.