SQL Error v5.1.1

[leemason]

I'm getting this in my activity log:

 

SQL Error: Unknown column 'important' in 'where clause' - Full Query: SELECT tblnotes.*,(SELECT CONCAT(firstname,' ',lastname) FROM tbladmins WHERE tbladmins.id=tblnotes.adminid) AS adminuser FROM tblnotes WHERE userid='599' AND important='1' ORDER BY `modified` DESC

[xister]

Any news on this?

we´ve the same error messages.

[leemason]

i have also just found another sql error when opening a ticket from the admin area:

 

SQL Error: Unknown column 'important' in 'where clause' - Full Query: SELECT tblnotes.*,(SELECT CONCAT(firstname,' ',lastname) FROM tbladmins WHERE tbladmins.id=tblnotes.adminid) AS adminuser FROM tblnotes WHERE userid='744' AND important='1' ORDER BY `modified` DESC 

 

 

as you can see this is the same query but is happening when opening a ticket.