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

  • Rvdzande
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
1 year 7 months ago #14969 by Rvdzande
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 7 months ago #14970 by Dima
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 7 months ago #14971 by Dima
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 7 months ago #14972 by Dima
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
  • Junior Member
More
1 year 7 months ago - 1 year 7 months ago #14973 by Rvdzande
Nevermind, I just posted this when you posted the SQL code, works like a charm! Thanks!
 
Attachments:
Last edit: 1 year 7 months ago by Rvdzande.

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

More
1 year 7 months ago - 1 year 7 months ago #14974 by Dima
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: 1 year 7 months ago by Dima.

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

    Time to create page: 0.342 seconds
    Powered by Kunena Forum