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
After February 6, this site will no longer have Facebook, Twitter, or OpenID sign-in options. Read our announcement about social media SSO support in 2.8 for more info.

Make sure you have a current, valid email address set in your profile and set a password so you can login without it. If you get locked out after that time, you can choose "Forgot Password" to fix it as long as a valid email is on your account.

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.