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

Rvdzande
Topic Author
Offline
Junior Member

2 years 6 months ago #14969 by Rvdzande

Replied by Rvdzande on topic "Call to undefined method Joomla\Database\Mysql\MysqlDriver::query()"

Do you have any workaround I can implement for the latest issue. I have a project and they ask me to demonstrate something this week. If it is 'ok' per their demand the project will continue, if it isn't the project will (at least for me) be canceled.

Can also switch to Joomla 3.x if needed.

Please Log in or Create an account to join the conversation.

Dima
Offline
Platinum Member

2 years 6 months ago #14970 by Dima

Replied by Dima on topic "Call to undefined method Joomla\Database\Mysql\MysqlDriver::query()"

You can do it by yourself.

Login to phpMyAdmin, for example, select your database, find table "zhgooglemaps_markers" with your prefix

Open structure and change for columns without default value set checkbox "Null"

or if you have knowledge - just do ALTER for it.
There are many columns like
attribute1 .... attribute9
tab1 ... tab19
tab1title ... tab19title
tab1image ... tab19image
And after that try to create placemark and change column in error to nullable

After that I hope you can create placemart and all will be OK

Don't forget support my developments: post review in JED , donate , help with translation

Please Log in or Create an account to join the conversation.

Dima
Offline
Platinum Member

2 years 6 months ago #14971 by Dima

Replied by Dima on topic "Call to undefined method Joomla\Database\Mysql\MysqlDriver::query()"

As for joomla 3 - if you have site on joomla 3 and want to use it with my extension.

If you have data, you can export tables data from J4 and import it to J3.
But I'm not guaranteed that you will do it without troubles, because there are some difference for tables J4 and J3

Don't forget support my developments: post review in JED , donate , help with translation

Please Log in or Create an account to join the conversation.

Dima
Offline
Platinum Member

2 years 6 months ago #14972 by Dima

Replied by Dima on topic "Call to undefined method Joomla\Database\Mysql\MysqlDriver::query()"

Hi
I create for you SQL clauses, you can execute it in phpMyAdmin on you database. Just change "j4" prefix for my tables to your

Code:

ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab1image` `tab1image` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab2image` `tab2image` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab3image` `tab3image` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab4image` `tab4image` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab5image` `tab5image` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab6image` `tab6image` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab7image` `tab7image` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab8image` `tab8image` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab9image` `tab9image` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab10image` `tab10image` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab11image` `tab11image` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab12image` `tab12image` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab13image` `tab13image` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab14image` `tab14image` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab15image` `tab15image` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab16image` `tab16image` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab17image` `tab17image` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab18image` `tab18image` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab19image` `tab19image` TEXT NULL;

ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab1title` `tab1title` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab2title` `tab2title` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab3title` `tab3title` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab4title` `tab4title` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab5title` `tab5title` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab6title` `tab6title` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab7title` `tab7title` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab8title` `tab8title` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab9title` `tab9title` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab10title` `tab10title` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab11title` `tab11title` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab12title` `tab12title` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab13title` `tab13title` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab14title` `tab14title` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab15title` `tab15title` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab16title` `tab16title` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab17title` `tab17title` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab18title` `tab18title` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab19title` `tab19title` TEXT NULL;

ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab1` `tab1` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab2` `tab2` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab3` `tab3` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab4` `tab4` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab5` `tab5` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab6` `tab6` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab7` `tab7` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab8` `tab8` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab9` `tab9` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab10` `tab10` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab11` `tab11` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab12` `tab12` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab13` `tab13` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab14` `tab14` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab15` `tab15` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab16` `tab16` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab17` `tab17` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab18` `tab18` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `tab19` `tab19` TEXT NULL;

ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `attribute1` `attribute1` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `attribute2` `attribute2` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `attribute3` `attribute3` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `attribute4` `attribute4` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `attribute5` `attribute5` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `attribute6` `attribute6` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `attribute7` `attribute7` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `attribute8` `attribute8` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `attribute9` `attribute9` TEXT NULL;

ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `labelclass` `labelclass` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `labelcontent` `labelcontent` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `alias` `alias` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `hrefcontact` `hrefcontact` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `hrefarticle` `hrefarticle` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `hrefdetail` `hrefdetail` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `attributesdetail` `attributesdetail` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `hrefsite` `hrefsite` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `hrefimage` `hrefimage` TEXT NULL;

ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `hrefimagecss` `hrefimagecss` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `hrefimagethumbnail` `hrefimagethumbnail` TEXT NULL;

ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `hrefsitename` `hrefsitename` TEXT NULL;

ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `hoverhtml` `hoverhtml` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `descriptionfullhtml` `descriptionfullhtml` TEXT NULL;
ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `descriptionhtml` `descriptionhtml` TEXT NULL;

ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `addresstext` `addresstext` TEXT NULL;

ALTER TABLE `j4_zhgooglemaps_markers` CHANGE `description` `description` TEXT NULL;

Don't forget support my developments: post review in JED , donate , help with translation

Please Log in or Create an account to join the conversation.

Rvdzande
Topic Author
Offline
Junior Member

2 years 6 months ago - 2 years 6 months ago #14973 by Rvdzande

Replied by Rvdzande on topic "Call to undefined method Joomla\Database\Mysql\MysqlDriver::query()"

Nevermind, I just posted this when you posted the SQL code, works like a charm! Thanks!

Last edit: 2 years 6 months ago by Rvdzande.

Please Log in or Create an account to join the conversation.

Dima
Offline
Platinum Member

2 years 6 months ago - 2 years 6 months ago #14974 by Dima

Replied by Dima on topic "Call to undefined method Joomla\Database\Mysql\MysqlDriver::query()"

No, this one

Use my script to do most of work

Don't forget support my developments: post review in JED , donate , help with translation

Last edit: 2 years 6 months ago by Dima.

Please Log in or Create an account to join the conversation.

Time to create page: 0.275 seconds