🔍 Debug SQL Error

1. Checking 'documents' table columns:

Columns: document_id, document_title, document_number, document_code, category_id, document_type, file_name, original_file_name, file_path, file_url, file_size, file_format, mime_type, description, keywords, summary, issuing_agency, issuing_date, effective_date, expiry_date, status, is_public, is_featured, view_count, download_count, uploaded_by, approved_by, created_at, updated_at, published_at

❌ Column 'display_order' MISSING. You must run update_schema.php

2. Testing get_news.php Query:

        SELECT 
            d.document_id as id,
            'article' as type,
            d.document_title as title
        FROM documents d
        LEFT JOIN document_categories c ON d.category_id = c.category_id
        WHERE d.status = 'published'
        ORDER BY d.display_order DESC, d.created_at DESC
        LIMIT 5

❌ SQL Error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'd.display_order' in 'ORDER BY'