Tag cloud module throws SQL error in S5 Vertex template

Quote

Guest
30 Dec 2012 16:58

Hi Sergey,

When I publish the free tag cloud module regardless of the position, it breaks the whole site and throws this error:


0 - SQL=SELECT t.tag, t.slug, t.id, rc.catid, r.client, r.client_id FROM prefix_js_res_tags AS t LEFT JOIN prefix_js_res_tags_history AS h ON h.tag_id = t.id LEFT JOIN prefix_js_res_record AS r ON r.id = h.record_id LEFT JOIN prefix_js_res_record_category AS rc ON rc.record_id = h.record_id WHERE r.client_id = 0 AND r.published = 1 AND h.section_id = "0" GROUP BY t.id LIMIT 0, 50

YOU_MAY_NOT_BE_ABLE_TO_VISIT_THIS_PAGE_BECAUSE_OF:

AN_OUT_OF_DATE_BOOKMARK_FAVOURITE

A_SEARCH_ENGINE_THAT_HAS_AN_OUT_OF_DATE_LISTING_FOR_THIS_SITE

A_MIS_TYPED_ADDRESS

YOU_HAVE_NO_ACCESS_TO_THIS_PAGE

The requested resource was not found

An error has occurred while processing your request.

PLEASE_TRY_ONE_OF_THE_FOLLOWING_PAGES:

HOME_PAGE

IF_DIFFICULTIES_PERSIST__PLEASE_CONTACT_THE_SYSTEM_ADMINISTRATOR_OF_THIS_SITE

I'll paste the debug info in a private message. Thank you!

Last Modified: 02 Mar 2014

Quote

Guest
30 Dec 2012 17:00

SQL=SELECT t.tag, t.slug, t.id, rc.catid, r.client, r.client_id FROM bzj0a_js_res_tags AS t LEFT JOIN bzj0a_js_res_tags_history AS h ON h.tag_id = t.id LEFT JOIN bzj0a_js_res_record AS r ON r.id = h.record_id LEFT JOIN bzj0a_js_res_record_category AS rc ON rc.record_id = h.record_id WHERE r.client_id = 0 AND r.published = 1 AND h.section_id = "0" GROUP BY t.id LIMIT 0, 50

Call stack

#    Function    Location

1    JSite->render()    /home/topcuri/public_html/index.php:58

2    JDocumentHTML->render()    /home/topcuri/public_html/includes/application.php:279

3    JDocumentHTML->_renderTemplate()    /home/topcuri/public_html/libraries/joomla/document/html/html.php:462

4    JDocumentHTML->getBuffer()    /home/topcuri/public_html/libraries/joomla/document/html/html.php:682

5    JDocumentRendererModules->render()    /home/topcuri/public_html/libraries/joomla/document/html/html.php:399

6    JDocumentRendererModule->render()    /home/topcuri/public_html/libraries/joomla/document/html/renderer/modules.php:39

7    JModuleHelper::renderModule()    /home/topcuri/public_html/libraries/joomla/document/html/renderer/module.php:107

8    include()    /home/topcuri/public_html/libraries/legacy/module/helper.php:176

9    modCobaltTagcloudHelper::getTags()    /home/topcuri/public_html/modules/mod_cobalt_tagcloud/mod_cobalt_tagcloud.php:29

10    JDatabaseDriver->loadObjectList()    /home/topcuri/public_html/modules/mod_cobalt_tagcloud/helper.php:68

11    JDatabaseDriverMysqli->execute()    /home/topcuri/public_html/libraries/joomla/database/driver.php:1218

I will unpublish the module until you have time to take a look over.

Thanks,

Marius

Quote