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