MySQL 1054 error Unknown column in field list

• Noniarise

  SSC Enthusiast

  Points: 163

  More actions

  March 12, 2015 at 8:09 am

  #305610

  Every time i am trying to select or update any data in the specific column in MySQL table i am getting the error n. 1054 :Unknown column 'column_name' in 'field list' I am using MySQL for a long time and have never seen such error. I am using DLE and time ago we are installed some modules on it, can it be a reason? At any rate, this is the one event i remember after that something could go in a wrong way. Frankly speaking i might restore the older database copy, but i do not want do that and i hope somebody will advise me any good solution

• g.britton

  SSChampion

  Points: 13863

  More actions

  March 12, 2015 at 8:11 am

  #1783579

  This is a SQL Server forum. You might want to post your question on MySql forums

  Gerald Britton, Pluralsight courses

• Quadrupeds

  SSC Rookie

  Points: 36

  More actions

  March 19, 2015 at 5:50 am

  #1785006

  Yep, this is not MySql forum, but i try to help anyway.

  It can be that you have a module designed on a newer version of CMS. Or during module installation the table structure has not changed, though it should to. Or after installation any third-party modules the system performed an upgrading, that led to a change in the structure of the tables; in this case the module has not been updated for compatible. Verify all this versions and write about results.

  And also read this discusion, it might help: https://answers.yahoo.com/question/index?qid=20140923082447AAAQ7DJ