On Aug 14, 2007, at 8:24 AM, Eric Dalquist wrote: > Would either of you be able to create a Jira issue detailing the > problem > so we can get this fixed for 2.6.1? > > Thanks, > -Eric > > Sherwin Shaidaee wrote: >> I had the same problem, I had to change the table names to the >> correct >> case. It worked fine after that.
MySQL table-name case-sensitivity depends on the operating system (filesystem really), but is something that seems to bite people a lot, since a lot of people develop on Windows or Macs which have case- insensitive file systems, but then deploy onto UNIX. To solve this longterm, we probably need to either: * beef up a developer style-guide that requires SQL to standardize on either UPPER or lower case for table names (lowercase would be more canonical MySQL) * produce database configuration notes that recommend MySQL users on Unix platforms set 'lower_case_table_names' in my.cnf [1] -- note there are some conversion implications with this approach if you have an existing database, but this is the recommended configuration for InnoDB tables (which most people use to enable transaction support) Thoughts? Jason [1] lower_case_table_names -- Jason Shao Application Developer Rutgers University, Office of Instructional & Research Technology v. 732-445-8726 | f. 732-445-5539 | [EMAIL PROTECTED] | http:// jay.shao.org -- You are currently subscribed to [email protected] as: [EMAIL PROTECTED] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-dev
