No Where Clause in SQL?

Hello all. I'm new to this forum and new to GK Pro, so thanks for helping a noob. I've researched online to try and find a solution, but I cannot.

I'm setting up a News Show Pro GK4 Module and am getting a SQL error. I can tell that the error is caused because there is no 'where' clause, and the SQL statement is failing:

Code: Select all

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 PARK_K2_ITEMS AS CONTENT LEFT JOIN PARK_K2_CATEGORIES AS CATS ON CATS.ID = CONTENT.CATID LEFT JOIN PARK_USERS AS USERS ON USERS.ID = CONTENT.CREATED_BY LEFT JOIN PARK_K2_RATING AS CONTENT_RATING ON CONTENT.ID = CONTENT_RATING.ITEMID WHERE ORDER BY RAND()

The offending part being: "WHERE ORDER BY RAND()".

In the datasource options section, I am selecting items from a K2 Category and clearly have it selected.

Can anyone help decipher the problem?

What type of data source do you use? K2 or Joomla! items? Probably something is wrong with configuration and that's why the query have no additional WHERE rules.

The data source is K2 Categories and I have a category selected. I've uploaded a screenshot of the data source configuration, hopefully you can see it.

There is no attachment in your latest response, could you upload file again?

http://tinypic.com/r/9ihdsp/5

Could you test it with News Show Pro GK5? If the problem will be also with this module please provide me access via PM.