Got it. Thank you On Tue, Feb 12, 2019 at 12:40 AM Mike Dewhirst <mi...@dewhirst.com.au> wrote:
> On 12/02/2019 4:54 pm, Victor H. Velasquez Rizo wrote: > > Hi Mike. > > I have spend hours trying to get the code where all this crazyness is > > happening with no good luck. > > I would like to ask you if there is any posibility you can access my > > computer trhoug TEAMVIWER and guide me on this. > > I would love to help except I am under time pressure myself. I am a > procrastinator and frequently do small things to postpone doing my own > hard things. That's why I responded to your original email. > > Let me recommend that you start a new thread with a new subject line to > seek fresh assistance. Write a detailed description of your problem > including what you have done to track it down. It might take you some > hours to edit it and get it exactly right. I have found nine times out > of ten doing that forces me to do extra research so my request for help > doesn't look too half-baked. Usually I end up needing to check things in > the docs and that frequently solves my problem. > > A fresh and well researched request for help will attract support from > people much more expert than me. > > In this thread you didn't reveal everything you had tried and you didn't > reveal the entire error trace nor any source which you suspected. I just > saw what the error said and pointed that out. The actual error is your > best lead. Try and follow that to write your story. > > Good luck > > Mike > > > > > On Mon, Feb 11, 2019 at 9:40 PM Mike Dewhirst <mi...@dewhirst.com.au > > <mailto:mi...@dewhirst.com.au>> wrote: > > > > On 12/02/2019 2:19 pm, Victor H. Velasquez Rizo wrote: > > > Hello mike. > > > Thank you for all this information. > > > > > > I've been checking the migrations but I don't see anything with the > > > *sort_value* > > > > In that case you have asked for gallery_photos.sort_value > > somewhere in > > your code and that is being interpreted by the Admin as a field and > > because it doesn't exist is calling it a programming error. > > > > Certainly easier to find/fix than cheating migrations! > > > > Cheers > > > > Mike > > > > > > > > Photologue <http://127.0.0.1:8000/admin/photologue/>Galleries > > Add > > > Change > > > Photo effects Add Change > > > Photo sizes Add Change > > > Photos Add Change > > > Watermarks > > > > > > > > > When I get into Photos, I see the whole list of pictures that > > has been > > > created, but once I *delete selected items, *the error comes up. > > > > > > > > > Select photo to change > > > > > > * Add photo <http://127.0.0.1:8000/admin/photologue/photo/add/> > > > * Upload a zip archive > > > <http://127.0.0.1:8000/admin/photologue/photo/upload_zip/> > > > > > > Search > > > > > > > > > > > > Action: Go 0 of 10 selected > > > > > > Title <http://127.0.0.1:8000/admin/photologue/photo/?o=1.-3> > > > > > > Date taken <http://127.0.0.1:8000/admin/photologue/photo/?o=2.-3> > > > > > > Date added <http://127.0.0.1:8000/admin/photologue/photo/?o=3> > > > > > > Is public <http://127.0.0.1:8000/admin/photologue/photo/?o=4.-3> > > > > > > View count <http://127.0.0.1:8000/admin/photologue/photo/?o=5.-3> > > > > > > Thumbnail > > > Paris <http://127.0.0.1:8000/admin/photologue/photo/215/> > > (None) > > > Feb. 11, 2019, 10:02 p.m. True 0 > > > <http://127.0.0.1:8000/photologue/photo/paris/> > > > VICTOR <http://127.0.0.1:8000/admin/photologue/photo/214/> > > (None) > > > Jan. 21, 2019, 11:50 a.m. True 0 > > > <http://127.0.0.1:8000/photologue/photo/victor/> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Mon, Feb 11, 2019 at 8:23 PM Mike Dewhirst > > <mi...@dewhirst.com.au <mailto:mi...@dewhirst.com.au> > > > <mailto:mi...@dewhirst.com.au <mailto:mi...@dewhirst.com.au>>> > > wrote: > > > > > > On 12/02/2019 11:47 am, Victor H. Velasquez Rizo wrote: > > > > Yes Mike. > > > > I have done both: > > > > > > In that case, you need to inspect the database itself using > > > PGAdmin (or > > > similar for other databases) and confirm that the > gallery_photos > > > table > > > does indeed have a sort_value column. > > > > > > If not - as the error message says - then the database might > > have > > > been > > > rebuilt from a dump taken prior the migration which added > > > sort_value. Or > > > perhaps restored from an earlier backup. In any case, if it > > doesn't > > > exist you have to make it exist. > > > > > > I'm assuming this is a development database not in production > so > > > one way > > > is to cheat. If anyone else reading this notices a mistake > > please > > > jump > > > in and correct it. > > > > > > Look through the migrations and find the one which first added > > > sort_value. Delete the migrations.AddField() call for > > sort_value from > > > that migration. Look for any mentions of sort_value in other > > > migrations > > > and get rid of them too. There will also be an AlterTable or > > Options > > > line referring to sort_value which needs to have sort_value > > removed. > > > > > > That will trick the migration system into thinking it doesn't > > > exist. The > > > next time you run makemigrations it will discover a new field > > > sort_value > > > and add it. > > > > > > There is a potential problem here. If migrations from other > apps > > > depend > > > on sort_value things may come unstuck. However, it is a good > > bet that > > > sort_value was added to adjust a display sequence and won't > have > > > wider > > > impact. > > > > > > This is tricky territory so you should do nothing until you > have > > > dumped > > > your database and proved you can restore it. Keep your dump as > a > > > pre-sort_value backup. > > > > > > Go carefully > > > > > > Good luck > > > > > > Mike > > > > > > > > > > > *python manage.py makemigrations* > > > > > > > > > > > /home/vic/dev/scribblitt/scribblitt-app/.env/local/lib/python2.7/site-packages/django/db/models/sql/query.py:1156: > > > > > > > RemovedInDjango19Warning: Passing callable argumentsto > > queryset is > > > > deprecated. > > > > value, lookups, used_joins = > > self.prepare_lookup_value(value, > > > > lookups, can_reuse,allow_joins) > > > > > > > > *No changes detected* > > > > > > > > *python manage.py migrate* > > > > > > > > > > > /home/vic/dev/scribblitt/scribblitt-app/.env/local/lib/python2.7/site-packages/django/db/models/sql/query.py:1156: > > > > > > > RemovedInDjango19Warning: Passing callable argumentsto > > queryset is > > > > deprecated. > > > > value, lookups, used_joins = > > self.prepare_lookup_value(value, > > > > lookups, can_reuse,allow_joins) > > > > > > > > Operations to perform: > > > > Synchronize unmigrated apps: anymail, filebrowser, > > staticfiles, > > > > admindocs, model_utils, tinymce, messages, widget_tweaks, > > sitemaps, > > > > humanize, django_extensions, rest_framework, storages, > > > debug_toolbar, > > > > admin_reorder > > > > Apply all migrations: invoices, general, chunks, makeaword, > > > > accounts, images, comic, orders, illustrate, pressroom, > sites, > > > write, > > > > contenttypes, book, thumbnail, django_comments, > tellinstories, > > > > sessions, cart, auth, definition, admin, gift_cards, > > photologue, > > > > wordsearch, stationary > > > > Synchronizing apps without migrations: > > > > Creating tables... > > > > Running deferred SQL... > > > > Installing custom SQL... > > > > *Running migrations:* > > > > * No migrations to apply.* > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Mon, Feb 11, 2019 at 5:42 PM Mike Dewhirst > > > <mi...@dewhirst.com.au <mailto:mi...@dewhirst.com.au> > > <mailto:mi...@dewhirst.com.au <mailto:mi...@dewhirst.com.au>> > > > > <mailto:mi...@dewhirst.com.au > > <mailto:mi...@dewhirst.com.au> <mailto:mi...@dewhirst.com.au > > <mailto:mi...@dewhirst.com.au>>>> > > > wrote: > > > > > > > > On 12/02/2019 10:23 am, Victor H. Velasquez Rizo wrote: > > > > > Hello Mike. > > > > > I have ran the migrations for PHOLOGUE: > > > > > *Running migrations:* > > > > > * No migrations to apply.* > > > > > > > > > > > > > Ok, have you done manage.py makemigrations followed by > > manage.py > > > > migrate? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Mon, Feb 11, 2019 at 4:02 PM Mike Dewhirst > > > > <mi...@dewhirst.com.au <mailto:mi...@dewhirst.com.au> > > <mailto:mi...@dewhirst.com.au <mailto:mi...@dewhirst.com.au>> > > > <mailto:mi...@dewhirst.com.au <mailto:mi...@dewhirst.com.au> > > <mailto:mi...@dewhirst.com.au <mailto:mi...@dewhirst.com.au>>> > > > > > <mailto:mi...@dewhirst.com.au > > <mailto:mi...@dewhirst.com.au> > > > <mailto:mi...@dewhirst.com.au > > <mailto:mi...@dewhirst.com.au>> <mailto:mi...@dewhirst.com.au > > <mailto:mi...@dewhirst.com.au> > > > <mailto:mi...@dewhirst.com.au <mailto:mi...@dewhirst.com.au > >>>>> > > > > wrote: > > > > > > > > > > On 12/02/2019 4:31 am, victor rizo wrote: > > > > >> Hello everyone. > > > > >> > > > > >> I am desperate trying to find a solution for this > > > issue... > > > > >> > > > > >> > > > > >> ProgrammingError at /admin/photologue/photo/ > > > > >> > > > > >> column photologue_gallery_photos.sort_value > > does not > > > exist > > > > > > > > > > This says the column "sort_value" does not exist in > > > the table > > > > > "gallery_photos". > > > > > > > > > > Column is database-speak for a model field. Your > > > software thinks > > > > > the column exists therefore it is a programming > > error. > > > My best > > > > > guess is that you need to do a migration. > > > > > > > > > > > > https://docs.djangoproject.com/en/1.11/topics/migrations/ > > > > > > > > > > Cheers > > > > > > > > > > Mike > > > > > > > > > > > > > > >> LINE 1: ...lery_id", > > > "photologue_gallery_photos"."photo_id", > > > > >> "photologu... > > > > >> > > > > >> It is happening every time I try to delete a > > photo from > > > > >> *admin/photologue/photo.* > > > > >> * > > > > >> * > > > > >> *Any help you can provided?* > > > > >> * > > > > >> * > > > > >> *Thank you in advance.* > > > > >> -- > > > > >> You received this message because you are > > subscribed > > > to the > > > > >> Google Groups "Django users" group. > > > > >> To unsubscribe from this group and stop > > receiving emails > > > > from it, > > > > >> send an email to > > > django-users+unsubscr...@googlegroups.com > > <mailto:django-users%2bunsubscr...@googlegroups.com> > > > <mailto:django-users%2bunsubscr...@googlegroups.com > > <mailto:django-users%252bunsubscr...@googlegroups.com>> > > > > <mailto:django-users%2bunsubscr...@googlegroups.com > > <mailto:django-users%252bunsubscr...@googlegroups.com> > > > <mailto:django-users%252bunsubscr...@googlegroups.com > > <mailto:django-users%25252bunsubscr...@googlegroups.com>>> > > > > >> > > <mailto:django-users+unsubscr...@googlegroups.com > > <mailto:django-users%2bunsubscr...@googlegroups.com> > > > <mailto:django-users%2bunsubscr...@googlegroups.com > > <mailto:django-users%252bunsubscr...@googlegroups.com>> > > > > <mailto:django-users%2bunsubscr...@googlegroups.com > > <mailto:django-users%252bunsubscr...@googlegroups.com> > > > <mailto:django-users%252bunsubscr...@googlegroups.com > > <mailto:django-users%25252bunsubscr...@googlegroups.com>>>>. > > > > >> To post to this group, send email to > > > > >> django-users@googlegroups.com > > <mailto:django-users@googlegroups.com> > > > <mailto:django-users@googlegroups.com > > <mailto:django-users@googlegroups.com>> > > > > <mailto:django-users@googlegroups.com > > <mailto:django-users@googlegroups.com> > > > <mailto:django-users@googlegroups.com > > <mailto:django-users@googlegroups.com>>> > > > > <mailto:django-users@googlegroups.com > > <mailto:django-users@googlegroups.com> > > > <mailto:django-users@googlegroups.com > > <mailto:django-users@googlegroups.com>> > > > > <mailto:django-users@googlegroups.com > > <mailto:django-users@googlegroups.com> > > > <mailto:django-users@googlegroups.com > > <mailto:django-users@googlegroups.com>>>>. > > > > >> Visit this group at > > > > https://groups.google.com/group/django-users. > > > > >> To view this discussion on the web visit > > > > >> > > > > > > > > > > https://groups.google.com/d/msgid/django-users/86a16f8d-1680-4418-9f00-d9eb41312dd7%40googlegroups.com > > > > >> > > > > > > > > > < > https://groups.google.com/d/msgid/django-users/86a16f8d-1680-4418-9f00-d9eb41312dd7%40googlegroups.com?utm_medium=email&utm_source=footer > >. > > > > >> For more options, visit > > > https://groups.google.com/d/optout. > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > > > > > > > > > > > > Atte...,. > > > > > Vìctor Hugo Velàsquez Rizo > > > > > Cali - Colombia > > > > > > > > -- > > > > You received this message because you are subscribed > > to the > > > Google > > > > Groups "Django users" group. > > > > To unsubscribe from this group and stop receiving emails > > > from it, > > > > send an email to > > django-users+unsubscr...@googlegroups.com > > <mailto:django-users%2bunsubscr...@googlegroups.com> > > > <mailto:django-users%2bunsubscr...@googlegroups.com > > <mailto:django-users%252bunsubscr...@googlegroups.com>> > > > > <mailto:django-users%2bunsubscr...@googlegroups.com > > <mailto:django-users%252bunsubscr...@googlegroups.com> > > > <mailto:django-users%252bunsubscr...@googlegroups.com > > <mailto:django-users%25252bunsubscr...@googlegroups.com>>>. > > > > To post to this group, send email to > > > django-users@googlegroups.com > > <mailto:django-users@googlegroups.com> > > <mailto:django-users@googlegroups.com > > <mailto:django-users@googlegroups.com>> > > > > <mailto:django-users@googlegroups.com > > <mailto:django-users@googlegroups.com> > > > <mailto:django-users@googlegroups.com > > <mailto:django-users@googlegroups.com>>>. > > > > Visit this group at > > > https://groups.google.com/group/django-users. > > > > To view this discussion on the web visit > > > > > > > > > > https://groups.google.com/d/msgid/django-users/3ca7d1f7-a15b-03d5-6514-716c397e235f%40dewhirst.com.au > . > > > > For more options, visit > > https://groups.google.com/d/optout. > > > > > > > > > > > > > > > > -- > > > > > > > > > > > > > > > > Atte...,. > > > > Vìctor Hugo Velàsquez Rizo > > > > Cali - Colombia > > > > -- > > > > You received this message because you are subscribed to > > the Google > > > > Groups "Django users" group. > > > > To unsubscribe from this group and stop receiving emails from > > > it, send > > > > an email to django-users+unsubscr...@googlegroups.com > > <mailto:django-users%2bunsubscr...@googlegroups.com> > > > <mailto:django-users%2bunsubscr...@googlegroups.com > > <mailto:django-users%252bunsubscr...@googlegroups.com>> > > > > <mailto:django-users+unsubscr...@googlegroups.com > > <mailto:django-users%2bunsubscr...@googlegroups.com> > > > <mailto:django-users%2bunsubscr...@googlegroups.com > > <mailto:django-users%252bunsubscr...@googlegroups.com>>>. > > > > To post to this group, send email to > > > django-users@googlegroups.com > > <mailto:django-users@googlegroups.com> > > <mailto:django-users@googlegroups.com > > <mailto:django-users@googlegroups.com>> > > > > <mailto:django-users@googlegroups.com > > <mailto:django-users@googlegroups.com> > > > <mailto:django-users@googlegroups.com > > <mailto:django-users@googlegroups.com>>>. > > > > Visit this group at > > https://groups.google.com/group/django-users. > > > > To view this discussion on the web visit > > > > > > > > > > https://groups.google.com/d/msgid/django-users/CAFCXTzimx%2BnMPz3-gYgohEsJay5coBrFwOsGPrVGwZLMhrU%2BcQ%40mail.gmail.com > > > > > > > > > > > > < > https://groups.google.com/d/msgid/django-users/CAFCXTzimx%2BnMPz3-gYgohEsJay5coBrFwOsGPrVGwZLMhrU%2BcQ%40mail.gmail.com?utm_medium=email&utm_source=footer > >. > > > > For more options, visit https://groups.google.com/d/optout. > > > > > > -- > > > You received this message because you are subscribed to the > > Google > > > Groups "Django users" group. > > > To unsubscribe from this group and stop receiving emails > > from it, > > > send an email to django-users+unsubscr...@googlegroups.com > > <mailto:django-users%2bunsubscr...@googlegroups.com> > > > <mailto:django-users%2bunsubscr...@googlegroups.com > > <mailto:django-users%252bunsubscr...@googlegroups.com>>. > > > To post to this group, send email to > > django-users@googlegroups.com <mailto:django-users@googlegroups.com> > > > <mailto:django-users@googlegroups.com > > <mailto:django-users@googlegroups.com>>. > > > Visit this group at > > https://groups.google.com/group/django-users. > > > To view this discussion on the web visit > > > > > > https://groups.google.com/d/msgid/django-users/4453e646-b9c6-31b9-de31-4a3b67508a12%40dewhirst.com.au > . > > > For more options, visit https://groups.google.com/d/optout. > > > > > > > > > > > > -- > > > > > > > > > > > > Atte...,. > > > Vìctor Hugo Velàsquez Rizo > > > Cali - Colombia > > > -- > > > You received this message because you are subscribed to the Google > > > Groups "Django users" group. > > > To unsubscribe from this group and stop receiving emails from > > it, send > > > an email to django-users+unsubscr...@googlegroups.com > > <mailto:django-users%2bunsubscr...@googlegroups.com> > > > <mailto:django-users+unsubscr...@googlegroups.com > > <mailto:django-users%2bunsubscr...@googlegroups.com>>. > > > To post to this group, send email to > > django-users@googlegroups.com <mailto:django-users@googlegroups.com> > > > <mailto:django-users@googlegroups.com > > <mailto:django-users@googlegroups.com>>. > > > Visit this group at https://groups.google.com/group/django-users. > > > To view this discussion on the web visit > > > > > > https://groups.google.com/d/msgid/django-users/CAFCXTzggJ5b%2BWNPZYZKpDSaqf%2B1k8P42GjL8HMq5ukQOzxdinw%40mail.gmail.com > > > > > > > < > https://groups.google.com/d/msgid/django-users/CAFCXTzggJ5b%2BWNPZYZKpDSaqf%2B1k8P42GjL8HMq5ukQOzxdinw%40mail.gmail.com?utm_medium=email&utm_source=footer > >. > > > For more options, visit https://groups.google.com/d/optout. > > > > -- > > You received this message because you are subscribed to the Google > > Groups "Django users" group. > > To unsubscribe from this group and stop receiving emails from it, > > send an email to django-users+unsubscr...@googlegroups.com > > <mailto:django-users%2bunsubscr...@googlegroups.com>. > > To post to this group, send email to django-users@googlegroups.com > > <mailto:django-users@googlegroups.com>. > > Visit this group at https://groups.google.com/group/django-users. > > To view this discussion on the web visit > > > https://groups.google.com/d/msgid/django-users/ef1d2218-5076-fed4-62a1-cf386b28ea7b%40dewhirst.com.au > . > > For more options, visit https://groups.google.com/d/optout. > > > > > > > > -- > > > > > > > > Atte...,. > > Vìctor Hugo Velàsquez Rizo > > Cali - Colombia > > -- > > You received this message because you are subscribed to the Google > > Groups "Django users" group. > > To unsubscribe from this group and stop receiving emails from it, send > > an email to django-users+unsubscr...@googlegroups.com > > <mailto:django-users+unsubscr...@googlegroups.com>. > > To post to this group, send email to django-users@googlegroups.com > > <mailto:django-users@googlegroups.com>. > > Visit this group at https://groups.google.com/group/django-users. > > To view this discussion on the web visit > > > https://groups.google.com/d/msgid/django-users/CAFCXTzjgFWXGJgc%3DBvvkvzpE6yObqKAXORUoC4sgNiXf07rYbg%40mail.gmail.com > > < > https://groups.google.com/d/msgid/django-users/CAFCXTzjgFWXGJgc%3DBvvkvzpE6yObqKAXORUoC4sgNiXf07rYbg%40mail.gmail.com?utm_medium=email&utm_source=footer > >. > > For more options, visit https://groups.google.com/d/optout. > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to django-users+unsubscr...@googlegroups.com. > To post to this group, send email to django-users@googlegroups.com. > Visit this group at https://groups.google.com/group/django-users. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/cc77cf2b-161e-2987-d780-5920c949f594%40dewhirst.com.au > . > For more options, visit https://groups.google.com/d/optout. > -- Atte...,. Vìctor Hugo Velàsquez Rizo Cali - Colombia -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAFCXTzi%3DbFkReQi5nz9xBZwC%2BJ8d5Mi%2BOQtNK_OhAm4-xZ4GDg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.