DB function failed with error number 1054

  • bltprfcupid
  • Topic Author
  • Offline
  • New Member
  • New Member
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!
Attachments:

Please Log in or Create an account to join the conversation.

More
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.
Attachments:
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
  • New Member
More
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