Modify

Opened 6 years ago

Closed 6 years ago

#3297 closed enhancement (fixed)

MySQL compatibility

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

Description

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 env_setup.py 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 6 years ago by anderson@…

Please include this in next releases.

comment:2 Changed 6 years ago by vnaum

  • Resolution set to fixed
  • Status changed from new to closed
  • Summary changed from MySQL compatibily to MySQL 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.

Add Comment

Modify Ticket

Action
as closed .
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.