U4-1632 - MySQL Database Setup - Table Names

Created by Carl Howarth 03 Feb 2013, 12:14:00 Updated by Shannon Deminick 21 Jun 2017, 07:58:15

There appears to be an issue when performing an initial installation when the DB is sitting on a Linux installation of MySQL.

Various parts of the script state that certain tables are not present.

This is due to inconsistancies in naming conventions when referencing the tables. A default Linux installation of MySQL is case sensitive and the installation script sometimes refers to table names using uppercase.

So far this seems to be specific to this installation type. Upgrading from a 4.11.x db does not present the problem.

Many thanks

Carl

Comments

Niels Hartvig 28 Feb 2013, 15:04:26

We don't have any plans to prioritise this in any foreseeable future as there's a valid workaround and MySQL is only used by a small minority of Umbraco users.


Tom Sommer 01 Mar 2013, 13:12:36

The issue can be fixed in several ways.

The basic problem is that before 6.0.0 new MySQL tables were installed as UPPERCASE, which is nolonger the case (and I can't figure out where in the code this changed? or if it was intentional?).

Either this needs to happen again, or the UppercaseIdentifiers() function needs to be removed from MysqlParser.cs so the tables and columns are referenced in the correct case. The problem with removing UppercaseIdentifiers() is that it will break any upgrades of MySQL-Umbraco (since tables in older versions are in uppercase), so something needs to be done at upgrade to 6.0.0 to rename all tables and columns to correct camelCase.

The reason why the upgrade from 4.11.x to 6.0.0 works, is basically that the tables continue to be named in uppercase, combined with UppercaseIdentifiers() being in effect.


Shannon Deminick 21 Jun 2017, 07:58:15

Closing issue due to inactivity - see blog post for details https://umbraco.com/blog/issue-tracker-cleanup/


Priority: Minor

Type: Bug

State: Closed

Assignee:

Difficulty: Normal

Category: Installation

Backwards Compatible: True

Fix Submitted:

Affected versions: 6.0.0

Due in version:

Sprint:

Story Points:

Cycle: