python - Django south illogical error -


so using south django project, , have been changing model logic. changed bunch of things, regardless, model looks now:

class group(models.model):     '''table of organizational groups'''     group_id = models.autofield(primary_key=true)     group_name = models.charfield(max_length=100,unique=true) #name of group string     icon_path_clicked = models.charfield(blank=true,max_length=255) #location icon stored     icon_path_unclicked = models.charfield(blank=true,max_length=255) #location icon stored     group_description = models.charfield(max_length=255) #description of group     is_active = models.booleanfield(default=true)     date_created = models.datetimefield(auto_now_add=true)

now previously, both icon_path_clicked , icon_path_unclicked had unique=true, took out, yet when try , migrate, following error:

django.db.utils.integrityerror: not create unique index "everything_group_icon_path_clicked_key" detail:  key (icon_path_clicked)=() duplicated.

why still treating if no longer have field unique?

full traceback

running migrations app:  - migrating forwards 0013_auto__chg_field_group_icon_path_clicked__chg_field_group_icon_path_unc.  > everything:0007_auto__add_field_group_icon_path_clicked__add_field_group_icon_path_unc fatal error - following sql query failed: alter table "everything_group" add column "icon_path_clicked" varchar(255) not null unique default ''; error was: not create unique index "everything_group_icon_path_clicked_key" detail:  key (icon_path_clicked)=() duplicated.  error in migration: everything:0007_auto__add_field_group_icon_path_clicked__add_field_group_icon_path_unc traceback (most recent call last):   file "manage.py", line 10, in <module>     execute_from_command_line(sys.argv)   file "/library/python/2.7/site-packages/django-1.6-py2.7.egg/django/core/management/__init__.py", line 399, in execute_from_command_line     utility.execute()   file "/library/python/2.7/site-packages/django-1.6-py2.7.egg/django/core/management/__init__.py", line 392, in execute     self.fetch_command(subcommand).run_from_argv(self.argv)   file "/library/python/2.7/site-packages/django-1.6-py2.7.egg/django/core/management/base.py", line 242, in run_from_argv     self.execute(*args, **options.__dict__)   file "/library/python/2.7/site-packages/django-1.6-py2.7.egg/django/core/management/base.py", line 285, in execute     output = self.handle(*args, **options)   file "/library/python/2.7/site-packages/south-0.8.3-py2.7.egg/south/management/commands/migrate.py", line 111, in handle     ignore_ghosts = ignore_ghosts,   file "/library/python/2.7/site-packages/south-0.8.3-py2.7.egg/south/migration/__init__.py", line 220, in migrate_app     success = migrator.migrate_many(target, workplan, database)   file "/library/python/2.7/site-packages/south-0.8.3-py2.7.egg/south/migration/migrators.py", line 230, in migrate_many     result = migrator.__class__.migrate_many(migrator, target, migrations, database)   file "/library/python/2.7/site-packages/south-0.8.3-py2.7.egg/south/migration/migrators.py", line 305, in migrate_many     result = self.migrate(migration, database)   file "/library/python/2.7/site-packages/south-0.8.3-py2.7.egg/south/migration/migrators.py", line 134, in migrate     result = self.run(migration, database)   file "/library/python/2.7/site-packages/south-0.8.3-py2.7.egg/south/migration/migrators.py", line 115, in run     return self.run_migration(migration, database)   file "/library/python/2.7/site-packages/south-0.8.3-py2.7.egg/south/migration/migrators.py", line 85, in run_migration     migration_function()   file "/library/python/2.7/site-packages/south-0.8.3-py2.7.egg/south/migration/migrators.py", line 61, in <lambda>     return (lambda: direction(orm))   file "/users/ryansaxe/documents/project/app/migrations/0007_auto__add_field_group_icon_path_clicked__add_field_group_icon_path_unc.py", line 14, in forwards     keep_default=false)   file "/library/python/2.7/site-packages/south-0.8.3-py2.7.egg/south/db/generic.py", line 47, in _cache_clear     return func(self, table, *args, **opts)   file "/library/python/2.7/site-packages/south-0.8.3-py2.7.egg/south/db/generic.py", line 418, in add_column     self.execute(sql)   file "/library/python/2.7/site-packages/south-0.8.3-py2.7.egg/south/db/generic.py", line 282, in execute     cursor.execute(sql, params)   file "/library/python/2.7/site-packages/django-1.6-py2.7.egg/django/db/backends/util.py", line 69, in execute     return super(cursordebugwrapper, self).execute(sql, params)   file "/library/python/2.7/site-packages/django-1.6-py2.7.egg/django/db/backends/util.py", line 53, in execute     return self.cursor.execute(sql, params)   file "/library/python/2.7/site-packages/django-1.6-py2.7.egg/django/db/utils.py", line 99, in __exit__     six.reraise(dj_exc_type, dj_exc_value, traceback)   file "/library/python/2.7/site-packages/django-1.6-py2.7.egg/django/db/backends/util.py", line 53, in execute     return self.cursor.execute(sql, params) django.db.utils.integrityerror: not create unique index "everything_group_icon_path_clicked_key" detail:  key (icon_path_clicked)=() duplicated.


-

Comments

Post a Comment

Popular posts from this blog

php - regexp cyrillic filename not matches -

i take list of files php glob(."*.pdf") . files have cyrillic names. example: ООО «Рога и копыта» then load company names database , try find them in file names: preg_match("/$firm_name/ui", $file_name, $match); i have problem: firms if $firm_name visually similar $file_name , preg_match says there no match. mb_detect_encoding both variables return utf-8. there problem in file name, or maybe there encoding or something, can not understand, ask help. upd: $file_name='ООО «Рога и копыта»'; preg_match("/... .Рога и копыта./ui", $file_name, $match); as result, ОО «Рога и копыта» , 1 О missing
Read more

c# - OpenXML hanging while writing elements -

Image
i have program pulls data database, caches file , exports data multiple formats (excel, excel 2003, csv). i'm using openxml sdk 2.0 excel work. these export processes run in parallel (using parallel.foreach ), , amount of data can pretty large - e.g. csvs 800mb. during these larger exports, i've noticed writing of xml documents hang. instance, if have 8 exporting in parallel, @ point "pause". hang around same point: //this.writer openxmlwriter created worksheetpart. this.writer.writeelement(new cell() { cellvalue = new cellvalue(value), datatype = cellvalues.string }); when happens, pause debugger (vs2013 in case) , notice threads blocking around same portion of code - bit deeper in openxml sdk - stem call openxmlwriter.writeelement . i dug through source using justdecompile didn't find answers. appears there intermediary stream in use writing isolated storage , is, reason, blocking. underlying stream each of these filestream . here screenshot ...
Read more

sql - Select Query has unexpected multiple records (MS Access) -

i may tired, can't seem figure out happening. have 2 queries. query 1 has 10 fields. query 2 has 5 fields. fields 1 through 3 same in both queries. trying write select query , simple add field 5 query2 query1 result should query1 additional field (query2.field5). i join first 3 fields both queries , choose select records in query1 , in query2 match. don't know sql, use query designer. expect same number of records have query 1 instead have 3 times or more. can tell me doing wrong. tried reversing joins still seem same records. thanks in advance. here query: the fields in common divisionname , supplierid = vendorid , commodityname . select [part revenue exposed query p1].divisionname, [part revenue exposed query p1].commodityname, [part revenue exposed query p1].suppliername, [part revenue exposed query p1].partnumber, [part revenue exposed query p1].partdescription, [part revenue exposed query p1].bucode, ...
Read more