[Solved] ERROR 1054 (42S22): Unknown column ‘‍‍’ in ‘field list’

I get this annoying error when I try to insert data from db1 to db2 in MaridaDB 10 using mysql CLI. This is while all the columns exist.

INSERT INTO db2.thread (threadid, title, postuserid, dateline, views)
SELECT  `nid`, `title`, `uid`, ‍‍`created`,
`comment`   from db1.node  where type = 'forum'  and status = 1;

When I execute the same query in PHPMyAdmin, I get:

#1054 - Unknown column 'â€

I tried different syntax like ‘like’ etc. with no avail. Appreciate your hints

Enquirer: qliq


Solution #1:

Looks like there are invisible garbage characters in your query.

Try retyping the query (don’t copy and paste or you’ll most likely include the garbage character) and it should work.

Respondent: qliq

The answers/resolutions are collected from stackoverflow, are licensed under cc by-sa 2.5 , cc by-sa 3.0 and cc by-sa 4.0 .

Leave a Reply

Your email address will not be published.