Tuesday, 2010-02-23

*** Joins: davidinc (~d5374b1e@gateway/web/freenode/x-yfqvmyfycejdxpby)00:49
*** Joins: mantisbot (~supybot@81-174-26-126.static.ngi.it)01:18
*** Quits: mantisbot (~supybot@81-174-26-126.static.ngi.it) (Ping timeout: 245 seconds)01:26
*** Quits: davidinc (~d5374b1e@gateway/web/freenode/x-yfqvmyfycejdxpby) (Ping timeout: 252 seconds)02:10
*** Joins: mantisbot (~supybot@81-174-26-126.static.ngi.it)02:19
*** Joins: giallu (~giallu@fedora/giallu)02:20
*** Quits: giallu (~giallu@fedora/giallu) (Remote host closed the connection)02:21
*** Joins: giallu_ (~giallu@fedora/giallu)02:21
*** Quits: mantisbot (~supybot@81-174-26-126.static.ngi.it) (Ping timeout: 265 seconds)02:27
*** Joins: davidinc (~d5374b1e@gateway/web/freenode/x-sbpwgejoldytzxrb)02:32
*** Quits: siebrand (~beis@sm.xs4all.nl) ()02:49
*** Quits: giallu_ (~giallu@fedora/giallu) (Quit: Leaving)02:52
*** Joins: giallu (~giallu@fedora/giallu)03:31
*** Quits: davidinc (~d5374b1e@gateway/web/freenode/x-sbpwgejoldytzxrb) (Quit: Page closed)03:42
*** Joins: rolfkleef (~rolf@urtica.xs4all.nl)03:43
*** Joins: mantisbot (~supybot@81-174-26-126.static.ngi.it)03:57
*** Quits: mantisbot (~supybot@81-174-26-126.static.ngi.it) (Ping timeout: 246 seconds)04:05
*** Joins: jotango (~57993c0d@gateway/web/freenode/x-atwdlclvbxhttwux)04:48
jotangohello, I have an issue with mantis 1.2.0 it may be corrupting tables04:49
jotangofollowing an upgrade from RC2 the table mantis_project_user_list_table is empty04:49
jotangoWhen I try to add developers to projects, I get an SQL error04:50
jotangoDatabase query failed. Error received from database was #1194: Table 'u' is marked as crashed and should be repaired for the query: SELECT DISTINCT p.id, p.name, p.view_state, u.access_level FROM mantis_project_table p LEFT JOIN mantis_project_user_list_table u ON p.id=u.project_id WHERE p.enabled = '1' AND u.user_id=? ORDER BY p.name.04:50
jotangoif I run repair table in mysql I can do selects and see an empty table04:50
jotangowhen I try to add the developers, same error occurs04:51
jotangoany ideas?04:51
jotangoChecking MyISAM file: /var/lib/mysql_data/mysql/mantis/mantis_project_user_list_table.MYI Data records:       2   Deleted blocks:       0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check data record references index: 3 - check data record references index: 4 - check data record references index:04:55
jotangorunning with -r fixes the problem, then same error04:55
paul__sounds like a mysql issue..05:17
*** Joins: mantisbot (~supybot@81-174-26-126.static.ngi.it)05:35
*** Quits: mantisbot (~supybot@81-174-26-126.static.ngi.it) (Ping timeout: 268 seconds)05:43
*** Quits: rolfkleef (~rolf@urtica.xs4all.nl) (Ping timeout: 265 seconds)05:45
*** Joins: fanno (~Morten@90.184.93.233)05:49
*** Joins: rolfkleef (~rolf@82-204-82-162.fttx.bbeyond.nl)06:03
jotangoI converted the table to InnoDB, stopped the problem. But not really a solution.06:05
*** Quits: jotango (~57993c0d@gateway/web/freenode/x-atwdlclvbxhttwux) (Quit: Page closed)06:08
*** Joins: davidinc (~d5374b1e@gateway/web/freenode/x-phtsoyctdabjztoa)06:15
*** Joins: HVittel (~none@host213-123-251-181.in-addr.btopenworld.com)06:17
HVittelIs there any reason I would always receive the error Project "0" not found. when clicking "Manage Configuration" ?06:17
HVittelI am using v1.2.0. It was previously installed using apt-get but I upgraded it to a proper mantis installation awhile back.06:18
dhx_mHVittel: hi06:42
dhx_mHVittel: can you try setting show_detailed_errors=ON in config_inc to get a backtrace showing what file/line the error is from?06:42
HVitteldhx_m: sure one sec :)06:46
dhx_mHVittel: thanks06:46
HVittelAt /var/www/mantis/core/project_api.php at line 89, by the looks06:50
dhx_mok and can you also let me know what the next highest function in the backtrace is?06:51
dhx_mparticularly the next line from adm_config_report.php06:51
HVittel/var/www/mantis/core/project_api.php419--project_cache_row( <string>'20' )06:52
HVittelArg. That copy/pasted a little worse than I anticipated. :)06:52
dhx_mit makes sense :)06:52
dhx_mbut I only got one line06:52
HVittel/var/www/mantis/core/project_api.php429--project_get_row( <string>'20' )06:53
HVittel/var/www/mantis/core/project_api.php446--project_get_field( <string>'20', <string>'name' )06:53
HVittel/var/www/mantis/adm_config_report.php139--project_get_name( <string>'20' )06:53
dhx_maha thanks06:53
HVittelIn case it is important, I get the same problem even if I choose a specific project or if I select all projects.06:54
HVittelI think it may be connected to the apt-get version of mantis we had installed, as it apparently had some issues and was a bit of a pain to upgrade. :)06:54
dhx_mI can't see any reason why it'd be broken from the source code06:54
dhx_mto explain what happens:06:55
dhx_mproject_get_name( 0 ) is called06:55
dhx_mwhere 0 is the project ID06:55
dhx_mMantis uses the project ID of 0 to refer to ALL_PROJECTS06:55
dhx_min core/constant_inc.php you should have a definition of 0 for ALL_PROJECTS06:55
dhx_m 442 function project_get_name( $p_project_id ) {06:55
dhx_m 443         if( ALL_PROJECTS == $p_project_id ) {06:55
dhx_m 444                 return lang_get( 'all_projects' );06:55
dhx_m 445         } else {06:55
dhx_m 446                 return project_get_field( $p_project_id, 'name' );06:55
dhx_m 447         }06:55
dhx_m 448 }06:55
dhx_mthus lang_get( 'all_projects' ) should be returned06:55
HVittelIt's 0. Seems fine.06:56
HVittelIt's rather bizarre.06:56
dhx_moh06:56
HVittelI've not changed the source code either.06:56
dhx_mit's actually sending project_get_name ( '20' )06:56
HVittelAny particularly reason that may occur?06:56
dhx_mI'm guessing project #20 no longer exists in your installation06:57
dhx_mso Mantis is trying to get the name of a non-existing project06:57
HVittelHow would I check? :)06:57
dhx_mhttp://localhost/mantis/manage_proj_edit_page.php?project_id=2006:58
HVittelAh. yea, we don't have a project 2006:58
HVittelWe've never even had close to a project 20, so it seems a little odd :)06:58
dhx_mdo:06:59
dhx_mSELECT config_id, project_id FROM mantis_config_table WHERE project_id=2007:00
* paul__ holds up hand07:00
paul__I know :)07:00
dhx_mshoosh :p07:00
paul__ok07:00
dhx_mactually, speak up :p07:01
paul__lets see what the db query returns07:01
paul__(as we need to know anyway)07:01
dhx_mHVittel: btw you've exposed a valid bug anyway, so I'll add it to the list of things to fix for 1.2.1 - thanks :)07:03
HVittelI shall check! (sorry, just had to fix a tech issue at work)07:04
dhx_mnp07:04
HVittel+------------------+------------+07:05
HVittel| config_id        | project_id |07:05
HVittel+------------------+------------+07:05
HVittel| database_version |         20 |07:05
HVittel+------------------+------------+07:05
dhx_moh :o07:05
dhx_mhave you had a lot of previous versions of Mantis installed?07:05
dhx_mdatabase_version shouldn't have an associated project_id07:06
dhx_mtherefore to fix the problem,07:06
HVittelI think it was 1.0807:06
dhx_m1.1.8 it would be07:06
HVittelI did run the upgrade scripts at least. :)07:06
dhx_mUPDATE mantis_config_table SET project_id=0 WHERE config_id="database_version";07:06
HVittelI know there was a paricular version of mantis available via apt-get which was never officially released, and somewhat broken.07:06
HVittelBut I can't remember which it was. I think we used to use that, but someone here helped with the upgrade process (some DB entry as incorrect preventing upgrading working properly).07:07
dhx_mhmm ok07:07
HVittelWhich may be the source of the problems :)  "Duplicate entry 'database_version-0-0' for key 1"!07:07
HVittelSo I guess I just nee to delete it.07:07
HVittelWhoo.07:08
HVittelIt finally works :)07:08
dhx_m:)07:08
HVittelThanks!07:08
dhx_myou still need one database_version entry though07:08
HVittelIt still appears to have one so that's cool. :)07:09
*** Joins: kirillka (~Miranda@155-211-36-78.baltnet.ru)07:09
dhx_mgreat07:10
HVittelThank you! :D07:10
*** Joins: mantisbot (~supybot@81-174-26-126.static.ngi.it)07:13
dhx_mno problems :)07:13
*** Quits: mantisbot (~supybot@81-174-26-126.static.ngi.it) (Ping timeout: 256 seconds)07:19
kirillkadhx_m: hi07:20
dhx_mkirillka: hi07:20
kirillkadhx_m: happy new release07:20
dhx_mhaha yep07:20
kirillkaOne my friend have wish07:21
kirillkaAll username - link to his issues07:21
dhx_mhttp://sourceforge.net/project/stats/detail.php?group_id=14963&ugn=mantisbt&mode=week&type=prdownload07:22
kirillkaview page with issues, created by this user07:22
kirillkanice downloads07:23
dhx_mah ok07:29
dhx_mso on the username page, have a link to filter/view all issues by the user?07:29
dhx_mie. assigned to, reported by, monitored by, etc07:30
dhx_mthat wouldn't be hard07:30
davidincdhx_m: hi07:42
dhx_mdavidinc: hi!07:42
davidincis it possible to use mantis as process management tool07:42
dhx_mI'm not quite sure what a process management tool is?07:43
davidincmantis mostly used for task management07:44
dhx_mif it's:07:44
dhx_mBusiness process management (BPM) is a management approach focused on aligning all aspects of an organization with the wants and needs of clients. It is a holistic management approach[1]  that promotes business effectiveness and efficiency while striving for innovation, flexibility, and integration with technology.07:44
dhx_mthen uh, I'm the wrong person to ask :p07:44
dhx_myou can keep track of any process with Mantis07:44
dhx_malthough it is really designed for bug tracking first and foremost07:45
dhx_mso if your process involves selling things to clients and needing to have automatic billing and other financial stuff built in to the software, Mantis is probably not the best option... without plugins07:45
davidincYes you right but still it's possible if I use plugin07:46
davidincIs there plugins already do this.07:49
dhx_mnot financial stuff AFAIK07:51
dhx_mbut it's really not hard to integrate another financial web app into Mantis07:51
dhx_m"not hard" = a few weeks work probably07:51
dhx_mit's not my area so I don't know the specifics or what other software is already available in that area07:52
davidincOk! thanks I'm know working on the reminder plugin I hope I will finish it soon.07:53
supergregCongrats on 1.2! I'd like to know how I can be notified by email whenever a ticket is created within a project? (Set this option per user or group)07:53
dhx_mdavidinc: I'll try to test it out soon :)07:59
dhx_msupergreg: thanks07:59
dhx_msupergreg: that is a little bit tricky at the moment, as it'd have to be set by an administrator with adm_config_report.php08:00
dhx_msupergreg: users can toggle global email notifications, but not per-project at the moment08:00
davidincdhx_m: Ok Thanks, I will luv to here your comment .08:01
supergregI have checked: E-mail on New With Minimum Severity of [any]08:01
supergregbut am not receiving emails for new tickets, only on update08:02
*** Joins: mantisbt_80529 (~5b59dbc0@gateway/web/freenode/x-vtbfwcsxjthzewxl)08:02
kirillkadhx_m: may be if field reporter, then all reporter by, assigned to view all issues assigned to, etc08:04
dhx_msupergreg: hmm I really need to test it out myself, as a few users were reporting problems with email notifications08:05
dhx_msupergreg: please note: $g_email_receive_own = OFF;08:05
dhx_msupergreg: you won't receive emails of new issues you create yourself (by default)08:05
dhx_mkirillka: on bug_view_page?08:06
kirillkadhx_m: yep08:06
dhx_mkirillka: I think it'd be best to link to the user information page on hyperlinked usernames, mostly for consistency reasons08:07
supergregI manage 2x 1.2 installs which both have several projects, and I for one would like to always receive email for all tickets in all projects, so I don't have to actively go in and check for new ones. I don't need notifies for my own, I just wanted to ask since I figured I had misconfigured something.08:07
kirillkagood idea08:07
dhx_msupergreg: $g_notify_flags['new']['threshold_min'] = DEVELOPER;08:08
dhx_madding that to config_inc.php will notify all users of at least level DEVELOPER of new bug reports08:09
supergregwill give that a shot, thanks!08:09
dhx_msupergreg: I actually think the per-user configuration option for "email on new" may be triggered only on reopened issues... I'm not too sure thought08:09
dhx_mit needs fixing/rewriting at some stage :)08:10
supergregmylyn notifies me of new tickets if I happen to open the right project in eclipse (which is awesome), but fo the projects I dont regularly work on, the email notification is very useful08:14
supergregeither way, thanks for a lovely piece of software. Have migrated from both trac and bugzilla to mantis now, loving it :)08:15
dhx_mfantastic :) please let us know via bug reports if you encounter any issues08:16
dhx_mand feel free to submit patches/etc if that's your thing08:16
dhx_mdevelopment is very open here08:16
davidincdhx_m: do u notice on mantisbt-1.2.0 After you click clone on the view page you found the due date default value (1970/01/01 03:00) that mine zero on unix. It shell print empty text box or the current date? what do you think?08:29
dhx_mdavidinc: yeah if no due date is set in the previous thread, the box should be empty when cloning08:31
dhx_mdavidinc: if that's not the case, can you reopen the bug I fixed for that?08:31
davidincOk! I didn't pull anything lately. Can you tell me the ticket no for the bugs you fix.08:34
davidincdhx_m: can you tell me the bug ticket number08:36
dhx_mdavidinc: http://www.mantisbt.org/bugs/view.php?id=1077908:38
davidincdhx_m: Thanks man08:48
davidincIt works08:48
dhx_mdavidinc: great :)08:49
davidincdhx_m: yap :)08:49
*** Joins: mantisbot (~supybot@81-174-26-126.static.ngi.it)08:52
*** Quits: mantisbot (~supybot@81-174-26-126.static.ngi.it) (Ping timeout: 256 seconds)09:00
*** Quits: mantisbt_80529 (~5b59dbc0@gateway/web/freenode/x-vtbfwcsxjthzewxl) (Quit: Page closed)09:04
*** Joins: daryn (~INTERACT\@rrcs-76-79-4-2.west.biz.rr.com)09:32
davidincdhx_x: Do you think email notification can be configured to send the message only09:37
davidincThe notification mails are not easy to read09:37
davidincMore important is, to show the recent notes on top to avoid long scrolling.09:37
davidincdhx_m: what do you think?09:38
dhx_mdavidinc: notifications need a big overhaul in Mantis09:39
dhx_mdavidinc: so it's certainly on the TODO list09:39
davidincdhx_m: Ok! so what do suggest?09:40
davidincdhx_m: Ok! so what do you suggest?09:41
dhx_mdavidinc: probably notifications as a plugin mechanism?09:41
dhx_mie. a notificationsplugin09:41
dhx_mthe reason being that notifications tend to be event based in the same way event triggers are09:41
davidincSo, I will create plugin it can be usefull.09:44
dhx_myou do realise this is a huge task? :)09:44
davidincBut not know I have other things!!09:45
dhx_mbasically it'd rip out email support from Mantis core into a plugin09:45
dhx_mthus you could run MantisBT with a completely different notification mechanism (SMS) if you wanted to09:45
davidincOk! that good option.09:46
dhx_mthe upshot of a plugin approach is that we start introducing plugin hooks everywhere they're needed09:46
* giallu sighs at plugins09:46
dhx_mit's really just an event system ;)09:47
dhx_malthough I certainly do see the downside09:47
dhx_mof this proposal09:47
davidincOk know I preferred sms mechanism but how can I integreted with mantisbt09:49
davidincDo mantis support any sms mechanism09:50
dhx_mnot yet09:50
davidincdhx_m: Thanks for your great advices!!!!!09:52
davidinccaio09:52
dhx_mdavidinc: ok cya later09:53
*** Quits: davidinc (~d5374b1e@gateway/web/freenode/x-phtsoyctdabjztoa) (Quit: Page closed)09:53
*** Quits: daryn (~INTERACT\@rrcs-76-79-4-2.west.biz.rr.com) (Quit: daryn)10:26
*** Joins: daryn (~INTERACT\@rrcs-76-79-4-2.west.biz.rr.com)10:27
*** Joins: mantisbot (~supybot@81-174-26-126.static.ngi.it)10:31
*** Quits: mantisbot (~supybot@81-174-26-126.static.ngi.it) (Ping timeout: 252 seconds)10:39
nuclear_eclipsedhx_m: rather than removing email from core, I'd rather see email stay in core, and the nebulus notification event system make it easy to have *multiple* notification methods at once10:43
*** Joins: thraxisp (~thraxisp@dsl-67-55-9-226.acanac.net)11:00
*** Joins: Madness (~mad@host52-5-static.58-217-b.business.telecomitalia.it)11:09
*** Parts: Madness (~mad@host52-5-static.58-217-b.business.telecomitalia.it)11:09
*** Joins: theMadness (~petal@host52-5-static.58-217-b.business.telecomitalia.it)11:09
theMadnessBetter.11:09
theMadnessI was trying out Mantis, and I noticed that some steps were taken with OpenID implementation, is that going anywhere?11:10
*** Quits: giallu (~giallu@fedora/giallu) (Ping timeout: 265 seconds)11:16
*** Joins: mantisbt_53326 (~d2c13501@gateway/web/freenode/x-cfgbqafusbjdvbhl)11:23
*** Quits: mantisbt_53326 (~d2c13501@gateway/web/freenode/x-cfgbqafusbjdvbhl) (Client Quit)11:24
*** Joins: Harpreet_ (~d2c13501@gateway/web/freenode/x-ccralfuyunhaoqqr)11:26
Harpreet_Dear All,11:27
Harpreet_Congrats to all of you, on the release of Mantis 1.2.011:27
*** Quits: Harpreet_ (~d2c13501@gateway/web/freenode/x-ccralfuyunhaoqqr) (Quit: Page closed)11:37
theMadnesswell.11:47
*** Joins: wolog (~wolog@77.245.1.125)11:53
*** Quits: wolog (~wolog@77.245.1.125) (Read error: Connection reset by peer)12:00
*** Quits: rolfkleef (~rolf@82-204-82-162.fttx.bbeyond.nl) (Ping timeout: 260 seconds)12:01
theMadnessMan this channel is REALLY dead.12:05
*** Joins: wolog (~wolog@77.245.1.125)12:06
*** Joins: mantisbot (~supybot@81-174-26-126.static.ngi.it)12:09
daryntheMadness depends on the day. should've been here yesterday12:11
daryn:)12:11
*** Quits: mantisbot (~supybot@81-174-26-126.static.ngi.it) (Ping timeout: 240 seconds)12:17
theMadnessI see.12:25
theMadnessI hope someone will drop here with some knowledge of openid/mantis.12:26
*** Joins: mantisbt_76677 (~d45ab866@gateway/web/freenode/x-ezorsmnkzjujgyfr)12:37
*** Joins: moto-moi (~hylke@cara.xs4all.nl)12:41
*** Quits: wolog (~wolog@77.245.1.125) (Ping timeout: 256 seconds)12:57
*** Joins: cobexer (~cobexer@91-113-60-136.adsl.highway.telekom.at)12:59
*** Joins: rolfkleef (~rolf@urtica.xs4all.nl)13:17
*** Joins: siebrand (~beis@sm.xs4all.nl)13:21
*** Joins: micahg (~micah@ubuntu/member/micahg)13:30
micahgnuclear_eclipse: PM?13:31
*** Joins: mantisbot (~supybot@81-174-26-126.static.ngi.it)13:42
nuclear_eclipsehi micahg 13:46
micahgnuclear_eclipse: hi, I have something OT for you13:47
* paul__ yawns13:48
paul__nuclear_eclipse: i'm still not talking to you btw :P13:48
nuclear_eclipsehi paul__ 13:48
*** Quits: mantisbot (~supybot@81-174-26-126.static.ngi.it) (Ping timeout: 265 seconds)13:51
nuclear_eclipsemicahg: go ahead :)13:52
*** cobexer is now known as \cobexer|away13:53
paul__yay13:54
paul__two emails from sohpos antivirus13:54
*** Joins: AzaToth (~azatoth@wikipedia/AzaToth)14:06
*** Parts: micahg (~micah@ubuntu/member/micahg)14:35
*** Quits: kirillka (~Miranda@155-211-36-78.baltnet.ru) (Quit: kirillka)14:36
*** Joins: mantisbot (~supybot@81-174-26-126.static.ngi.it)15:17
*** Quits: mantisbot (~supybot@81-174-26-126.static.ngi.it) (Ping timeout: 240 seconds)15:25
*** Quits: mantisbt_76677 (~d45ab866@gateway/web/freenode/x-ezorsmnkzjujgyfr) (Ping timeout: 252 seconds)16:13
*** Quits: \cobexer|away (~cobexer@91-113-60-136.adsl.highway.telekom.at) (*.net *.split)16:48
*** Quits: thraxisp (~thraxisp@dsl-67-55-9-226.acanac.net) (*.net *.split)16:48
*** Joins: \cobexer|away (~cobexer@91-113-60-136.adsl.highway.telekom.at)16:48
*** Joins: mantisbot (~supybot@81-174-26-126.static.ngi.it)16:53
*** Quits: mantisbot (~supybot@81-174-26-126.static.ngi.it) (Ping timeout: 245 seconds)17:01
*** Joins: cobexer (~cobexer@91-113-125-172.adsl.highway.telekom.at)17:07
*** Quits: \cobexer|away (~cobexer@91-113-60-136.adsl.highway.telekom.at) (Read error: Operation timed out)17:08
*** Joins: w00ter (~wouter@195-240-93-118.ip.telfort.nl)17:22
*** Quits: cobexer (~cobexer@91-113-125-172.adsl.highway.telekom.at) (Remote host closed the connection)17:29
*** Quits: daryn (~INTERACT\@rrcs-76-79-4-2.west.biz.rr.com) (Quit: daryn)17:53
*** Quits: moto-moi (~hylke@cara.xs4all.nl) (Quit: Ex-Chat)18:21
*** Joins: mantisbot (~supybot@81-174-26-126.static.ngi.it)18:29
*** Quits: mantisbot (~supybot@81-174-26-126.static.ngi.it) (Ping timeout: 265 seconds)18:37
*** Quits: rolfkleef (~rolf@urtica.xs4all.nl) (Ping timeout: 276 seconds)18:47
*** Quits: fanno (~Morten@90.184.93.233) (Read error: Connection reset by peer)18:51
*** Quits: scribe9343423 (~scribe934@mantisforge.org) (Remote host closed the connection)19:00
*** Joins: scribe9343423 (~scribe934@mantisforge.org)19:00
*** Joins: mantisbot (~supybot@81-174-26-126.static.ngi.it)20:27
*** Quits: mantisbot (~supybot@81-174-26-126.static.ngi.it) (Ping timeout: 265 seconds)20:36
*** Quits: AzaToth (~azatoth@wikipedia/AzaToth) (Remote host closed the connection)20:52
*** Joins: thraxisp (~thraxisp@24.139.16.154)20:55
*** Joins: mantisbot (~supybot@81-174-26-126.static.ngi.it)22:30
*** Quits: mantisbot (~supybot@81-174-26-126.static.ngi.it) (Ping timeout: 265 seconds)22:38
*** Joins: Jwv (~jwv@ac-217-129-178-207.netvisao.pt)23:31
*** Joins: mantisbot (~supybot@81-174-26-126.static.ngi.it)23:51
*** Quits: mantisbot (~supybot@81-174-26-126.static.ngi.it) (Ping timeout: 265 seconds)23:59

Generated by irclog2html.py 2.9.2 by Marius Gedminas - find it at mg.pov.lt!