Přidat otázku mezi oblíbenéZasílat nové odpovědi e-mailemVyřešeno MySQL - pomoc s dotazem

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',

Reakce na odpověď

1 Zadajte svou přezdívku:
2 Napište svou odpověď:
3 Pokud chcete dostat ban, zadejte libovolný text:

Zpět do poradny