*** 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 | |
paulr | mornin | 04: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 | |
SunnyJim | whats wrong with the HG in osgrid? | 12:14 |
*** Joins: yorkofkent (0cee081e@gateway/web/freenode/ip.12.238.8.30) | 14:13 | |
yorkofkent | admin/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 |
yorkofkent | mysql is 4.1.22-standard | 14:19 |
paulr | we now expect the columns/tables to be utf8 | 14:20 |
yorkofkent | I actually get lots of errors from the check.php, but they are all realated to numbers like: int, tinyint, smallint, longblob. | 14:20 |
paulr | depending on your collation depends how to convert to utf8 or whatever | 14:20 |
yorkofkent | paulr: That is even for numbers?! How can I make this change? SQLyog doesn't allow it. | 14:21 |
paulr | so atm, your coulumns/tables aren't utf8 | 14:21 |
paulr | what's sqlyog? :) | 14:21 |
yorkofkent | sql database editor... | 14:21 |
yorkofkent | So 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 |
paulr | I believe we run SHOW TABLE STATUS | 14:22 |
paulr | then we use SHOW FULL FIELDS FROM from each table | 14:23 |
yorkofkent | USE DATABASE mantis_db; then SHOW TABLE STATUS; --> results in all entires listing Collation = utf8_general_ci | 14:24 |
paulr | whats 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 |
yorkofkent | SHOW FULL FIELDS from mantis_bug_file_table ---> Does show NULL for int row Collations. | 14:25 |
paulr | as in current code | 14:25 |
paulr | and for other fields? | 14:25 |
yorkofkent | The other ones ... like title, etc... the varchar(250) is utf8_general_ci | 14:26 |
yorkofkent | how can I from raw sql try to change the collation? | 14:27 |
paulr | in fact | 14:27 |
paulr | does 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 |
paulr | hile( $row = db_fetch_array( $result ) ) { | 14:27 |
paulr | if ( $row['Collation'] === null ) { | 14:27 |
paulr | continue; | 14:27 |
paulr | if collation = null, we skip outputting the text ;/ | 14:28 |
paulr | could you go tino check.php find those lines and var_dump($row) | 14:28 |
paulr | and see what it thinks collation is ;/ | 14:28 |
yorkofkent | array(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 | |
yorkofkent | paulr: So did I screw up and make my Null field a "Null" string field? | 14:32 |
paulr | given that ["Default"]=> NULL is null | 14:33 |
paulr | i'd say youv'e done something | 14:33 |
yorkofkent | pualr: if you do: show full fields from mantis_bug_file_table; What do you get in the Collation column for id? I get NULL | 14:38 |
yorkofkent | the other columns return utf8_general_ci | 14:38 |
paulr | null | 14:42 |
yorkofkent | loewr case hmm? | 14:43 |
paulr | wlel, NULL | 14:43 |
paulr | you have string(NULL) | 14:43 |
paulr | in what you appeared to paste | 14:43 |
paulr | ["Collation"]=> string(4) "NULL" | 14:43 |
paulr | ["Default"]=> NULL | 14:43 |
yorkofkent | The result is: NULL ( int(10) unsigned) | 14:47 |
yorkofkent | in the original table describing the checking Non-null Column Collation... | 14:47 |
yorkofkent | from 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 |
yorkofkent | I 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 | |
mpp | What is the best place I can get localization (translation) packs? Is there any Mantis page with language packs? | 18:10 |
mpp | Looking for Polish lang pack | 18:10 |
paulr | is there not polish already ? | 18:11 |
paulr | built in | 18:11 |
paulr | we have a lot of languages out the box | 18:11 |
*** Quits: djSupport (~djsupport@188-221-240-190.zone12.bethere.co.uk) (Read error: Connection reset by peer) | 18:12 | |
mpp | I can see Polish in the list of 68 localizations....Sorry for newbie question but how can I enable this in my install? | 18:13 |
paulr | when your logged in as a user | 18:14 |
paulr | go to account page and select language you want | 18:14 |
paulr | I believe you can also change deafault language with $g_language or something in config file | 18:14 |
mpp | OK. will check it. Thank you | 18: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!