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?