Opened 17 years ago
Closed 17 years ago
#4557 closed (duplicate)
Case-sensitivity issue with app name when creating database tables on windows
Reported by: | anonymous | Owned by: | nobody |
---|---|---|---|
Component: | Database layer (models, ORM) | Version: | 0.96 |
Severity: | Keywords: | ||
Cc: | Triage Stage: | Unreviewed | |
Has patch: | no | Needs documentation: | no |
Needs tests: | no | Patch needs improvement: | no |
Easy pickings: | no | UI/UX: | no |
Description
If you name an app with capital letters when developing on windows, the table gets built all lower cases. Then when you run syncdb it first thinks the table doesn't exist (because the difference in capitals) then it tries to make the table and you end up with a SQL error.
Change History (4)
comment:1 by , 17 years ago
comment:2 by , 17 years ago
Summary: | windows app naming bug → Case-sensitivity issue with app name when creating database tables on windows |
---|
What database? MySQL right? Another work around is to set lower_case_table_name in your my.cnf/my.ini file.
comment:4 by , 17 years ago
Component: | Uncategorized → Database wrapper |
---|---|
Resolution: | → duplicate |
Status: | new → closed |
It's not likely we'll have our anonymous person back to answer questions or provide more information so for now I'll close as a dupe.
If anyone has more info, feel free to reopen.
Just to clarify first time you run syncdb everything is fine, then if you run syncdb again (for example you added a new app) thats when you get the errors. You can hack this by commenting out the app thats causing problems I think but that is a veryyyyy ugly fix.