| ←Prev date Next date→ Show only urls | (Click on time to select a line by its url) |
| Who | What | When |
|---|---|---|
| marclaporte | joined #tikiwiki | [00:02] |
| ............. (idle for 1h1mn) | ||
| joined #tikiwiki | [01:03] | |
| ......................... (idle for 2h1mn) | ||
| Tiki-KGB | 03chibaguy r50407 10trunk/styles/bootswatch_themes/options/ 10(12 files)
[ENH] Bootswatch themes updated to Bootstrap 3.1.1 (importantly, they now all contain grid rules, etc.). | [03:04] |
| 03chibaguy r50408 10trunk/styles/bootswatch_themes/options/ 03shamrock-bootstrap.min.css 03lumen-bootstrap.min.css 03darkly-bootstrap.min.css 03cupid-bootstrap.min.css
[NEW] New Bootswatch themes; like the previous ones, released under MIT license. See bootswatch.com for more information. | [03:12] | |
| 03chibaguy r50409 04trunk/styles/bootswatch_themes/options/journal-bootstrap.min - Copy.css * [KIL] Copy of file committed by mistake. | [03:20] | |
| chibaguy | joined #tikiwiki | [03:26] |
| .......... (idle for 49mn) | ||
| marclaporte | joined #tikiwiki | [04:15] |
| Tiki|bot | joined #tikiwiki | [04:20] |
| ...................... (idle for 1h47mn) | ||
| TomJarvis | Bye | [06:07] |
| ........ (idle for 39mn) | ||
| Tiki|bot | joined #tikiwiki | [06:46] |
| ...................... (idle for 1h48mn) | ||
| panamaus | joined #tikiwiki | [08:34] |
| ........ (idle for 37mn) | ||
| Telesight | joined #tikiwiki | [09:11] |
| redflo | joined #tikiwiki | [09:23] |
| ........ (idle for 39mn) | ||
| Jyhem_laptop | joined #tikiwiki | [10:02] |
| Odarys | joined #tikiwiki
Hello, I'm trying to upgrade from Tiki-Wiki 3.1 to 9.7 | [10:02] |
| Linh | joined #tikiwiki | [10:04] |
| Odarys | the old database is encoded in latin1_swedisch_ci
i'm trying to have the new one encoded in UTF8 however no matter what I try, it just doesn't work as expected, eg can't login (probably encoding issues) i've tryd to create latin1_swedisch_ci on the new server, then use the conver option within the tiki installer, but it fails i've also tryd converting it on my own, then important as UTF8, but then I get a duplicated primary key error also having the "force utf8" checked or unchecked in the installer makes no difference whatsoever the moment I click "upgrade the database" it does endup in UTF8 and yet again I face login issues etc. any ideas? | [10:05] |
| Jyhem_laptop | hi Odarys. My first idea would be to dig more into the duplicated primary key error.
Then I wonder why encoding issues prevent login? are there special charactes in logins? in passwords? Does it keep admin from loging? | [10:22] |
| Odarys | bascially it acts asif the password was wrong
so I am assuming that duo to some encoding issues, eg. after the upgrade the db is set as UTF8, but I believe that the password is still stored in latin1_swedich_ci thus when I try to login, it ain't working also this doesn't affect one account, but all of them, and no there are no special chars in the passwords Jyhem_laptop: i'm assuming that the primay key issue arrives, because of some special characters, eg ü so when converting, maybe in utf8 ü u leads to duplicated key also other stuff I tested mysqldump --default-character-set=latin1 --skip-set-charset -d -uroot -p tiki > tiki_schema.sql mysqldump --default-character-set=latin1 --skip-set-charset -t -uroot -p tiki > tiki_data.sql iconv -f iso-8859-1 -t utf8 tiki_schema.sql > tiki_schema_utf8.sql iconv -f iso-8859-1 -t utf8 tiki_data.sql > tiki_data_utf8.sql mysql -utiki -p -e 'CREATE DATABASE tiki DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci' mysql --default-character-set=utf8 -utiki -p tiki < tiki_schema_utf8.sql mysql --default-character-set=utf8 -utiki -p tiki < tiki_data_utf8.sql that's one of many methods that I attempted (tho I know that using iconv is a bad idea, because the binary data gets corrupted) (but I would fix that later on, if only everything else worked) | [10:34] |
| ............ (idle for 55mn) | ||
| Tiki|bot | joined #tikiwiki | [11:35] |
| chibaguy | joined #tikiwiki | [11:42] |
| ......... (idle for 43mn) | ||
| ricks99 | joined #tikiwiki | [12:25] |
| Tiki-KGB | 03jonnybradley r50410 10branches/12.x/lib/init/smarty.php
[FIX] title: Don't use route.php to guess the browser title (which always comes out as "Route"), but use the actual tiki-*.php file (in var $inclusion) instead | [12:38] |
| ricks99 | left #tikiwiki | [12:40] |
| joined #tikiwiki | [12:50] | |
| ....... (idle for 34mn) | ||
| rodrigoprimo | joined #tikiwiki | [13:24] |
| .... (idle for 19mn) | ||
| lukeg | joined #tikiwiki | [13:43] |
| Jyhem_laptop | Odarys: sorry, got involved in real work and forgot.
I feel iconv is not going to work, especially with binary fields and possibly with passwords the real way we use can be seen in : doc/devtools/fix-encoding.php also, you may want to look at the SQL section of /tiki-check.php | [13:51] |
| lukeg | joined #tikiwiki | [14:03] |
| lukeg1 | joined #tikiwiki | [14:07] |
| Odarys | Jyhem so I actually got it to the point, where the converting offered in the install page passes with flying colors
eg. export and import with --default-character-set=latin1, also the newdb is created as latin1_swedisch_ci then I go as instructed in the upgrade instructions eg. keep force utf8 checked then use the convert, then when it disappears (after converting) I use the upgrade database.. and then in the end I choose latin1 and fix double encoding also while using upgrade database, I'm getting a ton of "already exists" sql errors (50?) but in the end, after doing all that, I still can't login with my user/pw :/ Jyhem_laptop* | [14:08] |
| Tiki-KGB | 03lphuberdeau r50411 10trunk/lib/ 10(9 files in 5 dirs)
[FIX] Features with dynamic event bindings could lock out users and have less than desirable consequences on database schema errors, make sure they let issues be resolved | [14:12] |
| Tiki|bot | New Forum Posts: new structure page not visible at module - http://tiki.org/tiki-view_forum_thread.php?forumId=6&comments_parentId=51548 | [14:19] |
| ..... (idle for 20mn) | ||
| lphuberdeau | joined #tikiwiki | [14:39] |
| Jyhem_laptop | Odarys: I think the «ton of "already exists" sql errors» can be ignored
why do you «choose latin1 and fix double encoding» in the end ? Does it solve an issue ? It occurs to me that if you have accented chars or such in your password, no converting will solve this, as they are not stored. Only their hashes are stored (that is a security feature so nobody can get your password from the database dump) You might just want to change your password using "I lost my password", or the SQL command like UPDATE users_users SET hash= md5('yourpassword') WHERE login='yourlogin'; | [14:39] |
| Tiki-KGB | 03luciash r50412 10branches/12.x/lib/wiki-plugins/wikiplugin_slideshow.php
[FIX] added missing "none" and "default" theme options to the Slideshow wikiplugin dropdown | [14:56] |
| luciash | polom | [14:58] |
| Odarys | Jyhem_laptop no
actually I'm back at the point where the converting ain't working so The schema has UTF-8 as default encoding but some tables in the schema have a different collation, latin1_swedish_ci. that's the error I get when trying to conver via the option in the installer | [14:59] |
| lukeg | joined #tikiwiki | [15:06] |
| ..... (idle for 24mn) | ||
| joined #tikiwiki | [15:30] | |
| .... (idle for 18mn) | ||
| Tiki-KGB | 03luciash r50413 10branches/12.x/styles/layout/design.css * cleaning up | [15:48] |
| coaboa | joined #tikiwiki | [15:57] |
| Tiki-KGB | 03luciash r50414 10branches/12.x/styles/layout/design.css * [FIX] add subtle shadow to all ui-dialogs for better UX | [15:58] |
| jonnyb | joined #tikiwiki
polom | [16:10] |
| Tiki-KGB | 03luciash r50415 10branches/12.x/styles/fivealive.css
[FIX] fivealive theme: avoid bg contrast issue when topbar_modules menu wraps on two lines and better positioning of the search module there | [16:16] |
| marclaporte | joined #tikiwiki | [16:18] |
| Tiki-KGB | 03jonnybradley r50416 10(15 files in 13 dirs)
[MRG] Automatic merge, branches/12.x 50383 to 50415 Conflict fixed in tiki-slideshow.php (please check Luci?) | [16:28] |
| lukeg | joined #tikiwiki | [16:33] |
| Tiki-KGB | 03lphuberdeau r50417 10trunk/lib/user/monitorlib.php * [FIX] Oops. Re-using variable. | [16:38] |
| 03jonnybradley r50418 10branches/12.x/lib/wiki-plugins/wikiplugin_articles.php
[MOD] articles plugin: Set max per page to a sensible default (maxRecords pref) and remove dependency on pagination to avoid memory outage by default (seems there had been an attempt at this before but the var $countPagination was set conditionally but subsequently unused) | [16:48] | |
| Tiki|bot | joined #tikiwiki | [17:00] |
| lukeg | joined #tikiwiki | [17:04] |
| Tiki|bot | joined #tikiwiki | [17:05] |
| Tiki-KGB | 03luciash r50419 10branches/12.x/ 10styles/fivealive/options/orange.css 10styles/fivealive.css * [FIX] fivealive theme: some color fixes for menu items | [17:06] |
| 03lphuberdeau r50420 10trunk/lib/goal/eventlib.php * [FIX] Notices
03jonnybradley r50421 10branches/12.x/ 10lib/wiki-plugins/wikiplugin_articles.php 10templates/tiki-view_articles-titleonly.tpl 10templates/tiki-view_articles.tpl [ENH] articles plugin: Param to allow using the "linkto" source URL to be used for articles - enables external feeds to be managed using the articles generator but still linking them to the original feed URL 03jonnybradley r50422 10(6 files in 5 dirs) [MRG] Automatic merge, branches/12.x 50415 to 50421 Conflict resolved on styles/fivealive/options/orange.css using 12.x version (Luci please check, thanks) | [17:12] | |
| lukeg | joined #tikiwiki | [17:29] |
| .... (idle for 17mn) | ||
| Telesight | joined #tikiwiki | [17:46] |
| .... (idle for 15mn) | ||
| marclaporte | + | [18:01] |
| .......... (idle for 45mn) | ||
| Tiki-KGB | 03robertplummer r50423 10branches/experimental/ 10wikiLingo/lib/wikiLingo_tiki/WikiEvents.php 10wikiLingo/composer.lock * [FIX] Ensure that json can be traversed, s it might be an associative array | [18:46] |
| ......... (idle for 40mn) | ||
| 03lphuberdeau r50424 10trunk/ 10templates/tiki-list_trackers.tpl 10lib/core/Services/Tracker/Controller.php 10templates/tracker/import_profile.tpl * [ENH] Move imports to dialogs, fix errors in templates, javascript | [19:26] | |
| ........ (idle for 35mn) | ||
| Jyhem_laptop | Is there something wrong in footnote indexing ?
it seems to bring over plenty of extra references | [20:01] |
| Tiki-KGB | 03lphuberdeau r50425 10branches/12.x/ 03lib/core/Tiki/Profile/SymbolLoader.php 10lib/tikilib.php 10tiki-setup.php * [ENH] Add a way to access the profile symbols from within templates | [20:10] |
| 03lphuberdeau r50426 10trunk/lib/tikilib.php 03trunk/lib/core/Tiki/Profile/SymbolLoader.php 10trunk/tiki-setup.php 10trunk * [MRG] Automatic merge, branches/12.x 50421 to 50425 | [20:24] | |
| lukeg | joined #tikiwiki | [20:31] |
| .... (idle for 19mn) | ||
| Tiki-KGB | 03lphuberdeau r50427 10trunk/templates/tracker/replace.tpl * [ENH] Bootstrap classes on tracker replace form | [20:50] |
| ......... (idle for 40mn) | ||
| 03lphuberdeau r50428 10trunk/ 10(6 files in 4 dirs) * [ENH] Bootstrap classes on import/export/todo forms | [21:30] | |
| Tiki|bot | New Forum Posts: Slider plugin adds to URL? - http://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=51557 | [21:32] |
| ............ (idle for 58mn) | ||
| Robert___ | joined #tikiwiki
Hola alguien habla español? or english? necesito hacer unas preguntas i need to make some questions hi | [22:30] |
| .... (idle for 15mn) | ||
| please
hello? someone online? | [22:51] | |
| hi | [23:04] | |
| lphuberdeau | don't ask to ask, just ask | [23:17] |
| ....... (idle for 33mn) | ||
| Robert___ | i´m the webmaster of ciudadpolitica.org
i use xoops and im investigating about new cms to use please see my site and help me about the aplication of tikiwiki the migration | [23:50] |
| Jyhem | xavi ? | [23:57] |
| ←Prev date Next date→ Show only urls | (Click on time to select a line by its url) |