Saturday, 2010-11-13

*** Joins: kirillka (~Miranda@195.242.142.17)02:17
*** Quits: kirillka (~Miranda@195.242.142.17) (Quit: kirillka)02:23
*** Quits: roentgen (~arthur@openvpn/community/support/roentgen) (Ping timeout: 272 seconds)02:47
*** Joins: roentgen (~arthur@openvpn/community/support/roentgen)03:23
*** Joins: paulr (~IceChat09@cpc1-enfi9-0-0-cust389.hari.cable.virginmedia.com)04:40
paulrmornin04:55
*** Joins: djSupport (~djsupport@188-221-240-190.zone12.bethere.co.uk)06:35
*** Quits: thraxisp (~thraxisp@24.139.16.154) (Quit: thraxisp)07:11
*** Joins: kirillka (~Miranda@195.242.142.17)07:15
*** Quits: roentgen (~arthur@openvpn/community/support/roentgen) (Ping timeout: 260 seconds)08:52
*** Joins: moto-moi (~hylke@2001:888:13e4:0:21f:e2ff:fe0c:ce28)08:56
*** Joins: roentgen (~arthur@openvpn/community/support/roentgen)09:36
*** Quits: roentgen (~arthur@openvpn/community/support/roentgen) (Remote host closed the connection)09:37
*** Joins: cobexer (~cobexer@188-22-233-140.adsl.highway.telekom.at)09:52
*** Joins: roentgen (~arthur@openvpn/community/support/roentgen)09:58
*** Quits: kirillka (~Miranda@195.242.142.17) (Quit: kirillka)10:02
*** Quits: cobexer (~cobexer@188-22-233-140.adsl.highway.telekom.at) (Remote host closed the connection)11:10
*** Quits: giallu (~giallu@fedora/giallu) (Quit: Leaving)11:13
*** Joins: SunnyJim (~IceChat7@99-97-94-117.lightspeed.tukrga.sbcglobal.net)12:14
SunnyJimwhats wrong with the HG in osgrid?12:14
*** Joins: yorkofkent (0cee081e@gateway/web/freenode/ip.12.238.8.30)14:13
yorkofkentadmin/check.php is finding BAD for "Checking Non-null Column Collation in mantis_bug_file_table is utf8 for id..."    but id is an integer?!  So how can it be utf8?  I have upgraded from 1.1.6 to 1.2.3 and am trying to resolve the database issues.  I had read some posts up fixing the initial database issue, but this is still no-go and baffeling me.14:19
yorkofkentmysql is 4.1.22-standard14:19
paulrwe now expect the columns/tables to be utf814:20
yorkofkentI actually get lots of errors from the check.php, but they are all realated to numbers like: int, tinyint, smallint, longblob.14:20
paulrdepending on your collation depends how to convert to utf8 or whatever14:20
yorkofkentpaulr: That is even for numbers?!  How can I make this change?  SQLyog doesn't allow it.14:21
paulrso atm, your coulumns/tables aren't utf814:21
paulrwhat's sqlyog? :)14:21
yorkofkentsql database editor...14:21
yorkofkentSo the Charset is utf8 for all non-int type entries and Charset is utf8.  But Collation is blank for the int type entries.14:21
paulrI believe we run SHOW TABLE STATUS14:22
paulrthen we use SHOW FULL FIELDS FROM from each table14:23
yorkofkentUSE DATABASE mantis_db;   then SHOW TABLE STATUS; --> results in all entires listing Collation = utf8_general_ci14:24
paulrwhats show full fields from mantis_bug_file_Table show ?14:25
paulr$t_result = db_query_bound( 'SHOW FULL FIELDS FROM ' . $t_table );14:25
yorkofkentSHOW FULL FIELDS from mantis_bug_file_table ---> Does show NULL for int row Collations.14:25
paulras in current code14:25
paulrand for other fields?14:25
yorkofkentThe other ones ... like title, etc... the varchar(250) is utf8_general_ci14:26
yorkofkenthow can I from raw sql try to change the collation?14:27
paulrin fact14:27
paulrdoes the test pass or fail?14:27
yorkofkent| id          | int(10) unsigned | NULL            |      | PRI | NULL    | auto_increment | select,insert,update,references |         |14:27
paulr $result = db_query_bound( 'SHOW FULL FIELDS FROM ' . $t_table );14:27
paulrhile( $row = db_fetch_array( $result ) ) {14:27
paulrif ( $row['Collation'] === null ) {14:27
paulr continue;14:27
paulrif collation = null, we skip outputting the text ;/14:28
paulrcould you go tino check.php find those lines and var_dump($row)14:28
paulrand see what it thinks collation is ;/14:28
yorkofkentarray(9) { ["Field"]=>  string(2) "id" ["Type"]=>  string(16) "int(10) unsigned" ["Collation"]=> string(4) "NULL" ["Null"]=>  string(0) "" ["Key"]=>  string(3) "PRI" ["Default"]=>  NULL ["Extra"]=>  string(14) "auto_increment" ["Privileges"]=>  string(31) "select,insert,update,references" ["Comment"]=>  string(0) "" }14:31
*** Joins: kirillka (~Miranda@221-74-52-95.baltnet.ru)14:31
yorkofkentpaulr: So did I screw up and make my Null field a "Null" string field?14:32
paulrgiven that  ["Default"]=>  NULL is null14:33
paulri'd say youv'e done something14:33
yorkofkentpualr: if you do: show full fields from mantis_bug_file_table; What do you get in the Collation column for id?   I get    NULL14:38
yorkofkentthe other columns return utf8_general_ci14:38
paulrnull14:42
yorkofkentloewr case hmm?14:43
paulrwlel, NULL14:43
paulryou have string(NULL)14:43
paulrin what you appeared to paste14:43
paulr ["Collation"]=> string(4) "NULL"14:43
paulr ["Default"]=>  NULL14:43
yorkofkentThe result is: NULL ( int(10) unsigned)14:47
yorkofkentin the original table describing the checking Non-null Column Collation...14:47
yorkofkentfrom check.php...   I've been using mantis for 1 month with no issues since this upgrade (and having this issue)... however I have to admit I just had an issue -- which I'm wondering if this caused it...14:49
yorkofkentI added a new bug, and it displays well in any given display, except when I click on it to show the details, I get the error: APPLICATION ERROR #1100 --- Issue 17 not found.    (The bug number is 759)  -- I've not been able to figure this out...  I've looked at the view.php (and included) code... but not figured out anything.14:50
*** Quits: SunnyJim (~IceChat7@99-97-94-117.lightspeed.tukrga.sbcglobal.net) (Quit: Friends help you move. Real friends help you move bodies.)15:54
*** Quits: roentgen (~arthur@openvpn/community/support/roentgen) (Remote host closed the connection)16:39
*** Joins: roentgen (~arthur@openvpn/community/support/roentgen)17:54
*** Joins: mpp (~marcin_pa@apn-95-41-17-182.dynamic.gprs.plus.pl)18:08
mppWhat is the best place I can get localization (translation) packs? Is there any Mantis page with language packs?18:10
mppLooking for Polish lang pack18:10
paulris there not polish already ?18:11
paulrbuilt in18:11
paulrwe have a lot of languages out the box18:11
*** Quits: djSupport (~djsupport@188-221-240-190.zone12.bethere.co.uk) (Read error: Connection reset by peer)18:12
mppI can see Polish in the list of 68 localizations....Sorry for newbie question but how can I enable this in my install?18:13
paulrwhen your logged in as a user18:14
paulrgo to account page and select language you want18:14
paulrI believe you can also change deafault language with $g_language or something in config file18:14
mppOK. will check it. Thank you18:14
*** Parts: mpp (~marcin_pa@apn-95-41-17-182.dynamic.gprs.plus.pl)18:15
*** Quits: scribe9343423 (~scribe934@static.96.23.63.178.clients.your-server.de) (Remote host closed the connection)19:00
*** Joins: scribe9343423 (~scribe934@static.96.23.63.178.clients.your-server.de)19:00
*** Joins: micahg (~micah@ubuntu/member/micahg)19:14
*** Quits: micahg (~micah@ubuntu/member/micahg) (Read error: Connection reset by peer)19:20
*** Quits: kirillka (~Miranda@221-74-52-95.baltnet.ru) (Ping timeout: 276 seconds)19:30
*** Joins: micahg (~micah@ubuntu/member/micahg)20:02
*** Quits: paulr (~IceChat09@cpc1-enfi9-0-0-cust389.hari.cable.virginmedia.com) (Quit: There's nothing dirtier then a giant ball of oil)20:02
*** Quits: moto-moi (~hylke@2001:888:13e4:0:21f:e2ff:fe0c:ce28) (Read error: Operation timed out)20:49
*** Quits: muesli_ (~muesli@agsb-4d0488e3.pool.mediaWays.net) (Ping timeout: 240 seconds)21:11
*** Joins: muesli_ (~muesli@agsb-4d0492ad.pool.mediaWays.net)21:12

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