Please l need help with this ERROR on World News II TEMPLATE

error.jpg

Any time l select "k2 category" from the "article source" in the "NEW SHOW PRO GK" l get this error:

0
SQL=SELECT categories.title AS cat, content.id AS ID, content.access AS access, categories.title AS cat, users.email AS author_email, users.name AS author, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count, categories.id AS CID FROM hpn_content AS content LEFT JOIN hpn_categories AS categories ON categories.id = content.catid LEFT JOIN hpn_content_frontpage AS frontpage ON content.id = frontpage.content_id LEFT JOIN hpn_users AS users ON users.id = content.created_by LEFT JOIN hpn_content_rating AS content_rating ON content_rating.content_id = content.id WHERE AND categories.published = 1 ORDER BY content.created DESC


I am using Joomla 3.0 version. Please l need help.
Thanks

Hi,

Did you tried to download the NSP module from our download and install it?

No. I didn't it was already part of the template (joomla 3.0) quick start. I think it is a problem from the template.

Please help me out

Thanks

So first of all please try to reinstall the module using the package downloaded from our website.

It worked but I keep getting this error frequently with The World News II joomla 3.0

Warning: Invalid argument supplied for foreach() in public_html/components/com_content/models/articles.php on line 489

SQL=SELECT a.id, a.title, a.alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM hsm_content AS a LEFT JOIN hsm_categories AS c ON c.id = a.catid LEFT JOIN hsm_users AS ua ON ua.id = a.created_by LEFT JOIN hsm_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM hsm_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN hsm_categories as parent ON parent.id = c.parent_id LEFT JOIN hsm_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM hsm_categories AS cat JOIN hsm_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN hsm_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1,5) AND c.access IN (1,1,5) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-01-18 00:15:04') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-01-18 00:15:04') GROUP BY a.id, a.title, a.alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls ORDER BY c.lft, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC LIMIT 0, 9 SQL=SELECT a.id, a.title, a.alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM hsm_content AS a LEFT JOIN hsm_categories AS c ON c.id = a.catid LEFT JOIN hsm_users AS ua ON ua.id = a.created_by LEFT JOIN hsm_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM hsm_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN hsm_categories as parent ON parent.id = c.parent_id LEFT JOIN hsm_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM hsm_categories AS cat JOIN hsm_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN hsm_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1,5) AND c.access IN (1,1,5) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-01-18 00:15:04') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-01-18 00:15:04') GROUP BY a.id, a.title, a.alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls ORDER BY c.lft, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC


Please l need help

Please disable displaying warnings in your php.ini file.

It worked. But another issue

When l enabled the GK CACHE at the template settings, and also enabled GK CACHE and GKextended Cache at the plugin settings. And now when l click on any links it takes me to the homepage.. It refreshes and nothing happens.. Even clicking the menu and k2 items doesn't work as well..

What could be the cause

I have the same problem. I do not speak English. What should I do? http://eneascorrea.com/caminhodejesus/. I do not understand!

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 TCFRT_K2_ITEMS AS CONTENT LEFT JOIN TCFRT_K2_CATEGORIES AS CATS ON CATS.ID = CONTENT.CATID LEFT JOIN TCFRT_USERS AS USERS ON USERS.ID = CONTENT.CREATED_BY LEFT JOIN TCFRT_K2_RATING AS CONTENT_RATING ON CONTENT.ID = CONTENT_RATING.ITEMID WHERE ORDER BY CONTENT.CREATED ASC

@eneascorrea - please check your NSP instances - most probably you didn't selected the data sources in one of the existing ones, visible on the mentioned website.

@eneascorrea - please check your NSP instances - most probably you didn't selected the data sources in one of the existing ones, visible on the mentioned website.

Thank you. I solved the problem!