Errors after update General questions and topics about hsnm

[ivan]

After update from version 5.0.131 to version 5.0.144 there are every now and then some list of errors appearing. For example

Error! Query 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 'ELSE 1 END)) AS Amount FROM (SELECT SUM(HsRetailersCost) AS HsRetail' at line 1 Query: SELECT SQL_CACHE SQL_SMALL_RESULT SUM(HsRetailersCost * (CASE ELSE 1 END)) AS Amount FROM (SELECT SUM(HsRetailersCost) AS HsRetailersCost, Currency, HsCurrencyExchangeID FROM HsAdvImpressions GROUP BY Currency, HsCurrencyExchangeID) AS Results INNER JOIN HsCurrencyExchange ON HsCurrencyExchange.HsCurrencyExchangeID = Results.HsCurrencyExchangeID (/dashboards/functions/ContextData.php)

Error! Query 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 'ELSE 1 END)) AS Amount FROM (SELECT SUM(HsRetailersCost) AS HsRetail' at line 1 Query: SELECT SQL_CACHE SQL_SMALL_RESULT SUM(HsRetailersCost * (CASE ELSE 1 END)) AS Amount FROM (SELECT SUM(HsRetailersCost) AS HsRetailersCost, Currency, HsCurrencyExchangeID FROM HsAdvClicks GROUP BY Currency, HsCurrencyExchangeID) AS Results INNER JOIN HsCurrencyExchange ON HsCurrencyExchange.HsCurrencyExchangeID = Results.HsCurrencyExchangeID (/dashboards/functions/ContextData.php)

Error! Query 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 'ELSE 1 END)) AS Amount FROM HsAdvTransactions INNER JOIN HsCurrencyEx' at line 1 Query: SELECT SQL_CACHE SQL_SMALL_RESULT SUM(HsAdvTransactions.HsRetailersCost * (CASE ELSE 1 END)) AS Amount FROM HsAdvTransactions INNER JOIN HsCurrencyExchange ON HsCurrencyExchange.HsCurrencyExchangeID = HsAdvTransactions.HsCurrencyExchangeID (/dashboards/functions/ContextData.php)

Error! Query 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 'ELSE 1 END)) AS Amount FROM (SELECT SUM(HsRetailersCost) AS HsRetail' at line 1 Query: SELECT SQL_CACHE SQL_SMALL_RESULT SUM(HsRetailersCost * (CASE ELSE 1 END)) AS Amount FROM (SELECT SUM(HsRetailersCost) AS HsRetailersCost, Currency, HsCurrencyExchangeID FROM HsAdvImpressions GROUP BY Currency, HsCurrencyExchangeID) AS Results INNER JOIN HsCurrencyExchange ON HsCurrencyExchange.HsCurrencyExchangeID = Results.HsCurrencyExchangeID (/dashboards/functions/ContextData.php)

Error! Query 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 'ELSE 1 END)) AS Amount FROM (SELECT SUM(HsRetailersCost) AS HsRetail' at line 1 Query: SELECT SQL_CACHE SQL_SMALL_RESULT SUM(HsRetailersCost * (CASE ELSE 1 END)) AS Amount FROM (SELECT SUM(HsRetailersCost) AS HsRetailersCost, Currency, HsCurrencyExchangeID FROM HsAdvClicks GROUP BY Currency, HsCurrencyExchangeID) AS Results INNER JOIN HsCurrencyExchange ON HsCurrencyExchange.HsCurrencyExchangeID = Results.HsCurrencyExchangeID (/dashboards/functions/ContextData.php)

Error! Query 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 'ELSE 1 END)) AS Value FROM HsTransactions INNER JOIN HsCu' at line 1 Query: SELECT SQL_CACHE SUM(HsTransactions.HsRetailersCost * (CASE ELSE 1 END)) AS Value FROM HsTransactions INNER JOIN HsCurrencyExchange ON HsCurrencyExchange.HsCurrencyExchangeID = HsTransactions.HsCurrencyExchangeID WHERE TransactionType = 1 OR TransactionType = 2 (/dashboards/functions/ContextData.php)

Error! Query 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 'ELSE 1 END)) AS Value FROM HsUsersTransactions INNER JOIN HsCurren' at line 1 Query: SELECT SUM(HsUsersTransactions.SellPrice * (CASE ELSE 1 END)) AS Value FROM HsUsersTransactions INNER JOIN HsCurrencyExchange ON HsCurrencyExchange.HsCurrencyExchangeID = HsUsersTransactions.HsCurrencyExchangeID (/dashboards/functions/ContextData.php)

Error! Query 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 'ELSE 1 END)) AS Value FROM HsUsersTransactions INNER JOIN HsCurren' at line 1 Query: SELECT SUM(HsUsersTransactions.HsRetailersCost * (CASE ELSE 1 END)) AS Value FROM HsUsersTransactions INNER JOIN HsCurrencyExchange ON HsCurrencyExchange.HsCurrencyExchangeID = HsUsersTransactions.HsCurrencyExchangeID (/dashboards/functions/ContextData.php)

Error! Query 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 'ELSE 1 END)) AS Value FROM HsAdvTransactions INNER JOIN HsCurrency' at line 1 Query: SELECT SQL_CACHE SUM(HsAdvTransactions.HsRetailersCost * (CASE ELSE 1 END)) AS Value FROM HsAdvTransactions INNER JOIN HsCurrencyExchange ON HsCurrencyExchange.HsCurrencyExchangeID = HsAdvTransactions.HsCurrencyExchangeID WHERE HsAdvTransactions.CreationDate >= '2017-08-23' AND HsAdvTransactions.CreationDate < '2017-09-22' UNION ALL SELECT SUM(HsAdvTransactions.HsRetailersCost * (CASE ELSE 1 END)) AS Value FROM HsAdvTransactions INNER JOIN HsCurrencyExchange ON HsCurrencyExchange.HsCurrencyExchangeID = HsAdvTransactions.HsCurrencyExchangeID WHERE HsAdvTransactions.CreationDate >= '2017-07-24' AND HsAdvTransactions.CreationDate < '2017-08-23' (/dashboards/functions/AdvSold.php)

Error! Query 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 'ELSE 1 END)) AS Value FROM HsCards INNER JOIN HsDomainsData ON HsDo' at line 1 Query: SELECT SQL_CACHE SUM(HsCards.HsRetailersCost * (CASE ELSE 1 END)) AS Value FROM HsCards INNER JOIN HsDomainsData ON HsDomainsData.HsDomainsDataID = HsCards.HsDomainsDataID INNER JOIN HsManagers ON HsManagers.HsManagersID = HsDomainsData.HsManagersID INNER JOIN HsCurrencyExchange ON HsCurrencyExchange.HsCurrencyExchangeID = HsCards.HsCurrencyExchangeID WHERE HsManagers.EnablePrepaid = 1 AND HsCards.CreationDate >= '2017-07-24' AND HsCards.CreationDate < '2017-08-23' (/dashboards/functions/Sold.php)

Error! Query 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 'ELSE 1 END)) AS Value FROM HsCards INNER JOIN HsDomainsData ON HsDo' at line 1 Query: SELECT SQL_CACHE SUM(HsCards.HsRetailersCost * (CASE ELSE 1 END)) AS Value FROM HsCards INNER JOIN HsDomainsData ON HsDomainsData.HsDomainsDataID = HsCards.HsDomainsDataID INNER JOIN HsManagers ON HsManagers.HsManagersID = HsDomainsData.HsManagersID INNER JOIN HsCurrencyExchange ON HsCurrencyExchange.HsCurrencyExchangeID = HsCards.HsCurrencyExchangeID WHERE HsManagers.EnablePrepaid = 1 AND HsCards.CreationDate >= '2017-08-23' AND HsCards.CreationDate < '2017-09-22' (/dashboards/functions/Sold.php)

Error! Query 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 'ELSE 1 END)) AS Value FROM HsUsersTransactions INNER JOIN HsCurren' at line 1 Query: SELECT SQL_CACHE SUM(HsUsersTransactions.HsRetailersCost * (CASE ELSE 1 END)) AS Value FROM HsUsersTransactions INNER JOIN HsCurrencyExchange ON HsCurrencyExchange.HsCurrencyExchangeID = HsUsersTransactions.HsCurrencyExchangeID WHERE HsUsersTransactions.CreationDate >= '2017-08-23' AND HsUsersTransactions.CreationDate < '2017-09-22' UNION ALL SELECT SUM(HsUsersTransactions.HsRetailersCost * (CASE ELSE 1 END)) AS Value FROM HsUsersTransactions INNER JOIN HsCurrencyExchange ON HsCurrencyExchange.HsCurrencyExchangeID = HsUsersTransactions.HsCurrencyExchangeID WHERE HsUsersTransactions.CreationDate >= '2017-07-24' AND HsUsersTransactions.CreationDate < '2017-08-23' (/dashboards/functions/Sold.php)

And that's are errors from same time stamp, 8:21:21 - 8:21:22 
Again, with version 5.0.131 I didn't have such errors in log. 

[HSNMSupport]

Hi ivan,

please update your HSNM to the latest 5.0.146 version and you won't have that query error anymore.

Regards.

[ivan]

Updated yesterday! So far so good!