I get following debug message for the position error:
cannot calculate position of lft within BY `lft` DESC
Call stack
# Function Location
1 JSite->dispatch() /www/index.php:52
2 JComponentHelper::renderComponent() /www/includes/application.php:220
3 JComponentHelper::executeComponent() /www/libraries/legacy/component/helper.php:335
4 require_once() /www/libraries/legacy/component/helper.php:355
5 JControllerLegacy->execute() /www/components/com_content/content.php:16
6 ContentController->display() /www/libraries/legacy/controller/legacy.php:722
7 JControllerLegacy->display() /www/components/com_content/controller.php:79
8 ContentViewCategory->display() /www/libraries/legacy/controller/legacy.php:685
9 ContentViewCategory->_prepareDocument() /www/components/com_content/views/category/view.html.php:207
10 JRoute::_() /www/components/com_content/views/category/view.html.php:315
11 JRouterSite->build() /www/libraries/joomla/application/route.php:62
12 JRouter->build() /www/libraries/cms/router/site.php:97
13 JRouterSite->_processBuildRules() /www/libraries/joomla/application/router.php:203
14 JRouter->_processBuildRules() /www/libraries/cms/router/site.php:549
15 call_user_func_array() /www/libraries/joomla/application/router.php:436
16 JRouterJoomsef->build()
17 JoomSEF->build() /www/components/com_sef/sef.router.php:269
18 SefExt_com_content->create() /www/components/com_sef/joomsef.php:525
19 SefExt->getCategoryInfo() /www/components/com_sef/sef_ext/com_content.php:442
20 JdDatabase->loadObjectList() /www/components/com_sef/sef.ext.php:446
21 JdDatabase->loadTranslation() /www/libraries/jdiction/database/jddatabase.php:256
22 JDatabaseDriver->loadRowList() /www/libraries/jdiction/database/jddatabase.php:367
23 JdDatabase->execute() /www/libraries/joomla/database/driver.php:1391
24 JdDatabase->addJoinKeys() /www/libraries/jdiction/database/jddatabase.php:421
25 MySqlParser->parse() /www/libraries/jdiction/database/jddatabase.php:500
26 PositionCalculator->setPositionsWithinSQL() /www/libraries/jdiction/database/parser/mysql-parser.php:80
27 PositionCalculator->lookForBaseExpression() /www/libraries/jdiction/database/parser/classes/position-calculator.php:71
28 PositionCalculator->lookForBaseExpression() /www/libraries/jdiction/database/parser/classes/position-calculator.php:204
29 PositionCalculator->lookForBaseExpression() /www/libraries/jdiction/database/parser/classes/position-calculator.php:204
So - as I understand it - this expression:
$this->lookForBaseExpression($sql, $charPos, $parsed[$key], $key, $backtracking);
is giving the error
Do you know what that means?