1054 Unknown column 'access' in 'field list'

[alain_56]

Bonjour,
Cette erreur s'affiche lors de la modification du contenu d’une image : titre, description…
Savez-vous l'origine de cette erreur ?
Cordialement
Alain
Phoca Galerie : 4.5.4
PHP : 8.1.23
Joomla! 4.3.4 Stable 22-08-2023

[Benno]

Hi,
see: viewtopic.php?t=64981

Kind regards,
Benno

[alain_56]

Hi Benno
i checked Enable Thumbnail Génération : yes
but the error continues
Kind regards,
Alain

Une erreur est survenue
1054 Unknown column 'access' in 'field list'
Call stack
# Function Location
1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:137
2 mysqli->prepare() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:137
3 Joomla\Database\Mysqli\MysqliStatement->__construct() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1089
4 Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1900
5 Joomla\Database\DatabaseDriver->setQuery() JROOT/administrator/components/com_finder/src/Indexer/Adapter.php:511
6 Joomla\Component\Finder\Administrator\Indexer\Adapter->checkItemAccess() JROOT/plugins/finder/phocagallerytag/src/Extension/PhocaGalleryTag.php:86
7 Phoca\Plugin\Finder\PhocaGalleryTag\Extension\PhocaGalleryTag->onFinderBeforeSave() JROOT/libraries/src/Plugin/CMSPlugin.php:284
8 Joomla\CMS\Plugin\CMSPlugin->Joomla\CMS\Plugin\{closure}() JROOT/libraries/vendor/joomla/event/src/Dispatcher.php:486
9 Joomla\Event\Dispatcher->dispatch() JROOT/libraries/src/Application/EventAware.php:111
10 Joomla\CMS\Application\WebApplication->triggerEvent() JROOT/plugins/content/finder/finder.php:66
11 PlgContentFinder->onContentBeforeSave() JROOT/libraries/src/Plugin/CMSPlugin.php:284
12 Joomla\CMS\Plugin\CMSPlugin->Joomla\CMS\Plugin\{closure}() JROOT/libraries/vendor/joomla/event/src/Dispatcher.php:486
13 Joomla\Event\Dispatcher->dispatch() JROOT/libraries/src/Application/EventAware.php:111
14 Joomla\CMS\Application\WebApplication->triggerEvent() JROOT/administrator/components/com_phocagallery/models/phocagalleryimg.php:333
15 PhocaGalleryCpModelPhocaGalleryImg->save() JROOT/libraries/src/MVC/Controller/FormController.php:675
16 Joomla\CMS\MVC\Controller\FormController->save() JROOT/libraries/src/MVC/Controller/BaseController.php:678
17 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_phocagallery/phocagallery.php:50
18 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
19 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73
20 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:361
21 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:143
22 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:186
23 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:293
24 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:61
25 require_once() JROOT/administrator/index.php:32

[Benno]

Hi,

Hi, do you use version 4.5.3 of the finder plugin? There is no such line in this verison.

Jan

Means, this error occurs if you have installed an older version of the Phoca Gallery Finder Plugin(s). Update this plugin(s) to the current version 4.5.3

Kind regards,
Benno

[alain_56]

Hi
Version 4.5.3 of finder plugin (image) and Version 4.5.3 of finder plugin (categorie)
is installed, But the problem persists

Call stack
# Function Location
1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:137
2 mysqli->prepare() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:137
3 Joomla\Database\Mysqli\MysqliStatement->__construct() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1089
4 Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1900
5 Joomla\Database\DatabaseDriver->setQuery() JROOT/administrator/components/com_finder/src/Indexer/Adapter.php:511
6 Joomla\Component\Finder\Administrator\Indexer\Adapter->checkItemAccess() JROOT/plugins/finder/phocagallerytag/src/Extension/PhocaGalleryTag.php:86
7 Phoca\Plugin\Finder\PhocaGalleryTag\Extension\PhocaGalleryTag->onFinderBeforeSave() JROOT/libraries/src/Plugin/CMSPlugin.php:284
8 Joomla\CMS\Plugin\CMSPlugin->Joomla\CMS\Plugin\{closure}() JROOT/libraries/vendor/joomla/event/src/Dispatcher.php:486
9 Joomla\Event\Dispatcher->dispatch() JROOT/libraries/src/Application/EventAware.php:111
10 Joomla\CMS\Application\WebApplication->triggerEvent() JROOT/plugins/content/finder/finder.php:66
11 PlgContentFinder->onContentBeforeSave() JROOT/libraries/src/Plugin/CMSPlugin.php:284
12 Joomla\CMS\Plugin\CMSPlugin->Joomla\CMS\Plugin\{closure}() JROOT/libraries/vendor/joomla/event/src/Dispatcher.php:486
13 Joomla\Event\Dispatcher->dispatch() JROOT/libraries/src/Application/EventAware.php:111
14 Joomla\CMS\Application\WebApplication->triggerEvent() JROOT/administrator/components/com_phocagallery/models/phocagalleryimg.php:333
15 PhocaGalleryCpModelPhocaGalleryImg->save() JROOT/libraries/src/MVC/Controller/FormController.php:675
16 Joomla\CMS\MVC\Controller\FormController->save() JROOT/libraries/src/MVC/Controller/BaseController.php:678
17 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_phocagallery/phocagallery.php:50
18 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
19 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73
20 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:361
21 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:143
22 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:186
23 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:293
24 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:61
25 require_once() JROOT/administrator/index.php:32

[Jan]

Hi, what type of pluign is: plugins/finder/phocagallerytag? Where did you download this plugin?

[alain_56]

Hi Jan,
Phoca Gallery Finder Plugin (Tags) - searching Phoca Gallery tags
2.0.3
24-04-2023
ConseilGouz

Indexation - Champs personnalisés Phoca Gallery (Fields)
1.0.3
24-04-2023
ConseilGouz

https://github.com/conseilgouz/plg_find ... lerytag_j4

by deactivating these two plugins, the error disappears

[Jan]

Hi, unfortunately, I am not author of this plugin, so you need to ask the author of this plugin to change the code here:
https://github.com/conseilgouz/plg_find ... eryTag.php

Jan