Multiple MYSQL errors in log.

ive have turned on mysql debugging on while working on a few things and have found more errors than i would like to see in an official release version.

the below errors happen during the cron run:

SQL Error: Unknown column 'packageid' in 'where clause' - Full Query: SELECT hostingid FROM tblhostingaddons WHERE packageid IN (26,51,75,52,53,57,88,69,61,32,34,44,33,43,68,85,65,40,39,41,76,36,54,84,89,86,77,62,47,50,71,73,72,70,67,38,31,42,35) AND regdate='2012-11-15' AND domainstatus IN ('Pending','Active','Suspended','Terminated','Cancelled','Fraud') AND (SELECT COUNT(*) FROM tblhosting h2 WHERE h2.userid=tblhosting.userid AND h2.packageid IN (82,83,66) AND h2.domainstatus='Active')=0 AND addonid IN (47,34,42,17,31,48,33,35,37,18,44,39,19,45,21,29,30,20,28,43,23,22,40,25,32,26,46,24,36) AND regdate='2012-11-15' AND status IN ('Pending','Active','Suspended','Terminated','Cancelled','Fraud') AND (SELECT COUNT(*) FROM tblhosting h2 WHERE h2.userid=(SELECT userid FROM tblhosting WHERE tblhosting.id=tblhostingaddons.hostingid) AND h2.packageid IN (82,83,66) AND h2.domainstatus='Active')=0

SQL Error: Unknown column 'packageid' in 'where clause' - Full Query: SELECT hostingid FROM tblhostingaddons WHERE packageid IN (26,51,75,52,53,57,88,69,61,32,34,44,33,43,68,65,40,39,82,41,76,36,54,84,89,83,77,62,47,50,71,73,72,70,67,38,31,42,66) AND regdate='2012-11-25' AND domainstatus IN ('Pending','Active','Suspended','Terminated','Cancelled','Fraud') AND (SELECT COUNT(*) FROM tblhosting h2 WHERE h2.userid=tblhosting.userid AND h2.packageid IN (85,86,35) AND h2.domainstatus='Active')=0 AND addonid IN (47,34,42,17,31,48,33,35,37,18,44,39,19,45,21,29,30,20,28,43,22,40,25,32,41,26,46,24,36) AND regdate='2012-11-25' AND status IN ('Pending','Active','Suspended','Terminated','Cancelled','Fraud') AND (SELECT COUNT(*) FROM tblhosting h2 WHERE h2.userid=(SELECT userid FROM tblhosting WHERE tblhosting.id=tblhostingaddons.hostingid) AND h2.packageid IN (85,86,35) AND h2.domainstatus='Active')=0

the below errors where added when i mass updated a clients services:

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 'WHERE id='2168'' at line 1 - Full Query: UPDATE tblhosting SET WHERE id='2168'

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 'WHERE id='622'' at line 1 - Full Query: UPDATE tblhostingaddons SET WHERE id='622'

the last error i have seen today is when i replied to a ticket from the admin area:

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 ') ORDER BY useful DESC LIMIT 0,5' at line 1 - Full Query: SELECT id,parentid FROM tblknowledgebase WHERE (article LIKE '%okay,%' OR article LIKE '%clearing%' OR article LIKE '%up.\r%' OR article LIKE '%regards\r%') AND id NOT IN () ORDER BY useful DESC LIMIT 0,5

errors like this dont seem to be effecting the use of the system at all, but should really be resolved before releasing new updates.

Same here:

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=30 LIMIT 1

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

Kind of worries me.

Same here:

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=30 LIMIT 1

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

 

Kind of worries me.

The first query is resolved in the up coming release, and is currently not affecting the system.

The second query, is referencing the notes section in the client's profile page and is resolved via a patch we have available - please contact the support department to receive this.

ive have turned on mysql debugging on while working on a few things and have found more errors than i would like to see in an official release version.

 

the below errors happen during the cron run:

 

SQL Error: Unknown column 'packageid' in 'where clause' - Full Query: SELECT hostingid FROM tblhostingaddons WHERE packageid IN (26,51,75,52,53,57,88,69,61,32,34,44,33,43,68,85,65,40,39,41,76,36,54,84,89,86,77,62,47,50,71,73,72,70,67,38,31,42,35) AND regdate='2012-11-15' AND domainstatus IN ('Pending','Active','Suspended','Terminated','Cancelled','Fraud') AND (SELECT COUNT(*) FROM tblhosting h2 WHERE h2.userid=tblhosting.userid AND h2.packageid IN (82,83,66) AND h2.domainstatus='Active')=0 AND addonid IN (47,34,42,17,31,48,33,35,37,18,44,39,19,45,21,29,30,20,28,43,23,22,40,25,32,26,46,24,36) AND regdate='2012-11-15' AND status IN ('Pending','Active','Suspended','Terminated','Cancelled','Fraud') AND (SELECT COUNT(*) FROM tblhosting h2 WHERE h2.userid=(SELECT userid FROM tblhosting WHERE tblhosting.id=tblhostingaddons.hostingid) AND h2.packageid IN (82,83,66) AND h2.domainstatus='Active')=0

 

 

SQL Error: Unknown column 'packageid' in 'where clause' - Full Query: SELECT hostingid FROM tblhostingaddons WHERE packageid IN (26,51,75,52,53,57,88,69,61,32,34,44,33,43,68,65,40,39,82,41,76,36,54,84,89,83,77,62,47,50,71,73,72,70,67,38,31,42,66) AND regdate='2012-11-25' AND domainstatus IN ('Pending','Active','Suspended','Terminated','Cancelled','Fraud') AND (SELECT COUNT(*) FROM tblhosting h2 WHERE h2.userid=tblhosting.userid AND h2.packageid IN (85,86,35) AND h2.domainstatus='Active')=0 AND addonid IN (47,34,42,17,31,48,33,35,37,18,44,39,19,45,21,29,30,20,28,43,22,40,25,32,41,26,46,24,36) AND regdate='2012-11-25' AND status IN ('Pending','Active','Suspended','Terminated','Cancelled','Fraud') AND (SELECT COUNT(*) FROM tblhosting h2 WHERE h2.userid=(SELECT userid FROM tblhosting WHERE tblhosting.id=tblhostingaddons.hostingid) AND h2.packageid IN (85,86,35) AND h2.domainstatus='Active')=0

 

 

 

the below errors where added when i mass updated a clients services:

 

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 'WHERE id='2168'' at line 1 - Full Query: UPDATE tblhosting SET WHERE id='2168'

 

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 'WHERE id='622'' at line 1 - Full Query: UPDATE tblhostingaddons SET WHERE id='622'

 

 

the last error i have seen today is when i replied to a ticket from the admin area:

 

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 ') ORDER BY useful DESC LIMIT 0,5' at line 1 - Full Query: SELECT id,parentid FROM tblknowledgebase WHERE (article LIKE '%okay,%' OR article LIKE '%clearing%' OR article LIKE '%up.\r%' OR article LIKE '%regards\r%') AND id NOT IN () ORDER BY useful DESC LIMIT 0,5

 

 

errors like this dont seem to be effecting the use of the system at all, but should really be resolved before releasing new updates.

This is not something I've seen before - could you please open a ticket with our support department to have this looked into?

ticket opened