Page 1 of 1
Error after installing.
Posted: 05 Sep 2025, 15:21
by arctellion
Code: Select all
500 42601, 7, ERROR: syntax error at or near "`" LINE 2: FROM `tst_phocamaps_map` AS a ^ 42601, 7, ERROR: syntax error at or near "`" LINE 2: FROM `tst_phocamaps_map` AS a ^
Hi I'm new to Phoca & Joomla. I'm running a clean version of Joomla 5.3.3 on an Apache2 with Postgresql 14 server. After installing the component I goto any of the options and I get the error above. I have also installed the plugin just in case that was the issue. I'm using Phocamaps v5.0.2
Is there anything I'm doing wrong? Any other settings or options that are needed for it to work?
Re: Error after installing.
Posted: 05 Sep 2025, 16:50
by Benno
Hi,
please enable Joomla! Debug Mode and set Joomla! Error Reporting=Maximum to get a more detailed error message (Call Stack) and post this error message here.
Thank you, kind regards,
Benno
Re: Error after installing.
Posted: 08 Sep 2025, 15:38
by arctellion
The error trace as requested ..
Code: Select all
An error has occurred.
500 42601, 7, ERROR: syntax error at or near "`" LINE 2: FROM `tst_phocamaps_map` AS a ^ 42601, 7, ERROR: syntax error at or near "`" LINE 2: FROM `tst_phocamaps_map` AS a ^
Call Stack
# Function Location
1 () JROOT/administrator/components/com_phocamaps/views/phocamapsmaps/view.html.php:53
2 PhocaMapsCpViewPhocaMapsMaps->display() JROOT/libraries/src/MVC/Controller/BaseController.php:697
3 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_phocamaps/controller.php:51
4 phocaMapsCpController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:730
5 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_phocamaps/phocamaps.php:35
6 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
7 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73
8 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:361
9 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:150
10 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:205
11 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:304
12 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:58
13 require_once() JROOT/administrator/index.php:32
Re: Error after installing.
Posted: 09 Sep 2025, 02:32
by Jan
Hi, hard to say, but it seems, there is a problem directly in the database query, unfortunately, Phoca Maps is not tested in Postgresql, only in MariaDB or MySQL, so maybe this is related to this problem
Jan