[TYPO3-english] realURL on postgreSQL

[Christian Lerrahn]

Hi,
I've migrated a working site from MySQL to PostgreSQL. Everything seems
to work fine except for realURL. I've copied the config (see below)
from the old site where it used to work but it is not working any more.
All the tables should be ok and neither a core log nor the realURL error
log table give any clues.

There are several problems:

1. All URLs seem to look like http://www.example.com/<page alias>.
There is no hierarchy of pages. If alias is missing, I will see just
the page id in the URL.

2. While realURL does some magic on the menus, the generated links will
not work and only result in /Segment "..." was not a keyword for a
postVarSet as expected!'

3. I'm generating a language menu using the code as provided by
tt_news. The menu code should mark the active language and link to
http://www.example.com/foo and http://www.example.com/en/foo. Instead
the first link becomes http://www.example.com/foo/?L=0 and the second
one disappears (flag has no link). The marker for the active language
seems ok.

As exactly the same config and data (in the database) work like a charm
on MySQL, I assume something is going wrong in the DB queries. However,
I'm not sure how to debug that if nothing ever shows up in any of the
error logs.

Suggestions anyone?

Cheers,
Christian

**
RealURL configuration:
$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';

$TYPO3_CONF_VARS['EXTCONF']['realurl']['_DEFAULT'] = array(
    'init' => array(
        'enableCHashCache' => 1
    ),
    'preVars' => array(
        array(
            'GETvar' => 'no_cache',
            'valueMap' => array(
                'no_cache' => 1,
            ),
            'noMatch' => 'bypass',
        ),
    array(
        'GETvar' => 'L',
        'valueMap' => array(
            'en' => '1',
        ),
        'noMatch' => 'bypass',
        ),
    ),
    'fileName' => array (
        'index' => array(
            'backend.php' => array(
                'keyValues' => array (
                    'type' => 100,
                )
            ),
            'print' => array(                         
                'keyValues' => array(
                    'type' => 98,
                )
            ),
        ),
    ),
    'postVarSets' => array(
        '_DEFAULT' => array (
            'article' => array(
                array(
                    'GETvar' => 'tx_ttnews[tt_news]',
                ),
                array(
                    'GETvar' => 'tx_ttnews[backPid]',
                ),
            ),
            'category' => array(
                array(
                    'GETvar' => 'tx_ttnews[cat]',
                ),
            ),
            'neste' => array(
                array(
                    'GETvar' => 'tx_ttnews[pointer]',
                ),
            ),
        ),
    ), 
    'pagePath' => array(
        'type' => 'user',
        'userFunc' => 
'EXT:realurl/class.tx_realurl_advanced.php:&tx_realurl_advanced->main',
        'spaceCharacter' => '-',
        'languageGetVar' => 'L',
        'expireDays' => 3
    ),
); 

_______________________________________________
TYPO3-english mailing list
TYPO3-english@lists.netfielders.de
http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english