Jevents Categories & Joomfish

[Geraint]

That is the event itself and not the legend at th ebottom

[g39n22e]

how about now

SELECT det.evdet_id AS detailid, rpt.*, ev.*, rr.*, det.* , ev.state AS published, ev.created AS created , CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('http://www.*****/images/stories/jevents/',jevfil1.filename) END AS imageurl1
, CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="http://www.*****/images/stories/jevents/',jevfil1.filename,'" />') END AS imageimg1
, CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('http://www.*****/images/stories/jevents/thumbnails/thumb_',jevfil1.filename) END AS imagethumb1
, CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="http://www.*****/images/stories/jevents/thumbnails/thumb_',jevfil1.filename,'" />') END AS thumbimg1 , CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('http://www.*****/images/stories/jevents/',jevfil1.filename) END AS imageurl
, CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="http://www.*****/images/stories/jevents/',jevfil1.filename,'" />') END AS imageimg
, CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('http://www.*****/images/stories/jevents/thumbnails/thumb_',jevfil1.filename) END AS imagethumb
, CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="http://www.*****/images/stories/jevents/thumbnails/thumb_',jevfil1.filename,'" />') END AS thumbimg
, YEAR(rpt.startrepeat) AS yup, MONTH(rpt.startrepeat ) AS mup, DAYOFMONTH(rpt.startrepeat ) AS dup
, YEAR(rpt.endrepeat ) AS ydn, MONTH(rpt.endrepeat ) AS mdn, DAYOFMONTH(rpt.endrepeat ) AS ddn
, HOUR(rpt.startrepeat) AS hup, MINUTE(rpt.startrepeat ) AS minup, SECOND(rpt.startrepeat ) AS sup
, HOUR(rpt.endrepeat ) AS hdn, MINUTE(rpt.endrepeat ) AS mindn, SECOND(rpt.endrepeat ) AS sdn

FROM jos_jevents_repetition AS rpt
LEFT JOIN jos_jevents_vevent AS ev
ON rpt.eventid = ev.ev_id
LEFT JOIN jos_jevents_icsfile AS icsf
ON icsf.ics_id=ev.icsid
LEFT JOIN jos_jevents_vevdetail AS det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN jos_jevents_rrule AS rr
ON rr.eventid = rpt.eventid
LEFT JOIN jos_jev_files AS jevfil1
ON jevfil1.ev_id = ev.ev_id
AND jevfil1.filetype='image'
AND jevfil1.file_num=1
WHERE ev.catid IN(-1,3,4,5,6,8,9,10,11,13,12,14,15,16,17,18,19,20,21)

AND rpt.endrepeat >= '2013-03-01 00:00:00'
AND rpt.startrepeat <= '2013-03-31 23:59:59'
AND ev.state=1
AND ev.access <= 0
AND icsf.state=1
AND icsf.access <= 0
SELECT *
FROM jos_languages
WHERE active=1
ORDER BY ordering
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(2,3,1)
AND jf_content.reference_table='languages'
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2

AND jf_content.published=1

AND jf_content.reference_id IN(1,8,63,65,72,68,69,73,76,77,6,54,64,66,70,74,80,7,55,67,71,75,81,82,83,2,56,85,5,57,3,4,58,59,60,61,62,9,50,10,16,23,27,30,34,41,51,52,53,11,12,15,13,14,17,18,19,20,21,22,24,25,26,28,29,31,32,33,35,36,37,38,39,40,42,43,44,45,46,47,48,49)

AND jf_content.reference_table='menu'
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=3
AND jf_content.published=1
AND jf_content.reference_id IN(68)
AND jf_content.reference_table='menu'
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(68)
AND jf_content.reference_table='menu'

[Geraint]

No its none of those.

Please create a text file with all the queries and then zip it up and attach it to your reply

[g39n22e]

I've attached the file. Thank you

[Geraint]

This is the relevant section:

Code: Select all

SELECT *
      FROM jos_categories AS c
                                           
      LEFT JOIN jos_jevents_categories AS j
      ON j.id=c.id
     
      WHERE  c.access   <=  0
     
      AND c.published = 1
     
      AND c.SECTION = 'com_jevents'
     
      ORDER BY c.ordering
    SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(21,20,19,18,17,16,15,14,13,12,11,10,9,8,6,5,4,3)
       
      AND jf_content.reference_table='categories'

And you can see that Joomfish is being called for the translation.

Is it language 2 that you are using?

[g39n22e]

what do you mean by language 2?

[Tonyp]

Language 2 i.e. the language with ID 2.

Look in: Joomla! Language Manager. On the left it lists the language number.

[g39n22e]

1 Greek Default
2 English(United Kingdom)
3 French (Fr)

2 & 3 have the problem, they are not showing the translations that exist in joomfish

[g39n22e]

Hi again, do we have a solution to the above problem?

[Geraint]

It looks as though the issue is within Joomfish or that your translations are not published/public - the database query is triggering Joomfish to get the translations correctly.