MySQL Roll Out Error

This is a shorty but it was kind of irritating. It turned out to be a MySQL error that only occurred on my production server. Presumably this was because the version of MySQL was either different or configured differently on the production server as on my local development box. Either way it’s an easy work-around that I won’t have to deal with in the future.

Variable arguments in SQL statements are case sensitive on my production server but not on my development box. So, SELECT * FROM table_name; is not the same as SELECT * FROM Table_name. I had changed the naming convention to ‘everything lowercase’ midway through development, so some of my calls didn’t reflect this change. In the future, I’ll just make sure everything is of the correct case.

Leave a Comment

Your email address will not be published.