flyspray/flyspray

Flyspray Bug Tracking System

Flyspray Bug Tracking System

Flyspray is an uncomplicated, web-based bug and task tracking system.

Have you spotted Flyspray in the wild? Does your company or project use Flyspray? You can send a note to the Mailing List including your project or company name, Flyspray URL (if public), homepage, and a nice testimonial if you are in the mood and we'll have it added to the list of who is using Flyspray.

Installation

https://www.flyspray.org/manual/install

Upgrading

1. Create a backup of your files and database

2. Remove all files but keep:

   • flyspray.conf.php
   • attachments/ directory
   • avatars/ directory
   • maybe your own logo image if you replaced the flyspray logo
   • maybe .htaccess if you use it
   • maybe own extra customized *.css files like custom_yourproject.css in themes/CleanFS/ (only users of 1.0-dev versions)

3. Copy the new files to the Flyspray directory

4. Make sure flyspray.conf.php is writeable by the webserver.

5. Open http://yourflyspray/setup/ in your webbrowser. It detects the existing installation and you can follow the upgrade steps.

6. Note: Do not forget to press F5 (or CTRL+F5, depending on cache policy) after the upgrade in web browser to reload also cached CSS-files to see effects of updated CSS-files. They are cached by default for 14 days in the webbrowser.

Dependencies

Install php

Linux: Just use the package manager or one of its frontends of your Linux distribution.
For instance for Debian based Linux distributions:
sudo apt-get install php

Windows:
https://php.net/downloads

Install

Installing from prepackaged releases that include also needed 3rd party libraries

tar xzf flyspray-1.0-rc11.tgz

Rename folder flyspray-1.0-rc11 to shorter name or move to webroot if you want and point your webbrowser there and follow the configuration instructions.

Installing from source releases via command line

curl -L https://github.com/Flyspray/flyspray/archive/v1.0-rc11.tar.gz | tar xz
cd flyspray-1.0-rc11
curl -sS https://getcomposer.org/installer | php
php composer.phar install --no-dev

Rename folder flyspray-1.0-rc11 to shorter name or move to webroot if you want and point your webbrowser there and follow the configuration instructions.

Windows users can download Windows installer on https://getcomposer.org/download/

If you downloaded the installer, make sure to include it to shell when asked.

Download vendors

Using command lines:
- 'cd' to the main Flyspray directory
- Type 'php composer.phar install' to automatically download the vendors

flyspray's Issues

Updating from 0.9.9.7

We need a upgrade solution from 0.9.9.7

currently there is no upgrade.xml so none of the tables are created required in V1.0, Forcing the install.xml breaks aspects of flyspray

Set up

Why has the set up been made more complicated? Need for composer ...

Houston, we've got a problem (after merging pull request #111)

And another one too. Previous versions on Flyspray seem to have been saving detailed task descriptions as plain text, mostly with as utf-8, although I have a few really old examples where the encoding is something else. Might be my own fault and mess with database default character encodind, might be something that depended on the browser used. 1.0 saves them with html tags added and characters like ä converted to html character entity ä and after that pull request merge I get back ä when viewing task details... (github too might mangle this example totally incomprehensible).

First thing is to decide in what format the task descriptions are saved. If with html tags and encoding of characters, then the upgrader should convert existing entries and leave a flag in database that it has already done it, so it won't happen twice. If not, then something else must be done, like stripping all html tags and recoding html character entities to utf-8 when saving task descriptions.

mysql error

When I try to login
i see this error

Query {UPDATE flyspray_prefs SET pref_value = ? WHERE pref_name = ?} with params {1393109327,last_update_check} Failed! (MySQL server has gone away)

PHP 5.4
MYSQL 5.5

Quick actions button

@peterdd When clicking it, it nicely opens the menu. But you can't close this menu... Not even by clicking outside of it. I think we should rather use a hover for this, what do you think?

Pattern overflow in dokuwiki lexer and parser

When you have a lot of comments in an issue you might get this warning:

Warning: preg_match(): Compilation failed: regular expression is too large at offset 63063 in /var/www/flyspray/plugins/dokuwiki/inc/parser/lexer.php on line 115

On PHP5 it happens for me always above 30 comments (we have some extra patterns so YMMV, but it will happen eventually). Of course showing errors would have to be enabled to see the warning.

After some debugging I noticed large increase in a regexp length in Doku_LexerParallelRegex (in function _getCompoundedRegex). When the regexp was 65628 the pattern count was 599... Also smiley pattern is repeated as many times as there are comments (plus one).

new task screen breaks in IE cleanFS

the new task screen is broken in IE 11 using the cleanFS theme. everything is spaced wrongly and the round corners are gone.

insert script page

hi,
what flyspray html file would i have to edit to put a js script to be always executed ?

important things to be done for a 1.0 release

My personal list of requirements for a 1.0 release:

• anti-csrf token system (most important)
• rethink/rework session/cookie handling ; current cookie use is not well
• fixing some usability issues
• key features must be usable without javascript enabled for security concernd users. almost all that is handled by js currently can be replaced by html and css.
• make install and upgrade simple as a wordpress install
• basic responsive design (from 320 px wide to fullHD should be usable and look ok)
• stable estimated and effort tracking and summary of project (how many hours a project is estimated to consume and current workhours done => calculating costs) - natural with subtask data together!
• cleanup unused code, check if we really need so many jslibraries loaded.
• check if we really need so many composer dependencies

My personal wishlist:

• graphical output e.g. ganttlike diagrams realized with svg or canvas. I try to implement that.

make (project_id,version_name) unique in table list_version

It seems it is possible to insert 2 same version_name on a project.
Can someone address this?

Massop rework

The massop close doesn't respect open subtasks!

You can close a parent/supertask but the subtask stays uneffected.

Deactivate massops feature in source code for 1.0 and leave it for 1.1 or later?

Probably same problem on blocking/dependend tasks.

Mass operations must be IMHO handled by a real SQL transaction, where in case of an error in middle of processing a rollback can be done.

A poor mans solution - where real sql transactions aren't possible/enabled - would be to check all the possible dependencies of a mass operation and do the whole database operation only when there are no conflicts.

Also the movement of parent tasks to another project shouldn't be possible if there are subtasks.
Also the movement of sub tasks to another project shouldn't be possible if there are parent tasks.
Also the movement of tasks with dependencies shouldn't be possible to move to another project.

Syntax errors in php files

I cloned the master branch and found several issues to fight against:

1. in the file include/class.flyspray.php at line 683 i suppose that
   $pwOk = ($method == 'oauth') ?: ($password == $auth_details['user_pass']);
   should be something like
   $pwOk = ($method == 'oauth') ? true : ($password == $auth_details['user_pass']);
2. in file include/class.flyspray.php at line 992 there is a '' character before the FILTER_VALIDATE_EMAIL option of the filter_var function call
3. there should be a fallback for people that can't install composer due to system access limitations (just my two cents)

Flyspray API

It would be very useful to have a (preferably JSON) API for querying and preferably also opening/modifying/closing reports.

Currently one has to do hack things to parse the html to extract any information, which becomes even more annoying with pagination.

flyspray.org - Page Not Found

Hello,

I am trying to access the page to see the documentation, but I can not, what happened to the page? D:

Undefined index: baseurl

I got "Notice: Undefined index: baseurl in C:\src\pgflyspray\includes\class.flyspray.php on line 806" when running setup/upgrade.php. Maybe related to the new session session handling? I don't understand much about it, otherwise I'd have fixed it myself. Not critical, upgrade works anyway.

Default user not created

Not sure what I'm doing wrong but after installing the software the default user is not created. Looking at the database the user table is empty.

Is there a way to create the default (Admin) user?

heavy js and ckeditor

TODO Only load the ckeditor stuff when there is an textarea field in the loaded page.
TODO Only use the ckeditor extensions/plugins we really need for writing tasks or comments.

Do we really need a full blown ckeditor monster with all that plugins???

Using flyspray with that blown up javascript is so much slower
than when using flyspray with browser setting javascript.enabled= false.

For what reason the prototype and scriptaculous stuff is necessary? If its used, can it be replaced by something smaller JS or pure HTML(5) / CSS ?

Project Overview Page: All and Open Links Not Working

when clicking the all or open links on the project overview page I get the following: You don't have permission to access /project/index.php on this server - all the other links, recently opened etc work fine ....

Strict Standards error

Description:
When you click on a task this error shows in the comment section

Error:
Strict Standards: call_user_func() expects parameter 1 to be a valid callback, non-static method dokuwiki_TextFormatter::render() should not be called statically in /media/DATA/FS/CMIL/includes/class.tpl.php on line 557

Versions:
flyspray: latest from github
php: 5.5.18
apache: 2.2.27

mod_security documentation not found

The .htaccess distribution file references a blog entry which does not exist anymore. I suggest including the relevant information directly into the file while specifing the original author.

lost oauth config on upgrading dev->master

I tried the upgrade script on my dev setup with latest master. It seems I lost my testing github oauth setup in flyspray.conf.php

Before that I just unzipped the github master zipfile over my testing version.

The upgrader needs the user give a feedback from the upgrading process.
In the best case a dry run information what will be added/changed if the user starts the real upgrade.

Currently I don't understand what happened with the config by upgrading..

Undefined variable in includes/class.tpl.php

When running under PHP 5.4.20, I get an "Undefined variable" error referring to $onlyfs in includes/class.tpl.php

I left a comment in commit c43f127 which is when the error was introduced. As far as I can tell, all other occurrences of $onlyfs were removed so it would be safe to change

        if (@in_array('render', get_class_methods($conf['general']['syntax_plugin'] . '_TextFormatter')) && !$onlyfs) {
            return call_user_func(array($conf['general']['syntax_plugin'] . '_TextFormatter', 'render'),
                                  $text, $onlyfs, $type, $id, $instructions);

to

        if (@in_array('render', get_class_methods($conf['general']['syntax_plugin'] . '_TextFormatter'))) {
            return call_user_func(array($conf['general']['syntax_plugin'] . '_TextFormatter', 'render'),
                                  $text, $type, $id, $instructions);

I temporarily made the change and didn't notice any problems. I was forced to revert to an older version because of #18, so I can't do any further testing.

wrong use of global variable

In the file includes/utf8.inc.php
The array $UTF8_ALPHA_CHARS is declared and used in the function below.
The problem is, when after the file is required_once somewhere else, the array does not exist any more. This function would make any new created user to have an empty user name, and would block any new user to be created next.
It is strange that this never happened before. Might be revealed by some changes elsewhere recently.
We need to declare the array like this:
global $UTF8_ALPHA_CHARS;
$UTF8_ALPHA_CHARS = array(....);

Address in mailbox given [] does not comply with RFC 2822, 3.6.2.

If i try to leave a Comment or an Update and have other User to notificate, this error will appear: "Completely unexpected exception: Address in mailbox given [] does not comply with RFC 2822, 3.6.2. This should never happend, please inform Flyspray Developers"

how to view all items by default

currently only "open" items are shown by default. I would like to have a setting that shows all, irrespective of open/closed status.

Declaration of cache_instructions::retrieveCache() should be compatible with cache::retrieveCache($clean = true)

When running under PHP 5.4.20, I get the following error (which refers to plugins/dokuwiki/inc/cache.php):

Strict Standards: Declaration of cache_instructions::retrieveCache() should be compatible with cache::retrieveCache($clean = true)

The fix is changing (line 283)

  function retrieveCache() {

to the following:

  function retrieveCache($clean=true) {

php notice when viewing comments

when I look comments for task
I see php Notice

Notice: Undefined index: tasklist_type in /home/web/public_html/includes/class.tpl.php(128) : eval()'d code on line 85 Notice: Undefined index: tasklist_type in /home/web/public_html/includes/class.tpl.php(128) : eval()'d code on line 90

oauth third party vendor bug?

I was just testing the oauth stuff with github oauth..

Lol, I fixed an occurring error message by renaming that file

vendor/league/oauth2-client/src/Grant>cp AuthorizationCode.php Authorizationcode.php

So this seems to be a third party bug?

A quick workaround could be
in scripts/oauth.php line92

$token = $obj->getAccessToken('authorization_code', array('code' => $_GET['code']));

$token = $obj->getAccessToken('authorization_Code', array('code' => $_GET['code']));

but what if the League\Oauth2 updates their code?

I have no experience with oauth or composer stuff, so could someone please check the best way to fix it?

Upgrade 0.9.9.7 to 1.0 dev

Hi

Today I downloaded the ZIP from github to upgrade our Flyspray and I encountered this issues :

1/ Launching setup/upgrade.php returns :
Parse error: syntax error, unexpected ';' in /data/www/flyspray/themes/CleanFS/templates/admin.prefs.tpl on line 150

I added the missing parenthesis, here is the new line 150 :

2/ First time I tried to create a new task, I got multiples errors of missing fields (view_effort, track_effort, supertask_id, list_order, etc...) :
After a fiew search I replaced setup/upgrade/1.0/upgrade.xml by setup/upgrade/1.0/flyspray-install.xml and it solved

Hore it helps.
Nicolas

Install doesn't create admin user

Hello there,

I've cloned the repo today and proceeded to the install process, but when it finished, it didn't create the admin user specified. I can confirm there isn't any user created on flayspray_users table.

Tried to add the user manually inserting a record on the db, resetting the password, enabling the account, but it didn't worked. It keeps telling me "That user does not exist on this Flyspray installation".

not working preview button at index.php?do=admin&area=prefs

got no content back from callbacks/getpreview.php

and a 404 Not Found - themes/CleanFS/ajax_load.gif

Both no big problems, can also be fixed later...

IDEA: Flyspray in Node.js

Hey Guys,

I would just like to get everyones opinion and or interest in creating a node.js clone of Flyspray.

The project would keep the same philosophy and core concepts and then fix some of the set backs in our current Flyspray.

Then we would maintain the Flyspray 0.x branch as PHP and the Flyspray 2.x branch as Node?

Otherwise I was going to spin up another bug tracker project and clone node in Flyspray but I would sure like to see it get some love.

Personally, our department is moving away from any PHP apps and looking for alternatives in all departments.

Let me know guys!

Thanks

tasklist - task count

Is it possible to view more then 10 tasks per page in the tasklist? Maybe this can be solved editing the theme?

demo.flyspray.org not available

I would like to test out flyspray without setting up an instance. That what your demo installation is for but demo.flyspray.org is currently down :(

Upgrade didn't create "user_emails" table.

I upgraded from 0.9.9.7 to the latest code in the master branch as of 2014-01-01 (latest commit: 1e84126). I did not encounter any error messages during the upgrade.

Aside from a few PHP warnings, the pages appeared fine. However, when I tried to log in, I got the following error:

Query {SELECT id FROM `flyspray_user_emails` WHERE email_address = ?} with params {} Failed! (Table 'myflyspray.flyspray_user_emails' doesn't exist)

I checked in MySQL, and the table certainly doesn't exist.

The server is running PHP Version 5.4.20.

Non-ascii characters in new tasks leads to error

I have tried to report a task in my flyspray install which included some strange (utf-8) chars in the description, they are from my terminal prompt, which looks like this:

~ ❯❯❯ howdy
zsh: command not found: howdy
~ ❯❯❯

Then when i pick to create task and it triggers me an error in flyspray, like a creating-table debug entry, then I returned back, removed those special ">>>" chars and tried again which worked

So is there a bug that is unable to use utf-8 characters ? (which is very common in language characters)

Thanks

Eval

Do not use eval. Do not use undefined indexes. When developing enable notices.

Notice: Undefined index: tasklist_type in /x/includes/class.tpl.php(128) : eval()'d code on line 85 Notice: Undefined index: tasklist_type in /x/includes/class.tpl.php(128) : eval()'d code on line 90

Admin user created, but not allowe to login

New installation of 0.9.9.7 on OSX running XAMPP

Was able to create admin user. I used the suggested password.
Tried to login after successful installation and got the message:
"That user does not exist on this Flyspray Installation"

repeatable 3xs

Reinstalled and noticed some messages in the pre-installation check

Library Status
PHP >= 5.2.0 Yes
XML Extension Strict Standards: Non-static method Setup::ReturnStatus() should not be called statically, assuming $this from incompatible context in /Users/dandodd/PhpstormProjects/flyspray/includes/class.tpl.php(128) : eval()'d code on line 20 Yes
SAPI (apache2handler) Strict Standards: Non-static method Setup::ReturnStatus() should not be called statically, assuming $this from incompatible context in /Users/dandodd/PhpstormProjects/flyspray/includes/class.tpl.php(128) : eval()'d code on line 25 Supported
Database in PHP Flyspray

• MySQLi support Available Supported
• MySQL support Available Supported

next release after 0.9.9.7 ?

hello,
I see alot of merged PR's but can you tell when the next release is done and what version that will be ?

Make the csv export table fields respect the user permissions and fields choosable like for task list

At least the user permissions should be considered for 1.0 release so users without permissions for some fields can't workaround that by just exporting the issues list. :-)

Admin user not created after install

"That user does not exist on this Flyspray installation"

This happens after final step of install.

PHP 5.4.36-0+deb7u3 (fpm-fcgi) (built: Jan 9 2015 08:08:55)
Copyright (c) 1997-2014 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2014 Zend Technologies

nginx version: nginx/1.2.1
TLS SNI support enabled
configure arguments: --prefix=/etc/nginx --conf-path=/etc/nginx/nginx.conf --error-log-path=/var/log/nginx/error.log --http-client-body-temp-path=/var/lib/nginx/body --http-fastcgi-temp-path=/var/lib/nginx/fastcgi --http-log-path=/var/log/nginx/access.log --http-proxy-temp-path=/var/lib/nginx/proxy --http-scgi-temp-path=/var/lib/nginx/scgi --http-uwsgi-temp-path=/var/lib/nginx/uwsgi --lock-path=/var/lock/nginx.lock --pid-path=/var/run/nginx.pid --with-pcre-jit --with-debug --with-http_addition_module --with-http_dav_module --with-http_geoip_module --with-http_gzip_static_module --with-http_image_filter_module --with-http_realip_module --with-http_stub_status_module --with-http_ssl_module --with-http_sub_module --with-http_xslt_module --with-ipv6 --with-sha1=/usr/include/openssl --with-md5=/usr/include/openssl --with-mail --with-mail_ssl_module --add-module=/tmp/buildd/nginx-1.2.1/debian/modules/nginx-auth-pam --add-module=/tmp/buildd/nginx-1.2.1/debian/modules/nginx-echo --add-module=/tmp/buildd/nginx-1.2.1/debian/modules/nginx-upstream-fair --add-module=/tmp/buildd/nginx-1.2.1/debian/modules/nginx-dav-ext-module

Debian GNU/Linux 7 (wheezy)

Composer installed and installer ran, valid mysql credentials

PHP Issue with ShortTags

Reported by @nicohell in #68
The issues of shortcut tags are greater then the benefits, I found some shorcurt tags:

grep -r '"></ td>

themes/CleanFS/templates/index.tpl:381: < tr id="task" class="severity" onmouseover="Show(this,)" onmouseout="Hide(this, )">

themes/CleanFS/templates/index.tpl:403:< div id="desc_" class="descbox box">

I'm going to do a fix by my self now.

Advanced Search Does not show Task Properties

Hi,

Advanced Search does not work correctly, So it is not possible to search for closed tasks.

The Task Properties do not load correctly

Working Search on 0.9.9.7 using CleanFS Theme:

Not working search on V1.0Dev using CleanFS theme:

Versions:
flyspray: latest from github
php: 5.5.18 (Tried 5.3.29 had the same effect)
apache: 2.2.27

Bring back dokuwiki formatting.

1.0 broke it. Ok, I already opened a new branch restore_dokuwiki_formatting on my development machine and will start working on it. Might as well upgrade dokuwiki plugin itself.

hebCleanFS

This is the second theme... In my opinion, it should be dropped for 1.0 release... It wasn't maintained at all and needs complete rewrite.

I think we should focus on one theme only. After that, maybe we could consider an easy api to let people dev and propose themes for Flyspray, for free, on our webpage, bit like phpmyadmin is doing.

Any comment?

deletion of a comment at details page

If you want delete a comment without an attachment, there is no need for warning about deletion of attachments of this comment.

create REST API

Create REST API layer, so I could create Android client. Actually I could do the REST, but I don't have time :)

I don't have time to create Android client either, but mentioning both is a good start.

Thanks,

Effort tracking

It seems that both I and peterdd have been working on effort tracking on slightly different viewpoints. Let's have a discussion what we want to actually implement.

What I really need to have is to change estimated effort from hours to seconds, like actual effort. An hour is too coarse-grained for really small tasks. I and Peterdd seem to agree that 24 hours != 1 day. I used only hours:minutes for the display form, peterdd implemented manday (8 hours == manday). I'm fine with that too, although in theory I think that manhours have in reality almost nothing to do with any kind of days. The editable form, in my opinion, should always be H+(:mm)? to be easily parseable.

My suggestion:

• we come up with a resolution of what we implement
• peterdd makes a pull request, he's got a lot of other important things too to merge
• after that, I do a merge, fix the resulting mess and implement what we agreed upon, I've got time and there's nothing else that I see really important for 1.0

Flyspray 1.0

Hi all!

After discussing with Jordan, I think it's slowly time to speak about a 1.0 release... It is needed. 1.0 release is not the release that will revolution the world, but will be the revival release! 1.0 has been announced since 2012 and for reasons we all do understand never came out.

So the plan is for now (if needed):

• Stabilize the sources
• Fix security issues
• Get quick and real ideas about that composer
• Fix graphical output
• Work on the documentation (help welcome)
• Think of a real website, with a place for users to share together. (I have hosting plans available if you want). We are actually discussing in 3 places: Here, wikia, and Google groups... Not ok imo.

I think that, letting peterdd and Jouni finish their work is a good idea and plan a complete feature freeze for march the 15th 2015 is a good idea.

For real time discussion add me on skype, i'll invite you in the FS group. Make sure to specify your dev nickname, as the group is dev only.

Upgrading from a previous version to current not possible

I am trying to upgrade from the last stable release: flyspray-0.9.9.7.zip to what is in github as of now on master. I get the following:

Warning: parse_ini_file(/var/www/flyspray/setup/upgrade/1.0/flyspray.conf.php): failed to open stream: No such file or directory in /var/www/flyspray/setup/upgrade.php on line 207 Warning: array_walk() expects parameter 1 to be array, boolean given in /var/www/flyspray/setup/upgrade.php on line 209

If you hit the upgrade button it says done, but wipes out the current config, and never updates the database.