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

Hi,

I'm sorry for the late reply.

Could you post how the URLs for jDiction look with and without JoomSEF enabled? What handling do you use for jDiction in JoomSEF's Extensions Manager?

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

Is there any news regarding this issue??

Hi,

The SQL query used in JoomSEF shouldn't cause any problems. It works correctly with clean Joomla and with both JoomFish and FaLang.
I'm sorry, but I don't know what the error message "5 - cannot calculate position of lft within BY `lft` DESC" means - I think the author of the query parser should check what exactly it means and fix it.

This should be the whole query:



Where $idx->lft and $idx->rgt are values obtained by:



Where $id is the ID of the content category.

I don't see any problem with it.