Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question
add comment

1 Answer 1

up vote 1 down vote accepted

See lower_case_table_names system variable, maybe it can help you.

share|improve this answer
    
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. –  Conor H Jun 7 '10 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 '10 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. –  Conor H Jun 8 '10 at 18:39
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.