No one of cocorico cronjob are working

[nmateo]

Q	A
Bug report?	[X]
Feature request?	[ ]
Support request?	[ ]

This is the crontab of our enterprise we bought cocorico and no ones of the cronjobs are doing their jobs:,

/4 /usr/bin/php /var/www/Symfony/bin/console --env=prod cocorico:bookings:alertImminent >> /var/www/Alerts/log.log 2>&1 /5 /usr/bin/php /var/www/Symfony/bin/console --env=prod cocorico:bookings:expire >> /var/www/Alerts/log.log 2>&1 /5 /usr/bin/php /var/www/Symfony/bin/console --env=prod cocorico:bookings:validate >> /var/www/Alerts/log.log 2>&1 /5 /usr/bin/php /var/www/Symfony/bin/console --env=prod cocorico:bookings:alertExpiring >> /var/www/Alerts/log.log 2>&1 10 /1 /usr/bin/php /var/www/Symfony/bin/console --env=prod cocorico:bookings:checkBankWires >> /var/www/Alerts/log.log 2>&1 30 17 /usr/bin/php /var/www/Symfony/bin/console --env=prod cocorico:currency:update >> /var/www/Alerts/log.log 2>&1 30 2 /usr/bin/php /var/www/Symfony/bin/console --env=prod cocorico_listing_search:computeNotation >> /var/www/Alerts/log.log 2>&1 0 0 27 /usr/bin/php /var/www/Symfony/bin/console --env=prod cocorico:listings:alertUpdateCalendars >> /var/www/Alerts/log.log 2>&1

Here's the error, the same for each one of the job:

SQLSTATE[42000]: Syntax error or access violation: 1630 FUNCTION dbparty.DA TE_FORMAT does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual

In PDOStatement.php line 144:

SQLSTATE[42000]: Syntax error or access violation: 1630 FUNCTION dbparty.DA TE_FORMAT does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual

In PDOStatement.php line 142:

SQLSTATE[42000]: Syntax error or access violation: 1630 FUNCTION dbparty.DA TE_FORMAT does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual

[nmateo]

Resolved, change the syntax for DATEFORMAT (b0.start,'%Y-%m-%d') to DATEFORMAT(b0.start,'%Y-%m-%d') and it worked