leemason Posted December 5, 2012 Share Posted December 5, 2012 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. 0 Quote Link to comment Share on other sites More sharing options...
artizhay Posted December 6, 2012 Share Posted December 6, 2012 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. 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Chris Posted December 6, 2012 Share Posted December 6, 2012 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. 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Chris Posted December 6, 2012 Share Posted December 6, 2012 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? 0 Quote Link to comment Share on other sites More sharing options...
leemason Posted December 8, 2012 Author Share Posted December 8, 2012 ticket opened 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.