View Full Version : Can't get rid of 1054 error.

08-12-2006, 08:40 PM
Using SugarCRM, I have generated the following USER SPECIFIC error.

Error retrieving Inspections list: Query Failed:SELECT inspections.* FROM inspections where (inspections.deleted=0) ORDER BY order_no asc::MySQL error 1054: Unknown column 'order_no' in 'order clause'

I believe I have remedied the cause, however the bogus query seems to be lodged in some cache somewhere. I have flushed the users table, I have flushed the inspections table, I have dropped and reinstalled the module entirely, but can't seem get rid of the error for specific users. Any thoughts?

08-17-2006, 07:54 PM
I am not the best debugger myself, but I think your problem may lie within your punctuation. Try using different ways to say that. Maybe the
where (inspections.deleted=0) ORDER BY order_no asc should be WHERE inspections.deleted='0' ORDER BY order_no ASC. I captialized the MySQL commands because its ten times easier to read. It is just a guess though, I am probably wrong. Good luck!

08-17-2006, 07:54 PM
Let's see your SQL code for creating the table.