FUNCTION ANY_VALUE does not exist MariaDB 10.1.45

Somesh Zade

Member
Feb 8, 2019
6
0
1
India
cPanel Access Level
Root Administrator
We have migrated some accounts on the client's VPS and one of the accounts replicating this issue. Your help will be highly appreciated.

Code:
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.php
 

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,295
1,257
313
Houston