[TYPO3] MySQL result resource Error in Extension, only with realURL switched on.

[christian oettinger]

Hi all,


I get the following Error on the output-page of a very simple own 
Extension (kicktarted).

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL 
result resource in /typo3_src-3.8.1/t3lib/class.t3lib_db.php on line 741

The extension shows a list-view of fotos. It works in each case (!) the 
fotos are shown, but when realURL is switched on, the error is 
additionally outputted once for each foto.

I think I can trace this down to this line in my pi_list_makelist:
while($this->internal['currentRow'] = 
$GLOBALS['TYPO3_DB']->sql_fetch_assoc($res))

And pi_list_makelist is called through the lines:
$res = $this->pi_exec_query('tx_astridyomeikanphotos_photos');
$fullTable.=$this->pi_list_makelist($res);

All standard.

I then went to pi_exec_query, where my $res is created and debugged the 
$queryparts:

SELECT	tx_astridyomeikanphotos_photos.*
FROM	tx_astridyomeikanphotos_photos
WHERE	pid IN (12)
AND tx_astridyomeikanphotos_photos.deleted=0 AND 
tx_astridyomeikanphotos_photos.hidden=0
GROUPBY	
ORDERBY	tx_astridyomeikanphotos_photos.sorting
LIMIT	0,100

I can see nothing special.
DO I MISS SOMETHING? Do I need special fields in my extension for 
realURL to work with it (I think not)?

I would be greatful for ANY IDEAS!!
I'm working with 3.8.1 and realURL 0.3.0


thanks in advance

oe