hai,
eine eigene abfrage aus dem repository einer eigenen extension macht mir probleme:
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 'prop1,prop2,prop3, LIKE '%lorem%' AND tx_a' at line 1:
hier das statement
SELECT COUNT(*) FROM tx_xxxxx_domain_model_yyyyyy WHERE tx_xxxxx_domain_model_yyyyyy.prop1,prop2,prop3 LIKE '%lorem%' AND tx_xxxxx_domain_model_yyyyyy.deleted=0 AND tx_xxxxx_domain_model_yyyyyy.t3ver_state<=0 AND tx_xxxxx_domain_model_yyyyyy.pid<>-1 AND tx_xxxxx_domain_model_yyyyyy.hidden=0 AND tx_xxxxx_domain_model_yyyyyy.starttime<=1345124880 AND (tx_xxxxx_domain_model_yyyyyy.endtime=0 OR tx_xxxxx_domain_model_yyyyyy.endtime>1345124880) AND tx_xxxxx_domain_model_yyyyyy.sys_language_uid IN (0,-1) AND tx_xxxxx_domain_model_yyyyyy.pid IN (860) ORDER BY tx_xxxxx_domain_model_yyyyyy.crdate DESC
weiss jemand was hier falsch ist?
dies funktioniert:
SELECT COUNT(*) FROM tx_xxxxx_domain_model_yyyyyy WHERE tx_xxxxx_domain_model_yyyyyy.prop1 LIKE '%lorem%' AND tx_xxxxx_domain_model_yyyyyy.deleted=0 AND tx_xxxxx_domain_model_yyyyyy.t3ver_state<=0 AND tx_xxxxx_domain_model_yyyyyy.pid<>-1 AND tx_xxxxx_domain_model_yyyyyy.hidden=0 AND tx_xxxxx_domain_model_yyyyyy.starttime<=1345124880 AND (tx_xxxxx_domain_model_yyyyyy.endtime=0 OR tx_xxxxx_domain_model_yyyyyy.endtime>1345124880) AND tx_xxxxx_domain_model_yyyyyy.sys_language_uid IN (0,-1) AND tx_xxxxx_domain_model_yyyyyy.pid IN (860) ORDER BY tx_xxxxx_domain_model_yyyyyy.crdate DESC
gruss