[Typo3] RealURL Problem

[christian oettinger]

Hi all,


I try to configure realURL at the moment. I thought I have got it and it 
works very well, but I get one big problem nevertheless:
When viewing List view of my own extension (in FE) I get the following 
SQL-Error:

"Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL 
result resource in 
/homepages/24/d124225771/htdocs/t3lib/class.t3lib_db.php on line 723"

The error is created once for each record that is found, but
- only when realURL is switched on.
- only when I give out Field Content (via getFieldContent) that is 
linked. So when disabling these parts in function list_row in my plugin 
the error is gone.
Please note: I use $this->pi_list_linkSingle to link the field Content 
to SingleView. The link is generated. It is in beautiful realURL-Style 
and works well.

So everything works right!!! - only the SQL-Warning is given.
I'm working in 3.7.0 with realURL 0.2.0, below my configuration

thanks for any help!

oe (christian)


<?php
$TYPO3_CONF_VARS['SC_OPTIONS'] ['t3lib/class.t3lib_tstemplate.php'] 
['linkData-PostProc'] [] = 
'EXT:realurl/class.tx_realurl.php:&tx_realurl->encodeSpURL';
$TYPO3_CONF_VARS['SC_OPTIONS'] ['tslib/class.tslib_fe.php'] 
['checkAlternativeIdMethods-PostProc'] [] = 
'EXT:realurl/class.tx_realurl.php:&tx_realurl->decodeSpURL';
$TYPO3_CONF_VARS['SC_OPTIONS'] ['t3lib/class.t3lib_tcemain.php'] 
['clearAllCache_additionalTables'] ['tx_realurl_urldecodecache'] = 
'tx_realurl_urldecodecache';
$TYPO3_CONF_VARS['SC_OPTIONS'] ['t3lib/class.t3lib_tcemain.php'] 
['clearAllCache_additionalTables'] ['tx_realurl_urlencodecache'] = 
'tx_realurl_urlencodecache';
$TYPO3_CONF_VARS['FE'] ['addRootLineFields'] .= 
',tx_realurl_pathsegment,alias,nav_title,title';
$TYPO3_CONF_VARS['EXTCONF'] ['realurl'] ['_DEFAULT'] = array(
	'init' => array(
		'enableCHashCache' => 1,
		'enableUrlDecodeCache' => 1,
		'enableUrlEncodeHash' => 1,
		// 'postVarSet_failureMode' => 'redirect_goodUpperDir',
	),
	'rewrite' => array(
	),
	
	'preVars' => array(

		array(
			'GETvar' => 'L',
			'valueMap' => array(
			'de' => '1',
		),
			'noMatch' => 'bypass',
		),

	),
	'pagePath' => array(
		'type' => 'user',
		'userFunc' => 
'EXT:realurl/class.tx_realurl_advanced.php:&tx_realurl_advanced->main',
		'spaceCharacter' => '-',
		'languageGetVar' => 'L',
		'expireDays' => 3,
		'rootpage_id' => '1'
	),
	'fileName' => array (
		'defaultToHTMLsuffixOnPrev' => 1,
		'index' => array(
			'index.html' => array(
				'keyValues' => array (
					'type' => 1,
				),
			),
		),
	),
	'fixedPostVarSets' => array(
	),
	'postVarSets' => array(
		'_DEFAULT' => array(
			//archive
			
			'buch' => array (
				array (
					'GETvar' => 'tx_oebooksandmagazines_pi1[showUid]',
					'lookUpTable' => array (
						'table' => 'tx_oebooksandmagazines_books',
						'id_field' => 'uid',
						'useUniqueCache'=> 1,
						'useUniqueCache_conf' => array (
							'strtolower' => 1,
							'spaceCharacter' => '-',
						),
					),					
				),
			),

			'zeitschrift' => array (
				array (
					'GETvar' => 'tx_oebooksandmagazines_pi2[showUid]',
					'lookUpTable' => array (
						'table' => 'tx_oebooksandmagazines_magazines',
						'id_field' => 'uid',
						'useUniqueCache'=> 1,
						'useUniqueCache_conf' => array (
							'strtolower' => 1,
							'spaceCharacter' => '-',
						),
					),					
				),
			),
		),
	),
);
?>