mysql - Why this database migration error after I upgrade my version django-mptt? -


my django application has requirements.txt file (shown here) use install modules in virtual environment. works fine.

however, i'm trying upgrade django-mptt 0.6.1 latest version. (i don't care upgrade django-mptt. want upgrade version of django. seems upgrade django, must first upgrade django-mptt described here). pip install -u django-mptt. causes django-mptt go 0.6.1 0.7.4 , django go 1.7.1 1.8.2. , causes django-cache-machine origin master. can see changes in screenshot below.

then when manage.py runserver prompts me migrate. that. no problems. subsequently if drop tables , run migrate again, error during migration: 

django.db.utils.operationalerror:  (1005, 'can\'t create table `mydb_instance`.`#sql-21b_1e`  (errno: 150 "foreign key constraint incorrectly formed")')

full stack trace here.

what error? have fact i'm using mariadb (server version: 10.0.15-mariadb homebrew) instead of mysql database?

enter image description here

edit: portion below point added on july 6,2015 @ 5:28 utc

i mentioned above after upgrade, prompted migrate. strangely, occurred though upgrading mptt doesn't cause new migration files created! when did manage.py runserver, got following warning message. why? makes no sense:

you have unapplied migrations; app may not work until applied. run 'python manage.py migrate' apply them.

edit: portion below point added on july 6,2015 @ 17:00 utc

as experiment, switched out underlying database mariadb mysql (server version: 5.6.25). problem persisted. error got cannot add foreign key constraint. full stack trace here.

edit: portion below point added on july 6,2015 @ 17:05 utc

going through stack trace posted 5 minutes ago, found error being triggered following sql statement:

alter table `myapp2_mymodel2` add constraint `mymod_mymodel5_id_335ee73cecd6ecbf_fk_myapp5_mymodel5_id` foreign key (`mymodel5_id`) references `myapp5_mymodel5`;

i see issue is. myapp2_mymodel has foreign key constraint myapp5_mymodel. when tries create fk, fails because target of foreign key doesn't yet exist! why order of table creation different after upgrade?

i solved problem myself. looks 1 of django applications lacked myapp2 lacked migrations folder. repaired , things started working fine.


-

Comments

Post a Comment

Popular posts from this blog

OpenCV OpenCL: Convert Mat to Bitmap in JNI Layer for Android -

there several posts converting mat bitmap using utils.mattobitmap() function. i'm assuming function can called in java layer after importing utils class. i want transfer data memory address pointed uint32_t* bmpcontent; in code below. jniexport void jnicall java_com_nod_nodcv_nodcvactivity_runfilter( jnienv *env, jclass clazz, jobject outbmp, jbytearray indata, jint width, jint height, jint choice, jint filter) { int outsz = width*height; int insz = outsz + outsz/2; androidbitmapinfo bmpinfo; if (androidbitmap_getinfo(env, outbmp, &bmpinfo) < 0) { throwjavaexception(env,"gaussianblur","error retrieving bitmap meta data"); return; } if (bmpinfo.format != android_bitmap_format_rgba_8888) { throwjavaexception(env,"gaussianblur","expecting rgba_8888 format"); return; } uint32_t* bmpcontent; if (androidbitmap_lockpixels(env, outbmp,(void**)&bmpcontent)...
Read more

android - org.xmlpull.v1.XmlPullParserException: expected: START_TAG {http://schemas.xmlsoap.org/soap/envelope/}Envelope -

i trying hit soap api in application login purpose , getting above mentioned error , can 1 tell me going wrong , first time soap apis. here code hit soap :- vector<object> args = new vector<object>(); hashtable<string, object> hashtable = new hashtable<string, object>(); hashtable.put("email", "mss.siddhart28@gmail.com"); hashtable.put("password", "siddharth"); args.add(hashtable); soapserializationenvelope envelope = new soapserializationenvelope( soapenvelope.ver11); envelope.dotnet = true; envelope.xsd = soapserializationenvelope.xsd; envelope.enc = soapserializationenvelope.enc; (new marshalhashtable()).register(envelope); httptransportse androidhttptransport = new httptransportse( "http://tempuri.org/", 15000); androidhttptransport.debug = true; string result = ""; try { soapobject request = new soapobject("http:...
Read more

python - How to remove the Xframe Options header in django? -

i have made page has iframe . inside iframe want show multiple different links article facebook, or news, or youtube video or other possible url. but, due xframe header, unable so. referred following link: https://docs.djangoproject.com/en/1.8/ref/clickjacking/ , django xframeoptionsmiddleware (x-frame-options) - allow iframe client ip but didn't help. my settings.py file's middleware_classes is: middleware_classes = ( 'django.contrib.sessions.middleware.sessionmiddleware', 'django.middleware.common.commonmiddleware', 'django.middleware.csrf.csrfviewmiddleware', 'django.contrib.auth.middleware.authenticationmiddleware', 'django.contrib.auth.middleware.sessionauthenticationmiddleware', 'django.contrib.messages.middleware.messagemiddleware', 'django.middleware.clickjacking.xframeoptionsmiddleware', ) from http://django-secure.readthedocs.org/en/latest/middleware.html , found using ...
Read more