WARNING: concrete5 5.6 and earlier are end-of-life. Sales from the marketplace have now ended. Click here to learn more about this transition.

MySQL Case Insensitive Hell for C5 (version 2)

 

Convert your db tables names from lowercase format to mixedcase (CamelCase)

Because, MySQL lower_case_table_names variable is bad and ugly.

With this migration/repair tool, you can easily fix the problems arising, when you try to migrate your Concrete5 MySQL database from Windows and MacOSX to Linux/Unix-like systems (OS with case sensitive filesystems), by fixing table names.

If after C5 migration, you have messages like this:
'Fatal error: Uncaught exception 'ADODB_Exception' - means that this tool is probably for you.

This add-on is safe and smart - doesn't make changes in your database, or filesystem - only generates SQL patch to rename your tables from lower to case sensitive. Patch is based on your C5 installation, packages and "show tables".

MySQL Case Insensitive Hell can be used as repair tool or daily, for easy site developing on Win/Mac.

According to the MySQL Manual:

"Database and table names are not case sensitive in Windows, and case sensitive in most varieties of Unix. One notable exception is Mac OS X, which is Unix-based but uses a default file system type (HFS+) that is not case sensitive." 
This behaviour have consequences during MySQL Concrete5 migration.

read more: 
http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

 

Purchase

Sales have ended due to EOL

Approved by PRB

Our 30 Day Support Policy

  • Replies to tickets every few days.

Support Hosted

  • On marketplace.concretecms.com