error 1146

[lcchiodo]

i have a new installation of Phoca Gallery 4.3.18 on Joomla 3.9 and get errors when i try to add categories or images.
"1146 Table 'dbname.#_phocagallery_categories' doesn't exist." It appears that Phoca is not reading the Database Tables Prefix which is set correctly in joomla. All the Phoca tables were created with correct names during the installation. Has anyone else experienced this and know how to correct?

[Jan]

Hi, did you see the categories table in your database?

Jan

[lcchiodo]

yes. all the tables were created during install with correct prefix and all columns. same error happens when i try to add images in phoca. thanks

[Jan]

Hmm, hard to say, maybe you should check if your Joomla! installation is correctly installed. Installing Phoca Gallery, connecting to database and working with Phoca Gallery tables is completely managed by Joomla! methods Did you try to reinstall it?

Jan

[lcchiodo]

no, was trying to avoid that but i think that will be the only solution. Thanks. Cheers.

[Jan]

Ok

[lcchiodo]

delete dis, and reinstalled joomla and phoca gallery and got the same errors:
1146 Table 'lachiodo_ei5.#__phocagallery_categories' doesn't exist
1146 Table 'lachiodo_ei5.#__phocagallery' doesn't exist

all the phoca table were created correctly and are named correctly (i.e. jml3_phocagallery_categories)
anyone else ever have this problem?

[Jan]

Hi, can you paste whole error messages here (enable debug mode) so we can see from which part the tables are called. If this is from Phoca Gallery (this would mean some error in Joomla! as it does not translate prefixes) or from another part of system (this could mean that e.g. some external extension does not call the Phoca Gallery tables correctly )

Jan

[lcchiodo]

An error has occurred.
1146 Table 'lachiodo_ei5.jml3_phocagallery_categories' doesn't exist
/home/www/chiodo.net/joomla/libraries/joomla/database/driver/mysqli.php:665
Call stack
# Function Location
1 () JROOT/libraries/joomla/database/driver/mysqli.php:665
2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
3 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
4 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_phocagallery/models/phocagallerycs.php:116
5 PhocaGalleryCpModelPhocaGalleryCs->getItems() JROOT/administrator/components/com_phocagallery/views/phocagallerycs/view.html.php:26
6 PhocaGalleryCpViewPhocaGalleryCs->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
7 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_phocagallery/controller.php:60
8 PhocaGalleryCpController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_phocagallery/phocagallery.php:44
10 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402
11 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
12 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101
13 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159
14 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196
15 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51
Return to Control Panel

[lcchiodo]

Joomla 3.9.16 was installed using the hosting company's automated installer. Do you think it makes sense to uninstall and install it manually?