Print

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

[knackko]

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

[Harald Leithner]

Quote from github:

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.

[knackko]

Yes it is a frontend problem.

[Harald Leithner]

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

[Harald Leithner]

Attached is a version which hopefully fix the problem.

[knackko]

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

[knackko]

Attached is a version which hopefully fix the problem.

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