Opened 8 years ago

Closed 8 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:

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 Changed 8 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 8 years ago by Simon G. <dev@…>

  • Summary changed from windows app naming bug to 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:3 Changed 8 years ago by Simon G. <dev@…>

#4492 sounds related

comment:4 Changed 8 years ago by SmileyChris

  • Component changed from Uncategorized to Database wrapper
  • Resolution set to duplicate
  • Status changed from new to 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.

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