jDiction Forum
English => Install & Configure jDiction => Topic started by: knackko 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
-
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.
-
Yes it is a frontend problem.
-
could you please active the system debug option and post the output here?
-
Attached is a version which hopefully fix the problem.
-
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
-
Attached is a version which hopefully fix the problem.
Yes it is running now for user profile with user fields, thanks !