leemason Posted September 6, 2012 Share Posted September 6, 2012 im getting two errors in my activity log during the cron being processed: 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=719 LIMIT 1 and SQL Error: Unknown column 'packageid' in 'where clause' - Full Query: SELECT hostingid FROM tblhostingaddons WHERE packageid IN (67,26,38,51,52,53,57,69,61,32,34,31,44,33,43,68,65,40,39,66,41,36,54,48,49,64,59,58,60,42,62,47,50,71,73,72,70,63) AND regdate='2012-08-27' AND domainstatus IN ('Pending','Active','Suspended','Terminated','Cancelled','Fraud') AND (SELECT COUNT(*) FROM tblhosting h2 WHERE h2.userid=tblhosting.userid AND h2.packageid IN (35) AND h2.domainstatus='Active')=0 AND addonid IN (47,34,42,17,31,33,35,37,44,39,19,45,21,18,29,30,20,28,43,22,40,25,32,41,26,46,24,36) AND regdate='2012-08-27' 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 (35) AND h2.domainstatus='Active')=0 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.