Details
-
Bug
-
Resolution: Fixed
-
Medium
-
4.4.0
-
None
-
Operating System: 4.4
PHP Version: 5.x
Database and version:
Browser (and version): all
Description
hey guys,
i hope thats a valid report.
i just updated my page from 4.1.1 to 4.4 on one page i try to fetch all logged in user. before upgrade it worked fine. after it fails.
yes i set in override:
[Session] Handler=ezpSessionHandlerDB ForceStart=enabled
here its written how its supposed to work:
http://doc.ez.no/eZ-Publish/Technical-manual/4.x/Reference/Modules/user/Fetch-functions/logged_in_users
fetch:
{def = $user_names=fetch( 'user', 'logged_in_users', hash( 'sort_by', array( array( 'login', true() ) ) ) )}
result:
an attribute show gives me nothing..
debug tells me:
Error: eZMySQLDB Nov 23 2010 23:26:55 Query error: Unknown column 'ezuservisit.expiration_time' in 'where clause'. Query: SELECT distinct ezuser.* FROM ezuservisit, ezuser WHERE ezuservisit.user_id != '10' AND ezuservisit.expiration_time > '1290550914' AND ezuser.contentobject_id = ezuservisit.user_id ORDER BY ezuser.login asc Error: PHP: E_USER_ERROR Nov 23 2010 23:26:55 mysql_query(): Query error: Unknown column 'ezuservisit.expiration_time' in 'where clause'. Query: SELECT distinct ezuser.* FROM ezuservisit, ezuser WHERE ezuservisit.user_id != '10' AND ezuservisit.expiration_time > '1290550914' AND ezuser.contentobject_id = ezuservisit.user_id ORDER BY ezuser.login asc in /var/www/vhosts/seelenfeuer.web2.xrow.net/httpdocs/lib/ezdb/classes/ezmysqldb.php on line 433 Notice: eZMySQLDB::query(0.000 ms) query number per page:1 Nov 23 2010 23:26:55 SELECT distinct ezuser.* FROM ezuservisit, ezuser WHERE ezuservisit.user_id != '10' AND ezuservisit.expiration_time > '1290550914' AND ezuser.contentobject_id = ezuservisit.user_id ORDER BY ezuser.login asc