When ever I use the users online offline field in views i get this error. Any ideas?

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'IF1342654577MAXsessions.timestamp300101' in 'having clause'

Comments

manicato’s picture

I have the same problem. Any ideas?

liam mcdermott’s picture

Status: Active » Closed (duplicate)

Hello guys, thanks for the bug report!

It appears this Views handler doesn't translate well from Views v2.x -> v3.x as two of us spent most of yesterday struggling with it. Sorry for the problems you've been having, but this is a tricky problem to solve.

There have been several issues raised about this, so I'm consolidating them all into one: #1796882: SQL errors when using 'is_online' Views handler and marking this as a duplicate.