All we need is an easy explanation of the problem, so here it is.
I have executed a simple query
select * from content_model_reference cm where cm.element_id = "1.B.1.g";
The MySQL gives me this error message
ERROR 1054 (42S22): Unknown column '1.B.1.g' in 'where clause'
I don’t have any idea why this happens on the production server. The above query works fine at local.
How to solve :
I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.
The problem is most likely with the double-quotes. Some database engines will treat this as a column name rather than a value.
SELECT * FROM content_model_reference cm WHERE cm.element_id = '1.B.1.g';
This should give you what you’re looking for.
Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂