| ../irclogs/#mantishelp.2009-05-16.log | ||
| --- scribe started --- | 00:00 | |
| paulr | nuclear_eclipse: only thing i'm not sure is where to call the timezone command | 00:00 |
|---|---|---|
| * paulr half tempted to commit and deal with that *later* | 00:01 | |
| nuclear_eclipse | btw, that's a *lot* of schema revisions.... | 00:02 |
| nuclear_eclipse | jsut a random observation... | 00:03 |
| nuclear_eclipse | looks like it's almost as many revisions as there were in the entire schema file before that... | 00:03 |
| paulr | :) | 00:05 |
| paulr | well | 00:06 |
| paulr | we use DATETIME a lot | 00:06 |
| paulr | and if we are changing to INT | 00:06 |
| djz | how would i go about not having to login to see the project info? | 00:07 |
| nuclear_eclipse | djz: http://www.mantisbt.org/wiki/doku.php/mantisbt:enabling_anonymous_access | 00:09 |
| djz | doesnt allow them to post right? | 00:09 |
| nuclear_eclipse | depends on how you set it up | 00:09 |
| paulr | nuclear_eclipse: it's also why i'd like to get it in ;p | 00:09 |
| paulr | or otherwise | 00:10 |
| nuclear_eclipse | well, I completely agree with you | 00:10 |
| paulr | as sitting around = no use :) | 00:10 |
| paulr | if we are happy with the schema changes | 00:12 |
| paulr | can probably push changes | 00:13 |
| paulr | then fix anything we break | 00:13 |
| paulr | assuming | 00:13 |
| paulr | a) schema =ok | 00:13 |
| paulr | b) timestamps are gmt in db and not localised | 00:13 |
| paulr | c) timestamp conversion is fine for non-gmt counrties | 00:13 |
| paulr | d) I didn't just break stuff completely when looking at user pref's | 00:13 |
| djz | ( nuclear_eclipse ): is there anyway to log them in annon by default instead of having them click "login annon" | 00:14 |
| nuclear_eclipse | djz: it should do it automatically if you visit any page other than the login page | 00:14 |
| nuclear_eclipse | paulr: it seems to be storing them *not* in GMT... | 00:17 |
| djz | hmm weird field for password is gone from signup | 00:18 |
| nuclear_eclipse | I updated an issue, and it has the correct date when viewing the issue, but the value stored in the DB matches the time shown, not the appropriate GMT time | 00:18 |
| nuclear_eclipse | djz: it's never been ther afaik | 00:18 |
| paulr | nuclear_eclipse: sometimes I hate being GMT :) | 00:18 |
| nuclear_eclipse | I can set you up an account on my server in EST again if you'd like... | 00:19 |
| djz | okay only thing need to do is get the stupid email working | 00:19 |
| paulr | nuclear_eclipse: but that would make sense | 00:20 |
| paulr | my change to db_now | 00:20 |
| paulr | was return | 00:20 |
| paulr | time() | 00:20 |
| paulr | that's localised ofc... | 00:20 |
| paulr | I assume when you then view the issue | 00:20 |
| paulr | it gets localised so it's 2xtimezonediff? | 00:20 |
| nuclear_eclipse | I have no clue | 00:20 |
| paulr | (from gmt) | 00:21 |
| djz | whats prefered, sendmain/mail/smtp? | 00:21 |
| nuclear_eclipse | the times were all correct for my local time, but it's storing my local time in the database, not GMT | 00:21 |
| nuclear_eclipse | djz: depends on your server | 00:21 |
| djz | anyway to change severity list? | 00:34 |
| paulr | nn | 00:56 |
| paulr | nuclear_eclipse: probably catch you tomorrow | 00:56 |
| nuclear_eclipse | k, cheers | 00:57 |
| paulr | but yea | 01:00 |
| paulr | we need two functions | 01:01 |
| paulr | display_date | 01:01 |
| paulr | + | 01:01 |
| paulr | generate date for db | 01:01 |
| nuclear_eclipse | yep | 01:01 |
| paulr | atm, the I just call date() to generate db date | 01:03 |
| paulr | I suspect that is affected bytimezone | 01:03 |
| nuclear_eclipse | yep | 01:03 |
| paulr | whats date() return for you atm btw/ | 01:04 |
| nuclear_eclipse | root@mach[~] php < 21:00 | 01:04 |
| nuclear_eclipse | <?php var_dump( date() ); | 01:04 |
| nuclear_eclipse | Warning: date() expects at least 1 parameter, 0 given in /home/jreese/- on line 1 | 01:04 |
| nuclear_eclipse | bool(false) | 01:04 |
| nuclear_eclipse | :P | 01:04 |
| paulr | time() | 01:04 |
| paulr | 1242435900 ? | 01:05 |
| nuclear_eclipse | root@mach[~] php < 21:04 | 01:05 |
| nuclear_eclipse | <?php var_dump( time() ); | 01:05 |
| nuclear_eclipse | int(1242435929) | 01:05 |
| nuclear_eclipse | root@kepler[/srv] php < 21:06 | 01:06 |
| nuclear_eclipse | <?php var_dump( time() ); | 01:06 |
| nuclear_eclipse | int(1242435971) | 01:06 |
| nuclear_eclipse | desktop and server, resp | 01:06 |
| paulr | right so that's gmt | 01:07 |
| paulr | so db should be fine I think | 01:07 |
| nuclear_eclipse | ah, maybe date() takes local timezone into account when formatting date string? | 01:07 |
| nuclear_eclipse | root@mach[~] php < 21:05 | 01:08 |
| nuclear_eclipse | <?php var_dump( date( 'Y-m-d H:i:s', 1242435929 ) ); | 01:08 |
| nuclear_eclipse | string(19) "2009-05-15 21:05:29" | 01:08 |
| nuclear_eclipse | and that timestamp matches my local time | 01:08 |
| paulr | so erm | 01:09 |
| paulr | is it right atm? ;p | 01:09 |
| nuclear_eclipse | well, I guess it's "right" in that it stores GMT in the database, and converts GMT to server-local timestamp | 01:10 |
| paulr | 01:26 < nuclear_eclipse> the times were all correct for my local time, but it's storing my local time in the database, not GMT | 01:12 |
| paulr | does it store gmt in thedb | 01:12 |
| paulr | or your local time | 01:12 |
| nuclear_eclipse | well, running date() on the int resulted in a string representing local time, but assuming that date() does timevone conversions, then that int was probably GMT | 01:13 |
| paulr | right so you didn't actually look at db when stating it stores gmt in the db? :) | 01:13 |
| paulr | erm not storing | 01:14 |
| nuclear_eclipse | well, I lookde at the DB, grabbed the int, and ran it through date() to see what it stored, not realizing that date() does timezone stuff automagically | 01:14 |
| paulr | right cool | 01:18 |
| paulr | what do you think of the timezone selector dropdown in options? | 01:18 |
| nuclear_eclipse | where's that at? | 01:19 |
| paulr | under user prefs | 01:21 |
| nuclear_eclipse | I don't see anything there, is this in dates3? | 01:23 |
| mib_ddmoxe | Hi everybody | 01:26 |
| mib_ddmoxe | I'm reading the documentation page http://www.mantisforge.org/dev/manual/en/administration_guide/c124.html | 01:26 |
| mib_ddmoxe | and i found a broken link: http://www.mantisforge.org/dev/manual/en/administration_guide/manual.configuration.html | 01:27 |
| paulr | nuclear_eclipse: account -> preferences | 01:27 |
| paulr | above language selector | 01:27 |
| nuclear_eclipse | def not showing in mine... | 01:28 |
| paulr | ... | 01:28 |
| paulr | can you see where you change language? | 01:28 |
| nuclear_eclipse | unless you did something funky and I've got a config option that's hiding it.... | 01:28 |
| nuclear_eclipse | yeah, I can | 01:28 |
| paulr | timezone should be above | 01:28 |
| nuclear_eclipse | lemme paste screenie | 01:29 |
| paulr | oops | 01:30 |
| paulr | you need email notificatoisn on :P | 01:30 |
| paulr | if ( ON == config_get( 'enable_email_notification' ) ) { | 01:30 |
| * paulr moves ;p | 01:30 | |
| paulr | found it now? | 01:32 |
| paulr | anyway nn | 01:32 |
| nuclear_eclipse | looks nice, but it'd be better IMO to a) default to the server's timezone, and b) show/sort by timezone offset, eg New York (-0500) | 01:32 |
| nuclear_eclipse | goodnight | 01:33 |
| paulr | re a - i think that comes down to my 'where to set this stuff' thing | 01:34 |
| paulr | re b - yea, maybe - i was pulling timezones out of what php supports | 01:34 |
| paulr | i.e. there's some gettimezone functions | 01:34 |
| paulr | not sure if they give offset or not | 01:35 |
| paulr | (things change/improve between 5.1 and 5.2 and 5.3 re timezones iirc | 01:35 |
| paulr | *nn* | 01:35 |
| mib_ddmoxe | what is the pass for the administrator default account?? | 02:06 |
| mib_ddmoxe | anybody? | 02:11 |
| mib_ddmoxe | forgeret. I update the database for a personal md5 value ... | 02:15 |
| paulr | nuclear_eclipse: can you give us a poke if/when you start lurking today | 12:13 |
| nuclear_eclipse | paulr: awake now, will likely be in and out all day | 14:12 |
| paulr | can i put dates in trunk do you think? | 14:15 |
| paulr | and fix anything that comes up | 14:15 |
| dhx_m | hey | 14:16 |
| nuclear_eclipse | howdy dhx_m | 14:16 |
| dhx_m | I don't mind testing it now | 14:16 |
| dhx_m | forgot to do it before | 14:16 |
| nuclear_eclipse | let dhx_m test it, and then if he says go, push it | 14:16 |
| dhx_m | is your branch up to date with trunk? | 14:17 |
| dhx_m | *master | 14:17 |
| nuclear_eclipse | it merges cleanly | 14:17 |
| dhx_m | stupid SVN terminology ;) | 14:17 |
| dhx_m | ok well I'll merge it into a test branch | 14:17 |
| dhx_m | and try it out | 14:17 |
| dhx_m | anything in particular I should be checking? | 14:17 |
| nuclear_eclipse | dhx_m: it's dates3 btw | 14:17 |
| nuclear_eclipse | dhx_m: make sure it's storing GMT timestamps in the database, and displaying local timezone stamps when displaying | 14:18 |
| nuclear_eclipse | and just glance at the cade to make sure paulr isn't too insane | 14:18 |
| dhx_m | ok :) | 14:18 |
| nuclear_eclipse | I'm unfortunately too busy with final bullshit for graduation | 14:19 |
| paulr | nuclear_eclipse: i'm fairly insane | 14:57 |
| phl4kx | hi all | 15:21 |
| paulr | lo | 15:49 |
| paulr | phl4kx: was it you that was asking about ldap last night? | 15:49 |
| phl4kx | problem with OU | 15:50 |
| phl4kx | only 1 one accept :( | 15:50 |
| paulr | ahh yes | 15:51 |
| paulr | dhx_m: how you getting on? :P | 15:59 |
| paulr | giallu: it's not crashed again yet has it? :( | 15:59 |
| [KK]Kirill | paulr: lo | 16:35 |
| paulr | lo | 16:43 |
| * paulr pokes nuclear_eclipse and dhx_m :) | 18:27 | |
| nuclear_eclipse | paulr: here in spirit... :P | 18:50 |
| paulr | so | 18:50 |
| paulr | reckon I can commit and we deal with afterwards? | 18:50 |
| paulr | send mail to list warning it's unstable or something | 18:51 |
| nuclear_eclipse | would like to wait for dhx_m since he said he'd test, but... I reckon so | 19:08 |
| paulr | is it safe to empty /var/cache/apt/archies ? | 19:10 |
| nuclear_eclipse | iirc, yes | 19:26 |
| dhx_m | oh ahhhhhhhhh I totally forgot... got busy with something else | 19:28 |
| dhx_m | I'm happy to deal with it later... | 19:28 |
| dhx_m | as I might not end up being able to give this a good test for ~1day | 19:29 |
| * dhx_m hits multitasking with a baseball bat | 19:29 | |
| dhx_m | gtg for now, sorry for the delay! | 19:30 |
| dhx_m | cya | 19:30 |
Generated by irclog2html.py