User Activity over time page fails

Description

On opening the User Activity Over Time page, the following error appears. When looking in the database, it appears the table is no longer installed by FarCry as on version 5.2.

Error Details
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'statsHours'.
Exception Type java.sql.SQLSyntaxErrorException
Detail
Tag Context

  • /var/www/customs/webapps/cfusion/farcry/core/packages/types/farLog.cfc (line: 191)

  • /var/www/customs/webapps/cfusion/farcry/core/webskin/auditUserOverTime/edit.cfm (line: 50)

  • /var/www/customs/webapps/cfusion/farcry/core/packages/fourq/fourq.cfc (line: 457)

  • /var/www/customs/webapps/cfusion/farcry/core/packages/fourq/fourq.cfc (line: 348)

  • /var/www/customs/webapps/cfusion/farcry/core/webtop/conjuror/invocation.cfm (line: 152)

Environment

FarCry 6.0.7 CF9 MSSQL 2005

Activity

Former user November 29, 2010 at 12:14 PM

Once I added the table, the page loads, but when I changed the filter, nothing happened

Fixed

Details

Assignee

Reporter

Components

Fix versions

Affects versions

Priority

Created November 26, 2010 at 1:12 PM
Updated December 22, 2010 at 12:23 AM
Resolved December 22, 2010 at 12:23 AM