DB function failed with error number 1054

Hi!

I use J1.5+Eventlist 1.1beta3.2.2+CP 2.0(bought it today).

When I try to assign custom properties to event (select Content type: Event) I get page with error:

DB function failed with error number 1054

Unknown column 'c.catsid' in 'on clause' SQL=SELECT SQL_CALC_FOUND_ROWS c.id AS id ,c.title as title ,c.published as state ,'' AS section ,IFNULL(cat.catname, 'Static') AS category FROM jos_eventlist_events AS c LEFT JOIN jos_eventlist_categories cat ON(c.catsid = cat.id) WHERE 1 AND c.published >= 0 ORDER BY c.catsid,c.title LIMIT 0, 20

Could you give me any advice or solution, please!

Thanks for bringing this issue to our attention.
After investigating the problem we discovered that Custom Properties lost part of its compatibility with the newer versions of Eventlist. It's hard to tell when that happened. Arguably between 1.0x and 1.1.

Versions Compatibility
Custom Properties for Joomla 1.5 + Eventlist 1.0.rc:
- read event content item: Yes
- read event category: Yes
- read and process image: Yes
- display CP tags in Eventlist events: Yes

Custom Properties for Joomla 1.5 + Eventlist 1.1beta3.2.3-6.zip:
- read event content item: Yes
- read event category: No (1)
- read and process image: Yes
- display CP tags in Eventlist events: No (2)

(1) Eventlist DB structure changed, there's a new join table to associate an event with many categories
(2) internal structure of the object being passed to the plugin changed

Solutions:
Issue (1): there's no way for CP to recover multiple categories. Please find hereinafter a newly developed content element for Eventlist without category support. You'll be able to tag and search events. The result summary will not be as good looking as before.
Issue (2): with minimal PHP tweaking to Eventlist - less than 30 chars added - it's possible to display CP tags in Event details. Contact us by email if you need more information on that.

Thank you! I've got it.