MySQL Error: 1054 Unknown column in ‘field list’

By Tech-Assured     
January 27, 2021  25275 Views

MySQL-Error-1054

If you see this error, it means you have forgotten something while creating table.

Let’s see the causes & fixes to it

Possible causes for Error 1054


Solution


  • Check the database of the working site on localhost site and export the problematic table on the live site.
  • Save the file and open it using code editor.
  • Construct the ALTER SQL query to add missing column in database table.
  • ALTER TABLE<table_name>ADD<column_name><datatype>AFTER<after_column>

Apart from these causes, there could be many other reasons to this error code, if the issue still persists…

Ask for help –
 Our Support Engineers will walk you through the steps…

Tech-Assured can help you deploy best IT practices and mitigate risks with a fully compliant IT framework.


Hewson’s View | This was an election budget on steroids liothyronine online how a little-known agency reveals the web of influence between patient advocates and big pharma