Tuesday, 2009-04-28

../irclogs/#mantishelp.2009-04-28.log
--- scribe started ---00:00
lovelypp测试02:12
dhx_mhi04:15
mantisbotNew bug: Bug 10425 - karthiksudar - open - new04:36
mantisbotNew bug: defect raising - http://www.mantisbt.org/bugs/view.php?id=1042504:36
mantisbotNew bug: Bug 10426 - karthiksudar - open - new04:46
mantisbotNew bug: system check - http://www.mantisbt.org/bugs/view.php?id=1042604:46
mantisbotNew bug: Bug 10427 - karthiksudar - open - new04:46
mantisbotNew bug: system check - http://www.mantisbt.org/bugs/view.php?id=1042704:46
mantisbotNew bug: Bug 10428 - karthiksudar - open - new04:51
mantisbotNew bug: system check - http://www.mantisbt.org/bugs/view.php?id=1042804:51
* dhx_m stabs karthiksudar in the face via the internet04:53
gialluthe stupid guy could recreate his account in no time, given we don't check for duplicate emails... grrrr05:13
dhx_mcan't you change his password for him?05:16
dhx_mie. lock him out by setting his password to something random?05:16
prabhuranganHi guys08:41
[KK]Kirillhi, all09:59
[KK]Kirillanybody arround?10:00
mantisbotNew bug: Bug 10429 - cas - open - new10:28
mantisbotNew bug: Archiving old issues - http://www.mantisbt.org/bugs/view.php?id=1042910:28
sdjfklmo11:59
sdjfkljohn?11:59
nuclear_eclipsemorning all12:13
sdjfkljohn: shouldn't we use LOWER() in sql?12:14
nuclear_eclipsemy question would be: is LOWER() available in every SQL platform?12:14
nuclear_eclipsebecause I know there are a lot of functions in MySQL that aren't found elsewhere...12:15
sdjfklI believe lower() exists in mssql+postgres12:15
dhx_mhi12:18
sdjfkllo12:18
dhx_mwe use AdoDB anyway, which I imagine handles that for us?12:18
sdjfklgiallu: whers your utf8 convert script12:18
sdjfkldhx_m: if adodb handles something, it's probably broken12:18
sdjfkldhx_m: I find life is easier if I make that assumption12:19
sdjfklavoids disappointment12:19
dhx_mhaha12:19
[KK]Kirillnuclear_eclipse: dhx_m: hi12:59
dhx_mhi12:59
[KK]Kirillhttp://google-code-updates.blogspot.com/2009/04/mercurial-support-for-project-hosting.html13:02
dhx_mthey seemed to know what was coming... they provided a lot of information about why they didn't get git up and running13:06
nuclear_eclipseI think it really came down to the fact that Hg better supports cloning over HTTP compared to Git13:08
[KK]Kirilldhx_m: at first need convert to mercurial13:09
dhx_mare you converting something?13:10
[KK]KirillI only today know this.. At home will try convert13:11
dhx_mhttp://whygitisbetterthanx.com/#git-is-fast13:12
[KK]Kirill> If you would like to help us launch Mercurial and to try out the features as an invited user, please fill out the following form.13:12
[KK]Kirilldhx_m: bzr too slow?13:13
dhx_maccording to that site, yes13:13
dhx_mbranching in git is also 100000000 times faster :p13:14
dhx_mnot sure why it took them 9s to add files with git! :o13:14
[KK]Kirill:( only this system support national character13:14
[KK]Kirilland Mercurial and Bazaar more support Windows13:14
[KK]Kirillat now I have 3 system on my notebook13:15
dhx_mTortoiseSVN is a disaster IMO13:15
dhx_mso anything that resembles it can also get stuffed :p13:15
[KK]Kirillsorry. 4 system (I forgot svn)13:15
[KK]Kirill:D13:16
dhx_mCLI VCS is so much faster than doing tasks with a GUI13:16
[KK]KirillI use only TortoiseSVN - powerfull tool, other - bad clone of TSvn13:17
dhx_mI guess you could come up with an OK GUI13:17
dhx_mbut most I've seen slow you down too much13:17
dhx_myou have to click lots of buttons, read text, right click here, click there, etc13:17
[KK]Kirilldhx_m: I use FAR Manager and use keyboard more then mouse13:19
[KK]Kirillthan*13:19
dhx_mgit and hg seem quite similar13:20
dhx_malthough hg appears to be orders of magnitude slower than git with branching13:21
[KK]KirillI'll be use git or hg but they don't support russian character in filenames.13:21
dhx_mare you using Windows?13:21
[KK]Kirillyes13:21
dhx_mso I assume you're using an environment like mingw to run git?13:22
nuclear_eclipseour biggest reason for Git > Hg is that Git handles branching much more naturally, and allows for a much wore flexible workflow for developers13:22
[KK]Kirillfor begin I use mingw13:23
[KK]Kirillat now I use mingw only if commit13:23
dhx_mI don't see why git wouldn't work with UTF-8?13:23
[KK]Kirill(in mingw settings for editor)13:23
[KK]KirillI don't wee to, but...13:23
dhx_msounds to me like an operating system/environment issue?13:24
[KK]Kirillhttp://code.google.com/p/msysgit/issues/detail?id=23013:25
[KK]Kirilldhx_m: did you understand what he wrote?13:27
dhx_mI think so13:31
[KK]KirillBut I don't13:32
dhx_mit seems git doesn't support UTF-813:35
dhx_mit just uses plain old ASCII code pages?13:35
[KK]Kirill:(13:35
[KK]Kirillmercurial not support too13:35
dhx_mUnicode support is very hard to achieve properly13:36
dhx_myou have to either rely on OS specific string functions to do the work... or a 3rd party library like ICU13:37
[KK]KirillI think for current operation system it's in core?13:38
dhx_moh git does support UTF-8 (I couldn't really understand why you wouldn't)13:39
dhx_mcommit messages can be in UTF-8 (by default) as per http://www.kernel.org/pub/software/scm/git/docs/git-commit.html13:39
[KK]Kirillbut windows's vi don't support this13:40
dhx_m"git-log, git-show, git-blame and friends look at the encoding header of a commit object, and try to re-code the log message into UTF-8"13:40
[KK]KirillI think I can change editor to notepad2 and use git not in mingw13:41
dhx_mI imagine the problem is that Windows internally uses UTF-1613:41
[KK]Kirill:(13:41
dhx_malso UTF16 is not backwards compatible as is the case with UTF813:43
sdjfklnuclear_eclipse: google supports hg?13:52
[KK]Kirillsdjfkl: now for testing14:00
[KK]Kirillnot everyone14:00
[KK]Kirilldhx_m: notepad2 worked14:17
dhx_m:)14:18
[KK]KirillI don't use mingw14:18
[KK]Kirill*ROFL*14:19
[KK]Kirill[strings 1f84646] ¦â¦¦TÁT ¦î¦-¦¬¦¦¦-¦+¦- ¦- ¦¦¦-¦-¦-¦¬T¦¦ Merge commit 'HEAD'; branch 'master' into strings14:20
[KK]Kirillin system didn't show corectly14:20
[KK]Kirilldhx_m: unicode 16 don't work too14:25
[KK]Kirill[kkissue3 315d1fd] Tõ¸ª ¦ýøúþôýþóþ ÷ðóþûþòúð Merge commit 'HEAD'; branch 'master' into kkissue314:25
dhx_mah fun14:25
[KK]Kirilltry to install virtual box14:28
[KK]Kirillwith ubuntu 9.0414:28
harpreet_singhHi All,14:52
[KK]Kirillharpreet_singh: he14:52
harpreet_singhI would like to thanks to all who has supported me to install my mantis Ver 1.1.7.14:52
[KK]Kirillhi14:52
harpreet_singhSill I have some queries which I post here as per requirement.14:52
harpreet_singhho14:52
harpreet_singhhi14:52
harpreet_singhhow are you14:52
[KK]Kirillnormaly14:52
harpreet_singhmay I know how we can assing the bug to more than  a one person.14:53
[KK]Kirilldhx_m: See this15:00
[KK]Kirill[test e4b28ab] Òåñò êîäèðîâêè Äîñ 866 Merge commit 'HEAD'; branch 'Kirill' into test15:00
mantisbotNew bug: Bug 10430 - quazardous - open - new15:00
mantisbotNew bug: Cannot update custom date field - http://www.mantisbt.org/bugs/view.php?id=1043015:00
[KK]Kirilldhx_m: workin cp86615:02
[KK]Kirillstupid win15:02
mantisbotNew bug: Bug 10431 - gnipp - open - new15:25
mantisbotNew bug: SYSTEM WARNING: Division by zero, when displaying jpgraphs - http://www.mantisbt.org/bugs/view.php?id=1043115:25
* paulr slaps nuclear_eclipse 17:22
paulrDEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci17:25
paulrthose?17:25
* paulr slaps siebrand 17:52
paulryou there?17:52
siebrandpaulr: sup?19:06
siebrandpaulr: you should leave collation alone - even though I think I have read MySQL still does not have it under control, it will provide a sorting preference.19:07
siebrandcould add something like "If you do not know what you should pick, "utf8_unicode_ci" is probably OK for you"19:08
siebrand(afk again, will be at keyboard every 45 mins or so)19:10
paulrerm?19:49
paulrsiebrand: doesn't collation define charset?19:49
paulrso do19:56
paulrDEFAULT CHARSET=utf819:56
paulrbut not19:56
paulrCOLLATE=utf8_unicode_ci'19:56
paulr?19:56
siebrandpaulr: well, COLLATE can be utf8_<any> as far as I know.20:04
siebrandpaulr: from Wikipedia: Collation is the assembly of written information into a standard order. One common type of collation is called alphabetisation, though collation is not limited to ordering letters of the alphabet. Collating lists of words or names into alphabetical order is the basis of most office filing systems, library catalogs and reference books.20:06
eltonminettohi. when i export the cases in CSV format, can i export the tags included?20:21
paulrsiebrand: so dont specify?20:40
siebrandpaulr: uncertain about this; does the installer also create the database?20:53
siebrandpaulr: if it does not, do not specify anything for the default database. Just require users to create a database in UTF-8 with a chosen UFT-8 collation. All derivative tables and fields will inherit that character set and collation (or I must be very wrong here...)20:54
paulri'm thinking of specifiying 'ENGINE=MyISAM DEFAULT CHARSET=utf8'20:57
paulras table options20:57
paulr$sqlarray = $dict->CreateDatabase( $f_database_name );20:58
paulrand yes20:58
paulrwe can create db20:58
* paulr slaps nuclear_eclipse HARD20:59
thraxisppaulr: The installer does try to create the database if you can't log into it.21:09
paulrthraxisp: it's ENGINE not TYPE now right?21:11
mantisbotNew bug: Bug 10432 - julioempresa - open - new21:27
mantisbotNew bug: atal error: require_once() [function.require]: Failed opening required 'C:\xampp\htdocs\mantis\lang\strings_portugese_brazil.txt - http://www.mantisbt.org/bugs/view.php?id=1043221:27
mantisbotNew bug: Bug 10433 - tomekf - open - new22:22
mantisbotNew bug: Nie moge si? zalogowac - http://www.mantisbt.org/bugs/view.php?id=1043322:22
paulrdone!22:23
* paulr bounces22:23
paulrsiebrand: you gone to bed?22:32
thraxisppaulr: You are right (ENGINE)22:37
paulri've modified install.php to create db as utf8, create tables as utf8, and modified check.php to check that db+tables+columns on tables are utf822:39
paulrI now want to remove things like:22:39
paulr$g_db_table['mantis_project_category_table']= '%db_table_prefix%_project_category%db_table_suffix%';22:39
paulri.e. where we specify tables in config that no longer exist ;(22:40
paulronly thing I dont think we can do is convert to utf8 for users right?22:42
paulr(Existing db's)22:42
thraxisppaulr: right. There were instructions to do this, but only certain versions of MySQL can migrate the data in a table.22:47
paulrsome versions can?22:48
siebrandpaulr: yeah, to bow now at least..22:57
siebrandpaulr: above looks pretty great, though.22:57
paulrsiebrand: http://git.mantisforge.org/w/mantisbt/paul.git22:58
paulrnn23:10

Generated by irclog2html.py