Modify ↓

Opened 16 years ago

Closed 16 years ago

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

Description

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:1.9.0.1)
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 15 years ago.
Patch for SQL errors

Download all attachments as: .zip

Change History (3)

comment:1 Changed 16 years ago by anonymous

Resolution: → fixed
Status: new → closed

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

Changed 15 years ago by Jorrit Schippers

Attachment: ticketstats-mysql.patch​ added

Patch for SQL errors

comment:2 Changed 15 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
Action
as closed The owner will remain Prentice Wongvibulsin.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment

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

Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.