SQL Error on visualization Calendar

titoftit

New Member
Hi,

Visualization calendar don't show events. This SQL is not good, start element date is use with table prefix (dev_devis___) :

Code:
SELECT `dev_devis`.`id` AS id, `dev_devis`.`id` AS rowid, `dev_devis___date` AS startdate, '' AS enddate,'' AS link, '' AS label, '#f50e0e' AS colour, 0 AS formid,'' AS status
FROM dev_devis
ORDER BY `dev_devis___date` ASC

The correct SQL is :

Code:
SELECT `dev_devis`.`id` AS id, `dev_devis`.`id` AS rowid, `date` AS startdate, '' AS enddate,'' AS link, '' AS label, '#f50e0e' AS colour, 0 AS formid,'' AS status
FROM dev_devis
ORDER BY `date` ASC

It's a bug or a incorrect configuration ?

Thanks
 
This issue was fixed after the 3.1rc2 release, so you have to update from GitHub (joomla3 branch) to get the fix.
 
We are in need of some funding.
More details.

Thank you.

Members online

No members online now.
Back
Top