"Call to undefined method Joomla\Database\Mysql\MysqlDriver::query()"

Hello,

Today I started experimenting with your component (again, after quite some years).  Everything is setup and works, besides 'front end adding' markers. As soon as I enable this and login I get:

"Call to undefined method Joomla\Database\Mysql\MysqlDriver::query()"
When I log out the map shows again.

My info:
Joomla 4.2.9
ZH Google Map 12.22.12.8
Standard template (same issue with other template)
Php 8.0.28 (tested with PHP 7.4 as well)

When I enable debugging I do not see any other clues.

Site is kaart.robbyvanderzande.nl.

Could you please look into it, or tell me what I can do myself? Thanks in advance!

BTW if the project (for which I want to use the component) gets launched, I will let you know so I can donate / pay for your help

Well I've managed to fix this myself.

In the components/com_zhgooglemap/tmpl/map/ folder you have to make changes in 'display_map_data.php'

Search for:
$db->query();

And replace with:
$db->execute();

Should fix the issue!

Hi
I'm sorry for delay. Didn't see your message.

I really didn't check front end entering placemarks. On next week I will check it, test and will find out problem. Probably, you are right, but I need to check joomla docs and check how they do it.

Thank you for your request and solution suggestion.

No issue, you are in no way no obliged to provide any support. Thanks for your reply!

BTW I am now running into another error while placing a marker:

"0 HY000, 1364, Field 'addresstext' doesn't have a default value"

Hi
Thank you for this information.
I hope on this week I will do new release and will fix both problem.
As for "default value" error - it is due to in J3 all table columns have to be not null. In J4 implemented nullable columns, but in case front end creating placemarks I didn't fill all columns, and in J4 it cause this error.

I will do all columns, which is not used in front end insert clause as nullable and all will be OK.