Thursday, 22 December 2022
  2 Replies
  387 Visits
0
Votes
Undo
I can unpublish the category, but when I try to trash I get error:

0 mysqli_fetch_object(): Argument #1 ($result) must be of type mysqli_result, bool given
....../libraries/joomla/database/driver/mysqli.php:894

Call stack is:
# Function Location
1 () JROOT/libraries/joomla/database/driver/mysqli.php:894
2 mysqli_fetch_object() JROOT/libraries/joomla/database/driver/mysqli.php:894
3 JDatabaseDriverMysqli->fetchObject() JROOT/libraries/joomla/database/driver.php:1707
4 JDatabaseDriver->loadObjectList() JROOT/plugins/content/jevents/jevents.php:164
5 plgContentJEvents->onCategoryChangeState() JROOT/libraries/joomla/event/event.php:70
6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
7 JEventDispatcher->trigger() JROOT/administrator/components/com_categories/models/category.php:741
8 CategoriesModelCategory->publish() JROOT/libraries/src/MVC/Controller/AdminController.php:198
9 Joomla\CMS\MVC\Controller\AdminController->publish() JROOT/libraries/src/MVC/Controller/BaseController.php:702
10 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_categories/categories.php:27
11 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402
12 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
13 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101
14 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159
15 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
16 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51
craigh123 set the post as Normal priority — 2 years ago
craigh123 set the type of the post as  Technical — 2 years ago
2 years ago
·
#229238
0
Votes
Undo
It seemed there were some past trashed events in the category I was trying to remove which I needed to empty trash on first. This then avoided the problem code which was in the process of forming the error message for this situation.
2 years ago
·
#229302
0
Votes
Undo
Sorry for the poor level of support over the year end. Holidays and being ill is not a good combination :(

Glad you resolved the issue - I'll trap the error in the code for the next release.

JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!

  • Page :
  • 1
There are no replies made for this post yet.