0000041: Install Crashes with MySQL v4.0 due to inability to handle Collation/Character Set modification on table create. - Mantis for WoW Raid Manager

WoW Raid Manager Defect Tracking System

Mantis Bugtracker

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ Issue History ] [ Print ]

ID

Category

Severity

Reproducibility

Date Submitted

Last Update

0000041

[WoW Raid Manager (WRM)] Installation Failure

crash

always

2008-08-06 10:07

2008-08-20 15:51

Reporter

douglasw

View Status

public

Assigned To

douglasw

Priority

high

Resolution

fixed

Status

closed

Product Version

HEAD

Summary

0000041: Install Crashes with MySQL v4.0 due to inability to handle Collation/Character Set modification on table create.

Description

When creating a table in v4.0 with the DEFAULT CHARACTER SET 'UTF8' COLLATE=utf8_bin tags on the table create, MySQL 4.0 chokes.

This is not supported functionality in 4.0 (seems to work for 4.1) and as such blows up.

Additional Information

Tags

No tags attached.

Relationships

Notes
(0000054) douglasw (administrator) 2008-08-06 10:09	Added a new file "install/alter_tables.sql" which handles altering the table after creation to the UTF8/utf8_bin CharSets. This file is ONLY run if the MySQL version reported from phpinfo is > 4.1.0.

(0000072) douglasw (administrator) 2008-08-20 15:51	Released in v3.5.0 Final

Issue History
Date Modified	Username	Field	Change
2008-08-06 10:07	douglasw	New Issue
2008-08-06 10:07	douglasw	Status	new => assigned
2008-08-06 10:07	douglasw	Assigned To	=> douglasw
2008-08-06 10:09	douglasw	Status	assigned => resolved
2008-08-06 10:09	douglasw	Fixed in Version	=> 3.5.0
2008-08-06 10:09	douglasw	Resolution	open => fixed
2008-08-06 10:09	douglasw	Note Added: 0000054
2008-08-20 15:51	douglasw	Status	resolved => closed
2008-08-20 15:51	douglasw	Note Added: 0000072

Copyright © 2000 - 2008 Mantis Group