Search the web
Sign In
New User? Sign Up
speckcms · Speck CMS
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Hear how Yahoo! Groups has changed the lives of others. Take me there.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Mixed Case Table Names   Message List  
Reply | Forward Message #707 of 830 |
Re: [speckcms] Mixed Case Table Names

> Is their a way within Speck to force all table names to lower case.

Not really no, well, not without modifying a lot of code. I've just had
a look at the MySQL docs and it seems that this particular problem
you're having is due to a different default values for the
lower_case_table_names system variable on Windows and UNIX (on Windows,
table names are forced lower case, not so on UNIX).
http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

Speck uses the same mixed case names throughout the application so once
you set the lower_case_table_names to the same value on both machines
you should be able to copy the data from one machine to the other.


Mark



Fri Feb 16, 2007 3:07 pm

markthickpaddy
Offline Offline
Send Email Send Email

Forward
Message #707 of 830 |
Expand Messages Author Sort by Date

Is their a way within Speck to force all table names to lower case. I am having an issue because on my development mysql environment is linux and my production...
gspearson69
Offline Send Email
Feb 16, 2007
1:46 pm

... Not really no, well, not without modifying a lot of code. I've just had a look at the MySQL docs and it seems that this particular problem you're having is...
Mark Woods
markthickpaddy
Offline Send Email
Feb 16, 2007
3:12 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help