---
title: "mysql syntax error extbase repository"
url: "https://www.typo3.net/d/111749-mysql-syntax-error-extbase-repository"
source: "typo3.net"
tags: ["Extensions","Extbase","Frage"]
created: "2012-08-16"
last_reply: "2012-08-17"
replies: 2
solved: false
page: 1
pages: 1
lang: "de"
---

# mysql syntax error extbase repository

Extensions › Extbase · 2 Antworten · gestartet 2012-08-16

## Eröffnungsbeitrag

**zeitgenosse** · 2012-08-16 · [Beitrag #1](https://www.typo3.net/d/111749-mysql-syntax-error-extbase-repository/1)

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

## Antworten

### [#2](https://www.typo3.net/d/111749-mysql-syntax-error-extbase-repository/2) · einpraegsam.​net · 2012-08-16

Muss das nicht

```html
SELECT COUNT(*) FROM tx_xxxxx_domain_model_yyyyyy WHERE tx_xxxxx_domain_model_yyyyyy.prop1,tx_xxxxx_domain_model_yyyyyy.prop2,tx_xxxxx_domain_model_yyyyyy.prop3 ...
```

heißen?

Tipp: SQL Statement "im Trockenen" in Phpmyadmin oder t3adminer vorher mal überprüfen und herumspielen...

### [#3](https://www.typo3.net/d/111749-mysql-syntax-error-extbase-repository/3) · zeitgenosse · 2012-08-17

Damit bekomme ich leider den selben error.

---

Quelle: „mysql syntax error extbase repository“, typo3.net, https://www.typo3.net/d/111749-mysql-syntax-error-extbase-repository
Beiträge von Mitgliedern des Forums. Bitte mit Link auf die Diskussion zitieren.