Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[axa]

Hello,

I unfortunately can't change the language.
If I move the mouse over the flags the URL is shown correctly but nothing happens when I click on a flag.

The check tool (Ueberprüfung.jpg) shows:

Datenbank: jDiction Database Driver XML View is selected

But in fact in configuration (Konfiguration.jpg) is selected:

Typ: Jdiction_mysqli

If I select in configuration

Typ: Jdiction_mysqli_viewxml

then the check tool (Ueberpruefung_xml.jpg) shows:

Datenbank: jDiction Database Driver Legacy is selected

but the frontend (Frontend_xml.jpg) only shows:

1305 - FUNCTION prader04.EXTRACTVALUE does not exist SQL=CREATE OR REPLACE ALGORITHM=UNDEFINED SQL SECURITY INVOKER VIEW `#__jd_3_categories` AS SELECT `t1`.`id`,`t1`.`asset_id`,`t1`.`parent_id`,`t1`.`lft`,`t1`.`rgt`,`t1`.`level`,`t1`.`path`,`t1`.`extension`,IFNULL(IF(EXTRACTVALUE(`jds`.`value`,'count(/jDiction/title)') = 0 , `t1`.`title`, EXTRACTVALUE(`jds`.`value`,'/jDiction/title')), `t1`.`title`) AS `title`,IFNULL(IF(EXTRACTVALUE(`jds`.`value`,'count(/jDiction/alias)') = 0 , `t1`.`alias`, EXTRACTVALUE(`jds`.`value`,'/jDiction/alias')), `t1`.`alias`) AS `alias`,`t1`.`note`,IFNULL(IF(EXTRACTVALUE(`jds`.`value`,'count(/jDiction/description)') = 0 , `t1`.`description`, EXTRACTVALUE(`jds`.`value`,'/jDiction/description')), `t1`.`description`) AS `description`,`t1`.`published`,`t1`.`checked_out`,`t1`.`checked_out_time`,`t1`.`access`,`t1`.`params`,IFNULL(IF(EXTRACTVALUE(`jds`.`value`,'count(/jDiction/metadesc)') = 0 , `t1`.`metadesc`, EXTRACTVALUE(`jds`.`value`,'/jDiction/metadesc')), `t1`.`metadesc`) AS `metadesc`,IFNULL(IF(EXTRACTVALUE(`jds`.`value`,'count(/jDiction/metakey)') = 0 , `t1`.`metakey`, EXTRACTVALUE(`jds`.`value`,'/jDiction/metakey')), `t1`.`metakey`) AS `metakey`,`t1`.`metadata`,`t1`.`created_user_id`,`t1`.`created_time`,`t1`.`modified_user_id`,`t1`.`modified_time`,`t1`.`hits`,`t1`.`language`,`t1`.`version` FROM `#__categories` AS `t1` LEFT JOIN `#__jd_store` AS `jds` ON `t1`.`id` = `jds`.`idReference` AND (`jds`.`referenceTable` = '#__categories' AND `jds`.`idLang` = '3')

Please, could anybody help me?

Thank you for your help in advance!


Kind regards

axa

[Harald Leithner]

Please use the Jdiction_mysqli database driver because the viewxml is not supported on your mysql server.

[axa]

Thank you for your answer.
If I use the Jdiction_mysqli database there also the issue that I can't switch the language ...

Would Jdiction_mysqli_viewxml be better? Should I ask my provider for support?

Do you have any idea what else I can do?

[Harald Leithner]

the provider have to support the mysql xml extension, you can ask him.

It would be better but I found a bug yesterday in mysql that maybe make big trouble, anyway you can switch later if you like.