error 1064 sql syntax

Hi there,
i have installed joomla 3.2.1 and k2. To display some news, i downloaded and installed the modules "News Show Pro GK4" and "News Show Pro GK5". At the moment i publish it, i get the following error message:

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 RAND()' at line 25 SQL=SELECT content.id AS ID, cats.name AS cat_name, cats.alias AS cat_alias, content.catid AS cat_id, users.name AS author, users.email AS author_email, users.id AS author_id, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count FROM xg08j_k2_items AS content LEFT JOIN xg08j_k2_categories AS cats ON cats.id = content.catid LEFT JOIN xg08j_users AS users ON users.id = content.created_by LEFT JOIN xg08j_k2_rating AS content_rating ON content.id = content_rating.itemID WHERE ORDER BY RAND()

I checked if there´s an item in the k2 category i choose in the module.

These are the system informations
PHP 5.3.18
MySQL 5.1.7
Joomla 3.2.1 Stable

hope someone knows how to fix it.

thank you in advance!

Hello,

Did you checked which module cause this error? News Show Pro GK4 or GK5?

both modules cause this error.

Are you using the newest version of the module? As I remember this problem was fixed some times ago on J!3.x.

hm, i hope so! i downloaded it here: https://www.gavick.com/download/joomla- ... owpro.html

News Show Pro GK4 ver. 3.3.7.1
News Show Pro GK5 ver. 1.3.6

Please send me a pm message with access data to your website - I'll check it tonight. Most probably there is a problem with configuration.

Now it should works fine - the problem was caused by fact that you set as data source K2 categories but you didn't selected any category.

Perfect! Thank you so much!!

Hello,

Same error i get when i select an k2 category. Not an empty one! Strange is that if select a different category is working fine. same if i select all k2 items.

Is about the gknews GK4 latest version, i just have update it GK4 3.3.7.1 ... on Joomla 3.2.1, k2 2.6.7.

Please help!

Hello. I manage to get rid of the error. It was something related to time offset. That's why there where no articles to show, I will look further for see how to set that in order to get articles at the right time displayed.

Not an nice message anyway, i have to dig deep into google in order to find an solution.

Mircea Rusu

Hey, is something wrong with time, I went back with 12 hours and nothing, my server is GMT+2 let=s say that i set it wrong so there are 4 hours but 12?
The news appears only when i set the date from yesterday!

Hello,

I have made the following changes in order to make that module work (sort of)

I have set the module time offset at +12 (maximim available)
I have set the article with more than 9 hours behind the current time.
so i have a offset of 21 hours!!! It must be something wrong.

My server time zone reported by php in joomla system/system Information PHP information tab is Europe/Bucharest
My settings in Joomla general settings is Bucharest

When i post a k2 item i get the correct Created time. Same for joomla article.
The gk4 is having the same error with joomla article system also.

So please help me to set this thing in order to have the items displayed as soon as the cache refreshes not after almost a day.

@denvarel - please try to upgrade your module to GK5 version - version GK4 is old and in general not supported.