DB function failed with error number 1054

  • bltprfcupid
  • Autore della discussione
  • Offline
  • Nuovo Utente
  • Nuovo Utente
Di più
13 Anni 3 Settimane fa #168 da bltprfcupid
DB function failed with error number 1054 è stato creato da 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!
Allegati:

Si prega Accesso o Crea un account a partecipare alla conversazione.

Di più
13 Anni 3 Settimane fa - 13 Anni 3 Settimane fa #169 da andrea_4g
Risposta da andrea_4g al 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.
Allegati:
Ultima Modifica 13 Anni 3 Settimane fa da andrea_4g.
I seguenti utenti hanno detto grazie : bltprfcupid

Si prega Accesso o Crea un account a partecipare alla conversazione.

  • bltprfcupid
  • Autore della discussione
  • Offline
  • Nuovo Utente
  • Nuovo Utente
Di più
13 Anni 3 Settimane fa #170 da bltprfcupid
Risposta da bltprfcupid al topic Re: DB function failed with error number 1054
Thank you! I've got it.

Si prega Accesso o Crea un account a partecipare alla conversazione.

Tempo creazione pagina: 0.164 secondi