History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: FC-1606
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Blocker Blocker
Assignee: Matthew Bryant
Reporter: Tomek Kott
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
FarCry Core Framework

"User Activity Over Time" / Oracle fails due to bad SQL

Created: 19/Nov/08 07:58 AM   Updated: 17/Dec/08 11:40 AM
Component/s: Core Types, Administration
Affects Version/s: 5.0.2
Fix Version/s: FarCry 5.1

Time Tracking:
Not Specified

File Attachments: 1. File farLog.cfc (18 kb)

Environment: Oracle 8i, CFMX 7, Shared Host


 Description  « Hide
There were two problems with the farLog.cfc file, which I am attaching as a reference. The first was in the function "getTypeEventList", where the SQL query used characters illegal in Oracle (the concatenation shorthand '+'). Instead, I changed the function to use CONCAT(), which can only take two values in Oracle. However, there is an identical function in MySQL that should work.

The second problem was in the getUserActivityDaily function. There was a table name under the oracle section "farLogin" instead of the correct "farLog".

 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
Tomek Kott - 19/Nov/08 07:59 AM
Corrected farLog file from 5.0.2

Matthew Bryant - 17/Dec/08 11:40 AM
Thanks Tomek.