JEvents 1.5 (No longer actively supported)

[FIXED IN SVN] Can't search events in Backend

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 hifi » Mon Jan 12, 2009 6:47 pm

* PHP version: 5.2.6
* Joomla! version: 1.5.9 (Legacy: ON)
* JEvents version: 1.5.0 Alpha3 (Revision 1245)
* Web Server software: Apache 2.2.8
* Server Operating system: Windows XP SP3 (WAMP)
* Database version: 5.0.51b
* memory_limit: 128M
* Browser: Google Chrome & Firefox 3.0.5

When trying to search events (after converting old events to JEvents), got following error:
Code: Select all
Unknown column 'a.summary' in 'where clause' SQL=SELECT count(*) FROM (jos_jevents_vevent AS ev ) LEFT JOIN jos_jevents_rrule as rr ON rr.eventid = ev.ev_id WHERE LOWER(a.summary) LIKE '%periodi%'
Warning: Invalid argument supplied for foreach() in C:\wamp\www\CB_testi\administrator\components\com_jevents\controllers\icalevent.php on line 132
DB function failed with error number 1054
Unknown column 'a.summary' in 'where clause' SQL=SELECT ev.*, ev.state as evstate, detail.*, g.name AS _groupname , rr.rr_id, rr.freq,rr.rinterval ,MAX(rpt.endrepeat) as endrepeat ,MIN(rpt.startrepeat) as startrepeat FROM (jos_jevents_vevent as ev ) LEFT JOIN jos_jevents_vevdetail as detail ON ev.detail_id=detail.evdet_id LEFT JOIN jos_jevents_rrule as rr ON rr.eventid = ev.ev_id LEFT JOIN jos_jevents_repetition as rpt ON rpt.eventid = ev.ev_id LEFT JOIN jos_groups AS g ON g.id = ev.access WHERE LOWER(a.summary) LIKE '%periodi%' GROUP BY rpt.eventid LIMIT 0, 10
hifi
 
Posts: 87
Joined: Tue Oct 28, 2008 6:29 am

Postby Geraint » Mon Jan 12, 2009 7:49 pm

Good spot - not tried that functionality yet
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 Geraint » Sat Jan 17, 2009 11:33 am

I've just fixed this in SUBVERSION
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


Return to JEvents 1.5 (No longer actively supported)

cron
  • 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