JEvents 1.5 (No longer actively supported)

Event Display Error

JEvents 2.0 was launched over 2 years ago and the latest stable version is version 2.2 which will run on Joomla 1.5 and Joomla 2.5. JEvents 1.5 is therefore no longer actively supported - you should upgrade to JEvents 2.2+ as soon as possible.
Forum rules
Please include as much detail in any test or bug reports for JEvents 1.5 as possible.

First of all, check if you are running the latest available version of Joomla! and JEvents. Posts for issues, where both systems are not updated, will be ignored.

We need the following at least:

* PHP version (e.g. 5.2.5). Note: Support for PHP4 is discontinued.
* Joomla! version
* JEvents version
* Web Server software (Apache or IIS with version number if possible)
* Server Operating system (e.g. Linux, Windows, Solaris, Darwin ...)
* Database version
* memory_limit from your phpinfo
* Web browser and version

Please enable error reporting and include any error messages in your posting. You do this via the Joomla Configuration - set "error reporting" to "maximum" on the Server tab.

Finally, please describe the steps required to recreate the problem and also please enable error reporting and give us any error messages generated.

Postby cdmilton » Sun Feb 08, 2009 6:24 pm

When I go to the calendar display page in my site I am getting the following error before my event displays on the month view:

Notice: Undefined index: 42 in /home/content/c/d/m/cdmilton/html/components/com_jevents/libraries/commonfunctions.php on line 83

Notice: Trying to get property of non-object in /home/content/c/d/m/cdmilton/html/components/com_jevents/libraries/commonfunctions.php on line 83

Any ideas? I am sure I just installed or setup something wrong.


PHP Built on: Linux
Database Version: 5.0.67-log
Database Collation: utf8_general_ci
PHP Version: 5.2.8
Web Server: Apache
Web Server to PHP interface: cgi-fcgi
Joomla! Version: Joomla! 1.5.8 Production/Stable [ Wohnaiki ] 10-November-2008 23:00 GMT
User Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.0.6) Gecko/2009011912 Firefox/3.0.6

memory_limit 64M
cdmilton
 
Posts: 9
Joined: Sun Feb 08, 2009 6:19 pm

Postby Geraint » Sun Feb 08, 2009 7:13 pm

You haven't followed all the installation steps I suspect - did you click "setup database"?
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: 42837
Joined: Fri Feb 15, 2008 6:14 pm

Postby cdmilton » Sun Feb 08, 2009 9:26 pm

Yes, Although it is titled DB Setup. I was messing around with the config and I now get this when I try to view any calendar page:


Fatal error: Call to undefined method AlternativeMonth::viewNavTableBar() in /home/content/c/d/m/cdmilton/html/components/com_jevents/views/default/helpers/defaultviewhelpershownavtablebar.php on line 71
cdmilton
 
Posts: 9
Joined: Sun Feb 08, 2009 6:19 pm

Postby Geraint » Mon Feb 09, 2009 7:51 am

For your new issue see viewtopic.php?f=17&t=1212

Are you still getting the original message? do you have access to a tool like phpmyadmin? If so can you look at the table jos_jevents_categories and tell me what columns are in it etc.

Geraint
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: 42837
Joined: Fri Feb 15, 2008 6:14 pm

Postby macku » Sat Feb 14, 2009 6:09 pm

I have same error. I also run DB Setup. My jos_jevent_categories is empty (but in component, when I saving iCal file, I can pick one of previously created categories), and have columns "id" and "color".
macku
 
Posts: 16
Joined: Sat Apr 26, 2008 11:48 am
Location: Poland

Postby Geraint » Sun Feb 15, 2009 10:34 am

This could be related to mysql version - I have changed the queries slightly and this may well solve the problem. Please try the latest version (beta build 1314) from the sticky at the top of this forum.

Geraint
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: 42837
Joined: Fri Feb 15, 2008 6:14 pm

Postby cdmilton » Wed Feb 18, 2009 2:04 am

I was able to resolve all of the php errors but now I have created a calendar, categories and events but none of them seem to show up. Any advice would be appreciated.
cdmilton
 
Posts: 9
Joined: Sun Feb 08, 2009 6:19 pm

Postby Geraint » Wed Feb 18, 2009 7:48 am

From the pink box
Please enable error reporting and include any error meesages in your posting.
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: 42837
Joined: Fri Feb 15, 2008 6:14 pm

Postby cdmilton » Wed Feb 18, 2009 5:24 pm

10.
SELECT c.id

FROM ahs_categories AS c
LEFT JOIN ahs_categories AS p
ON p.id=c.parent_id
LEFT JOIN ahs_categories AS gp
ON gp.id=p.parent_id
LEFT JOIN ahs_categories AS ggp
ON ggp.id=gp.parent_id

WHERE c.access <= 0

AND c.published = 1

AND c.section = 'com_jevents'
11.
SELECT c.id

FROM ahs_categories AS c
LEFT JOIN ahs_categories AS p
ON p.id=c.parent_id
LEFT JOIN ahs_categories AS gp
ON gp.id=p.parent_id
LEFT JOIN ahs_categories AS ggp
ON ggp.id=gp.parent_id

WHERE c.access <= 0

AND c.published = 1

AND c.section = 'com_jevents'

AND (c.id IN (42) OR p.id IN (42) OR gp.id IN (42) OR ggp.id IN (42))
12.
SELECT ev.*, rpt.*, rr.*, det.*, ev.state AS published
, 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 ahs_jevents_vevent AS ev

LEFT JOIN ahs_jevents_icsfile AS icsf
ON icsf.ics_id=ev.icsid

LEFT JOIN ahs_jevents_repetition AS rpt
ON rpt.eventid = ev.ev_id

AND ((rpt.startrepeat >= '2009-03-01 00:00:00%'
AND rpt.startrepeat <= '2009-03-31 23:59:59%')
OR (rpt.endrepeat >= '2009-03-01 00:00:00%'
AND rpt.endrepeat <= '2009-03-31 23:59:59%')
OR (rpt.startrepeat >= '2009-03-01 00:00:00%'
AND rpt.endrepeat <= '2009-03-31 23:59:59%')
OR (rpt.startrepeat <= '2009-03-01 00:00:00%'
AND rpt.endrepeat >= '2009-03-31 23:59:59%'))

LEFT JOIN ahs_jevents_vevdetail AS det
ON det.evdet_id = rpt.eventdetail_id

LEFT JOIN ahs_jevents_rrule AS rr
ON rr.eventid = ev.ev_id

WHERE ev.catid IN(-1)
AND ev.state=1

AND ev.access <= 0
AND icsf.state=1
AND icsf.access <= 0

GROUP BY rpt.rp_id
13.
SELECT id, title, module, position, content, showtitle, control, params
FROM ahs_modules AS m
LEFT JOIN ahs_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 28 OR mm.menuid = 0 )
ORDER BY position, ordering
14.
SELECT cat.id, cat.name, cat.description, cat.access, evcat.color

FROM ahs_jevents_categories AS evcat, ahs_categories AS cat

WHERE evcat.id = cat.id

AND cat.section = 'com_jevents'

AND cat.access <= 0
AND evcat.id IN (42)
ORDER BY cat.ordering ASC
15.
SELECT *, RAND() AS ordering
FROM ahs_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 1
AND catid = 33
ORDER BY sticky DESC, ordering
LIMIT 0, 1
16.
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM ahs_content AS a
INNER JOIN ahs_categories AS cc
ON cc.id = a.catid
INNER JOIN ahs_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-02-18 17:19:31' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-02-18 17:19:31' )
AND cc.id = 3
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
cdmilton
 
Posts: 9
Joined: Sun Feb 08, 2009 6:19 pm

Postby cdmilton » Wed Feb 18, 2009 5:30 pm

These are the tables I have:

# Structure ahs_jevents_categories
# Structure ahs_jevents_exception
# Structure ahs_jevents_icsfile
# Structure ahs_jevents_repetition
# Structure ahs_jevents_rrule
# Structure ahs_jevents_vevdetail
# Structure ahs_jevents_vevent
# Structure ahs_jev_users
cdmilton
 
Posts: 9
Joined: Sun Feb 08, 2009 6:19 pm

Next

Return to JEvents 1.5 (No longer actively supported)

  • Who is online
  • View new posts
  • View unanswered posts
  • In total there are 0 users online :: 0 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: No registered users