Database Error after installing related items extended

Hi ,

I just installed the related items extended module.

But the extension is not working. I get this error. What could this mean?

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 ') AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-07-20 12:18' at line 11 SQL=SELECT a.id,a.title,a.introtext,a.images,a.metakey,DATE_FORMAT(a.created, "%Y-%m-%d") as created,a.catid,cc.title as category_title,cc.access AS cat_access,cc.published AS cat_state, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug,u.name AS author,contact.id as contactid FROM jos_content AS a LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id LEFT JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_users AS u on u.id = a.created_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM jos_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by WHERE a.id != 109 AND a.state = 1 AND a.access IN (1,1,5) AND (CONCAT(",", REPLACE(a.metakey, ", ", ","), ",") LIKE "%nijmegen%" OR CONCAT(",", REPLACE(a.metakey, ", ", ","), ",") LIKE "%bouwplannen%" OR CONCAT(",", REPLACE(a.metakey, ", ", ","), ",") LIKE "%bouwen%") AND cc.id in () AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-07-20 12:18:37') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-07-20 12:18:37') AND ( (TO_DAYS('2015-07-20') - TO_DAYS(a.created) ) <= '1200') ORDER BY a.created DESC LIMIT 0, 5

Hi,

I tried the package that you send but still have the same issue..... What can be done?
I use Joomla 3.4.3

I used the latest version I guess because I bought the package this week.

Any idea's?

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 ') AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-07-21 13:51' at line 11 SQL=SELECT a.id,a.title,a.introtext,a.images,a.metakey,DATE_FORMAT(a.created, "%Y-%m-%d") as created,a.catid,cc.title as category_title,cc.access AS cat_access,cc.published AS cat_state, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug,u.name AS author,contact.id as contactid FROM jos_content AS a LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id LEFT JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_users AS u on u.id = a.created_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM jos_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by WHERE a.id != 109 AND a.state = 1 AND a.access IN (1,1,5) AND (CONCAT(",", REPLACE(a.metakey, ", ", ","), ",") LIKE "%nijmegen%" OR CONCAT(",", REPLACE(a.metakey, ", ", ","), ",") LIKE "%bouwplannen%" OR CONCAT(",", REPLACE(a.metakey, ", ", ","), ",") LIKE "%bouwen%") AND cc.id in () AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-07-21 13:51:13') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-07-21 13:51:13') AND ( (TO_DAYS('2015-07-21') - TO_DAYS(a.created) ) <= '1200') ORDER BY a.created DESC LIMIT 0, 5

I bought and installed it monday ... that is less then 5 days ago.

Do you have another solution for this problem? As I also paid for this module..

What kind of support is given to paid extensions?