Opened 4 years ago

Closed 3 years ago

#13510 closed defect (fixed)

Description field not large enough

Reported by: Martijn Zeedijk Owned by: Cinc-th
Priority: normal Component: SimpleMultiProjectPlugin
Severity: normal Keywords:
Cc: Trac Release: 1.2

Description (last modified by Ryan J Ollos)

I have about 10 milestones that I want to show with a ticketQuery in the description of the project. At some point saving will result in an error, although it doesn't show one. It will just show an empty project list instead.

My guess it that I went over 255 chars which is the maximum of the varchar field in the database. This field should be of type text instead.

I changed this myself with

 ALTER TABLE smp_project ALTER COLUMN description TYPE text;

and it seems to work.

Attachments (0)

Change History (4)

comment:1 Changed 4 years ago by Ryan J Ollos

Description: modified (diff)

comment:2 Changed 4 years ago by Ryan J Ollos

Type: enhancementdefect

comment:3 Changed 4 years ago by Ryan J Ollos

For portability we should eliminate all uses of varchar in the tables. An environment upgrade step will need to be added to migrate the schema.

Version 0, edited 4 years ago by Ryan J Ollos (next)

comment:4 Changed 3 years ago by Cinc-th

Owner: set to Cinc-th
Resolution: fixed
Status: newclosed

In 17810:

SimpleMultiProjectPlugin: implemented new permission system, new admin page, unit tests and more.

  • The new permission system uses Trac permissions instead of a private user list
  • Admin page for projects rewritten to use the new permissions and for license reasons
  • Changed field types in SMP database tables from varchar(255) to text (see #13510 for info)
  • Unit tests for new features
  • removal of obsolete code

Refs #13850
closes #13510

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Cinc-th.
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.