Is there any news regarding this issue??

Hi,

With Apache mod_rewrite OFF and Global SEF URLs OFF in SEF Status I have urls like:

www.mysite.com/index.php?lang=da
www.mysite.com/index.php?lang=de
www.mysite.com/index.php?lang=en

If I switch Apache mod_rewrite ON and Global SEF URLs ON in SEF Status I have urls like:

www.mysite.com/da

But if I switch languages I get:
www.mysite.com/en with the following error: "5 - cannot calculate position of lft within BY `lft` DESC" .

I am using JoomSEF default handler. However I have tried the others as well - the result seems to be the same.

/Soren

Hi,

I am running:

Joomla 3.1.5 Stable
PHP 5.3.5
JoomSEF 4.4.4
jDiction 0.9.9.10

Language is handled by JoomSEF as described in installation notes (System - Language Filter, disabled / all JoomSEF plug-ins/modules, enabled).


Problem is that JoomSEF (com_sef) uses a query syntax that can not be parsed by jdiction.

This is the debug message:

cannot calculate position of lft within BY `lft` DESC

Call stack
# Function Location
1 JSite->dispatch() /home/kaspernj/www/vus.as_joomla/www/index.php:52
2 JComponentHelper::renderComponent() /home/kaspernj/www/vus.as_joomla/www/includes/application.php:220
3 JComponentHelper::executeComponent() /home/kaspernj/www/vus.as_joomla/www/libraries/legacy/component/helper.php:335
4 require_once() /home/kaspernj/www/vus.as_joomla/www/libraries/legacy/component/helper.php:355
5 JControllerLegacy->execute() /home/kaspernj/www/vus.as_joomla/www/components/com_content/content.php:16
6 ContentController->display() /home/kaspernj/www/vus.as_joomla/www/libraries/legacy/controller/legacy.php:722
7 JControllerLegacy->display() /home/kaspernj/www/vus.as_joomla/www/components/com_content/controller.php:79
8 ContentViewCategory->display() /home/kaspernj/www/vus.as_joomla/www/libraries/legacy/controller/legacy.php:685
9 ContentViewCategory->_prepareDocument() /home/kaspernj/www/vus.as_joomla/www/components/com_content/views/category/view.html.php:207
10 JRoute::_() /home/kaspernj/www/vus.as_joomla/www/components/com_content/views/category/view.html.php:315
11 JRouterSite->build() /home/kaspernj/www/vus.as_joomla/www/libraries/joomla/application/route.php:62
12 JRouter->build() /home/kaspernj/www/vus.as_joomla/www/libraries/cms/router/site.php:97
13 JRouterSite->_processBuildRules() /home/kaspernj/www/vus.as_joomla/www/libraries/joomla/application/router.php:203
14 JRouter->_processBuildRules() /home/kaspernj/www/vus.as_joomla/www/libraries/cms/router/site.php:549
15 call_user_func_array() /home/kaspernj/www/vus.as_joomla/www/libraries/joomla/application/router.php:436
16 JRouterJoomsef->build()
17 JoomSEF->build() /home/kaspernj/www/vus.as_joomla/www/components/com_sef/sef.router.php:269
18 SefExt_com_content->create() /home/kaspernj/www/vus.as_joomla/www/components/com_sef/joomsef.php:525
19 SefExt->getCategoryInfo() /home/kaspernj/www/vus.as_joomla/www/components/com_sef/sef_ext/com_content.php:442
20 JdDatabase->loadObjectList() /home/kaspernj/www/vus.as_joomla/www/components/com_sef/sef.ext.php:446
21 JdDatabase->loadTranslation() /home/kaspernj/www/vus.as_joomla/www/libraries/jdiction/database/jddatabase.php:256
22 JDatabaseDriver->loadRowList() /home/kaspernj/www/vus.as_joomla/www/libraries/jdiction/database/jddatabase.php:367
23 JdDatabase->execute() /home/kaspernj/www/vus.as_joomla/www/libraries/joomla/database/driver.php:1391
24 JdDatabase->addJoinKeys() /home/kaspernj/www/vus.as_joomla/www/libraries/jdiction/database/jddatabase.php:421
25 MySqlParser->parse() /home/kaspernj/www/vus.as_joomla/www/libraries/jdiction/database/jddatabase.php:500
26 PositionCalculator->setPositionsWithinSQL() /home/kaspernj/www/vus.as_joomla/www/libraries/jdiction/database/parser/mysql-parser.php:80
27 PositionCalculator->lookForBaseExpression() /home/kaspernj/www/vus.as_joomla/www/libraries/jdiction/database/parser/classes/position-calculator.php:71
28 PositionCalculator->lookForBaseExpression() /home/kaspernj/www/vus.as_joomla/www/libraries/jdiction/database/parser/classes/position-calculator.php:204
29 PositionCalculator->lookForBaseExpression() /home/kaspernj/www/vus.as_joomla/www/libraries/jdiction/database/parser/classes/position-calculator.php:204


The developer of jDiction is very interested in the solving of this issue, but needs your cooperation.

I hope you will prioritize looking at this problem ASAP.

Thank you in advance.

Best,
Soren Scheibye