Bug #17563 Getting this missmatch error
Submitted: 19 Feb 2006 22:56 Modified: 20 Feb 2006 5:49
Reporter: Lukas Kure Email Updates:
Status: Duplicate Impact on me:
None 
Category:Eventum Severity:S3 (Non-critical)
Version:1.7 OS:Windows (XP)
Assigned to: CPU Architecture:Any

[19 Feb 2006 22:56] Lukas Kure
Description:
Hello,

An error was found at 02/19/2006 23:39:54 (1140388794) on line '538' of script 'I:\Program Files\Apache Group\Apache2\htdocs\eventum\include\class.time_tracking.php'.

The error message passed to us was:

'DB Error: mismatch'

A more detailed error message follows:

'SELECT
                    ttc_title,
                    COUNT(ttr_id) as total,
                    SUM(ttr_time_spent) as total_time
                 FROM
                    eventum.eventum_time_tracking,
                    eventum.eventum_time_tracking_category
                 WHERE
                    ttr_ttc_id = ttc_id AND
                    ttr_usr_id = 3 AND
                    ttr_created_date BETWEEN '2006-02-19 23:00:00' AND '2006-02-26 22:59:59'
                 GROUP BY
                    ttc_title [DB Error: mismatch]'

That happened on page '/eventum/reports/weekly.php' from IP Address '127.0.0.1' coming from the page (referrer) 'http://localhost:3236/eventum/reports/weekly.php';.

The user agent given was 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.1) Gecko/20060111 Firefox/1.5.0.1'.

Sincerely yours,
Automated Error_Handler Class

A backtrace is available:

Array
(
    [0] => Array
        (
            [file] => I:\Program Files\Apache Group\Apache2\htdocs\eventum\include\class.report.php
            [line] => 308
            [function] => getSummaryByUser
            [class] => Time_Tracking
            [type] => ::
            [args] => Array
                (
                    [0] => 3
                    [1] => 2006-02-19 23:00:00
                    [2] => 2006-02-26 22:59:59
                )

        )

    [1] => Array
        (
            [file] => I:\Program Files\Apache Group\Apache2\htdocs\eventum\reports\weekly.php
            [line] => 80
            [function] => getWeeklyReport
            [class] => Report
            [type] => ::
            [args] => Array
                (
                    [0] => 3
                    [1] => 2006-02-20
                    [2] => 2006-02-26
                    [3] => 
                )

        )

)

How to repeat:
Use Reports, dunno exactly whi one produces this but from Worload by Date Range because last 4 pics are unavailable. The table just shows some data...
[20 Feb 2006 5:49] Bryan Alsdorf
Hi, This has already been fixed and will be in our next release.

Thanks for the report.