Hi,
Visualization calendar don't show events. This SQL is not good, start element date is use with table prefix (dev_devis___) :
The correct SQL is :
It's a bug or a incorrect configuration ?
Thanks
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