Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 05:02 pm EDT

Geeklog Forums

Geeklog/Mantis Bug Tracker Integration

Page navigation


Status: offline

vinny

Site Admin
Admin
Registered: 06/24/02
Posts: 352
Location:Colorado, USA
I have just finished up integrating Mantis Bug Tracker (0.18.1) with Geeklog (1.3.8). You can get the current release from the gplugs sourceforge site. You can see mantis in use on this site or check it out on the test server (where anonymous users have developer access to the Test Project).

-Vinny
 Quote

Status: offline

jnordquist

Forum User
Full Member
Registered: 03/14/03
Posts: 129
Location:Kenosha
I tried to install Mantis, but the database won't go. I get the error:



#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 'title varchar(250) NOT NULL default ' ', description varchar

Any ideas? The line looks fine to me.

John Nordquist,
Applications Specialist, medical Technologies
 Quote

Status: offline

vinny

Site Admin
Admin
Registered: 06/24/02
Posts: 352
Location:Colorado, USA
I'm afraid I won't be able to take a look at this until sometime next week. Could someone else take a look at the SQL in question and see if there is anything wrong with it? Usually with MySQL the problem is with the line before the one quoted in the error statement (missing comma, bad syntax, etc).

I didn't have any problem installing the tables on my two test machines.

Thanks,
Vinny
 Quote

Status: offline

Clumber

Forum User
Newbie
Registered: 02/12/04
Posts: 2
I ran into the same thing... looks like a line or 2 got cut out of the sql commands. I grabbed the mantis-0.18.1 tarball and used the one from there and that worked fine. I also grabbed the doc directory from the mantis-0.18.1 tarball too, as that was not in the plugin tar.

One other problem I ran into was that I did a cut and paste from the README for the stuff to put into all the theme header.thtml files and in there the closing tag is "sytle" and "style" was required.
 Quote

remy

Anonymous
Quote by vinny: I'm afraid I won't be able to take a look at this until sometime next week. Could someone else take a look at the SQL in question and see if there is anything wrong with it? Usually with MySQL the problem is with the line before the one quoted in the error statement (missing comma, bad syntax, etc).


The CREATE line is missing.
 Quote

Status: offline

vinny

Site Admin
Admin
Registered: 06/24/02
Posts: 352
Location:Colorado, USA
Thanks everyone. I'll have this fixed and a new release available Sunday night or sometime Monday.

-Vinny
 Quote

Status: offline

vinny

Site Admin
Admin
Registered: 06/24/02
Posts: 352
Location:Colorado, USA
OK. I have a "r2" version of the integration with the previously mentioned problems fixed. Notice that this version will work with Geeklog 1.3.9rc1 (and likely 1.3.9).

Downloads of the new release are still available at gplugs.

-Vinny
 Quote

Jim Phelps

Anonymous
curious
Hi There,

I have a few questions about Mantis -
(1) Do the Projects align with Topics (e.g., if I have a topic "Cool stuff" is there a corresponding project in Mantis "Cool Stuff&quotWink?
(2) How are the rights to add issues, edit issues et al managed - through the same user group rights management interface as in Geeklog?
(3) How fine grained are the rights for Mantis? Are they Project specific (Bob can add issues to project X but not see project Y)?
 Quote

Status: offline

vinny

Site Admin
Admin
Registered: 06/24/02
Posts: 352
Location:Colorado, USA
1) No

2) For global rights (aka to assign rights to all projects) you can create groups like "Mantis Admin", "Mantis Developer", etc within Geeklog. This is currently an undocumented feature. You can get more info on the group names you must use by looking at the code in core/user_api.php.

3) First you can set global default access by editing the config_inc.php file. This is delivered as REPORTER (see the following code):
Text Formatted Code

$g_user_default_level   = REPORTER;

 

As an admin or project maintainer you can go to "Manage Projects" page and assign users rights to particular projects. This overrides the global rights they have (unless they are a global admin).

-Vinny
 Quote

Status: offline

Clumber

Forum User
Newbie
Registered: 02/12/04
Posts: 2
Is there any way to go directly to one of the projects? I'd like to have a front page geeklog menu to go to project X or Y at the click of a menu item.

Andy Pierce
 Quote

Status: offline

vinny

Site Admin
Admin
Registered: 06/24/02
Posts: 352
Location:Colorado, USA
I talked to the mantis "guys" on IRC (irc.freenode.net, #mantishelp) and they suggest:

http://yoursite.com/mantis/set_project.php?project_id=X&ref=view_all_bug_page.php

Where X is the project you want displayed.

-Vinny
 Quote

Jaguthin

Anonymous
Seems like a decent system. I seem to be having one problem, though. How do I reassign to another person? Only Admin shows up in the dropdown list. I've added another user and given him Developer rights but can't assign bugs to him.

Any thoughts?

 Quote

Status: offline

vinny

Site Admin
Admin
Registered: 06/24/02
Posts: 352
Location:Colorado, USA
Jaguthin, I haven't seen this problem. Could you email me a link to your site so that I can see it?

Thanks,
Vinny
 Quote

Status: offline

Euan

Forum User
Full Member
Registered: 04/22/02
Posts: 292
I've noticed this too. The only users that appear in the dropdown for being assigned tasks are root users, as far as i can tell. If you have no other root users, then there will be no other names to assign to.

I would imagine a nice improvement would be a Mantis Admin group?

Cheers,

Euan.
-- Heather Engineering
-- No job too small
 Quote

Jaguthin

Anonymous
Vinny,

I actually figured this out. The specifics elude me at the moment, but I think it had to do with creating the corresponding groups in geeklog and adding the users to those groups.

Thanks,

Jag
 Quote

Status: offline

vinny

Site Admin
Admin
Registered: 06/24/02
Posts: 352
Location:Colorado, USA
Jaguthin, any chance you can describe this a bit more clearly? Have you made code changes to fix the problem (showing those would be the best explanation )

Thanks,
Vinny
 Quote

Status: offline

rav

Forum User
Chatty
Registered: 01/14/03
Posts: 37
Fatal error: Call to undefined function: com_mail() in /home/cubsjvjb/public_html/mantis/core/email_api.php on line 686

When ever I create or modify a bug report - I get the above message. Did I miss something in the install?
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by rav: Fatal error: Call to undefined function: com_mail()

Are you running Geeklog 1.3.9?

bye, Dirk
 Quote

Status: offline

rav

Forum User
Chatty
Registered: 01/14/03
Posts: 37
1.3.8-1sr2
 Quote

Status: offline

vinny

Site Admin
Admin
Registered: 06/24/02
Posts: 352
Location:Colorado, USA
COM_mail doesn't exist in 1.3.8sr2. You need to upgrade to 1.3.9 for the Mantis integration to work without code changes (hence the name: mantis_0.18.2_1.3.9).

Your other option is to edit email_api.php and replace COM_mail() with mail().

-Vinny
 Quote

Page navigation

All times are EDT. The time is now 05:02 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content