Mantis - ISSUES

0001053: Todo - Filter by project

I wish I could filter the project tasks from the All option. Currently showing all tasks and tasks are not ordered by projects.

excuses for my English.

0001052: User roles in System Admin not available in SVN build from 2012.01.23

When select "User roles" from "Administration" section at "System Administration" page no role management tools are shown. See attached screenshot.

0001051: My Info does not work with latest snapshot

I have installed latest snapshots (23.01.2012) and My Info page does not work.
I have tried with more users (including admin user), in different browsers.

0000947: LDAP authentication fails if the BINDDN is given as a complete DN

We have a bug in the LDAP code. Edit web2project-2.4/classes/w2p/Authenticators/LDAP.class.php by changing line 53 from:
$ldap_bind_dn = 'CN='.$this->ldap_search_user.',OU=users,'.$this->base_dn;
to:
$ldap_bind_dn = $this->ldap_search_user;

I don't know if that is the proper fixed but it worked well enough for us to be able to get our work done. It looks like the logic assumes we are using an MS Active Directory server and that we have only supplied a short name. In our case, we are using RedHat Directory Server and we provide the complete DN of the ldap_search_user.

0001050: LDAP does not update user passwords

When using LDAP, the passwords in the database do not get updated. This became an issue as the DPDesktop plugin looks in the database for authentication. While the DPDesktop plugin should probably be changed to use regular w2p auth structures, there is code in the W2P LDAP module to update the password hashes in the database. This functionality is broken in 2.4.

0001049: Task Overdue Notification cannot be turned off

We are on 2.3.1.
We receive many notifications of overdue tasks. We want to stop this.
We are not using queuescanner, instead we are mailing directly.

We tried to turn off task notification like so:
Go to "System Admin -> System Configuration", scroll down to the "Tasks" section and set the following values:

Send Task Reminders (SET TO BLANK)
Number of days warning for due tasks (SET TO 1)
Maximum number of reminders to set (SET TO 1)

Apache was restarted afterwards, but the task notifications are STILL coming. We received 30-40 of these per day, per person. We are a very small shop, but this is very disruptive. Please help.

0001048: View User Not Working

View User page does not show anything. Here's the error in the log:

PHP Fatal error: Call to undefined method CUser::_getQuery() in /web2project/modules/admin/admin.class.php on line 194, referer: /web2project/index.php?m=admin

my admin.class.php file is the latest version on SVN (2011-11)

0001044: Task Logs not available when task has child task

I changed a task with 10 tasklog entries to a subtask of another task, and logs are no longer visible, editable, etc.

0001047: Project actual end date in project view is not displayed + FIX

$criticaltasks is not defined, thus date is empty.
fix see http://forums.web2project.net/viewtopic.php?p=14269#14269 [^]

0001046: allow new budget section in projects and tasks to be hidden

On a notebook, the new budget section in projects and tasks takes much screen space. Please add sysconfig to hide it when w2p budgeting is not used.
Thanks, Klaus

0001045: Name of user is not showed on posted reply on forum

On read the forum don't are listed the name of user on the post.

0001042: Fatal error when deleting budget item

At rev 2347
Attempting to delete a Budget entry
Page http://192.168.1.10/web2dev/index.php?m=system&a=budgeting [^]
Fatal error: Call to a member function getLibraryClass() on a non-object in /opt/web2dev/classes/w2p/Extensions/Permissions.class.php on line 7

w2p will now not restart.
Restarted Apache - still no response (same message Fatal error: Call to a member function getLibraryClass() on a non-object in /opt/web2dev/classes/w2p/Extensions/Permissions.class.php on line 7 )

Suspect issues with mods to BaseObject class (rev 2346) or Permissions class (rev 2347)

0000950: Unable to assign user through "Edit task" form

In the "Edit task" form, when clicking on human resources tab I see only one blank entry and one user listed in the "Human Resources:" box, although I have 4 users created via User Admin. However assigning a user through the "Tasks" view allows to properly select from existing users. Could be something broken with the "Human Resources" list. Cant remember having this problem in W2P 2.2.

Steps to reproduce:
I've installed a fresh 2.4 version. Added several companies, 4 users, 2 projects and one task per project.

PHP 5.2.17
MySQL 5.0.84
Apache/2.2.19 (Unix)

0001043: Files won't move between folders

I've tried to move files in root to a subfolder using checkboxes and the "move to folder" selection at the bottom and they never move. I have tried this with single files as well as multiple selections.

0001040: SQL errors on removal of module

Running latest svn version 2297 under Ubuntu 10.04LTS 64 bit.
Uninstalled Todos module & error text resulted as:

"ERROR: /opt/web2dev/classes/w2p/Database/Query.class.php(1128) : query failed(SELECT a.value AS a_value, a.name AS a_name,
b.value AS b_value, b.name AS b_name,
c.value AS c_value, c.name AS c_name,
d.value AS d_value, d.name AS d_name,
e.value AS e_value, e.name AS e_name,
f.value AS f_value, f.name AS f_name
,DISTINCT(g.aro_id) FROM ((`gacl_aco_sections` AS a,`gacl_groups_aro_map` AS g)) LEFT JOIN `gacl_aco` AS b ON a.value=b.section_value,gacl_aro_sections c LEFT JOIN `gacl_aro` AS d ON c.value=d.section_value,gacl_axo_sections e LEFT JOIN `gacl_axo` AS f ON e.value=f.section_value) - error was: 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 'DISTINCT(g.aro_id) FROM ((`gacl_aco_sections` AS a,`gacl_groups_aro_map` AS g)) ' at line 7
Backtrace:
0 /opt/web2dev/classes/w2p/Database/Query.class.php:1128 dprint()
1 /opt/web2dev/classes/w2p/Database/Query.class.php:1193 exec()
2 /opt/web2dev/classes/w2p/Extensions/Permissions.class.php:556 loadHashList()
3 /opt/web2dev/classes/w2p/Extensions/Permissions.class.php:1020 getUsersWithRole()
4 /opt/web2dev/classes/w2p/Extensions/Permissions.class.php:282 recalcPermissions()
5 /opt/web2dev/classes/w2p/Core/Module.class.php:106 deleteModuleItems()
6 /opt/web2dev/modules/system/domodsql.php:79 remove()
7 /opt/web2dev/index.php:277 require()
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 'DISTINCT(g.aro_id) FROM ((`gacl_aco_sections` AS a,`gacl_groups_aro_map` AS g)) ' at line 7"
Using Back button on browser shows that module was removed.

Reinstalling the module gives another error page:

"Warning: array_keys() expects parameter 1 to be array, boolean given in /opt/web2dev/classes/w2p/Extensions/Permissions.class.php on line 1021 Warning: implode(): Invalid arguments passed in /opt/web2dev/classes/w2p/Extensions/Permissions.class.php on line 1021

ERROR: /opt/web2dev/classes/w2p/Database/Query.class.php(1128) : query failed(SELECT a.value AS a_value, a.name AS a_name,
b.value AS b_value, b.name AS b_name,
c.value AS c_value, c.name AS c_name,
d.value AS d_value, d.name AS d_name,
e.value AS e_value, e.name AS e_name,
f.value AS f_value, f.name AS f_name
,DISTINCT(g.aro_id) FROM ((`gacl_aco_sections` AS a,`gacl_groups_aro_map` AS g)) LEFT JOIN `gacl_aco` AS b ON a.value=b.section_value,gacl_aro_sections c LEFT JOIN `gacl_aro` AS d ON c.value=d.section_value,gacl_axo_sections e LEFT JOIN `gacl_axo` AS f ON e.value=f.section_value) - error was: 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 'DISTINCT(g.aro_id) FROM ((`gacl_aco_sections` AS a,`gacl_groups_aro_map` AS g)) ' at line 7
Backtrace:
0 /opt/web2dev/classes/w2p/Database/Query.class.php:1128 dprint()
1 /opt/web2dev/classes/w2p/Database/Query.class.php:1193 exec()
2 /opt/web2dev/classes/w2p/Extensions/Permissions.class.php:556 loadHashList()
3 /opt/web2dev/classes/w2p/Extensions/Permissions.class.php:1020 getUsersWithRole()
4 /opt/web2dev/classes/w2p/Extensions/Permissions.class.php:178 recalcPermissions()
5 /opt/web2dev/classes/w2p/Core/Module.class.php:65 addModuleSection()
6 /opt/web2dev/modules/system/domodsql.php:72 install()
7 /opt/web2dev/index.php:277 require()
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 'DISTINCT(g.aro_id) FROM ((`gacl_aco_sections` AS a,`gacl_groups_aro_map` AS g)) ' at line 7"

0001041: Setup budgets - no del;ete available

Under System Admin/ Setup Budgets, you can create an entry but the edit feature a/ doesn't edit the entry but creates another on save and;
b/ there's no provision for deleting an entry

0000598: adodb-mysql does not set default character set for db connection, this can lead in unusable database content

Hi,
adodb-mysql.inc.php functions _connect() and _pconnect() do not set default character set for database connections nor does web2project code elsewhere.

This results in wrong encoding of non-ascii strings stored in database depending on host configuration - to be specific if system wide mysql default_character_set differs from utf8, i.e. debian's default value is 'latin1'.

Wrong character encoding has at least following critical consequences:

* Sorting of strings with non-ascii charactes does probably not work correctly.
* Strings will be totaly messed up if mysql's default_character_set will be changed or database will be migrated to host with different configuration.

Adding mysql_set_charset('utf8') call to both mentioned functions or setting this later from web2Project code (if adodb modification is not an option) will solve this. This solution will have a side effect of messing up strings already stored in wrong encoding.

0000760: Currency appends EEK after GB pound symbol selected

If you select a currency symbol (£ in my case) there isn't an appropriate currency format in preferences. EUR formats append a suffix (e.g EEK - estonian Kroons) after the budget figure. Thus £1000.00 EEK

I commented out the line:

$currency .= $currency_prefix . $mondat['int_curr_symbol'] . $currency_suffix;

in \includes\main_functions.php around line 1002 to get the format I wanted.

I have noticed also however, that doing this changes the drop down list of currency formats in Sysadmin->default user preferences.

Can't say I understand what is going on but what is wanted is the option:

a) specify currency symbol
b) select a currency format that doesn't include suffix or prefix

0000963: Subproject icon does no appear when multi-subproject context is set

The "plus" icon that indicates a project with subprojects is missing when we use a multi-subproject context.
In my organization we have a root project that means the current portfolio. This project contains programs (a collection of projects) or projects). When we need to create a program (second hierarchical level) attached to portfolio (first hierarchical level), and from this program we insert many projects (as subproject), this program does not shows subproject plus icon. If we detach the program from de portfolio, the subproject icon is shown.
My suggestion is that could be possible to set an endless level of hierarchy of projects.

0000745: New project creation error , child project not visible in list of project

1) When a new project is created and any of budget field remains empty, project is not stored correctly. An error message "incorrect decimal value: '' for column 'project_target_budget' at row 1" is shown.

2) If a new project is created with parent project created with error message mentioned above, then child project is not shown anywhere in list of project

0000932: Binding LDAP with a null DN string

There is no way to configure a null DN binding string.

Code 2.4 LDAP.class.php does not consider that case.
No way (?) to set it in "Full LDAP Connect String" field

0000967: Files in the projects_tab.view.files.php view does not display files deeper then the first level in the folder tree

The company i work for wants to use a rather explicit folder structure to organize files and because of that all files belonging to a project is placed in its own sub-folder within a more general folder called projects.

This is causing issues with the files view in the projects module, as it looks like no files are attached in the folder structure. See attached file.

I would like it to be possible to traverse the folder structure and have a clear method of seeing where the files belonging to this project are placed, much like how the file explorer works.

0000993: If more than one file is uploaded for a project only the last uploaded file is displayed as to be attached to the project.

When a file is uploaded for a project, the first file works as expected, however from the second file onwards only the last file uploaded is displayed as file attachment in the system.

0001024: bug description & suggested solution

http://forums.web2project.net/viewtopic.php?p=13827#13827 [^]

@pedroa:
@opto:

Thanks opto, I installed XAMPP for Win on my VISTA-PC and started to debug the php-code with Netbeans & Xdebug. Very nice & so simpel. I would recommend for anyone to do it. If I can do (no clue about servers, php and so on) probably anybody can do it too....

As I already evaluated in the posts before the error is caused by a really stupid syntax bug!

Enclosed I put also the "gantt_pdf.php" where I marked and commented the problem & solution.

The slicing works for the tasks (25x) but I kept the time-x-axis constant, so I dont know this is the expected behaviour. Otherwise the date-range on each slice has to be handled.

I would suggest that the developers take this as a suggestion, reviewing it and rework it where necessary and put it to SVN.

@pedroa:
Could you please additionally post the bug that the time-range can not be adjusted by the start/end-Tabs in the top of the view? It would be nice to adjust the time scale as already for the gantt-view possible! Thanks.

---------------------------------------------------------------------------
Change the following in gantt_pdf.php:

// set here any date span you want: bug work around!
$start_date = '2012-03-01 00:00:00' ;
$end_date = '2012-05-01 00:00:00' ;

/* --------------------------------------------------------- */
// initial store String variables $start_date & $end_date !!!
/* --------------------------------------------------------- */
$start_date2 = $start_date;
$end_date2 = $end_date;

/* --------------------------------------------------------- */
// 1. loop handling the number of sliced sub-projects, each having 25/26 tasks
/* --------------------------------------------------------- */
foreach ($gtask_sliced as $gts) {

/* --------------------------------------------------------- */
// always restore String variables $start_date & $end_date !!!
/* --------------------------------------------------------- */
$start_date = $start_date2;
$end_date = $end_date2;
/* --------------------------------------------------------- */
//
// during slicing(), if more than 25 tasks !, the variables $start_date & $end_date are re-assigned to an object...
// and also re-used in an another context.
//
// ---> in 2. loop: for($i = 0; $i ... count($gts); $i ++) {...
// ---> re-assign & re-use:
//
// $start_date = new w2p_Utilities_Date($a['task_start_date']);
// $end_date = new w2p_Utilities_Date($a['task_end_date']);
//
// causing:
// "strpos() expects parameter 1 to be string, object given in /var/customers/.../web2project-3.0/lib/jpgraph/src/jpgraph_gantt.php on line 524"
/* --------------------------------------------------------- */
---------------------------------------------------------------------------

Please notice also the other bug-report/solution for:

"JpGraph Error General PHP error : Undefined variable: criticalTasks"

http://forums.web2project.net/viewtopic.php?p=13826#13826 [^]

roger & out.

0001029: New features added

Hi!
Added new fetaures, check this out.

-added hierarchy, you can tick a task, then move up and down, you can outdent and indent these tasks also - just click on the arrows,
-autonumbering feature, now when you build your chart, it all numbered.
-finally, when you change the date of the task it is not changing it's positions, it sits there