jDiction Forum

Please login or register.

Login with username, password and session length
Advanced search  

News:

jDiction 2.2.0 released. http://jdiction.org/downloads

Author Topic: Language doesn't change  (Read 2244 times)

axa

  • Newbie
  • *
  • Posts: 7
    • View Profile
Language doesn't change
« on: September 12, 2016, 11:59:02 am »

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:
Quote
Datenbank: jDiction Database Driver XML View is selected

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





If I select in configuration
Quote
Typ: Jdiction_mysqli_viewxml

then the check tool (Ueberpruefung_xml.jpg) shows:
Quote
Datenbank: jDiction Database Driver Legacy is selected


but the frontend (Frontend_xml.jpg) only shows:
Quote
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
Logged

Harald Leithner

  • Administrator
  • Hero Member
  • *****
  • Posts: 1652
    • View Profile
Re: Language doesn't change
« Reply #1 on: September 12, 2016, 12:10:40 pm »

Please use the Jdiction_mysqli database driver because the viewxml is not supported on your mysql server.
Logged
Joomla 3.9.x Release Lead
Joomla Production Coordinator
Vote at JED

axa

  • Newbie
  • *
  • Posts: 7
    • View Profile
Re: Language doesn't change
« Reply #2 on: September 12, 2016, 02:16:29 pm »

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?
Logged

Harald Leithner

  • Administrator
  • Hero Member
  • *****
  • Posts: 1652
    • View Profile
Re: Language doesn't change
« Reply #3 on: September 12, 2016, 02:38:26 pm »

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.
Logged
Joomla 3.9.x Release Lead
Joomla Production Coordinator
Vote at JED