Opened 10 years ago

Closed 10 years ago

Last modified 9 years ago

#3775 closed defect (fixed)

OperationalError: (1054, "Unknown column 'created' in 'where clause'")

Reported by: anonymous Owned by: Prentice Wongvibulsin
Priority: normal Component: TracTicketStatsPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.10


Oops… Trac detected an internal error:

OperationalError: (1054, "Unknown column 'created' in 'where clause'")

User Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:
Gecko/2008070208 Firefox/3.0.1

Trac: 0.11.1
Python: 2.5 (r25:51908, Sep 19 2006, 09:52:17) [MSC v.1310 32 bit (Intel)]
setuptools: 0.6c8
MySQL: server: "5.0.51b-community", client: "5.0.27", thread-safe: 1
MySQLdb: 1.2.2
Genshi: 0.5.1
mod_python: 3.3.1
Subversion: 1.5.1 (r32289)
jQuery: 1.2.6

Attachments (1)

ticketstats-mysql.patch (2.3 KB) - added by Jorrit Schippers 9 years ago.
Patch for SQL errors

Download all attachments as: .zip

Change History (3)

comment:1 Changed 10 years ago by anonymous

Resolution: fixed
Status: newclosed

I changed the qry by hand.. now it works fine

Changed 9 years ago by Jorrit Schippers

Attachment: ticketstats-mysql.patch added

Patch for SQL errors

comment:2 Changed 9 years ago by Jorrit Schippers

I have attached a patch that fixed some SQL errors for me. I think it has something to do with using MySQL instead of SQLite. I don't know if the patch works with SQLite or PostgreSQL, so please don't apply this blindly to the source.

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Prentice Wongvibulsin.
The resolution will be deleted.

Add Comment

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

Note: See TracTickets for help on using tickets.