• Resolved sinahosseinigst

    (@sinahosseinigst)


    And when I go to ‘Pods’ on the left dashboard of WP, it shows nothing but this:
    Database Error; SQL: SELECT DISTINCTt.idFROMwp_pods_best_seller_itemAStWHERE (t.id< 1 ) ORDER BYt.idDESC,t.name,t.idLIMIT 0, 1; Response: Unknown column 't.name' in 'order clause'
    and here is my pod setup:

    {
        "meta": {
            "version": "2.8.8.1",
            "build": 1640110327
        },
        "pods": [
            {
                "name": "best_seller_item",
                "id": 202,
                "label": "Best Seller Items",
                "description": "",
                "type": "pod",
                "storage": "table",
                "label_singular": "Best Seller Item",
                "public": "1",
                "show_ui": "1",
                "pod_index": "name",
                "_migrated_28": "1",
                "required": "0",
                "unique": "0",
                "groups": [
                    {
                        "name": "details",
                        "id": 203,
                        "label": "Details",
                        "description": "",
                        "weight": 0,
                        "fields": [
                            {
                                "name": "food_image",
                                "id": 209,
                                "label": "Food Image",
                                "description": "",
                                "weight": 0,
                                "type": "file",
                                "sister_id": "-- Select One --",
                                "required": "0",
                                "unique": "0",
                                "file_format_type": "single",
                                "file_uploader": "attachment",
                                "file_attachment_tab": "upload",
                                "file_upload_dir": "wp",
                                "file_edit_title": "1",
                                "file_show_edit_link": "0",
                                "file_linked": "0",
                                "file_limit": "0",
                                "file_type": "images",
                                "file_field_template": "rows",
                                "file_add_button": "Add File",
                                "file_modal_title": "Attach a file",
                                "file_modal_add_button": "Add File",
                                "roles_allowed": "administrator"
                            },
                            {
                                "name": "food_title",
                                "id": 210,
                                "label": "Food Title",
                                "description": "",
                                "weight": 1,
                                "type": "text",
                                "sister_id": "-- Select One --",
                                "required": "0",
                                "unique": "0",
                                "text_allowed_html_tags": "strong em a ul ol li b i",
                                "text_max_length": "255",
                                "roles_allowed": "administrator"
                            },
                            {
                                "name": "food_price",
                                "id": 211,
                                "label": "Food Price",
                                "description": "",
                                "weight": 2,
                                "type": "text",
                                "sister_id": "-- Select One --",
                                "required": "0",
                                "unique": "0",
                                "text_allowed_html_tags": "strong em a ul ol li b i",
                                "text_max_length": "255",
                                "roles_allowed": "administrator"
                            },
                            {
                                "name": "food_button_text",
                                "id": 212,
                                "label": "Food Button Text",
                                "description": "",
                                "weight": 3,
                                "type": "text",
                                "sister_id": "-- Select One --",
                                "required": "0",
                                "unique": "0",
                                "text_allowed_html_tags": "strong em a ul ol li b i",
                                "text_max_length": "255",
                                "roles_allowed": "administrator"
                            },
                            {
                                "name": "food_button_link",
                                "id": 213,
                                "label": "Food Button Link",
                                "description": "",
                                "weight": 4,
                                "type": "website",
                                "sister_id": "-- Select One --",
                                "required": "0",
                                "unique": "0",
                                "website_format": "normal",
                                "website_allow_port": "0",
                                "website_clickable": "0",
                                "website_new_window": "0",
                                "website_max_length": "255",
                                "website_html5": "0",
                                "roles_allowed": "administrator"
                            }
                        ]
                    }
                ]
            },
            {
                "name": "best_seller_group",
                "id": 200,
                "label": "Best Sellers Group",
                "description": "",
                "type": "post_type",
                "storage": "table",
                "label_singular": "Best Seller Group",
                "public": "1",
                "show_ui": "1",
                "rest_enable": "1",
                "supports_title": "1",
                "supports_editor": "1",
                "_migrated_28": "1",
                "required": "0",
                "unique": "0",
                "groups": [
                    {
                        "name": "more_fields",
                        "id": 201,
                        "label": "More Fields",
                        "description": "",
                        "weight": 0,
                        "fields": [
                            {
                                "name": "best_seller_item",
                                "id": 214,
                                "label": "Best Seller Item",
                                "description": "",
                                "weight": 0,
                                "type": "pandarepeaterfield",
                                "sister_id": "-- Select One --",
                                "required": "0",
                                "unique": "0",
                                "pandarepeaterfield_table": "best_seller_item",
                                "pandarepeaterfield_field_width": "100",
                                "pandarepeaterfield_entry_limit": "0",
                                "pandarepeaterfield_enable_load_more": "0",
                                "pandarepeaterfield_initial_amount": "10",
                                "pandarepeaterfield_enable_trash": "0",
                                "pandarepeaterfield_order_by": "pandarf_order",
                                "pandarepeaterfield_order": "ASC",
                                "pandarepeaterfield_display_order_info": "0",
                                "pandarepeaterfield_apply_admin_columns": "0",
                                "pandarepeaterfield_allow_reassign": "0",
                                "pandarepeaterfield_public_access": "0",
                                "roles_allowed": "administrator",
                                "rest_pick_response": "array",
                                "rest_pick_depth": "1"
                            }
                        ]
                    }
                ]
            }
        ]
    }

    My hero, help again @codingpanda! I can create Pods and they work well, but don’t know what’s wrong with this one! Thanks, waiting for your support!

Viewing 15 replies - 1 through 15 (of 26 total)
Viewing 15 replies - 1 through 15 (of 26 total)
  • The topic ‘‘Form submitted successfully’ message appeared without any item added!’ is closed to new replies.