Date: 10 May, 2006 - 12:28
After a long hiatus, product #2 - the dotProject/Mantis Integration is available for sponsorship and download...
dotProject - a web-based Project Management - which forms the core of most of CaseySoftware's operations now has integration with Mantis Bugtracker. This provides users of either system to completely monitor and manage all information associated with issues and tickets submitted via either system.
A demo of the system is available for review:
http://demo.caseysoftware.com/mantis/
http://demo.caseysoftware.com/dotproject-man/
using the credentials: admin / testtest
Initially, we considered implementing a completely different module with a completely distinct codebase, but opted instead to use the dotProject Module known as "Helpdesk" as the framework. It supports a pluggable backend which offers compatibility with the base Helpdesk structure, Eventum, and now Mantis. One of my personal goals is to continue these efforts and offer a simple interface to FogBugz, Cerberus, and other proprietary systems as customers request. I believe that this will continue to demonstrate the usefulness of these systems while simultaneously blurring the lines between them and giving everyone involved better information.
There are two known weaknesses in this current implementation:
* First, a project must be named identically between the two systems in order for matching to occur. This is quite simple to ensure and project names in either system can be changed quite quickly.
* Second, a user must have the same User id in each system. This implementation may be replaced with a lookup/cache model similar to that of the Domino Bridge.
If you're interested in participating in this sponsorship and wish to receive this module, simply procced to the Mantis / dotProject Integration and add it to your cart. All code - thouroughly tested with dotProject 2.0.x and Mantis 1.x - along with installation instructions is delivered within 24 hours. In this case, the two sets of tables are not required to be in the same database or even the same server as long as there is a mysql user who has permissions on both.
Please note:These demos should *not* be used to store sensitive and/or production information. All data is wiped and restored to a base state on a regular basis. This also means that if some fool decides to change the passwords or write offensive messages, don't worry about it and check back in a few hours.
Demo
Very interested in your product but would like to see a working demo. When I log into your system and click on Help Desk I receive a message stating that the help desk module is missing.
Error
This error is happening when, in demo, under "Opened today", I click on number "2".
ERROR: /home/caseydk/public_html/demo/dotproject-man/includes/db_adodb.php(62): Error 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 1 executing:
SELECT project_name, project_color_identifier, project_company AS item_company_id FROM projects where project_id=
Backtrace:
0 /home/caseydk/public_html/demo/dotproject-man/includes/db_adodb.php:62 dprint('/home/caseydk/public_html/demo/dotproject-man/includes/db_adodb.php',62,0,'Error 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 1 executing:
SELECT project_name, project_color_identifier, project_company AS item_company_id FROM projects where project_id=
')
1 /home/caseydk/public_html/demo/dotproject-man/includes/db_connect.php:134 db_exec('SELECT project_name, project_color_identifier, project_company AS item_company_id FROM projects where project_id=')
2 /home/caseydk/public_html/demo/dotproject-man/modules/helpdesk/view.php:27 db_loadlist('SELECT project_name, project_color_identifier, project_company AS item_company_id FROM projects where project_id=')
3 /home/caseydk/public_html/demo/dotproject-man/index.php:326 require('/home/caseydk/public_html/demo/dotproject-man/modules/helpdesk/view.php')
ERROR: /home/caseydk/public_html/demo/dotproject-man/includes/db_adodb.php(62): Error 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 1 executing:
SELECT company_name FROM companies where company_id=
Backtrace:
0 /home/caseydk/public_html/demo/dotproject-man/includes/db_adodb.php:62 dprint('/home/caseydk/public_html/demo/dotproject-man/includes/db_adodb.php',62,0,'Error 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 1 executing:
SELECT company_name FROM companies where company_id=
')
1 /home/caseydk/public_html/demo/dotproject-man/includes/db_connect.php:134 db_exec('SELECT company_name FROM companies where company_id=')
2 /home/caseydk/public_html/demo/dotproject-man/modules/helpdesk/view.php:33 db_loadlist('SELECT company_name FROM companies where company_id=')
3 /home/caseydk/public_html/demo/dotproject-man/index.php:326 require('/home/caseydk/public_html/demo/dotproject-man/modules/helpdesk/view.php')
Error - Resolved
Thank you for reporting this error. It had been reported once already and has been resolved.
The error itself was two-pronged. There was a single file out of date and a few rows of the database were missing from this deployment. The applicable fixes have been applied... so enjoy!
how it work?
Hi, I was very impressed while reading about the mantis-dotproject integration; We already use Mantis (1.0.3), and we would start using both to improve our project planning with customer reports; I've some questions:
- we have to change our current Mantis installation/DB?
- can we map current "Severity: feature" field in Mantis as "New Feature Request" in dotproject help-desk? this is very important, cause currently customers signal new feature requests by setting Severity in Mantis as "feature"; I tried to do that but in dotproject I see items as "Not Specified" type.
- Is the project stable? We would use to manage our project, not to play... ;-) While trying the demo I got an error in dotproject, and after the corresponding issue in Mantis disappeared; if I go directly to the issue number I got errors:
http://demo.caseysoftware.com/mantis/view.php?id=2
APPLICATION WARNING #403: Database field 'name' not found.
- what about upgrade? if dotproject or Mantis will upgrade systems, do you plan to release script/info on how to upgrade both platform?
- How many changes did you made to the mantis/dotproject sources? Are they just plugins (i.e. additional modules which do not modifiy the core) or patches?
tnx in advance,
Gino
Additional Information
Thanks for your interest. Here are some responses for you:
- No changes were made to either dotProject or Mantis. The code was developed via a dotProject Module and is entirely self-contained.
- The code is very stable. It has changed very little in 3 months.
- The only change you must implement is the addition of a table to your dotProject install.
- There is no plan to update the project indefinitely, but I'll look into it.
- Setting up a custom mapping (Feature -> New Feature Request) should be trivial.
- I have not been able to reproduce your error. The two databases are automatically wiped every few hours, so either a) this happened while you were using the system or b) this happened afterwards and now I can't duplicate it.
Missing Help Desk module
I can't see any of the bugs I enter in mantis through dotProject. When I go to Help Desk I get an error that the module is missing. I've tried this on a couple different days now but I always get the same error.
I am seeing the same error
I am seeing the same error
Post new comment