Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Try Vanilla Forums Cloud product
Vanilla 2.6 is here! It includes security fixes and requires PHP 7.0. We have therefore ALSO released Vanilla 2.5.2 with security patches if you are still on PHP 5.6 to give you additional time to upgrade.

Case sensitive database table names

CsabbencsCsabbencs
edited January 2012 in Development

The name of database tables in Garden contain uppercase letters i.e. 'ActivityType' and are hard-coded. This gives me a headache when porting the database between different platforms.

Since webhosts are not so keen on changing MySQL system variables, I recommend that in next version, pull out every DB table name from the code to a config file as constants. Then people could easily change uppercase to lowercase in db table names if they want to.

Please make the database cross-platform.

Comments

  • By did you move from windows to linux?

    Besides if case is the issue just after a move, changing existing table name would solve the issue. Or using the porter.

    Only a poor host would force lowercase table name on creation, and case sensitive connections.

    Setting table name in config is a poor solution, if the issue is not addressed by ensuring the table names are correct after move, then you really have a shoddy set up, that is going to affect the schema in the future.

    This is a general problem not really vanilla/garden specific.

    also be wary with old, versions of MySQL.

    grep is your friend.

  • CsabbencsCsabbencs
    edited February 2012

    Finally, I didn't find a better way than changing table names to uppercase one by one. It took some time, though.

Sign In or Register to comment.