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

charlynancy
Topic Author
Offline
Premium Member

9 years 3 months ago - 9 years 3 months ago #56211 by charlynancy

[SOLVED: old version of jcomments search plugin] Error 1054 when you search from home page was created 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 :

Code:

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

Last edit: 9 years 3 months ago by ggppdk.

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

ggppdk
Offline
Administrator

9 years 3 months ago #56224 by ggppdk

Replied by ggppdk on topic [Old version of jcomments search plugin] Error 1054 when you search from home page

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...

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