Kunena 7.0.3 Released

The Kunena team has announce the arrival of Kunena 7.0.3 [K 7.0.3] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0

Solved Error when adding categories: Cannot set the query type to "update" as the query

More
3 years 1 month ago #227527 by toddjharrison
Replied by toddjharrison on topic Error when adding categories: Cannot set the query type to "update" as the query

Thanks for the screenshot i got it now, it's in the plugin for the integration with Joomsocial i will look to make a fix for it later
Thank you Xillibit! I will await your notification that the problem is resolved. Please let me know if you need anything else from me.
Todd
--
Todd Harrison
Founder: MyUAP Report

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

More
3 years 1 month ago #227529 by xillibit
Replied by xillibit on topic Error when adding categories: Cannot set the query type to "update" as the query
Try with this fix : github.com/Kunena/Kunena-Forum/commit/37...e93d0fe229dd918a7a26
I don't provide support by PM, because this can be useful for someone else.
The following user(s) said Thank You: toddjharrison

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

More
3 years 1 month ago #227530 by toddjharrison
Replied by toddjharrison on topic Error when adding categories: Cannot set the query type to "update" as the query
Ok, we have some movement, but we're still throwing errors. Here are the steps I took.

I tried creating an override in /$template_dir/html/plg_kunena_community/KunenaAccessCommunity.php

Nothing happened.

I tried creating an override in /$template_dir/html/KunenaAccessCommunity.php

Nothing happened.

I then changed the original file in plugins/kunena/community/KunenaAccessCommunity.php

This had a result, but then threw a 1064 error when trying to add a category:
Code:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SELECT CONCAT('c', id) AS id, CONCAT('c', parent) AS parentid, name FROM `m6a...' at line 1 Call stack

Screenshot: myuap [dot] report [slash] images [slash] kunenaError1064 [dot] png.

Any ideas? Also, do you know what did I do wrong when trying to create the override?

Thanks again for your help.

Todd

 
--
Todd Harrison
Founder: MyUAP Report

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

More
3 years 1 month ago #227531 by xillibit
Replied by xillibit on topic Error when adding categories: Cannot set the query type to "update" as the query
It's not from your override there was another error in the query with this fix it should be better (youd need to keep the previous one fix) : github.com/Kunena/Kunena-Forum/commit/5d...95435d658de513b89fa9
I don't provide support by PM, because this can be useful for someone else.

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

More
3 years 1 month ago #227532 by toddjharrison
Replied by toddjharrison on topic Error when adding categories: Cannot set the query type to "update" as the query
Closer?

Error 1054 now:
Code:
1054 Unknown column 'c' in 'field list'
--
Todd Harrison
Founder: MyUAP Report

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

More
3 years 1 month ago #227533 by xillibit
Replied by xillibit on topic Error when adding categories: Cannot set the query type to "update" as the query
Try with that : github.com/Kunena/Kunena-Forum/commit/d8...53ef14e96d2fd1daf796
I don't provide support by PM, because this can be useful for someone else.
The following user(s) said Thank You: toddjharrison

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

Time to create page: 0.330 seconds