i have not faced with such an error, i am using 1.8.5.
But i think the error is caused by this part.
params LIKE "userid=#t%"
Try this one:
$param = 'userid='.$userid.'%';
$eventlogCount = qa_db_read_one_value(qa_db_query_sub(
'SELECT COUNT(event)
FROM ^eventlog
WHERE datetime >= FROM_UNIXTIME(#) AND ((userid = # AND event LIKE "in_%") OR (event IN ("u_message", "u_wall_post") AND params LIKE $))',
$last_visit,
$userid,
$param
)); |