List widget is not shown when using maxlength
We found a bug with the list widget: when we try to reduce it to the next 3 events (maxlength=3), then the widget is not showing any events. When we remove it, it's back again. Gancio 1.5.3 (last version)
gancio | 2022-09-06T19:36:26.317Z error: [EVENT] (conn=3726, no: 1064, SQLState: 42000) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''1') AS `event` LEFT OUTER JOIN ( `event_tags` AS `tags->event_tags` INNER JO...' at line 1
gancio | sql: SELECT `event`.*, `tags`.`tag` AS `tags.tag` FROM (SELECT `event`.`id`, `event`.`title`, `event`.`slug`, `event`.`multidate`, `event`.`start_datetime`, `event`.`end_datetime`, `event`.`media`, `event`.`updatedAt`, `event`.`parentId`, `place`.`id` AS `place.id`, `place`.`name` AS `place.name`, `place`.`address` AS `place.address` FROM `events` AS `event` INNER JOIN `places` AS `place` ON `event`.`placeId` = `place`.`id` WHERE (`event`.`start_datetime` >= 1662492986 OR `event`.`end_datetime` >= 1662492986) AND (EXISTS(SELECT 1 FROM event_tags WHERE `event_tags`.`eventId`=`event`.`id` AND LOWER(`tagTag`) in ('meetup'))) AND `event`.`recurrent` IS NULL AND `event`.`is_visible` = true ORDER BY `event`.`start_datetime` ASC LIMIT 0, '1') AS `event` LEFT OUTER JOIN ( `event_tags` AS `tags->event_tags` INNER JOIN `tags` AS `tags` ON `tags`.`tag` = `tags->event_tags`.`tagTag`) ON `event`.`id` = `tags->event_tags`.`eventId` ORDER BY `event`.`start_datetime` ASC; - parameters:[]
gancio | Error
gancio | at Query.run (/usr/local/share/.config/yarn/global/node_modules/sequelize/lib/dialects/mariadb/query.js:53:25)
gancio | at /usr/local/share/.config/yarn/global/node_modules/sequelize/lib/sequelize.js:311:28
gancio | at async MySQLQueryInterface.select (/usr/local/share/.config/yarn/global/node_modules/sequelize/lib/dialects/abstract/query-interface.js:407:12)
gancio | at async Function.findAll (/usr/local/share/.config/yarn/global/node_modules/sequelize/lib/model.js:1134:21)
gancio | at async Object._select (/usr/local/share/.config/yarn/global/node_modules/gancio/server/api/controller/event.js:688:20)
gancio | at async select (/usr/local/share/.config/yarn/global/node_modules/gancio/server/api/controller/event.js:733:14)