Jevents 2.x (Free Access)

Jevents Categories & Joomfish

Discuss JEvents 2.x for Joomla 1.5-2.5 here - club members can use the special club forum for faster response times.
Forum rules
When requesting support please follow these steps:

1. Update all JEvents add on's first, via the Joomla! Updater
2. Copy and Paste the JEvents Support Information from the JEvents Control Panel.
3. If you get a 500 error OR white page, enable Maximum Error Reporting in Joomla! Global Config and visit the page again, this should give you a more detailed error and help us provide a prompt response.

Postby Geraint » Mon Mar 18, 2013 10:12 am

That is the event itself and not the legend at th ebottom
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!
User avatar
Geraint
 
Posts: 42811
Joined: Fri Feb 15, 2008 6:14 pm

Postby g39n22e » Sun Mar 24, 2013 12:12 pm

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'
g39n22e
Gold Members
 
Posts: 45
Joined: Mon Nov 09, 2009 11:46 pm

Postby Geraint » Mon Mar 25, 2013 8:36 am

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
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!
User avatar
Geraint
 
Posts: 42811
Joined: Fri Feb 15, 2008 6:14 pm

Postby g39n22e » Sat Apr 06, 2013 6:15 pm

I've attached the file. Thank you
Attachments
query_s.zip
(3.16 KiB) Downloaded 22 times
g39n22e
Gold Members
 
Posts: 45
Joined: Mon Nov 09, 2009 11:46 pm

Postby Geraint » Mon Apr 08, 2013 8:16 am

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?
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!
User avatar
Geraint
 
Posts: 42811
Joined: Fri Feb 15, 2008 6:14 pm

Postby g39n22e » Mon Apr 08, 2013 4:21 pm

what do you mean by language 2?
g39n22e
Gold Members
 
Posts: 45
Joined: Mon Nov 09, 2009 11:46 pm

Postby Tonyp » Mon Apr 08, 2013 4:25 pm

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

Look in: Joomla! Language Manager. On the left it lists the language number.
---------------------------------------
Feel free to PM me if you would like Custom Installs or Joomla! related work for a competitive quote.

User avatar
Tonyp
Team Staff
 
Posts: 23779
Joined: Tue Oct 12, 2010 9:12 pm
Location: Isle of Man

Postby g39n22e » Mon Apr 08, 2013 4:41 pm

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
Gold Members
 
Posts: 45
Joined: Mon Nov 09, 2009 11:46 pm

Postby g39n22e » Thu Apr 11, 2013 5:23 pm

Hi again, do we have a solution to the above problem?
g39n22e
Gold Members
 
Posts: 45
Joined: Mon Nov 09, 2009 11:46 pm

Postby Geraint » Fri Apr 12, 2013 8:43 am

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.
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!
User avatar
Geraint
 
Posts: 42811
Joined: Fri Feb 15, 2008 6:14 pm

PreviousNext

Return to Jevents 2.x (Free Access)

  • Who is online
  • View new posts
  • View unanswered posts
  • In total there is 1 user online :: 1 registered and 0 hidden (based on users active over the past 5 minutes)
  • Most users ever online was 94 on Tue Sep 01, 2009 12:33 am
  • Users browsing this forum: Bing [Bot]