Databasewarning
Unknown column 'X' in 'field list'
Also seen as: Unknown column in field list column doesn't exist sql missing column oxmysql
What causes it
A query references a column that doesn't exist in the table — usually because a required SQL import wasn't run, or the resource expects a newer database schema than you have.
How to fix it
Import the resource's SQL / add the missing column.
- Run the resource's provided .sql file to create required tables/columns.
- If upgrading a resource, apply any migration SQL it ships.
- Confirm you're pointed at the correct database.
- Check the column name spelling in both the code and the table.
Related errors
Related guides
Still stuck? We can help.
Optimized, dual-framework scripts for QBCore and ESX from Viper Development — escrow protected, delivered instantly to your Cfx portal.