Opened 16 years ago

Closed 16 years ago

#3297 closed enhancement (fixed)

MySQL compatibility

Reported by: anderson@… Owned by: Vladislav Naumov
Priority: high Component: TracUnreadPlugin
Severity: major Keywords:
Cc: Trac Release: 0.11


The creation of the fields must be diffent for MySQL db. To put the fields on the primary key they must have a limitation. So, they can´t be TEXT fields. I have used smaller sizes for the fields because the index key can´t be longer than 1024 bytes. you can increase it if you want but i must not pass 1024 bytes (remember that the db is in utf8_general collation)

This lines on file were modified to work with mysql:

CREATE TABLE trac_unread (

username varchar(50), last_read_on integer, type varchar(50), id varchar(20), UNIQUE (type, id, username)


Attachments (0)

Change History (2)

comment:1 Changed 16 years ago by anderson@…

Please include this in next releases.

comment:2 Changed 16 years ago by Vladislav Naumov

Resolution: fixed
Status: newclosed
Summary: MySQL compatibilyMySQL compatibility

Issue must be fixed in rev3935.

SQL generation code is used now (the same one that Trac uses internally), so all current and future backends should work.

Please test, if possible and re-open this ticket if there are any issues unresolved.

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Vladislav Naumov.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment

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

Note: See TracTickets for help on using tickets.