FUNCTION ANY_VALUE does not exist MariaDB 10.1.45
We have migrated some accounts on the client's VPS and one of the accounts replicating this issue. Your help will be highly appreciated.
Error Number: 1305
FUNCTION gstprime_latest.ANY_VALUE does not exist
SELECT ANY_VALUE(SUM(taxableAmount+freightAmount)*currencyFactor) as total, ANY_VALUE(date_format(str_to_date(invoiceDate,'%d/%m/%Y'),'%Y-%m')) as newDate, MONTHNAME(date_format(str_to_date(invoiceDate,'%d/%m/%Y'),'%Y-%m-%d')) as month, ANY_VALUE(Year(date_format(str_to_date(invoiceDate,'%d/%m/%Y'),'%Y-%m-%d'))) as year, ANY_VALUE(date_format(str_to_date(invoiceDate,'%d/%m/%Y'),'%Y-%m-%d')) as chartDate FROM `seller_transactions` WHERE userId = '25' AND set_up = '12' AND cancelled != 'Y' AND date_format(str_to_date(invoiceDate,'%d/%m/%Y'),'%Y-%m-%d') >= '2020-04-01' AND date_format(str_to_date(invoiceDate,'%d/%m/%Y'),'%Y-%m-%d') <= '2020-07-17' GROUP BY month
Filename: models/ReportModel.phpPlease sign in to leave a comment.
Comments
0 comments