I'm having issues on my live server with case sensitive table names.
When I did the install, all the tables were created with lower case table names, but all the SS queries use camel case table names
eg.
SELECT `SiteTree`.*, `GhostPage`.*, `Calendar`.*, `CalendarEvent`.*, `Reader`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `UserDefinedForm`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `Calendar` ON `Calendar`.ID = `SiteTree`.ID LEFT JOIN `CalendarEvent` ON `CalendarEvent`.ID = `SiteTree`.ID LEFT JOIN `Reader` ON `Reader`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID LEFT JOIN `UserDefinedForm` ON `UserDefinedForm`.ID = `SiteTree`.ID WHERE (HomepageForDomain REGEXP '(, ^) *guidinglight\.co\.nz *(,|$)') ORDER BY Sort LIMIT 1 | Table 'guidingl_ss.SiteTree' doesn't exist
So on my live server the site isn't working as it can't find the table SiteTree, even though the table sitetree is there.
I did some research and found that there is a mysql setting for lower case table names, but the problem is I am on a shared server, so I'm not sure how to change this.
Any suggestions on what I can do to fix this?