Empty k2 category causes 1064 error in Highlighter

atolli

I was testing your great highlighter module. I have 2 entries when I unpublished both i get 1064 error. When set is empty what does the module do, as on empty i do not want the module to show at all.
Thank you!

atolli

Hope you can provide FIX soonest.
1064
YOU HAVE AN ERROR IN YOUR SQL SYNTAX; CHECK THE MANUAL THAT CORRESPONDS TO YOUR MYSQL SERVER VERSION FOR THE RIGHT SYNTAX TO USE NEAR 'ORDER BY CONTENT.CREATED DESC' AT LINE 25
atolli

manhta

atolli
You can try this path. Extract and override it to

modules\mod_highlighter_gk5\gk_classes\gk.source.k2.php

gksourcek2.zip

3kB

aman204

atolli Kindly try and update to the latest version of Highlighter GK5 J!3 Module i.e.1.2.3 as the same comes with various updates/improvements and bug fixes.

Would again suggest to take backup of your site before performing aforesaid steps, in case rollback required whilst facing any issues e.t.c

atolli

Installed new version, problem is still there however. Also if set is empty what will the module return?

aman204

atolli Also if set is empty what will the module return?

As per my perspective, Module will return with ticker notification asking to assign or publish category which is being fetched as "data source"

Have reported the relative bug with JA Dev. Team and will revert back as we get an update on the same

Thanks for your patience

atolli

no more error thanks.
What does the module return when there a no items? I have my module set to not display in case it is empty so you must be sending some kind of message?

aman204

atolli What does the module return when there a no items? I have my module set to not display in case it is empty so you must be sending some kind of message?

However, The module wont derive any purpose if no category has been assigned/published so would suggest to assign some category as "data source" ensuring there are optimum results being derived by the robust functionality being offered by GK Highlighter