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>> 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>>>
    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>>>>
    >     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+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/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>>.
    >     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/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+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/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>.
    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/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+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/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.
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/ef1d2218-5076-fed4-62a1-cf386b28ea7b%40dewhirst.com.au.
For more options, visit https://groups.google.com/d/optout.

Reply via email to