MySQL 1054 error Unknown column in field list

  • 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

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

    Gerald Britton, Pluralsight courses

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply