*** Joins: Cupertino (~Cupez@unaffiliated/cupertino) | 02:32 | |
angelete2 | hi again | 02:46 |
---|---|---|
angelete2 | i'm trying to upgrade my 1.0.7 to 1.2.8 | 02:46 |
angelete2 | i've followed instructions from both documentation and @dregad, but whe i click on Upgrade button i get the following error message | 02:47 |
angelete2 | BAD | 02:48 |
angelete2 | CREATE TABLE mantis_email_table ( email_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, email VARCHAR(64) NOT NULL DEFAULT '', subject VARCHAR(250) NOT NULL DEFAULT '', submitted DATETIME NOT NULL DEFAULT '1970-01-01 00:00:01', metadata LONGTEXT NOT NULL, body LONGTEXT NOT NULL, PRIMARY KEY (email_id) )ENGINE=MyISAM DEFAULT CHARSET=utf8 | 02:48 |
angelete2 | Table 'mantis_email_table' already exists | 02:48 |
*** Joins: Rixie (~Rixie@188.177.20.182) | 02:51 | |
*** Joins: asm89 (~asm89@unaffiliated/asm89) | 03:15 | |
*** Joins: dhx1 (~anonymous@60-242-108-164.static.tpgi.com.au) | 03:30 | |
angelete2 | everybody is still asleep | 03:58 |
*** Joins: soustruh (~Miranda@ip-86-49-121-75.net.upcbroadband.cz) | 03:59 | |
*** Joins: kirillka (~Miranda@195.242.142.17) | 05:14 | |
*** Quits: soustruh (~Miranda@ip-86-49-121-75.net.upcbroadband.cz) (Ping timeout: 244 seconds) | 07:10 | |
*** Joins: soustruh (~Miranda@ip-86-49-121-75.net.upcbroadband.cz) | 07:30 | |
*** Quits: soustruh (~Miranda@ip-86-49-121-75.net.upcbroadband.cz) (Quit: visit http://wormscesky.cz) | 07:36 | |
jreese | angelete2: is your 1.0.7 install from a Debian package by chance? | 07:37 |
*** Quits: Cupertino (~Cupez@unaffiliated/cupertino) (Quit: I give up...) | 08:04 | |
*** Joins: FreeAir (57dd0301@gateway/web/freenode/ip.87.221.3.1) | 08:07 | |
FreeAir | Hello! I just upgraded to 1.2.8 from 1.2.5 for the security reasons and all seems fine, BUT, when I look at admin/check.php I see a lot of pink and "BAD" with the text "Checking Table Collation is utf8 for mantis_bug_file_table.... latin1_swedish_ci" | 08:09 |
FreeAir | I guess the first question is, why swedish!? :-) And what does this mean? The upgrade process showed me lots of green. | 08:09 |
FreeAir | I've not commited the upgrade changes on the server yet, but I'd like to. | 08:10 |
FreeAir | And, if there are any devs in here, which I think there might be from my last visit, some feedback on this page: http://www.mantisbt.org/manual/manual.installation.upgrading.php | 08:11 |
jreese | I believe that's a "standard" default encoding. As long as your users don't need to enter international (utf8) characters, you should be fine | 08:11 |
FreeAir | OK, and if they do? what is the process to fix this? And is it a mantis issue or my server setup somehow? | 08:12 |
FreeAir | First feedback on the above link is: It assumes a path, rather than an entire server, it should probably be made a bit more generic and clear in the process. | 08:13 |
jreese | iirc, there is a script in our mantisbt-tools repository that automates the process of updating your mysql tables to use utf8 encodings | 08:13 |
FreeAir | cool | 08:14 |
jreese | that's not an up to date manual anyways, that's the one from 1.1x | 08:14 |
FreeAir | Those instructions do not say to remove the admin directory, however my old install had no admin directory, perhaps I removed it? Should it be there? Or should it be removed? | 08:14 |
jreese | the latest upgrade instructions are in doc/INSTALL of every release | 08:14 |
FreeAir | ok, then the feedback is make the 1.2.8 release blog post point at the right docs :-) | 08:15 |
FreeAir | and move the old docs to some other path? | 08:15 |
jreese | afaik, the blog posts don't point at instructions... | 08:15 |
FreeAir | my docs suck, but i like it when i get feedback on them :-) | 08:15 |
FreeAir | hmmm | 08:15 |
FreeAir | you're right | 08:16 |
FreeAir | bottom of the download page | 08:16 |
FreeAir | just under the "box" | 08:16 |
FreeAir | http://www.mantisbt.org/download.php | 08:16 |
jreese | ah, then that link should be updated | 08:16 |
FreeAir | under the last yellow box | 08:16 |
FreeAir | yay, i did something useful :-) | 08:16 |
FreeAir | let me look for that script... | 08:16 |
FreeAir | still, that path the link points to looks legit | 08:17 |
FreeAir | has no old version number in it | 08:17 |
FreeAir | etc | 08:17 |
FreeAir | and google will have a copy | 08:17 |
FreeAir | so... | 08:17 |
jreese | we have two sets of manuals on the site, one for older 1.0 and 1.1, and another for 1.2+ (/docs) | 08:17 |
FreeAir | phpmyadmin shows a mix of table types | 08:18 |
FreeAir | ok | 08:18 |
FreeAir | fair enough | 08:18 |
FreeAir | its a shame they didnt have versioning in the path when they first went up | 08:19 |
* FreeAir writes a note not to make the same mistake. | 08:19 | |
jreese | https://github.com/mantisbt/mantisbt-tools but now I don't see the script I was thinking of | 08:20 |
FreeAir | I may be able to fix them with phpbb, do you recommend utf8-romainian-ci ? lol | 08:20 |
jreese | basically you have to convert every column's encoding, and then convert every table's encoding, and then ideally modify the database's default encoding to utf8 | 08:21 |
FreeAir | bin, general, unicode seem promising | 08:21 |
jreese | utf8 | 08:22 |
jreese | oops | 08:22 |
jreese | utf8_general_ci | 08:22 |
FreeAir | ok, thank you! :-) | 08:22 |
jreese | you're welcome | 08:22 |
FreeAir | my database has swedish for a default, all of the phpbb tables are utf8-bin though | 08:29 |
FreeAir | seems like something that the app could handle if phpbb are doing it | 08:29 |
FreeAir | From mysql manuals "There are default settings for character sets and collations at four levels: server, database, table, and column. The description in the following sections may appear complex, but it has been found in practice that multiple-level defaulting leads to natural and obvious results. " | 08:38 |
*** Joins: soustruh (~Miranda@193.85.226.67) | 08:43 | |
FreeAir | Any idea what this is? phing/tasks/mantisbt/ExtractMantisBTVersion.php - should it be there? phing seems to be unit testing, which is great to hear, but unit testing in a live app, included by accident? | 08:46 |
FreeAir | jreese: you're right about the swedish thing, it's attached to "latin1" so it's "normal" apparently. | 08:50 |
FreeAir | seems to be something to do with the build system, re phing. | 09:02 |
*** Joins: deavid (~quassel@ns311218.ovh.net) | 09:03 | |
deavid | hi | 09:03 |
deavid | i just installed mantisbt | 09:03 |
deavid | and noticed that captcha isn't working | 09:03 |
deavid | i'm looking for the problem, but i can't find anything | 09:04 |
jreese | FreeAir: mantis already handles enforcing utf8 on any newly created tables, but in cases where you created your database before 1.2, they'll still have older default encodings | 09:06 |
jreese | deavid: you need to have the php-gd module enabled | 09:06 |
deavid | yes, i have that enabled | 09:06 |
deavid | i noticed that the JPG returned is corrupt: it is preceded by php-errors. | 09:06 |
deavid | because some basedir restriction is in effect | 09:07 |
deavid | ok, i prepended to "make_captcha_img.php" the line "error_reporting(0);" and now i can see the image | 09:08 |
FreeAir | jreese: yes, my install started life back at 1.1.7 I think. Thanks for that information :-) Top service! | 09:09 |
FreeAir | btw, fyi, a managerial dev friend told me that mantis was dying this morning, i gave him the eclipse user stats and my personal feelings on issue trackers and got an apology out of him :-) | 09:10 |
jreese | hehe | 09:10 |
FreeAir | he's using the fork of redmine for his stuff, but he's time oriented | 09:10 |
FreeAir | but... | 09:10 |
FreeAir | i have to say, i wish mantis tracked time spent... | 09:10 |
FreeAir | i prefer the rest, so... :-) | 09:10 |
jreese | it does support time tracking ;) | 09:11 |
FreeAir | also, weighted percentages in the roadmap would go down well | 09:11 |
FreeAir | OOTB? | 09:11 |
FreeAir | to what extent? | 09:11 |
FreeAir | and since when? :-) | 09:11 |
jreese | it's had simple time tracking support in the core since 1.1.x iirc | 09:11 |
jreese | I also wrote a plugin called Timecard that gives a more thorough set of features | 09:12 |
FreeAir | link? | 09:13 |
jreese | by default, mantis only supports tracking how many hours were spent on each issue; with the plugin, you can also give an up-front time estimate, attach a timecard # for each issue, and see some statistics for each project | 09:13 |
jreese | https://github.com/mantisbt-plugins/timecard | 09:13 |
jreese | http://www.mantisbt.org/docs/master-1.2.x/en/administration_guide/admin.config.timetracking.html | 09:14 |
FreeAir | fantastic, i'll look into it | 09:14 |
jreese | http://www.mantisbt.org/docs/master-1.2.x/en/administration_guide/admin.project.timetracking.htmlhttp://www.mantisbt.org/docs/master-1.2.x/en/administration_guide/admin.project.timetracking.html | 09:14 |
jreese | oops, double paste | 09:14 |
*** Quits: asm89 (~asm89@unaffiliated/asm89) (Quit: bye!) | 09:50 | |
*** Quits: Rixie (~Rixie@188.177.20.182) (Quit: Rixie) | 10:53 | |
*** Joins: Rixie (~Rixie@188.177.20.182) | 10:55 | |
*** Quits: soustruh (~Miranda@193.85.226.67) (Quit: visit http://wormscesky.cz) | 12:49 | |
*** Joins: Paul24 (~IceChat09@2001:470:9310:aaaa:1174:d96b:6070:19e3) | 13:53 | |
*** Joins: cerf (~quassel@mcl71-3-78-241-52-239.fbx.proxad.net) | 14:00 | |
*** Quits: cerf (~quassel@mcl71-3-78-241-52-239.fbx.proxad.net) (Remote host closed the connection) | 15:02 | |
*** Joins: [KK]Kirill (~Miranda@195.242.142.17) | 17:05 | |
*** Quits: kirillka (~Miranda@195.242.142.17) (Ping timeout: 245 seconds) | 17:08 | |
*** Quits: dhx1 (~anonymous@60-242-108-164.static.tpgi.com.au) (Remote host closed the connection) | 17:25 | |
*** Quits: Paul24 (~IceChat09@2001:470:9310:aaaa:1174:d96b:6070:19e3) (Quit: Beware of programmers who carry screwdrivers.) | 19:09 | |
*** Quits: sdfjkljkdfsljkl (~sdfjkljkd@static.96.23.63.178.clients.your-server.de) (Remote host closed the connection) | 20:00 | |
*** Joins: sdfjkljkdfsljkl (~sdfjkljkd@static.96.23.63.178.clients.your-server.de) | 20:00 | |
*** Joins: thraxisp (~thraxisp@24-246-27-148.cable.teksavvy.com) | 20:30 | |
*** Joins: kirillka (~Miranda@195.242.142.17) | 20:43 | |
*** Quits: [KK]Kirill (~Miranda@195.242.142.17) (Ping timeout: 248 seconds) | 20:46 | |
*** Joins: ToffeePops (~chatzilla@202.20.3.13) | 22:06 | |
*** Quits: thraxisp (~thraxisp@24-246-27-148.cable.teksavvy.com) (Quit: thraxisp) | 22:33 | |
*** Quits: ToffeePops (~chatzilla@202.20.3.13) (Ping timeout: 260 seconds) | 23:21 |
Generated by irclog2html.py 2.10.0 by Marius Gedminas - find it at mg.pov.lt!