eventum / eventum

Eventum Issue Tracking System

Eventum Issue Tracking System

Eventum is a user friendly and very flexible issue tracking system, that can be used by a support department to track incoming technical support requests, or by a software development team to quickly organize tasks and bugs.

More information can be found at the following URL:

https://github.com/eventum/eventum/

We welcome you to send patches, bug fixes and other contributions to Eventum. Please see the CONTRIBUTING.md file for more details into how to do so.

Bryan Alsdorf
Elan Ruusamäe
The Eventum Team

eventum's Issues

Workflow: shouldAutoAddToNotificationList: Return false

I have been unable to prevent 3.0.6 from adding addresses to the NL.

// ./config/workflow/class.foo.php
class Foo_Workflow_Backend extends Abstract_Workflow_Backend
{
    public function shouldAutoAddToNotificationList($prj_id)
    {
        return false;
    }
}

I also tried the following:

// ./lib/eventum/workflow/class.abstract_workflow_backend.php
class Abstract_Workflow_Backend
{
    public function shouldAutoAddToNotificationList($prj_id)
    {
        return false;
    }
}

Even trying to overide the function in class.workflow.php, but it didn't help.

// ./lib/eventum/class.workflow.php
public static function shouldAutoAddToNotificationList($prj_id)
   {
      if (!self::hasWorkflowIntegration($prj_id)) {
         return false;
      }
      $backend = self::_getBackend($prj_id);

      // return $backend->shouldAutoAddToNotificationList($prj_id);
      return false;
}

But the address is still being added to the NL.
My best guess, it's in class.support.php

// Eventum 2.3.6
if ((@$_POST['add_unknown'] == 'yes') || (Workflow::shouldAutoAddToNotificationList(Issue::getProjectID($_POST['issue_id'])))) {
...
}

// Eventum 3.0.6
if (($add_unknown || Workflow::shouldAutoAddToNotificationList($prj_id)) && $issue_id) {
...
}

"Scheduled Release" field alphabetically sorted

When you create an issue, the combo with Scheduled Release field shows you the Releases you've created but are not sorted. It would be nice that were sorted.

closed issues not formatted as strike-trough

the closed issues used to be displayed as strike-trough in 2.3, it seems to be not working in current master v3.0.0-pre1-19-g7e2ab9c (7e2ab9c)

Eventum git scm plugin does not detect issues on lines 2 and later of commit message

Hi, I was playing around with the git hook in eventum/scm against a 3.1 eventum installation. This is really nice guys, great work!

The problem I encountered is that my commit message most of the time contain the issue id on line number 3, and this code only returns the first line of the commit message:

function git_scm_ping($rev, $refname)
{
$commit_msg = git_commit_msg($rev);
$issues = match_issues($commit_msg);
...

git_commit_msg runs git_format with an explicit comment that it should return 1 line which breaks issue matching. This hack solves that problem, but this breaks the comment:

diff --git a/eventum-git-hook.php b/eventum-git-hook.php
index c71b800..456e301 100755
--- a/eventum-git-hook.php
+++ b/eventum-git-hook.php
@@ -207,7 +207,7 @@ function git_commit_msg($rev)
*/
function git_format($rev, $format)
{

• return execl("git log --format=$format -n1 $rev");
• return implode("\n", execx("git log --format=$format -n1 $rev"));
  }

Regards,
Robbert-Jan

modern uploader

should modernize uploader, upload should be drag and droppable, allow multiple files and previews if upload is type image

here's 15 minute review of drag and drop upload google search:

http://html5demos.com/dnd-upload

• no library, inline js, but tiny

https://github.com/devbridge/html5-file-uploader

• license: mit
• pure js
• code: 15 commits, 0 releases
• demo: https://www.devbridge.com/sourcery/components/drag-and-drop-uploader/

https://github.com/ProgerXP/FileDrop

• license public domain
• version 2.0.0
• code: 41 commits, 0 releases
• pure js
• jquery ready
• 500+ lines of unit tests
• demo: http://filedropjs.org/
• bower integration

https://github.com/enyo/dropzone

• license: mit
• no jquery, pure js
• version 3.12.0
• code: 708 commits, 88 releases
• demo: http://www.dropzonejs.com/
• examples: https://github.com/enyo/dropzone/wiki
• includes "component" integration
• image thumbnail previews
• retina enabled
• big files not problem
• ui and code separated, clean apis
• previews via callback that doesn't kill browser
• does not care for old browsers

https://github.com/danielm/uploader

• mit/gpl license
• code 11 commits, 1 release
• version 0.1.0
• jquery plugin
• focuses modern browsers, but legacy ones should work too
• callbacks
• image preview
• blog http://blog.daniel.com.uy/2013/11/jquery-drag-and-drop-progress-files.html
• demo bootstrap: http://danielm.herokuapp.com/demos/dnd/
• demo plain: http://danielm.herokuapp.com/demos/dnd/simple.php
• demo with preview: http://danielm.herokuapp.com/demos/dnd/image-preview.php

https://github.com/Formstone/Dropper

• code 11 commits, 6 releases
• version 1.0.1
• bower integration
• jquery plugin
• demo http://formstone.it/components/Dropper/demo/index.html
• multiple files drop
• events

Bad translation 'Casa'

I'm using Eventum with spanish as Language. (Spanish from Spain/Europe).
There is a terrible translation that is 'Casa' from the English word Case or issue. I think it is a direct wrong translation. I would prefer 'Casos' or 'Caso', or much better 'Estadísticas' that is the Word used in the 2.2 versión.
'Casa' means home or house not issue, the translation is complete mistaken.

It is the Word between my assignments and reports in the upper part of the page when you logon.

Download emails in 3.0.2 after upgrade from 2.3.6

download_emails.php calls Email_Account::getAccountID (on line 172) and it returns 0 after an upgrade from 2.3.6. DB_Helper::getInstance()->getOne() is returning null within that function. Executing the SQL from getAccountID returns the correct result when executed manually. (See comment 4 for clarification)

download_emails.php was called with only a user and host (not folder) as my accounts are using POP3.

I'll try and trace it further, for now I have hard-coded the account ID's for my accounts. After hard-coding, the balance of the script is working correctly.

Also the UPGRADE doc should be updated to point out the cron scripts moved from the crons folder to the bin folder.

email address used for notifications

Hey Eventum dudes, thanks for the help with the email issues in upgrading to 3.0.5. Email is working awesomely now, however I'd like to change the email address that Eventum is sending notifications from. I went into https://ourserver.com/eventum/manage/general.php and changed the email address there for all of our projects, however when I make a new issues I'm still getting notifications from the old email address. Where do I need to make this change?

Colours of states. Possible enhancement

I just installed the 3.0.6 release.

In the administration panel you can create new cases with the hex color you decide. In 2.2 version you can see the color you put as background colour of the cell in the table. This option was nice and for see previously the color.

https://github.com/eventum/eventum/blob/v3.0.6/htdocs/manage/statuses.php

add notification category 'notes'

Translate name last action type

Please, add option to translate field "iss_last_internal_action_type". This information is showing in view issues, only in original language (text direct from DB).

Files:

• https://github.com/eventum/eventum/blob/v3.0.10/templates/list.tpl.html#L121
• https://github.com/eventum/eventum/blob/v3.0.10/lib/eventum/class.issue.php#L2478

Bulk update feature - absolutely don't works

The part of code for "Bulk update" feature is absent. As a result - "Bulk update" feature absolutely doesn't works.

Sending emails inside an issue

Hy, i'm running 3.0.6 version.
Yes Glensc I know i've to update.

Only a question, when you send an email inside an issue the mail don't reach the notification list members. Is not a problem of the mail server because the other mails of eventum (when you create or you are assigned) reach you. I download the email sent in the original format and it seems the RCPT TO is not fullfill with the emails from the people in the notification list. I check the database tables eventum_mail_queue and eventum_mail_queue_log and i can't see the mails.

Do you have the similar behavior?

config.php: APP_xxx_COLOR: CSS

Seems the color controls have been depreciated.
I suggest adding a note, colors are now handled by the css files.

// define colors used by eventum
define('APP_CELL_COLOR', '#255282');
define('APP_LIGHT_COLOR', '#DDDDDD');
define('APP_MIDDLE_COLOR', '#CACACA');
define('APP_DARK_COLOR', '#CACACA');
define('APP_CYCLE_COLORS', '#DDDDDD,#CACACA');
define('APP_INTERNAL_COLOR', '#9C494B');

Looks like they can even be removed.

Brian

changes to Initial Description are sent in html mail

found another regression:

when I update Initial Description area in issue, then email that gets sent out to notification list, contains <br> at the end of the each "old" line:

Changed Fields:
----------------------------------------------------------------------
Description:
@@ -1,61 +1,61 @@
-overall status:<br />
+overall status:

change installation to ask for default user and password

currently there are two users created to system (one inactive)
both hashes can be resolved quickly via rainbow tables from internet search

best is to solve this by creating admin user in setup screen with password input by user. that should randomize quite a bit the used password and use latest provided password hashing, not md5

ps: https://bugs.mysql.com/bug.php?id=7551

Error in the first pie chart in main.php

I'm getting an error when i access to:
https://github.com/eventum/eventum/blob/v3.0.6/htdocs/main.php

in the first pie chart. The error message: "SetRGBColor(): Color Green is not valid." The rest of pie charts are ok and i see the Green colors in the rest of pie charts.

Someone is getting this error or know why?
(I'll debug glesnc..)

Associate Emails not working

When the action selection page (associate as email, reference mail or internal note) displayed there are already two notices in the log:

[2016-06-13 13:52:07] app.NOTICE: E_NOTICE: Undefined index: unknown_contacts {"code":8,"message":"Undefined index: unknown_contacts","file":"/var/https/eventum.xxx.hu/var/cache/74052b47bde4d161151a14effecd4fa1986eeaed_0.file.associate.tpl.html.php","line":144} {"url":"/associate.php?cat=associate&item%5B%5D=19479&issue=existing&issue_id=7813&page_size=50&hide_associated=on","ip":"78.92.241.115","http_method":"GET","server":"eventum.xxx.hu","referrer":"https://eventum.xxx.hu/emails.php","file":"/var/https/eventum.xxx.hu/var/cache/74052b47bde4d161151a14effecd4fa1986eeaed_0.file.associate.tpl.html.php","line":144,"class":null,"function":"block_170527151575d3451188fd1_29983974","memory_usage":"1.75 MB","memory_peak_usage":"1.75 MB","version":"3.1.2","usr_id":"3"}
[2016-06-13 13:52:07] app.NOTICE: E_NOTICE: Trying to get property of non-object {"code":8,"message":"Trying to get property of non-object","file":"/var/https/eventum.xxx.hu/var/cache/74052b47bde4d161151a14effecd4fa1986eeaed_0.file.associate.tpl.html.php","line":144} {"url":"/associate.php?cat=associate&item%5B%5D=19479&issue=existing&issue_id=7813&page_size=50&hide_associated=on","ip":"78.92.241.115","http_method":"GET","server":"eventum.xxx.hu","referrer":"https://eventum.xxx.hu/emails.php","file":"/var/https/eventum.xxx.hu/var/cache/74052b47bde4d161151a14effecd4fa1986eeaed_0.file.associate.tpl.html.php","line":144,"class":null,"function":"block_170527151575d3451188fd1_29983974","memory_usage":"1.75 MB","memory_peak_usage":"1.75 MB","version":"3.1.2","usr_id":"3"}

If one of the first two options, email or reference email is selected and continue is clicked there is a warning that some parameter is not passed and then the error:

[2016-06-13 13:55:15] app.WARNING: E_WARNING: array_values() expects parameter 1 to be array, null given {"code":2,"message":"array_values() expects parameter 1 to be array, null given","file":"/var/https/eventum.xxx.hu/src/Db/Adapter/PdoAdapter.php","line":171} {"url":"/associate.php","ip":"78.92.241.115","http_method":"POST","server":"eventum.xxx.hu","referrer":"https://eventum.xxx.hu/associate.php?cat=associate&item%5B%5D=19479&issue=existing&issue_id=7813&page_size=50&hide_associated=on","file":null,"line":null,"class":null,"function":"array_values","memory_usage":"1.5 MB","memory_peak_usage":"1.5 MB","version":"3.1.2","usr_id":"3"}
[2016-06-13 13:55:15] app.ERROR: Uncaught Exception PDOException: "SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 6" at /var/https/eventum.xxx.hu/src/Db/Adapter/PdoAdapter.php line 135 {"exception":"[object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 6 at /var/https/eventum.xxx.hu/src/Db/Adapter/PdoAdapter.php:135)"} {"url":"/associate.php","ip":"78.92.241.115","http_method":"POST","server":"eventum.xxx.hu","referrer":"https://eventum.xxx.hu/associate.php?cat=associate&item%5B%5D=19479&issue=existing&issue_id=7813&page_size=50&hide_associated=on","file":null,"line":null,"class":null,"function":null,"memory_usage":"1.5 MB","memory_peak_usage":"1.5 MB","version":"3.1.2","usr_id":"3"}

If the third option, internal note is selected then the foreach loop complains about its input and the page is not closed but reloaded but without the issue number passed this time:

[2016-06-13 14:10:35] app.WARNING: E_WARNING: Invalid argument supplied for foreach() {"code":2,"message":"Invalid argument supplied for foreach()","file":"/var/https/eventum.xxx.hu/src/Controller/AssociateController.php","line":104} {"url":"/associate.php","ip":"78.92.241.115","http_method":"POST","server":"eventum.xxx.hu","referrer":"https://eventum.xxx.hu/associate.php?cat=associate&item%5B%5D=19479&issue=existing&issue_id=7813&page_size=50&hide_associated=on","file":"/var/https/eventum.xxx.hu/src/Controller/AssociateController.php","line":104,"class":"Eventum\\Controller\\AssociateController","function":"associateAction","memory_usage":"1.5 MB","memory_peak_usage":"1.5 MB","version":"3.1.2","usr_id":"3"}
[2016-06-13 14:10:35] app.NOTICE: E_NOTICE: Undefined variable: res {"code":8,"message":"Undefined variable: res","file":"/var/https/eventum.xxx.hu/src/Controller/AssociateController.php","line":120} {"url":"/associate.php","ip":"78.92.241.115","http_method":"POST","server":"eventum.xxx.hu","referrer":"https://eventum.xxx.hu/associate.php?cat=associate&item%5B%5D=19479&issue=existing&issue_id=7813&page_size=50&hide_associated=on","file":"/var/https/eventum.xxx.hu/src/Controller/AssociateController.php","line":120,"class":"Eventum\\Controller\\AssociateController","function":"associateAction","memory_usage":"1.5 MB","memory_peak_usage":"1.5 MB","version":"3.1.2","usr_id":"3"}
[2016-06-13 14:10:35] app.NOTICE: E_NOTICE: Undefined index: unknown_contacts {"code":8,"message":"Undefined index: unknown_contacts","file":"/var/https/eventum.xxx.hu/var/cache/74052b47bde4d161151a14effecd4fa1986eeaed_0.file.associate.tpl.html.php","line":144} {"url":"/associate.php","ip":"78.92.241.115","http_method":"POST","server":"eventum.xxx.hu","referrer":"https://eventum.xxx.hu/associate.php?cat=associate&item%5B%5D=19479&issue=existing&issue_id=7813&page_size=50&hide_associated=on","file":"/var/https/eventum.xxx.hu/var/cache/74052b47bde4d161151a14effecd4fa1986eeaed_0.file.associate.tpl.html.php","line":144,"class":null,"function":"block_652056384575ea0b0d987d5_81676239","memory_usage":"1.75 MB","memory_peak_usage":"1.75 MB","version":"3.1.2","usr_id":"3"}
[2016-06-13 14:10:35] app.NOTICE: E_NOTICE: Trying to get property of non-object {"code":8,"message":"Trying to get property of non-object","file":"/var/https/eventum.xxx.hu/var/cache/74052b47bde4d161151a14effecd4fa1986eeaed_0.file.associate.tpl.html.php","line":144} {"url":"/associate.php","ip":"78.92.241.115","http_method":"POST","server":"eventum.xxx.hu","referrer":"https://eventum.xxx.hu/associate.php?cat=associate&item%5B%5D=19479&issue=existing&issue_id=7813&page_size=50&hide_associated=on","file":"/var/https/eventum.xxx.hu/var/cache/74052b47bde4d161151a14effecd4fa1986eeaed_0.file.associate.tpl.html.php","line":144,"class":null,"function":"block_652056384575ea0b0d987d5_81676239","memory_usage":"1.75 MB","memory_peak_usage":"1.75 MB","version":"3.1.2","usr_id":"3"}
[2016-06-13 14:10:35] app.NOTICE: E_NOTICE: Undefined index: issue_id {"code":8,"message":"Undefined index: issue_id","file":"/var/https/eventum.xxx.hu/var/cache/74052b47bde4d161151a14effecd4fa1986eeaed_0.file.associate.tpl.html.php","line":162} {"url":"/associate.php","ip":"78.92.241.115","http_method":"POST","server":"eventum.xxx.hu","referrer":"https://eventum.xxx.hu/associate.php?cat=associate&item%5B%5D=19479&issue=existing&issue_id=7813&page_size=50&hide_associated=on","file":"/var/https/eventum.xxx.hu/var/cache/74052b47bde4d161151a14effecd4fa1986eeaed_0.file.associate.tpl.html.php","line":162,"class":null,"function":"block_652056384575ea0b0d987d5_81676239","memory_usage":"1.75 MB","memory_peak_usage":"1.75 MB","version":"3.1.2","usr_id":"3"}
[2016-06-13 14:10:35] app.NOTICE: E_NOTICE: Undefined index: issue_id {"code":8,"message":"Undefined index: issue_id","file":"/var/https/eventum.xxx.hu/var/cache/74052b47bde4d161151a14effecd4fa1986eeaed_0.file.associate.tpl.html.php","line":184} {"url":"/associate.php","ip":"78.92.241.115","http_method":"POST","server":"eventum.xxx.hu","referrer":"https://eventum.xxx.hu/associate.php?cat=associate&item%5B%5D=19479&issue=existing&issue_id=7813&page_size=50&hide_associated=on","file":"/var/https/eventum.xxx.hu/var/cache/74052b47bde4d161151a14effecd4fa1986eeaed_0.file.associate.tpl.html.php","line":184,"class":null,"function":"block_652056384575ea0b0d987d5_81676239","memory_usage":"1.75 MB","memory_peak_usage":"1.75 MB","version":"3.1.2","usr_id":"3"}
[2016-06-13 14:10:35] app.NOTICE: E_NOTICE: Undefined index: issue_id {"code":8,"message":"Undefined index: issue_id","file":"/var/https/eventum.xxx.hu/var/cache/74052b47bde4d161151a14effecd4fa1986eeaed_0.file.associate.tpl.html.php","line":184} {"url":"/associate.php","ip":"78.92.241.115","http_method":"POST","server":"eventum.xxx.hu","referrer":"https://eventum.xxx.hu/associate.php?cat=associate&item%5B%5D=19479&issue=existing&issue_id=7813&page_size=50&hide_associated=on","file":"/var/https/eventum.xxx.hu/var/cache/74052b47bde4d161151a14effecd4fa1986eeaed_0.file.associate.tpl.html.php","line":184,"class":null,"function":"block_652056384575ea0b0d987d5_81676239","memory_usage":"1.75 MB","memory_peak_usage":"1.75 MB","version":"3.1.2","usr_id":"3"}
[2016-06-13 14:10:35] app.NOTICE: E_NOTICE: Undefined index: issue_id {"code":8,"message":"Undefined index: issue_id","file":"/var/https/eventum.xxx.hu/var/cache/74052b47bde4d161151a14effecd4fa1986eeaed_0.file.associate.tpl.html.php","line":185} {"url":"/associate.php","ip":"78.92.241.115","http_method":"POST","server":"eventum.xxx.hu","referrer":"https://eventum.xxx.hu/associate.php?cat=associate&item%5B%5D=19479&issue=existing&issue_id=7813&page_size=50&hide_associated=on","file":"/var/https/eventum.xxx.hu/var/cache/74052b47bde4d161151a14effecd4fa1986eeaed_0.file.associate.tpl.html.php","line":185,"class":null,"function":"block_652056384575ea0b0d987d5_81676239","memory_usage":"1.75 MB","memory_peak_usage":"1.75 MB","version":"3.1.2","usr_id":"3"}

Email issues when upgrading from 2.3.3 to 3.0.2

Hi!

I upgraded from 2.3.3 to 3.0.2 on an Ubuntu 12 machine and the email notifications are no longer working. Fortunately I made this upgrade on a clone so I've been able to compare the settings of the functional 2.3.3 to the non-functional 3.0.2 and am seeing no difference. I've dug through all of the class.email....php files and am seeing no irregularities. Is there something I need to change to fix this?

Thanks for your help!

add checkboxes (TaskLists) to issue initial description area

add support for github style Task Lists

optionally control issue's "percentage complete" status field (or make it to be controlled via workflow)

severity field on issue create page

when severity is defined for project, it is marked as required field.

however, in new issue page (new.php), when i do not fill the field, and hit create issue, i see the field error appear for a second, and then redirected to new issue page with a flash message "Your issue was created successfully."

first should fix that when field is incorrectly filled, the submit would abort.

optionally maybe make field optional, but i can live with it being not optional.

Translate jquery-ui/datepicker + jquery.timeago

Please, add support of languages on Datepicker and Timeago plugin.

Set datepicker: https://jqueryui.com/datepicker/#localization
Localization files can be found at https://github.com/jquery/jquery-ui/tree/master/ui/i18n

Timeago: https://github.com/rmm5t/jquery-timeago/tree/master/locales

add associated issues field to new issue page

when new issue is opened, then currently there is no possibility to
add "associated issues"

you first have to save/issue, then edit again - and only then you can
add associated issues.

issue lock and cancel

somebody edits issue, it's locked:

note that html is shown

and when he presses cancel, js error pops up:

3.0.6: General Setup: SMTP: Requires Authentication: Radio Buttons

After a fresh base install, where SMTP requires authentication...
When loading the General setup page, the yes and no radio buttons are unchecked.

• yes
• no

Appears the setting isn't being loaded.
So have to select the value before I can Update Setup for every change.

Brian

"List Issues" display only one column for issues in new projects

When creating a new project and adding issues, the "List Issues" only shows the "All" column with the checkbox. But not problem for issues in Default project. (Running a fresh install of v3.0.10).

Password for pop account are plain text in the database

Like user passwords i consider the email passwords must to be hashed in the database.
Consider this like an enhacement.

display status and status color next to the Associated Issues / duplicates issue number

display status and status color next to the Associated Issues / duplicates issue number

EG if issue 106 is a duplicate of issue 55 and the status of issue 106 is open (color: green) show this in issue 55 as:
Duplicates: Duplicated by: 106 ([green background]open[/green background])

Status Change Date column missing in list

In v 3.1.1 when viewing an issue list (list.php) with the "Status Change Date" column showing the column is blank even if the status has changed after creation of the issue.

Looking at the values passed to smarty:

the "list" passed to smarty includes for every issue:
"status_change_date" => ""

for all values (even where the status was changed after issue creation)

The "columns" passed to smarty show this:

...
"sta_change_date" => array:2 [
      "title" => "Status Change Date"
      "width" => ""
    ]
...

I'm not sure if the "sta_change_date" should match "status_change_date" or if it matters if no data is passed into the Smarty "list"?

Craig.

Error updating 'Completion Percentage'

if you update an issue and change the value it's not recorded. Always 0.
In update.php

Regards

Database upgrade failure on Mysql 5.7.12

Note: I should probably be using MariaDB, but don't know if this would have fixed it.

This was on Mysql v5.7.12 using all default values on Ubuntu upgrading my prod db in a dev environment. Original extracted database was from Mysql v5.4.9. There were no errors on importing the database, it did accept the create statements that led to 1. below.

When performing a database upgrade (running bin/upgrade.php) from database version 40 to 55 I experienced several errors.

1. Any ALTER TABLE statements on tables containing a datetime column with a definition and default value of datetime NOT NULL default '0000-00-00 00:00:00' failed to update. This happened even though the patches were not changing the columns in the error.
   ERROR:

* Applying patch: 45 (45_multiple_groups.php)
SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'usr_created_date'

---
* Applying patch: 48 (48_access_restriction.sql)
SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'iss_created_date'

---
* Applying patch: 52 (52_support_to_null.sql)
SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'sup_date'
--
* Applying patch: 53 (53_scm_changesets.php)
SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'isc_created_date'

---
* Applying patch: 56 (56_maq_message_id.php)
SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'maq_queued_date'

Possible solution - execute the ALTER statements below (or changed to remove a default value due to version compatibility issue) in each of the patches and create a new patch to run the same ALTER statements for implementations that are already current.

I'm not sure whether this would be fixed, so in case it helps anyone running Mysql >= v5.6.5 I have included the SQL below to change the column and allow the upgrade to continue.
Note my table prefix is eventum, you will need to change if yours is different.
I chose to default these to CURRENT_TIMESTAMP which is supported >5.6.5, as any inserted value overrides the CURRENT_TIMESTAMP. Dropping the default would also likely work.

ALTER TABLE eventum_user CHANGE COLUMN usr_created_date usr_created_date datetime NOT NULL default CURRENT_TIMESTAMP;
ALTER TABLE eventum_issue CHANGE COLUMN iss_created_date iss_created_date datetime NOT NULL default CURRENT_TIMESTAMP;
ALTER TABLE eventum_support_email CHANGE COLUMN sup_date sup_date datetime NOT NULL default CURRENT_TIMESTAMP;
ALTER TABLE eventum_issue_checkin CHANGE COLUMN isc_created_date isc_created_date datetime NOT NULL default CURRENT_TIMESTAMP;
ALTER TABLE eventum_mail_queue CHANGE COLUMN maq_queued_date maq_queued_date datetime NOT NULL default CURRENT_TIMESTAMP;

1. Mysql doesn't like the GROUP BY of this patch. SQL install was the default. Does the "sql mode" in the error need to be changed for Eventum?

First INSERT:

* Applying patch: 55 (55_scm_migrate.sql)
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'support.eventum_issue_checkin.isc_reponame' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Last INSERT (first one commented out):

* Applying patch: 55 (55_scm_migrate.sql)
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'support.isc.isc_iss_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

1. Patch 57 (not important)

* Applying patch: 57 (57_drop_table_prefix.php)
If you see error above, please retry the upgrade command
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'support.eventum_version' doesn't exist

The word "above" should be "below". Or "any" if the user is supposed to review the line for each of their mail_queue entries.

percentage complete not notified

having d7d5616 (v3.0.11-18-gd7d5616) installed, i update issue and change only percentage value.
eventum sends out notification about changes, but no changes are noted in the email.

This is an automated message sent at your request from Eventum.

The issue was updated by Elan Ruusamäe

To view more details of this issue, or to update it, please visit the
following URL: issue 84215

----------------------------------------------------------------------
Issue #: 84215
Summary: summary here
Changed Fields:
----------------------------------------------------------------------
Description:

----------------------------------------------------------------------

notification list user picker

seems since 43cc7ae user list picker is gone.
should add it back, or at least let choose from developers, like send note dialog does.

we use jquery chosen now, could be implemented with it

Download attachments as archive

As people upload lots of attachments into one entry, it would be great, if there is possible to download all attachments (per entry) with one click, when there are more than 3? entries.
Because it's very painful to download them one by one.
I have no clue, where to put it though :) Should it be link or a button.

Check boxes: Edit Notification List

Hi again, not sure if there is anything that can be done about this, but when I'm in an issue and I click Edit Notification List a window pops up allowing me to add emails to be notified for various things; I'm wondering if the "Get a Notification When" checkboxes can be prechecked when I open this window? Is there somewhere in the settings that those boxes can default as checked so that when adding several emails to an issue I don't have to click 4 boxes every time?

restore html table in issue view page

also duplicate ticket in #1339865 launchpad

html table should be restored, as making layout to function properly with only div's is very difficult and result is very poor.

besides that it looks ugly, now it is hiding text as well, especially seen on wide screens:

there unwrapped text is truncated after pretium.Morbi,semper.

the long text for reproducing is lorem ipsum with spaces removed:

Lorem ipsum dolor sit amet, Vestibulum,consequat,ante,et,purus,pretium,in,interdum,mi,dapibus.Etiam,viverra,nulla,sit,amet,consectetur,pretium.Morbi,semper,tristique,erat,a,semper,nisi,pellentesque,vel.Ut,vulputate,vestibulum,sem,vel,eleifend.Donec,consectetur,tempor,ante,a,venenatis.Praesent,sit,amet,hendrerit,velit.Aliquam,magna,mi,laoreet,id,eros,vel,molestie,imperdiet,enim.Nunc,feugiat,gravida,lectus,id,laoreet,nibh,aliquam,non.Aenean,lacinia,finibus,enim,vel,tristique,eros,auctor,et.Curabitur,risus,elit,elementum,in,odio,vitae,rhoncus,tincidunt,velit.

issue will be not listed in weekly report, when timetracking was added next week

Let's say I worked really hard last week, so hard that I had no time to insert time tracking.
If new week has started, I have little time to fill the time tracking for previous week.

When I open WEEKLY report, then there is "Total Time Spent: N" but no issues listed.
When I change "Weekly" to "Date Range" for that week, same problem - no issues listed.
When I use "Date Range" and include the date, when I inserted time tracking, it will be shown, with the others.

So, please find way to display issues with time spent when using "Weekly"/"Date range" report.

Images:

• Weekly / Date Range 13-19.06
  
• Date Range 13-22.06 (with included date)
  

Release field blocked in red

Hello,

I've intalled a 3.0.2 versión from scratch. I've created several Releases. When i create an issue and i want update it the reléase field is blocked. I entered with the admin user and i can't update it in this field. I've reviewed the configuration but i don't know where to change this behaviour. We used 2.3.6 for several years and we can change this field as developers.

Any one can help me?
Regards
Antonio

associated issues

should not be able to fill current issue id to issue's associated issue field. if you do it gets filled twice.

Zend Mail fails on emails with "From XXX" header

If an email starts with a header such as "From [email protected] Wed Mar 23 01:42:50 2016" then this exception will be thrown:

Zend\Mail\Header\Exception\InvalidArgumentException: Invalid header name detected in /media/data/work/eventum-skysql/vendor/zendframework/zend-mail/src/Header/GenericHeader.php on line 57

I've attached an example email.

I can't find any reference to this in Zend Mail.

My two solution ideas are to either filter this line out in the routing class or in MailMessage::createFromHeaderBody(). However I'm not sure if it would also impact us in other areas.
from_nocolon.txt

buttons do not work in listing view

All clickable nonlinks in issue view do not work. Well, except header button Search.

In header:

• Clear filters

In Search Results:

• All
• |<
• <<
• Go

• |

• Set
• Hide Closed Issues

In Bulk Update Tool:

• Bulk Update
• Reset

Click so much if you want, nothing happens. Nothing in console.

Upgrade from v2.2 & v2.3.3 to v3.0.3 - "Error: Cookies support seem to be disabled in…”

When upgrading from v2.2 or v2.3.3 to v3.0.3:

This is an old question in the FAQ provided.
The problem I found was, in the upgrading process there is no instruction or automatic change to update the "config.php" file.

When trying to login the system return:
"Error: Cookies support seem to be disabled in your browser. Please enable this feature and try again".

I solved it manually updating the config.php file.

// The old code was: define('APP_RELATIVE_URL', '/eventum-2.2/');
define('APP_RELATIVE_URL', '/eventum/htdocs/');

Just to include in the FAQ if it is possible.
Thanks!

severity field hints

in new issue page, when i choose severity, yellow hint is presented what each of them mean.
however on issue update page, no such hint is rendered

this is inconsistent, should be on issue update page as well.

Is there anyway to populate demo data for testing?

3.0.5: General Setup: Daily Tips?

Checking out v3.0.5 and updating docs. Found General Setup shows: "Display Description as Email #0" where "Daily Tips" should be.

Brian

Upgrade from v2.2 & v2.3.3 to v3.0.3 - There is no “logout” button in main screen

When upgrading from v2.2 or v2.3.3 to v3.0.3:
The main screen (list.php) does not show the "logout" text.
I'm not a developer so the way I found to fix is described as follows:

• Modification in the file: “navigation.tpl.html”
  Inserted the code just before the "administration" link.

          {if $core.current_role >= $core.roles.reporter}
          <li><a title="{t}logout from{/t} {$app_setup.tool_caption|default:$application_title}" target="_top" href="{$rel_url}logout.php" class="white_link">{t}Logout{/t}</a></li>
          {/if}
  

I hope I'm helping the community.
Thanks!

Error Checking configuration email buttom

I installed the new 3.0.5. Before i had 3.0.2 with a pop account and works fine.
But in 3.0.5 in the administration panel when i push the bottom check configuration i get and error for undefined index for 'folder'.
In check_email_settings.php i commented 49 line

'ema_folder' => $_POST['folder'],

and put this
'ema_folder' => isset($_POST['folder']) ? $_POST['folder'] : '',
working fine.

I'm getting similar errors in 'associated emails' in lines 236,237,238 and 239 of class.mail_helper.php. I'm going to do the same that before.
In all the cases eventum is downloading the emails and checking ok the connection.

Regards
Antonio

Scheduled Release field loses selected value when updating issue

When updating an issue the Scheduled Release field loses its selected value when the current date > Tentative Date of the release

Error updating associated issues in update.php

In the new 3.0.6 there is an strange circunstance:

1. you create an issue without any state selected
2. You select the issue and update buttom
3. Fill the the associated issue field with the number of other associated issue.
4. Then you open the other associated issue and then the number of the original issue is not shown but if you put a state or select a default state in the new issue this behavior doesn't occur and in the other associated issue this field is automatically updated .

It's not a logical situation creating issues wihtout an state and moreover associating with others but perhaps is designed in this way because is not a logical situation.

Progress Bar for % Complete

If you have interest, I offer this improvements.

Patch is created on version 3.0.11. I am beginner in git, I can't work with Fork and Pull requests.

Eventum_ProgressBar.zip