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 :idea:

Jan