Skip to main content

Table or column not found

❌ Error​

Table 'your_database.table_name' doesn't exist

or

Unknown column 'xyz' in 'field list'

📍 Context​

This happens when a FiveM script tries to query a table or column that isn’t created in the database.
For example, forgetting to run the SQL migrations for new jobs, licenses, or inventory items.

✅ Solution​

  • Ensure you have imported the correct .sql files for your scripts.
  • Check that the missing column exists:
    SHOW COLUMNS FROM your_table;
  • If missing, add it manually with ALTER TABLE or re-import the SQL.

ℹ️ Additional Information​

  • Some scripts require manual SQL edits to add items or tables.
  • Always check your script’s sql/ folder and import all files.