- Posts: 3
- Thank you received: 0
DB function failed with error number 1054
- bltprfcupid
- Topic Author
- Offline
- New Member
Less
More
13 years 1 month ago #168
by bltprfcupid
DB function failed with error number 1054 was created by bltprfcupid
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!
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!
Please Log in or Create an account to join the conversation.
- andrea_4g
- Offline
- Administrator
Less
More
- Posts: 1122
- Thank you received: 163
13 years 1 month ago - 13 years 1 month ago #169
by andrea_4g
Replied by andrea_4g on topic Re: DB function failed with error number 1054
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.
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.
Last edit: 13 years 1 month ago by andrea_4g.
The following user(s) said Thank You: bltprfcupid
Please Log in or Create an account to join the conversation.
- bltprfcupid
- Topic Author
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
13 years 1 month ago #170
by bltprfcupid
Replied by bltprfcupid on topic Re: DB function failed with error number 1054
Thank you! I've got it.
Please Log in or Create an account to join the conversation.
Time to create page: 0.126 seconds