banners plugin dysfunctional

Issue #11 resolved
Former user created an issue

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'escape_subtitle' in 'order clause' (SQL: select planetadeleste_techmarket_banners.*, (select name from planetadeleste_techmarket_sizes where planetadeleste_techmarket_banners.size_id = planetadeleste_techmarket_sizes.id) as size from planetadeleste_techmarket_banners order by escape_subtitle desc limit 20 offset 0) /Applications/MAMP/htdocs/ocms_shopster_3/vendor/laravel/framework/src/Illuminate/Database/Connection.php line 664

Comments (2)

  1. Alvaro Canepa repo owner

    Will be fixed in next release.

    The issue is a simple format in `plugins/planetadeleste/techmarket/models/banner/columns.yaml`

    # ===================================
    #  List Column Definitions
    # ===================================
    
    columns:
        size:
            label: planetadeleste.techmarket::lang.fields.size
            relation: size
            select: name
        escape_title:
            label: planetadeleste.techmarket::lang.fields.title
            searchable: false
            sortable: false
        escape_subtitle:
            label: planetadeleste.techmarket::lang.fields.subtitle
            searchable: false
            sortable: false
    

  2. Log in to comment