Error: Trying to delete a Photo from admin

[dco5]

Hello.
I have a message error saying that there is a column that is not existing, when intend to delete a photo.

This is trying to be done on /admin/photologue/photo/

column photologue_gallery_photos.sort_value does not exist
LINE 1: ...lery_id", "photologue_gallery_photos"."photo_id", "photologu...

[richardbarran]

Try python manage.py migrate ?

[dco5]

Hi Richard.
I did it, yes.

"No migrations to apply."

[richardbarran]

That's strange; did you add photologue to INSTALLED_APPS?

[dco5]

Yes.
It is on that list.

[richardbarran]

Stranger and stranger. Could you post here:

1. A list of all the tables in your database.
2. The output of python manage.py showmigrations.

Thanks in advance!

[dco5]

1. A list of all the tables in your database.

accounts_useractivationkey
accounts_useractivationkey_id_seq
accounts_userprofile
accounts_userprofile_id_seq
app_plugins_plugin
app_plugins_plugin_id_seq
app_plugins_pluginpoint
app_plugins_pluginpoint_id_seq
app_plugins_userpluginpreference
app_plugins_userpluginpreference_id_seq
area_taxrate
area_taxrate_id_seq
auth_group
auth_group_id_seq
auth_group_permissions
auth_group_permissions_id_seq
auth_message
auth_message_id_seq
auth_permission
auth_permission_id_seq
auth_user
auth_user_groups
auth_user_groups_id_seq
auth_user_id_seq
auth_user_user_permissions
auth_user_user_permissions_id_seq
book_book
book_book_id_seq
book_characterpage
book_characterpage_id_seq
captcha_captchastore
captcha_captchastore_id_seq
chunks_chunk
chunks_chunk_id_seq
chunks_chunk_old
chunks_chunk_old_id_seq
configurable_configurableproduct
configurable_configurableproduct_option_group
configurable_configurableproduct_option_group_id_seq
configurable_productvariation
configurable_productvariation_options
configurable_productvariation_options_id_seq
contact_addressbook
contact_addressbook_id_seq
contact_contact
contact_contact_id_seq
contact_contactinteractiontype
contact_contactorganization
contact_contactorganizationrole
contact_contactrole
contact_interaction
contact_organization
contact_organization_id_seq
contact_phonenumber
contact_phonenumber_id_seq
custom_customproduct
custom_customproduct_option_group
custom_customproduct_option_group_id_seq
custom_customtextfield
custom_customtextfield_id_seq
custom_customtextfieldtranslation
custom_customtextfieldtranslation_id_seq
definition_answer
definition_answer_id_seq
definition_player
definition_player_id_seq
definition_question
definition_question_answers
definition_question_answers_id_seq
definition_question_id_seq
django_admin_log
django_admin_log_id_seq
django_comment_flags
django_comment_flags_id_seq
django_comments
django_comments_id_seq
django_content_type
django_content_type_id_seq
django_migrations
django_migrations_id_seq
django_session
django_site
django_site_id_seq
general_avatar
general_avatar_id_seq
general_cart
general_cart_id_seq
general_communitycomment
general_communitycomment_id_seq
general_communitytopic
general_communitytopic_id_seq
general_competitions
general_competitions_id_seq
general_discountcode
general_discountcode_id_seq
general_favorites
general_favorites_id_seq
general_featured
general_featured_id_seq
general_giftcardorders
general_giftcardorders_id_seq
general_imageitem
general_imageitem_id_seq
general_imageitemgroup
general_imageitemgroup_id_seq
general_library
general_library_id_seq
general_messages
general_messages_id_seq
general_messagesfirst
general_messagesfirst_id_seq
general_messagesfourth
general_messagesfourth_id_seq
general_messagessecond
general_messagessecond_id_seq
general_messagesthird
general_messagesthird_id_seq
general_orders
general_orders_id_seq
general_page
general_page_id_seq
general_stationary
general_stationary_id_seq
general_yoobi
general_yoobi_id_seq
illustrate_character
illustrate_character_id_seq
illustrate_charactertype
illustrate_charactertype_id_seq
illustrate_piece
illustrate_piece_character_type
illustrate_piece_character_type_id_seq
illustrate_piece_id_seq
illustrate_piecetype
illustrate_piecetype_id_seq
l10n_adminarea
l10n_adminarea_id_seq
l10n_country
l10n_country_id_seq
livesettings_longsetting
livesettings_longsetting_id_seq
livesettings_setting
livesettings_setting_id_seq
makeaword_puzzle
makeaword_puzzle_id_seq
makeaword_word
makeaword_word_puzzles
makeaword_word_puzzles_id_seq
payment_creditcarddetail
payment_creditcarddetail_id_seq
payment_paymentoption
payment_paymentoption_id_seq
photologue_gallery
photologue_gallery_id_seq
photologue_gallery_photos
photologue_gallery_photos_id_seq
photologue_gallery_sites
photologue_photo
photologue_photo_id_seq
photologue_photo_sites
photologue_photoeffect
photologue_photoeffect_id_seq
photologue_photosize
photologue_photosize_id_seq
photologue_watermark
photologue_watermark_id_seq
pressroom_article
pressroom_article_documents
pressroom_article_documents_id_seq
pressroom_article_id_seq
pressroom_article_photos
pressroom_article_photos_id_seq
pressroom_article_sections
pressroom_article_sections_id_seq
pressroom_document
pressroom_document_id_seq
pressroom_section
pressroom_section_id_seq
product_attributeoption
product_attributeoption_id_seq
product_category
product_category_id_seq
product_category_related_categories
product_category_related_categories_id_seq
product_categoryattribute
product_categoryattribute_id_seq
product_categoryimage
product_categoryimage_id_seq
product_categoryimagetranslation
product_categoryimagetranslation_id_seq
product_categorytranslation
product_categorytranslation_id_seq
product_discount
product_discount_id_seq
product_discount_valid_categories
product_discount_valid_categories_id_seq
product_discount_valid_products
product_discount_valid_products_id_seq
product_option
product_option_id_seq
product_optiongroup
product_optiongroup_id_seq
product_optiongrouptranslation
product_optiongrouptranslation_id_seq
product_optiontranslation
product_optiontranslation_id_seq
product_price
product_price_id_seq
product_product
product_product_also_purchased
product_product_also_purchased_id_seq
product_product_category
product_product_category_id_seq
product_product_id_seq
product_product_related_items
product_product_related_items_id_seq
product_productattribute
product_productattribute_id_seq
product_productimage
product_productimage_id_seq
product_productimagetranslation
product_productimagetranslation_id_seq
product_productpricelookup
product_productpricelookup_id_seq
product_producttranslation
product_producttranslation_id_seq
product_taxclass
product_taxclass_id_seq
registration_registrationprofile
registration_registrationprofile_id_seq
shop_cart
shop_cart_id_seq
shop_cartitem
shop_cartitem_id_seq
shop_cartitemdetails
shop_cartitemdetails_id_seq
shop_config
shop_config_shipping_countries
shop_config_shipping_countries_id_seq
shop_order
shop_order_id_seq
shop_orderauthorization
shop_orderauthorization_id_seq
shop_orderitem
shop_orderitem_id_seq
shop_orderitemdetail
shop_orderitemdetail_id_seq
shop_orderpayment
shop_orderpayment_id_seq
shop_orderpaymentfailure
shop_orderpaymentfailure_id_seq
shop_orderpendingpayment
shop_orderpendingpayment_id_seq
shop_orderstatus
shop_orderstatus_id_seq
shop_ordertaxdetail
shop_ordertaxdetail_id_seq
shop_ordervariable
shop_ordervariable_id_seq
tellinstories_field
tellinstories_field_id_seq
tellinstories_story
tellinstories_story_id_seq
thumbnail_kvstore
wordsearch_newpuzzle
wordsearch_newpuzzle_id_seq
wordsearch_puzzle
wordsearch_puzzle_id_seq
wordsearch_word
wordsearch_word_id_seq
write_badword
write_badword_id_seq
write_badwords
write_badwords_id_seq
write_page
write_page_id_seq

2. The output of python manage.py showmigrations

accounts
[X] 0001_initial
[X] 0002_auto_20170519_2012
[X] 0003_userprofile_company
[X] 0004_userprofile_checkout_data
[X] 0004_auto_20180911_1259
[X] 0005_merge
admin
[X] 0001_initial
auth
[X] 0001_initial
[X] 0002_alter_permission_name_max_length
[X] 0003_alter_user_email_max_length
[X] 0004_alter_user_username_opts
[X] 0005_alter_user_last_login_null
[X] 0006_require_contenttypes_0002
book
[X] 0001_initial
[X] 0002_auto_20161102_0939
[X] 0003_auto_20161124_0018
[X] 0004_auto_20170203_2154
[X] 0005_auto_20180209_1633
[X] 0006_auto_20180227_2317
[X] 0007_auto_20180322_0011
[X] 0008_auto_20180322_0050
[X] 0009_bookpdf
[X] 0010_auto_20180405_1227
[X] 0011_auto_20180405_1313
cart
[X] 0001_initial
chunks
[X] 0001_initial
[X] 0002_chunk_description
[X] 0003_auto_20161120_1821
[X] 0004_auto_20161121_0711
comic
[X] 0001_initial
[X] 0002_auto_20160825_1215
[X] 0003_auto_20160825_1341
[X] 0004_auto_20160827_1141
[X] 0005_auto_20160827_1626
[X] 0006_cover_layout
[X] 0007_auto_20160909_2202
[X] 0008_auto_20160916_1127
[X] 0009_panel_print_image
[X] 0010_comic_title_background_color
[X] 0011_comic_is_shared
[X] 0012_comic_in_library
[X] 0013_remove_comic_back_image
[X] 0014_comic_back_image
[X] 0015_remove_comic_back_image
[X] 0016_comic_back_image
[X] 0017_auto_20161102_0812
[X] 0018_comic_is_in_libary
[X] 0019_auto_20161123_0640
[X] 0020_auto_20161123_0751
[X] 0021_comic_added_to_library_on
[X] 0022_comic_title_font
[X] 0023_comic_author_font
[X] 0024_auto_20180220_1843
[X] 0025_auto_20180227_2317
[X] 0026_comicpdf
[X] 0027_auto_20190121_1339
contenttypes
[X] 0001_initial
[X] 0002_remove_content_type_name
definition
[X] 0001_initial
django_comments
[X] 0001_initial
[X] 0002_update_user_email_field_length
[X] 0003_add_submit_date_index
general
[X] 0001_initial
[X] 0002_auto_20160809_1439
[X] 0003_cart_comic
[X] 0004_auto_20161116_1249
[X] 0005_auto_20161126_1310
[X] 0006_auto_20161126_1848
[X] 0007_auto_20161122_0111
[X] 0008_auto_20170223_2211
[X] 0009_auto_20170223_2222
[X] 0010_auto_20170519_1435
[X] 0011_competitions_competition_type
[X] 0012_auto_20171015_1703
[X] 0013_auto_20180118_2304
[X] 0014_auto_20190121_1339
gift_cards
[X] 0001_initial
[X] 0002_giftcard_discount_used
[X] 0003_giftcard_messages
[X] 0004_auto_20180722_2100
[X] 0005_auto_20180722_2103
[X] 0006_giftcard_country
illustrate
[X] 0001_initial
[X] 0002_auto_20160701_1307
[X] 0003_character_image
[X] 0004_auto_20180227_2317
images
[X] 0001_initial
[X] 0002_auto_20160822_1254
[X] 0003_image_low_res_image
[X] 0004_auto_20180228_1410
invoices
[X] 0001_initial
[X] 0002_auto_20180911_1642
[X] 0003_auto_20180911_1659
[X] 0004_auto_20180918_1826
library
(no migrations)
makeaword
[X] 0001_initial
orders
[X] 0001_initial
[X] 0002_auto_20180330_2008
[X] 0003_auto_20180330_2327
[X] 0004_auto_20180331_0025
[X] 0005_auto_20180331_2037
[X] 0006_auto_20180401_1753
[X] 0007_auto_20180401_1804
[X] 0008_remove_discountcode_free_shipping
[X] 0009_discountcode_charge_id
[X] 0010_auto_20180402_0240
[X] 0011_auto_20180402_1934
[X] 0012_order_charge_id
[X] 0013_order_shipping_type
[X] 0014_remove_orderitem_processed_item_pdf
[X] 0015_auto_20180605_2253
[X] 0016_auto_20180606_1722
[X] 0017_remove_discountcode_charge_id
[X] 0018_auto_20190121_1339
payflowpro
(no migrations)
photologue
[X] 0001_initial
[X] 0002_photosize_data
[X] 0003_auto_20140822_1716
[X] 0004_auto_20140915_1259
[X] 0005_auto_20141027_1552
[X] 0006_auto_20141028_2005
[X] 0007_auto_20150404_1737
[X] 0008_auto_20150509_1557
[X] 0009_auto_20160102_0904
[X] 0010_auto_20160105_1307
pressroom
[X] 0001_initial
recaptcha2
(no migrations)
reports
(no migrations)
sessions
[X] 0001_initial
sites
[X] 0001_initial
stationary
[X] 0001_initial
[X] 0002_auto_20180810_2108
[X] 0003_auto_20180816_1723
[X] 0004_auto_20180821_1056
[X] 0005_auto_20180911_1046
[X] 0006_auto_20180921_1729
tellinstories
[X] 0001_initial
thumbnail
[X] 0001_initial
wordsearch
[X] 0001_initial
write
[X] 0001_initial
[X] 0002_page_type
[X] 0003_auto_20160719_2052
[X] 0004_page_image
[X] 0005_auto_20170519_1435
[X] 0006_auto_20180227_2317

[dco5]

Hi Richard.
Could you check the info you asked me?
I still having this issue

[dco5]

#195

[richardbarran]

Hi,
I've been very busy in the last month so apologies for not following up this conversation. Did you manage to fix this issue?

[dco5]

Hello @richardbarran
No Ihave not been able to fix this

[timthelion]

Do you have sortedm2m in INSTALLED_APPS?