search

extras-evolution / multiTV

Custom TV for Evolution CMS: Transform a template variables into a sortable multi item list for the Evolution content management framework
8 stars 23 forks source link

MySQL 5.7 issue #45

Open Jako opened 6 years ago

Jako commented 6 years ago

Please replace 

"elements": "@SELECT 'Unknown' AS username, 0 as id FROM [+PREFIX+]web_users LIMIT 1 UNION (SELECT username, id FROM [+PREFIX+]web_users ORDER BY username ASC)"

with

"elements": "@SELECT 'Unknown' AS username, 0 as id UNION (SELECT username, id FROM [+PREFIX+]web_users ORDER BY username ASC)"

in assets/tvs/multitv/configs/dbtabledemo.config.json and assets/tvs/multitv/moduleconfigs/event_log.moduleconfig.json