SQL Syntax from plugin will be broken if MySQL is used

[RaduM]

Hi there if you use MySQL with Trac and this plugin all the SQL syntax will be broken and needs to be changed.

For example:

cursor.execute("SELECT id, name, notes, sort, timestamp, deleted "

"FROM downloader_category " "WHERE id = %s", (id,))

This will break near id = %s because you need to specify the table where ID resides. Something like this:

cursor.execute("SELECT id, name, notes, sort, timestamp, deleted "

"FROM downloader_category " "WHERE downloader_category.id = %s", (id,))

I have changed all the syntax and now works ok.

[radu.micu@…]

model.py updated