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

[hifi]

* 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

[Geraint]

Good spot - not tried that functionality yet

[Geraint]

I've just fixed this in SUBVERSION