SQL error

[ThobbeBoy]

Hi there!

 

I got this stange error with no luck to resolve it.

 

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='8' AND important='1' ORDER BY `modified` DESC

[altomarketing]

when are you having this issue? this can be easily repaired with phpmyadmin, but it is important to detect what cause this issue

[ThobbeBoy]

It will come when iam adding user or edit some user with there domain and so on.

 

Edit: Deleted Product/Service - User ID: 3 - Service ID: 3

- 10/08/2012 00:57 - MYUSERNAME - MYIP

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='3' AND important='1' ORDER BY `modified` DESC

Edited August 10, 2012 by ThobbeBoy
updated with more info

[ThobbeBoy]

Well this is full info i can get with the error now.

SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT (SELECT COUNT(*) FROM tblhosting WHERE userid=tblclients.id AND domainsta' at line 1 - Full Query: SELECT * FROM SELECT (SELECT COUNT(*) FROM tblhosting WHERE userid=tblclients.id AND domainstatus IN ('Active','Suspended'))+(SELECT COUNT(*) FROM tblhostingaddons WHERE hostingid IN (SELECT id FROM tblhosting WHERE userid=tblclients.id) AND status IN ('Active','Suspended'))+(SELECT COUNT(*) FROM tbldomains WHERE userid=tblclients.id AND status IN ('Active')) AS activeservices FROM tblclients WHERE tblclients.id=12 LIMIT 1

[xister]

Any news on this?

we´ve the same error messages.