---
title: "Fehler auf der Detailansichtseite von tt_products 2.6.0"
url: "https://www.typo3.net/d/81919-fehler-auf-der-detailansichtseite-von-tt-products-260"
source: "typo3.net"
tags: ["Extensions","Frage","PHP","TYPO3 4"]
created: "2008-09-18"
last_reply: "2008-09-22"
replies: 3
solved: false
page: 1
pages: 1
lang: "de"
---

# Fehler auf der Detailansichtseite von tt_products 2.6.0

Extensions · 3 Antworten · gestartet 2008-09-18

## Eröffnungsbeitrag

**intensivstation** · 2008-09-18 · [Beitrag #1](https://www.typo3.net/d/81919-fehler-auf-der-detailansichtseite-von-tt-products-260/1)

Auf der Detailansicht-Seite eines Produktes werden 2 Fehlermeldungen angezeigt.
Sonst klappt alles. Wie kommts? Was kann man dagegen tun?

```html
<table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr>
						<td valign="top"><font face="Verdana,Arial" size="1">caller</font></td>
						<td><font face="Verdana,Arial" size="1" color="red">t3lib_DB::exec_SELECTquery<br /></font></td>
					</tr><tr>
						<td valign="top"><font face="Verdana,Arial" size="1">ERROR</font></td>
						<td><font face="Verdana,Arial" size="1" color="red">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 '< '' AND products.pid IN (116,683,684,685,1453,1454,681,1447,1449,1451,1455,672,' at line 4<br /></font></td>

					</tr><tr>
						<td valign="top"><font face="Verdana,Arial" size="1">lastBuiltQuery</font></td>
						<td><font face="Verdana,Arial" size="1" color="red">SELECT products.uid uid,products.pid pid,products.tstamp tstamp,products.crdate crdate,products.deleted deleted,products.sorting sorting,products.hidden hidden,products.starttime starttime,products.endtime endtime,products.fe_group fe_group,products.title title,products.subtitle subtitle,products.prod_uid prod_uid,products.itemnumber itemnumber,products.price price,products.price2 price2,products.note note,products.note2 note2,products.note_uid note_uid,products.unit_factor unit_factor,products.unit unit,products.www www,products.category category,products.address address,products.inStock inStock,products.datasheet datasheet,products.tax tax,products.weight weight,products.bulkily bulkily,products.offer offer,products.highlight highlight,products.directcost directcost,products.related_uid related_uid,products.color color,products.color2 color2,products.color3 color3,products.size size,products.size2 size2,products.size3 size3,products.description description,products.gradings gradings,products.material material,products.quality quality,products.additional_type additional_type,products.additional additional,products.special_preparation special_preparation,products.image image,products.shipping shipping,products.shipping2 shipping2,products.handling handling,products.delivery delivery,products.sellstarttime sellstarttime,products.sellendtime sellendtime<br />
			FROM tt_products products<br />
			WHERE<br />
				< '' AND products.pid IN (116,683,684,685,1453,1454,681,1447,1449,1451,1455,672,781,673,674,675,676,1445,1446) AND products.deleted=0 AND products.hidden=0 AND (products.starttime<=1221747206) AND (products.endtime=0 OR products.endtime>1221747206) AND products.fe_group IN (' ',0,-1) <br />

			ORDER BY DESC<br /></font></td>
					</tr><tr>
						<td valign="top"><font face="Verdana,Arial" size="1">debug_backtrace</font></td>
						<td><font face="Verdana,Arial" size="1" color="red">require#76 // include#446 // TSpagegen::renderContent#77 // tslib_cObj->cObjGet#332 // tslib_cObj->cObjGetSingle#444 // tslib_cObj->TEMPLATE#578 // tslib_cObj->cObjGetSingle#2469 // tslib_cObj->CONTENT#529 // tslib_cObj->cObjGetSingle#1251 // tslib_cObj->cObjGetSingle#483 // tslib_cObj->CASEFUNC#550 // tslib_cObj->cObjGetSingle#1566 // tslib_cObj->COBJ_ARRAY#502 // tslib_cObj->cObjGet#685 // tslib_cObj->cObjGetSingle#444 // tslib_cObj->CASEFUNC#550 // tslib_cObj->cObjGetSingle#1566 // tslib_cObj->CASEFUNC#550 // tslib_cObj->cObjGetSingle#1566 // tslib_cObj->cObjGetSingle#483 // tslib_cObj->USER#572 // tslib_cObj->callUserFunction#720 // call_user_func_array#5842 // tx_ttproducts_pi1->main# // tx_ttproducts_pi1->doProcessing#223 // tx_ttproducts_pi1->products_display#422 // tx_ttproducts_single_view->printView#1035 // tx_table_db->exec_SELECTquery#471 // t3lib_DB->exec_SELECTquery#752 // t3lib_DB->debug#234<br /></font></td>

					</tr></table><br />
<b>Warning</b>:  mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in <b>/var/ich/typo3sourcen/typo3_src-4.2.1/t3lib/class.t3lib_db.php</b> on line <b>808</b><br />

			<table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr>
						<td valign="top"><font face="Verdana,Arial" size="1">caller</font></td>
						<td><font face="Verdana,Arial" size="1" color="red">t3lib_DB::exec_SELECTquery<br /></font></td>

					</tr><tr>
						<td valign="top"><font face="Verdana,Arial" size="1">ERROR</font></td>
						<td><font face="Verdana,Arial" size="1" color="red">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 '> '' AND products.pid IN (116,683,684,685,1453,1454,681,1447,1449,1451,1455,672,' at line 4<br /></font></td>
					</tr><tr>
						<td valign="top"><font face="Verdana,Arial" size="1">lastBuiltQuery</font></td>
						<td><font face="Verdana,Arial" size="1" color="red">SELECT products.uid uid,products.pid pid,products.tstamp tstamp,products.crdate crdate,products.deleted deleted,products.sorting sorting,products.hidden hidden,products.starttime starttime,products.endtime endtime,products.fe_group fe_group,products.title title,products.subtitle subtitle,products.prod_uid prod_uid,products.itemnumber itemnumber,products.price price,products.price2 price2,products.note note,products.note2 note2,products.note_uid note_uid,products.unit_factor unit_factor,products.unit unit,products.www www,products.category category,products.address address,products.inStock inStock,products.datasheet datasheet,products.tax tax,products.weight weight,products.bulkily bulkily,products.offer offer,products.highlight highlight,products.directcost directcost,products.related_uid related_uid,products.color color,products.color2 color2,products.color3 color3,products.size size,products.size2 size2,products.size3 size3,products.description description,products.gradings gradings,products.material material,products.quality quality,products.additional_type additional_type,products.additional additional,products.special_preparation special_preparation,products.image image,products.shipping shipping,products.shipping2 shipping2,products.handling handling,products.delivery delivery,products.sellstarttime sellstarttime,products.sellendtime sellendtime<br />

			FROM tt_products products<br />
			WHERE<br />
				> '' AND products.pid IN (116,683,684,685,1453,1454,681,1447,1449,1451,1455,672,781,673,674,675,676,1445,1446) AND products.deleted=0 AND products.hidden=0 AND (products.starttime<=1221747206) AND (products.endtime=0 OR products.endtime>1221747206) AND products.fe_group IN (' ',0,-1) <br />
			ORDER BY ASC<br /></font></td>
					</tr><tr>

						<td valign="top"><font face="Verdana,Arial" size="1">debug_backtrace</font></td>
						<td><font face="Verdana,Arial" size="1" color="red">require#76 // include#446 // TSpagegen::renderContent#77 // tslib_cObj->cObjGet#332 // tslib_cObj->cObjGetSingle#444 // tslib_cObj->TEMPLATE#578 // tslib_cObj->cObjGetSingle#2469 // tslib_cObj->CONTENT#529 // tslib_cObj->cObjGetSingle#1251 // tslib_cObj->cObjGetSingle#483 // tslib_cObj->CASEFUNC#550 // tslib_cObj->cObjGetSingle#1566 // tslib_cObj->COBJ_ARRAY#502 // tslib_cObj->cObjGet#685 // tslib_cObj->cObjGetSingle#444 // tslib_cObj->CASEFUNC#550 // tslib_cObj->cObjGetSingle#1566 // tslib_cObj->CASEFUNC#550 // tslib_cObj->cObjGetSingle#1566 // tslib_cObj->cObjGetSingle#483 // tslib_cObj->USER#572 // tslib_cObj->callUserFunction#720 // call_user_func_array#5842 // tx_ttproducts_pi1->main# // tx_ttproducts_pi1->doProcessing#223 // tx_ttproducts_pi1->products_display#422 // tx_ttproducts_single_view->printView#1035 // tx_table_db->exec_SELECTquery#489 // t3lib_DB->exec_SELECTquery#752 // t3lib_DB->debug#234<br /></font></td>

					</tr></table><br />
<b>Warning</b>:  mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in <b>/var/ich/typo3sourcen/typo3_src-4.2.1/t3lib/class.t3lib_db.php</b> on line <b>808</b><br />
<br />
```

## Antworten

### [#2](https://www.typo3.net/d/81919-fehler-auf-der-detailansichtseite-von-tt-products-260/2) · intensivstation · 2008-09-22

Ich wundere mich, dass dieser Fehler bei niemand anderem aufrtitt.
Ich habe keine besonderen Artikel eingestellt!

Den 2. Fehler habe ich eliminiert, indem ich ein if "strlen($queryNextPrefix) > 5" in tx_ttproducts_single_view->printView eingebaut habe.

```php
  if (strlen($queryNextPrefix) > 5) {
    $querynext = $queryNextPrefix.' AND pid IN ('.$this->page->pid_list.')'. $wherestock . $itemTableArray[$this->type]->table->enableFields();
    // $resnext = $GLOBALS['TYPO3_DB']->exec_SELECTquery('*', 'tt_products', $querynext, $nextOrderby);
    $resnext = $itemTableArray[$this->type]->table->exec_SELECTquery('*', $querynext, '', $TYPO3_DB->stripOrderBy($nextOrderby));
  }

  if ((strlen($queryNextPrefix) > 5) && ($rownext = $TYPO3_DB->sql_fetch_assoc($resnext)) )	{
```

### [#3](https://www.typo3.net/d/81919-fehler-auf-der-detailansichtseite-von-tt-products-260/3) · intensivstation · 2008-09-22

Das ganze noch bei $queryPrevPrefix und schon läufts.
Keine Ahnung, wieso diese Dinger nur "> ''" oder "< ''" enthalten.

### [#4](https://www.typo3.net/d/81919-fehler-auf-der-detailansichtseite-von-tt-products-260/4) · Eros · 2008-09-22

Hallo intensivstation,

möglicherweise habe ich den selben Fehler, allerdings bis jetzt nur in der Version 2.7.0.

Er tritt bei mir auf, wenn was in den Warenkorb gelegt wird und man auf der Single-Seite bleiben will (clickIntoBasket = 0).

Ein Wechsel in den Warenkorb (clickIntoBasket = 1) bringt dagegen keinen Fehler!

Grüße

---

Quelle: „Fehler auf der Detailansichtseite von tt_products 2.6.0“, typo3.net, https://www.typo3.net/d/81919-fehler-auf-der-detailansichtseite-von-tt-products-260
Beiträge von Mitgliedern des Forums. Bitte mit Link auf die Diskussion zitieren.
