- Posts: 34
- Thank you received: 0
"Call to undefined method Joomla\Database\Mysql\MysqlDriver::query()"
- Rvdzande
- Topic Author
- Offline
- Junior Member
-
- Dima
-
- Offline
- Platinum Member
-
1 year 7 months ago #14970
by Dima
Don't forget support my developments: post review in JED , donate , help with translation
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
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
-
1 year 7 months ago #14971
by Dima
Don't forget support my developments: post review in JED , donate , help with translation
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
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
-
1 year 7 months ago #14972
by Dima
Don't forget support my developments: post review in JED , donate , help with translation
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
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
-
1 year 7 months ago - 1 year 7 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: 1 year 7 months ago by Rvdzande.
Please Log in or Create an account to join the conversation.
- Dima
-
- Offline
- Platinum Member
-
1 year 7 months ago - 1 year 7 months ago #14974
by Dima
Don't forget support my developments: post review in JED , donate , help with translation
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
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.200 seconds