Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

Component compatibility issue, jDiction
(1 viewing) (1) Guest
Support forum for customers who have purchased JoomSEF 4 (Joomla 1.6/1.7/2.5+ compatible). Archive only, no new post can be added.

NOTE: This category has been locked. If you have purchased paid version, please, use our Support Ticket system instead. If you are using free edition, please see the Community Support section.
  • Page:
  • 1

TOPIC: Component compatibility issue, jDiction

Component compatibility issue, jDiction 10 years, 5 months ago #41188

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
The topic has been locked.

Re: Component compatibility issue, jDiction 10 years, 5 months ago #41382

  • dajo
  • OFFLINE
  • Posts: 5069
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?
ARTIO Support Team
The topic has been locked.

Re: Component compatibility issue, jDiction 10 years, 5 months ago #41409

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
The topic has been locked.

Re: Component compatibility issue, jDiction 10 years, 4 months ago #41588

Is there any news regarding this issue??
The topic has been locked.

Re: Component compatibility issue, jDiction 10 years, 4 months ago #41595

  • dajo
  • OFFLINE
  • Posts: 5069
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:

SELECT `id`, `title`, `alias`, `description`, language, `metakey`, `metadesc`, `metadata`, `parent_id` FROM `#__categories` WHERE `lft` <= '{$idx->lft}' AND `rgt` >= '{$idx->rgt}' AND id!=1 ORDER BY `lft` DESC


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

SELECT `lft`, `rgt` FROM `#__categories` WHERE `id` = '{$id}'


Where $id is the ID of the content category.

I don't see any problem with it.
ARTIO Support Team
The topic has been locked.
  • Page:
  • 1
User Login Empty