Geeklog Forums

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

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

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

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.

The CREATE line is missing.

Thanks everyone. I'll have this fixed and a new release available Sunday night or sometime Monday.

-Vinny

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

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&quot?
(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)?

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):

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

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

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

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?

Jaguthin, I haven't seen this problem. Could you email me a link to your site so that I can see it?

Thanks,
Vinny

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

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

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

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?

Are you running Geeklog 1.3.9?

bye, Dirk

1.3.8-1sr2

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