All Projects

ID Project Category Task Type Severity Summary Status Opened by Opened Progress
 1104 FlysprayUser InterfaceBug ReportLow Selected project changes when it isn't supposed to Closedmeirian06.11.2006
100%
2 Task Description

When multiple projects is defined to the Flyspray, the selected project changes when it isn't supposed to. For example on the Editing Group page after pressing Update details -button changes the selected project
Project Manager's Toolbox :: Project 1 : Edit Group
→ Project Manager's Toolbox :: Project 2 : Edit Group

(Flyspray 0.9.9 beta 1 and browser Firefox 1.5.0.7)

 1103 FlysprayBackend/CoreBug ReportLow Updating group rights Closedmeirian06.11.2006
100%
1 Task Description

I tried to update group rights as admin user, but the changes I made won't affect. For example selecting Add self to assignees won't change the flyspray_users.add_to_assignees field 0 → 1. There is something wierd with the checkboxes.. Now there is situation where changing the checkboxes statuses won't affect at all.

(Flyspray 0.9.9 beta 1 and browser Firefox 1.5.0.7)

 1102 FlysprayDatabase QueriesBug ReportLow Reports and ordering by the user name Closedmeirian06.11.2006
100%
1 Task Description

Hi,

there are few bugs I have noticed using Flyspray 0.9.9 beta 1 (and browser Firefox 1.5.0.7). Here is the first one.

In the Reports section on the Events tab I made a simple query where Assigned and From date to date were defined. The report was generated ok, but ordering by the user name caused an error report below.

array(2) {
  [0]=>
  array(7) {
    ["file"]=>
    string(39) "/www/hosts/flyspray/scripts/reports.php"
    ["line"]=>
    int(151)
    ["function"]=>
    string(5) "Query"
    ["class"]=>
    string(8) "Database"
    ["object"]=>
    object(Database)#1 (4) {
      ["dbprefix"]=>
      string(9) "flyspray_"
      ["cache"]=>
      array(0) {
      }
      ["dbtype"]=>
      string(5) "MySQL"
      ["dblink"]=>
      object(ADODB_mysql)#2 (77) {
        ["databaseType"]=>
        string(5) "mysql"
        ["dataProvider"]=>
        string(5) "mysql"
        ["hasInsertID"]=>
        bool(true)
        ["hasAffectedRows"]=>
        bool(true)
        ["metaTablesSQL"]=>
        string(11) "SHOW TABLES"
        ["metaColumnsSQL"]=>
        string(20) "SHOW COLUMNS FROM %s"
        ["fmtTimeStamp"]=>
        string(13) "'Y-m-d H:i:s'"
        ["hasLimit"]=>
        bool(true)
        ["hasMoveFirst"]=>
        bool(true)
        ["hasGenID"]=>
        bool(true)
        ["isoDates"]=>
        bool(true)
        ["sysDate"]=>
        string(9) "CURDATE()"
        ["sysTimeStamp"]=>
        string(5) "NOW()"
        ["hasTransactions"]=>
        bool(false)
        ["forceNewConnect"]=>
        bool(false)
        ["poorAffectedRows"]=>
        bool(true)
        ["clientFlags"]=>
        int(0)
        ["substr"]=>
        string(9) "substring"
        ["nameQuote"]=>
        string(1) "`"
        ["_genIDSQL"]=>
        string(38) "update %s set id=LAST_INSERT_ID(id+1);"
        ["_genSeqSQL"]=>
        string(33) "create table %s (id int not null)"
        ["_genSeq2SQL"]=>
        string(26) "insert into %s values (%s)"
        ["_dropSeqSQL"]=>
        string(13) "drop table %s"
        ["database"]=>
        string(8) "flyspray"
        ["host"]=>
        string(9) "localhost"
        ["user"]=>
        string(8) "flyspray"
        ["password"]=>
        string(16) "fE6cs9wKTPTMMs3Y"
        ["debug"]=>
        bool(false)
        ["maxblobsize"]=>
        int(262144)
        ["concat_operator"]=>
        string(1) "+"
        ["length"]=>
        string(6) "length"
        ["random"]=>
        string(6) "rand()"
        ["upperCase"]=>
        string(5) "upper"
        ["fmtDate"]=>
        string(7) "'Y-m-d'"
        ["true"]=>
        string(1) "1"
        ["false"]=>
        string(1) "0"
        ["replaceQuote"]=>
        string(2) "'"
        ["charSet"]=>
        bool(false)
        ["metaDatabasesSQL"]=>
        string(0) ""
        ["uniqueOrderBy"]=>
        bool(false)
        ["emptyDate"]=>
        string(6) " "
        ["emptyTimeStamp"]=>
        string(6) " "
        ["lastInsID"]=>
        bool(false)
        ["hasTop"]=>
        bool(false)
        ["readOnly"]=>
        bool(false)
        ["genID"]=>
        int(0)
        ["raiseErrorFn"]=>
        bool(false)
        ["cacheSecs"]=>
        int(3600)
        ["arrayClass"]=>
        string(18) "ADORecordSet_array"
        ["noNullStrings"]=>
        bool(false)
        ["numCacheHits"]=>
        int(0)
        ["numCacheMisses"]=>
        int(0)
        ["pageExecuteCountRows"]=>
        bool(true)
        ["uniqueSort"]=>
        bool(false)
        ["leftOuter"]=>
        bool(false)
        ["rightOuter"]=>
        bool(false)
        ["ansiOuter"]=>
        bool(false)
        ["autoRollback"]=>
        bool(false)
        ["fnExecute"]=>
        bool(false)
        ["fnCacheExecute"]=>
        bool(false)
        ["blobEncodeType"]=>
        bool(false)
        ["rsPrefix"]=>
        string(13) "ADORecordSet_"
        ["autoCommit"]=>
        bool(true)
        ["transOff"]=>
        int(0)
        ["transCnt"]=>
        int(0)
        ["fetchMode"]=>
        int(3)
        ["_oldRaiseFn"]=>
        bool(false)
        ["_transOK"]=>
        NULL
        ["_connectionID"]=>
        resource(21) of type (mysql link)
        ["_errorMsg"]=>
        bool(false)
        ["_errorCode"]=>
        bool(false)
        ["_queryID"]=>
        bool(false)
        ["_isPersistentConnection"]=>
        bool(false)
        ["_bindInputArray"]=>
        bool(false)
        ["_evalAll"]=>
        bool(false)
        ["_affected"]=>
        bool(false)
        ["_logsql"]=>
        bool(false)
      }
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(1) {
      [0]=>
      &string(3493) "SELECT h.*, t.*,
                              tt1.tasktype_name AS task_type1,
                              tt2.tasktype_name AS task_type2,
                              los1.os_name AS operating_system1,
                              los2.os_name AS operating_system2,
                              lc1.category_name AS product_category1,
                              lc2.category_name AS product_category2,
                              p1.project_title AS attached_to_project1,
                              p2.project_title AS attached_to_project2,
                              lv1.version_name AS product_version1,
                              lv2.version_name AS product_version2,
                              ls1.status_name AS item_status1,
                              ls2.status_name AS item_status2,
                              ls3.status_name AS status_name,
                              lr.resolution_name,
                              c.date_added AS c_date_added,
                              c.user_id AS c_user_id,
                              att.orig_name, att.file_desc

                        FROM  {history} h

                    LEFT JOIN {tasks} t ON t.task_id = h.task_id
                    
                    LEFT JOIN {list_tasktype} tt1 ON tt1.tasktype_id = h.old_value AND h.field_changed='task_type'
                    LEFT JOIN {list_tasktype} tt2 ON tt2.tasktype_id = h.new_value AND h.field_changed='task_type'

                    LEFT JOIN {list_os} los1 ON los1.os_id = h.old_value AND h.field_changed='operating_system'
                    LEFT JOIN {list_os} los2 ON los2.os_id = h.new_value AND h.field_changed='operating_system'

                    LEFT JOIN {list_category} lc1 ON lc1.category_id = h.old_value AND h.field_changed='product_category'
                    LEFT JOIN {list_category} lc2 ON lc2.category_id = h.new_value AND h.field_changed='product_category'
                    
                    LEFT JOIN {list_status} ls1 ON ls1.status_id = h.old_value AND h.field_changed='item_status'
                    LEFT JOIN {list_status} ls2 ON ls2.status_id = h.new_value AND h.field_changed='item_status'
                    LEFT JOIN {list_status} ls3 ON ls3.status_id = t.item_status
                    
                    LEFT JOIN {list_resolution} lr ON lr.resolution_id = h.new_value AND h.event_type = 2

                    LEFT JOIN {projects} p1 ON p1.project_id = h.old_value AND h.field_changed='attached_to_project'
                    LEFT JOIN {projects} p2 ON p2.project_id = h.new_value AND h.field_changed='attached_to_project'
                    
                    LEFT JOIN {comments} c ON c.comment_id = h.field_changed AND h.event_type = 5
                    
                    LEFT JOIN {attachments} att ON att.attachment_id = h.new_value AND h.event_type = 7

                    LEFT JOIN {list_version} lv1 ON lv1.version_id = h.old_value
                              AND (h.field_changed='product_version' OR h.field_changed='closedby_version')
                    LEFT JOIN {list_version} lv2 ON lv2.version_id = h.new_value
                              AND (h.field_changed='product_version' OR h.field_changed='closedby_version')
                        WHERE (h.event_type = 14 OR h.event_type = 29) AND h.event_date > 1162332000 AND h.event_date < 1164924000
                     ORDER BY u.real_name DESC, h.event_date DESC"
    }
  }
  [1]=>
  array(4) {
    ["file"]=>
    string(29) "/www/hosts/flyspray/index.php"
    ["line"]=>
    int(169)
    ["args"]=>
    array(1) {
      [0]=>
      string(39) "/www/hosts/flyspray/scripts/reports.php"
    }
    ["function"]=>
    string(12) "require_once"
  }
}

Query {SELECT h.*, t.*, tt1.tasktype_name AS task_type1, tt2.tasktype_name AS task_type2, los1.os_name AS operating_system1, los2.os_name AS operating_system2, lc1.category_name AS product_category1, lc2.category_name AS product_category2, p1.project_title AS attached_to_project1, p2.project_title AS attached_to_project2, lv1.version_name AS product_version1, lv2.version_name AS product_version2, ls1.status_name AS item_status1, ls2.status_name AS item_status2, ls3.status_name AS status_name, lr.resolution_name, c.date_added AS c_date_added, c.user_id AS c_user_id, att.orig_name, att.file_desc FROM `flyspray_history` h LEFT JOIN `flyspray_tasks` t ON t.task_id = h.task_id LEFT JOIN `flyspray_list_tasktype` tt1 ON tt1.tasktype_id = h.old_value AND h.field_changed='task_type' LEFT JOIN `flyspray_list_tasktype` tt2 ON tt2.tasktype_id = h.new_value AND h.field_changed='task_type' LEFT JOIN `flyspray_list_os` los1 ON los1.os_id = h.old_value AND h.field_changed='operating_system' LEFT JOIN `flyspray_list_os` los2 ON los2.os_id = h.new_value AND h.field_changed='operating_system' LEFT JOIN `flyspray_list_category` lc1 ON lc1.category_id = h.old_value AND h.field_changed='product_category' LEFT JOIN `flyspray_list_category` lc2 ON lc2.category_id = h.new_value AND h.field_changed='product_category' LEFT JOIN `flyspray_list_status` ls1 ON ls1.status_id = h.old_value AND h.field_changed='item_status' LEFT JOIN `flyspray_list_status` ls2 ON ls2.status_id = h.new_value AND h.field_changed='item_status' LEFT JOIN `flyspray_list_status` ls3 ON ls3.status_id = t.item_status LEFT JOIN `flyspray_list_resolution` lr ON lr.resolution_id = h.new_value AND h.event_type = 2 LEFT JOIN `flyspray_projects` p1 ON p1.project_id = h.old_value AND h.field_changed='attached_to_project' LEFT JOIN `flyspray_projects` p2 ON p2.project_id = h.new_value AND h.field_changed='attached_to_project' LEFT JOIN `flyspray_comments` c ON c.comment_id = h.field_changed AND h.event_type = 5 LEFT JOIN `flyspray_attachments` att ON att.attachment_id = h.new_value AND h.event_type = 7 LEFT JOIN `flyspray_list_version` lv1 ON lv1.version_id = h.old_value AND (h.field_changed='product_version' OR h.field_changed='closedby_version') LEFT JOIN `flyspray_list_version` lv2 ON lv2.version_id = h.new_value AND (h.field_changed='product_version' OR h.field_changed='closedby_version') WHERE (h.event_type = 14 OR h.event_type = 29) AND h.event_date > 1162332000 AND h.event_date < 1164924000 ORDER BY u.real_name DESC, h.event_date DESC} with params {} Failed! (Unknown column 'u.real_name' in 'order clause')
Showing tasks 1 - 3 of 3 Page 1 of 1

Available keyboard shortcuts

Tasklist

Task Details

Task Editing