Jump to content

JReviews Listing Module


Rik Brown

Recommended Posts

This is odd: For several weeks, I had the Listings Module creating two different lists of cities sorted by population, descending. It was working fine but suddenly, it broke and when I access the Joomla menu to take me to the Joomla category list page with these two city lists, I just get an error page that starts with the first quote below and ends with the second quote.

Quote

1 - 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 jr_viatordestinationid IS NULL LIMIT 100)) ) ORDER BY Listing.modifie' at line 80 => SELECT Listing.id AS `Listing.listing_id`, Listing.alias AS `Listing.slug`, Listing.title AS `Listing.title`, Listing.introtext AS....

Quote

Category.id = Listing.catid AND Category.extension = 'com_content' LEFT JOIN #__jreviews_directories AS Directory ON Directory.id = JreviewsCategory.dirid LEFT JOIN #__users AS User ON User.id = Listing.created_by LEFT JOIN #__jreviews_claims AS Claim ON Claim.listing_id = Listing.id AND Claim.user_id = Listing.created_by AND Claim.approved = 1 WHERE 1 = 1 AND ( Listing.catid IN (93,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,120,121,122,123,124,127,129,130,131,132,133,134,135,136,137,138,139,140,141,142,145,147,148,149,150,151,152,155,158,159,160,162,165,252,254,255,256,257,258,259,461,462,463,464) AND Listing.state = 1 AND Listing.access IN ( 1,2,3) AND ( Listing.publish_up IS NULL OR Listing.publish_up <= UTC_TIMESTAMP ) AND ( Listing.publish_down IS NULL OR Listing.publish_down > UTC_TIMESTAMP ) AND (Field.jr_country = ( SELECT jr_country FROM #__jreviews_content WHERE contentid = {listing_id} AND jr_viatordestinationid IS NULL LIMIT 100)) ) ORDER BY Listing.modified DESC LIMIT 51

The two lists are accessed by a Joomla menu item taking one to a Joomla category list page containing two Joomla articles -- each having the JReviews listing module following some article text.

Oddly, I have disabled the JReviews listing module and yet when I click on the Joomla menu item to take me to Joomla page showing the two articles, I get the MySQL error page shown above (whether or not the JReviews listing module is enabled) with the following exception:

I thought that this might of been a caching issue as the pages show fine in my cellphone browser (whether or not the JR listing module is enabled). But I tried Chrome, Foxfire, and MS Edge and they all give me the error -- even after clearing their caches. I've also cleared the Joomla and JReviews caches.

Since I currently have the listing module(s) disabled, I don't know where or why the JReviews tables should be queried at all.

Any ideas what could be causing this?

Thanks. -- Rik

Link to comment
×
×
  • Create New...