Opened 6 years ago

Closed 6 years ago

Last modified 5 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


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 5 years ago.
Patch for SQL errors

Download all attachments as: .zip

Change History (3)

comment:1 Changed 6 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 5 years ago by jorrit

Patch for SQL errors

comment:2 Changed 5 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 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.