tenants
Well-known member
I'm using the following order stament for one of my plugins:
A plugin user found that their database returned the following error:
"Mysqli prepare error: FUNCTION scenemar_xenforo.GREATEST does not exist"
This to me implies their database doesn't support the GREATEST function, or using it in this way
Is GREATEST, or using GREATEST in this way not supported by all versions of MySQL?
Code:
Order by GREATEST (1, IF(sft.king_pinned_bid IS NULL, 0, sft.king_pinned_bid)) DESC
A plugin user found that their database returned the following error:
"Mysqli prepare error: FUNCTION scenemar_xenforo.GREATEST does not exist"
This to me implies their database doesn't support the GREATEST function, or using it in this way
Is GREATEST, or using GREATEST in this way not supported by all versions of MySQL?