1. Forum
  3. Zh GoogleMap
  5. Component
  7. "Call to undefined method Joomla\Database\Mysql\MysqlDriver::query()"

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

  • Rvdzande
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
1 year 2 weeks 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.

More
1 year 2 weeks 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.

More
1 year 2 weeks 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.

More
1 year 2 weeks 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
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
  • Junior Member
More
1 year 2 weeks ago - 1 year 2 weeks 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!
 
Attachments:
Last edit: 1 year 2 weeks ago by Rvdzande.

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

More
1 year 2 weeks ago - 1 year 2 weeks 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 ;)
Attachments:
Last edit: 1 year 2 weeks ago by Dima.

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

  1. Forum
  3. Zh GoogleMap
  5. Component
  7. "Call to undefined method Joomla\Database\Mysql\MysqlDriver::query()"
Time to create page: 0.114 seconds

Main Menu

Help

Donate

Login Form


Go to top