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: jdiction 2.1.0, Joomla 3.8.4&3.8.5 dev issue  (Read 9480 times)

knackko

  • Newbie
  • *
  • Posts: 4
    • View Profile
jdiction 2.1.0, Joomla 3.8.4&3.8.5 dev issue
« on: February 05, 2018, 10:32:33 am »

Hello,
Please check that issue opened at joomla! github:
https://github.com/joomla/joomla-cms/issues/19568
Logged

Harald Leithner

  • Administrator
  • Hero Member
  • *****
  • Posts: 1652
    • View Profile
Re: jdiction 2.1.0, Joomla 3.8.4&3.8.5 dev issue
« Reply #1 on: February 05, 2018, 10:58:42 am »

Quote from github:
Quote
Steps to reproduce the issue
Joomla 3.8.5 dev
Jdiction 2.1.0 activated
One or more User fields
Users ยป Edit User Profile

Expected result
Edit user profile

Actual result
Edit user profile (FR or EN): 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND referenceTable='' AND idLang='2'' at line 4
Edit user profile is OK when user fields are deactivated !

System information (as much as possible)
OS Linux k
PHP 7.1.13-1+ubuntu16.04.1+deb.sury.org+1
MySQLi 5.7.21-0ubuntu0.16.04.1
Time 10:26
Caching Enabled
Gzip Enabled

Test   Result
    
Version   Library Version: 2.1.0
Joomla Version 3.8.5-rc is unkown.   
Plugin   Joomla Languagefilter Plugin is enabled
JDiction Plugin is enabled.   
Database   jDiction Database Driver XML View is selected
Language   Seam to be good
Module   Module is enabled
Common mistakes   At least one content item has the language set not to ALL.
Additional comments
It appears after 3.8.4 update, tried 3.8.5 dev, is there anybody else in that case with jdiction?

is this a frontend problem? Because in backend jdiction isn't active.
Logged
Joomla 3.9.x Release Lead
Joomla Production Coordinator
Vote at JED

knackko

  • Newbie
  • *
  • Posts: 4
    • View Profile
Re: jdiction 2.1.0, Joomla 3.8.4&3.8.5 dev issue
« Reply #2 on: February 05, 2018, 11:00:56 am »

Yes it is a frontend problem.
Logged

Harald Leithner

  • Administrator
  • Hero Member
  • *****
  • Posts: 1652
    • View Profile
Re: jdiction 2.1.0, Joomla 3.8.4&3.8.5 dev issue
« Reply #3 on: February 05, 2018, 11:10:31 am »

could you please active the system debug option and post the output here?

Logged
Joomla 3.9.x Release Lead
Joomla Production Coordinator
Vote at JED

Harald Leithner

  • Administrator
  • Hero Member
  • *****
  • Posts: 1652
    • View Profile
Re: jdiction 2.1.0, Joomla 3.8.4&3.8.5 dev issue
« Reply #4 on: February 05, 2018, 11:40:25 am »

Attached is a version which hopefully fix the problem.
Logged
Joomla 3.9.x Release Lead
Joomla Production Coordinator
Vote at JED

knackko

  • Newbie
  • *
  • Posts: 4
    • View Profile
Re: jdiction 2.1.0, Joomla 3.8.4&3.8.5 dev issue
« Reply #5 on: February 05, 2018, 11:49:34 am »

could you please active the system debug option and post the output here?

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND referenceTable='' AND idLang='2'' at line 4

Call stack
#    Function    Location
1    ()    JROOT/libraries/joomla/database/driver/mysqli.php:650
2    JDatabaseDriverMysqli->execute()    JROOT/libraries/jdiction/database/driver/mysqli.php:82
3    JdDatabaseAdapter->execute()    JROOT/libraries/jdiction/database/jddatabaseviewxml.php:501
4    JdDatabaseViewXML->execute()    JROOT/libraries/joomla/database/driver.php:1691
5    JDatabaseDriver->loadObjectList()    JROOT/libraries/jdiction/database/jddatabaseviewxml.php:256
6    JdDatabaseViewXML->loadObjectList()    JROOT/libraries/jdiction/jdiction.php:1082
7    jDiction->getRawTranslations()    JROOT/libraries/jdiction/jdiction.php:1045
8    jDiction->getRawTranslationsByView()    JROOT/plugins/system/jdiction/jdiction.php:398
9    plgSystemjDiction->onCustomFieldsBeforePrepareField()    JROOT/libraries/joomla/event/event.php:70
10    JEvent->update()    JROOT/libraries/joomla/event/dispatcher.php:160
11    JEventDispatcher->trigger()    JROOT/administrator/components/com_fields/helpers/fields.php:197
12    FieldsHelper::getFields()    JROOT/plugins/system/fields/fields.php:427
13    PlgSystemFields->onContentPrepare()    JROOT/libraries/joomla/event/event.php:70
14    JEvent->update()    JROOT/libraries/joomla/event/dispatcher.php:160
15    JEventDispatcher->trigger()    JROOT/components/com_users/views/profile/view.html.php:93
16    UsersViewProfile->display()    JROOT/components/com_users/controller.php:133
17    UsersController->display()    JROOT/libraries/src/MVC/Controller/BaseController.php:710
18    Joomla\CMS\MVC\Controller\BaseController->execute()    JROOT/components/com_users/users.php:15
19    require_once()    JROOT/libraries/src/Component/ComponentHelper.php:382
20    Joomla\CMS\Component\ComponentHelper::executeComponent()    JROOT/libraries/src/Component/ComponentHelper.php:357
21    Joomla\CMS\Component\ComponentHelper::renderComponent()    JROOT/libraries/src/Application/SiteApplication.php:194
22    Joomla\CMS\Application\SiteApplication->dispatch()    JROOT/libraries/src/Application/SiteApplication.php:233
23    Joomla\CMS\Application\SiteApplication->doExecute()    JROOT/libraries/src/Application/CMSApplication.php:303
24    Joomla\CMS\Application\CMSApplication->execute()    JROOT/index.php:49
Logged

knackko

  • Newbie
  • *
  • Posts: 4
    • View Profile
Re: jdiction 2.1.0, Joomla 3.8.4&3.8.5 dev issue
« Reply #6 on: February 05, 2018, 11:51:19 am »

Attached is a version which hopefully fix the problem.

Yes it is running now for user profile with user fields, thanks !
Logged