Na serveru byly zjisteny chyby:
SELECT *, CASE WHEN users.zastupce > 0 THEN 'liska' ELSE 'nula' END , sms.id as myID, sms.jmeno as myNAME, users.jmeno as jmeno, users.prijmeni as prijmeni FROM sms LEFT JOIN users us ON us.zalozilID = sms.zalozilID INNER JOIN users ON sms.iduzivatele = users.zastupce OR users.id = sms.iduzivatele AND (odeslano = 1 AND sms.zalozilID = 100 AND platnaSMS = 1 OR users.zastupce = sms.iduzivatele AND odeslano = 1 AND platnaSMS = 1 OR sms.iduzivatele = 100 AND odeslano = 1 AND platnaSMS = 1) GROUP BY sms.id ORDER BY sms.id DESC
Ja se z toho po....
.\vendor\phpmyadmin\sql-parser\src\Utils\Query.php#443
Undefined property: PhpMyAdmin\SqlParser\Components\CaseExpression::$expr
Backtrace
.\libraries\parse_analyze.lib.php#30: PhpMyAdmin\SqlParser\Utils\Query::getAll(string 'SELECT *, CASE WHEN users.zastupce > 0 THEN \'liska\' ELSE \'nula\' END , sms.id as myID, sms.jmeno as myNAME, users.jmeno as jmeno, users.prijmeni as prijmeni FROM sms LEFT JOIN users us ON us.zalozilID = sms.zalozilID INNER JOIN users ON sms.iduzivatele = users.zastupce OR users.id = sms.iduzivatele AND (odeslano = 1 AND sms.zalozilID = 100 AND platnaSMS = 1 OR users.zastupce = sms.iduzivatele AND odeslano = 1 AND platnaSMS = 1 OR sms.iduzivatele = 100 AND odeslano = 1 AND platnaSMS = 1) GROUP BY sms.id ORDER BY sms.id DESC')
.\import.php#656: PMA_parseAnalyze(
string 'SELECT *, CASE WHEN users.zastupce > 0 THEN \'liska\' ELSE \'nula\' END , sms.id as myID, sms.jmeno as myNAME, users.jmeno as jmeno, users.prijmeni as prijmeni FROM sms LEFT JOIN users us ON us.zalozilID = sms.zalozilID INNER JOIN users ON sms.iduzivatele = users.zastupce OR users.id = sms.iduzivatele AND (odeslano = 1 AND sms.zalozilID = 100 AND platnaSMS = 1 OR users.zastupce = sms.iduzivatele AND odeslano = 1 AND platnaSMS = 1 OR sms.iduzivatele = 100 AND odeslano = 1 AND platnaSMS = 1) GROUP BY sms.id ORDER BY sms.id DESC',