Shahid Karimi
Shahid Karimi

Reputation: 4357

MySQL Error: #1054 - Unknown column in 'field list'

I am having a strange error in mysql that despite of existing the column it generates and error saying that the column does not exists.

This is the table schema:

enter image description here

This is the Error in query: enter image description here

Upvotes: 1

Views: 2197

Answers (4)

xkeshav
xkeshav

Reputation: 54084

go to that table structure, edit the field.. there may b space before and after attribute name

Upvotes: 3

Independent
Independent

Reputation: 2987

Should there be imagepath != 'NA' in mysql sql language? I would prefer <> 'NA'

Upvotes: 0

Luixv
Luixv

Reputation: 8710

Try to do a dump of the database in order to see the data structure. For doing that you can use the mysqldump command. Take a look at the ouput of this command.

Upvotes: 0

Spyros
Spyros

Reputation: 48706

Seems that the column does not exist. Try to execute a 'desc user_ads' to check whether the column has indeed been removed or not.

Upvotes: 0

Related Questions