Opened 9 years ago

Closed 9 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: UI/UX:


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 Changed 9 years ago by anonymous

Needs documentation: unset
Needs tests: unset
Patch needs improvement: unset

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.

comment:2 Changed 9 years ago by Simon G. <dev@…>

Summary: windows app naming bugCase-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:3 Changed 9 years ago by Simon G. <dev@…>

#4492 sounds related

comment:4 Changed 9 years ago by Chris Beaven

Component: UncategorizedDatabase wrapper
Resolution: duplicate
Status: newclosed

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.

Note: See TracTickets for help on using tickets.
Back to Top