Opened 8 years ago

Closed 8 years ago

Last modified 7 years ago

#3775 closed defect (fixed)

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

Reported by: anonymous Owned by: echo0101
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 7 years ago.
Patch for SQL errors

Download all attachments as: .zip

Change History (3)

comment:1 Changed 8 years ago by anonymous

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

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

Changed 7 years ago by jorrit

Patch for SQL errors

comment:2 Changed 7 years ago by jorrit

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.

Add Comment

Modify Ticket

as closed The owner will remain echo0101.
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.