[SOLVED: old version of jcomments search plugin] Error 1054 when you search from home page

3 years 3 months ago - 3 years 3 months ago #56211 by charlynancy
Hi,
when you search from home page www.flexicontent.org/ (search field in top right)
you obtain an 1054 error
Example with the search word flexi :
1054 
Unknown column 'c.deleted' in 'where clause' SQL=SELECT c.comment AS text, c.date AS created, '2' AS browsernav, 'Comments' AS section, '' AS href, c.id, jo.title AS object_title, jo.link AS object_link FROM j25_jcomments AS c INNER JOIN j25_jcomments_objects AS jo ON jo.object_id = c.object_id AND jo.object_group = c.object_group and jo.lang=c.lang WHERE c.published=1 AND c.deleted=0 AND jo.link <> '' AND ((LOWER(c.name) LIKE '%flexi%' OR LOWER(c.comment) LIKE '%flexi%' OR LOWER(c.title) LIKE '%flexi%')) AND jo.access IN (1,0) ORDER BY c.object_id, c.date DESC LIMIT 0, 50

Please Log in or Create an account to join the conversation.

3 years 3 months ago #56224 by ggppdk
Hello

it was caused by JComments seach plugin,

it happened after upgrading JComments,

i have unpublished the search plugin and look at it more later

thanks


-- FLEXIcontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star review. Thanks!

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
© 2018 Flexicontent. All Rights Reserved.