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

jim
  • 183
  • 1
  • 7

1 Answers1

1

See lower_case_table_names system variable, maybe it can help you.

lg.
  • 4,649
  • 3
  • 21
  • 20
  • 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 07 '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 08 '10 at 06: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 08 '10 at 18:39