Ticket #1010 (testing defect)

Opened 6 weeks ago

Last modified 4 weeks ago

Size of referrers field exceeds maximum allowed in MySQL

Reported by: BrianKoontz Owned by: BrianKoontz
Priority: high Milestone: 1.3
Component: database Version: 1.3
Severity: major Keywords:
Cc: DotMG

Description

(From MikeS via the wiki):

In latest current release 20100729-r1712 install.php have bug. When use fresh instalation, install.php try create referrer_blacklist and referrers with varchar(300), max is varchar(255), in previous version table have varchar(150).

Change History

Changed 5 weeks ago by BrianKoontz

  • owner changed from unassigned to BrianKoontz
  • status changed from new to assigned

Indeed, 255 is the max size for a varchar prior to MySQL 5 ( reference).

Changed 5 weeks ago by BrianKoontz

(In [1720]) Reduced max varchar size to 255 (required for MySQL < 5). Refs #1010

Changed 5 weeks ago by BrianKoontz

  • status changed from assigned to testing

Changed 4 weeks ago by BrianKoontz

(In [1721]) Missed two instances of varchar(300), changed to varchar(250). Refs #1010

Note: See TracTickets for help on using tickets.