Martijn Moeling wrote: > Hi, > > I have a weird problem. > > (Mysql) > > When I do a create_all(), i get the error : > > File > "/Library/Python/2.6/site-packages/SQLAlchemy-0.5.8-py2.6.egg/sqlalchemy/engine/base.py", > line 931, in _handle_dbapi_exception > raise exc.DBAPIError.instance(statement, parameters, e, > connection_invalidated=is_disconnect) > sqlalchemy.exc.OperationalError: (OperationalError) (1050, "Table > 'calendarevents' already exists") '\nCREATE TABLE `CalendarEvents` > (\n\t`Id` INTEGER NOT NULL AUTO_INCREMENT, \n\t`CalendarId` INTEGER, > \n\t`Allday` BOOL, \n\t`DtStart` DATETIME, \n\t`DtEnd` DATETIME, > \n\t`DTStamp` DATETIME, \n\t`Class` VARCHAR(20), \n\t`Created` DATETIME, > \n\t`Description` TEXT, \n\t`Duration` DATETIME, \n\t`LastModified` > DATETIME, \n\t`Location` TEXT, \n\t`Priority` VARCHAR(10), \n\t`RecurId` > DATETIME, \n\t`Sequence` INTEGER, \n\t`Status` TEXT, \n\t`Summary` TEXT, > \n\t`Transparent` VARCHAR(15), \n\tuid TEXT, \n\turl TEXT, \n\t`Organizer` > VARCHAR(100), \n\t`OrganizerCN` VARCHAR(100), \n\t`OrganizerDIR` > VARCHAR(50), \n\t`OrganizerSendBy` VARCHAR(50), \n\t`OrganizerLanguage` > VARCHAR(50), \n\tPRIMARY KEY (`Id`), \n\t FOREIGN KEY(`CalendarId`) > REFERENCES `Calendars` (`Id`)\n)\n\n' () > > even though the table is not there!, Only the Calendars table is created > > Any suggestions?
seems likely that your MySQL database is on a case insensitive filesystem so you should be naming your table "calendarevents", all lowercase. > > Martijn > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalch...@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
