Closed (duplicate)
Project:
User Stats
Version:
7.x-1.x-dev
Component:
User interface
Priority:
Critical
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
18 Jul 2012 at 23:40 UTC
Updated:
1 Mar 2013 at 18:54 UTC
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
Comment #1
manicato commentedI have the same problem. Any ideas?
Comment #2
liam mcdermott commentedHello 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.