I am moving my site to a new server and ran into a problem with a code that used to work on the old server but gives error on the new one. It is a query:
"SELECT *
FROM myTable
WHERE status = 'active'
GROUP BY projectID
ORDER BY call_exp ASC, RAND(projectID)
LIMIT 8"
The error I get is:
Last Error -- [Incorrect arguments to RAND]
projectID column contains a numeric values ( int(11) )
When I substitute RAND(projectID) for RAND(5) script works fine.
I'm at a loss...Any suggestions?
