0

I have just finished developing an app using CodeIgniter. When I upload it to my Host (Hostgator shared) some of the SQL text is converted to uppercase and rendering the app unusable.

In my database I have two tables client and transaction. When I upload the App to the server client and transaction is replaced with all caps. Obviously this is bad as MySQL queries are case sensitive.

At first I was uploading with FTP and thought FTP was to blame. I then zipped up the app and uploaded the archive, unpacking it on the server shell. Still no joy.

Any ideas on how to fix this? At the moment I just have to go into the server and edit my queries back to lowercase..

Cheers in advance for any ideas..

--Conor

Improve this question

1 Answer 1

Reset to default
1

See lower_case_table_names system variable, maybe it can help you.

Improve this answer
3
  • Is this for correcting the table names within the database. Sorry if I wasn't clear befire but it's the queries in my PHP code that are converted to uppercase once they land on my webserver.
    – jim
    Jun 7, 2010 at 16:26
  • Read the linked reference page, so you can learn what does this system variable. Anyway are you sure that only the queries in php code are converted to uppercase?
    – lg.
    Jun 8, 2010 at 6:31
  • I'll have a look this evening. I'll also chat to Hostgator support. I'm not sure it's only the queries, I only noticed them because they break when in uppercase. I'd say it could be any code.. Strange.
    – jim
    Jun 8, 2010 at 18:39

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .