?
avatar wunschradio
wunschradio
18 Jun 2018

Steps to reproduce the issue

Go to users, select a user and delete

Expected result

user should be deleted

Actual result

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 4

System information (as much as possible)

Joomla 3.8.8
mySQL: 5.5.5-10.0.32-MariaDB-0+deb8u1
PHP: 7.1.18

avatar wunschradio wunschradio - open - 18 Jun 2018
avatar joomla-cms-bot joomla-cms-bot - change - 18 Jun 2018
Labels Added: ?
avatar joomla-cms-bot joomla-cms-bot - labeled - 18 Jun 2018
avatar carlitorweb
carlitorweb - comment - 18 Jun 2018

I cant reproduce your issue. Tested in the last staging and a real site.

avatar Quy
Quy - comment - 18 Jun 2018

Unable to reproduce too. Under Global Configuration > System, please enable Debug System and post debug info.

avatar wunschradio
wunschradio - comment - 18 Jun 2018

Tested on several sites, but you are right. It's not happening on all sites. Here is the debug info:
`

Call stack

| Function | Location

1 | () | JROOT/libraries/joomla/database/driver/mysqli.php:650
2 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691
3 | JDatabaseDriver->loadObjectList() | JROOT/plugins/user/jomsocialuser/jomsocialuser.php:281
4 | plgUserJomSocialUser->deleteFromCommunityMsg() | JROOT/plugins/user/jomsocialuser/jomsocialuser.php:41
5 | plgUserJomSocialUser->onBeforeDeleteUser() | JROOT/plugins/user/jomsocialuser/jomsocialuser.php:64
6 | plgUserJomSocialUser->onUserBeforeDelete() | JROOT/libraries/joomla/event/event.php:70
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160
8 | JEventDispatcher->trigger() | JROOT/administrator/components/com_users/models/user.php:379
9 | UsersModelUser->delete() | JROOT/libraries/src/MVC/Controller/AdminController.php:132
10 | Joomla\CMS\MVC\Controller\AdminController->delete() | JROOT/libraries/src/MVC/Controller/BaseController.php:710
11 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_users/users.php:21
12 | require_once() | JROOT/libraries/src/Component/ComponentHelper.php:382
13 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357
14 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/AdministratorApplication.php:101
15 | Joomla\CMS\Application\AdministratorApplication->dispatch() | JROOT/libraries/src/Application/AdministratorApplication.php:159
16 | Joomla\CMS\Application\AdministratorApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195
17 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/administrator/index.php:51

`
Seems to be a problem of JomSocial. The problem does not occur on other sites. Sorry for adding an issue while its not Joomla's fault. I just opened this because it happened in the Joomla core user section.

avatar brianteeman
brianteeman - comment - 18 Jun 2018

As shown by the stack trace this is a problem with nonsocial and not joomla. You should ask them for support.

avatar brianteeman brianteeman - change - 18 Jun 2018
Status New Closed
Closed_Date 0000-00-00 00:00:00 2018-06-18 15:59:49
Closed_By brianteeman
avatar brianteeman brianteeman - close - 18 Jun 2018
avatar carlitorweb
carlitorweb - comment - 18 Jun 2018

Seen you have a 3rd extension making problem on you site "jomsocialuser"

Add a Comment

Login with GitHub to post a comment