marclaporte: joined #tikiwiki 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.).
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.
03chibaguy r50409 04trunk/styles/bootswatch_themes/options/journal-bootstrap.min - Copy.css * [KIL] Copy of file committed by mistake. chibaguy: joined #tikiwiki marclaporte: joined #tikiwiki Tiki|bot: joined #tikiwiki TomJarvis: Bye Tiki|bot: joined #tikiwiki panamaus: joined #tikiwiki Telesight: joined #tikiwiki redflo: joined #tikiwiki Jyhem_laptop: joined #tikiwiki Odarys: joined #tikiwiki
Hello, I'm trying to upgrade from Tiki-Wiki 3.1 to 9.7 Linh: joined #tikiwiki 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? 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? 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) Tiki|bot: joined #tikiwiki chibaguy: joined #tikiwiki ricks99: joined #tikiwiki 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 ricks99: left #tikiwiki
joined #tikiwiki rodrigoprimo: joined #tikiwiki lukeg: joined #tikiwiki 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 lukeg: joined #tikiwiki lukeg1: joined #tikiwiki 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* 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 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 lphuberdeau: joined #tikiwiki 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'; 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 luciash: polom 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 lukeg: joined #tikiwiki
joined #tikiwiki Tiki-KGB: 03luciash r50413 10branches/12.x/styles/layout/design.css * cleaning up coaboa: joined #tikiwiki Tiki-KGB: 03luciash r50414 10branches/12.x/styles/layout/design.css * [FIX] add subtle shadow to all ui-dialogs for better UX jonnyb: joined #tikiwiki
polom 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 marclaporte: joined #tikiwiki 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?) lukeg: joined #tikiwiki Tiki-KGB: 03lphuberdeau r50417 10trunk/lib/user/monitorlib.php * [FIX] Oops. Re-using variable.
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) Tiki|bot: joined #tikiwiki lukeg: joined #tikiwiki Tiki|bot: joined #tikiwiki Tiki-KGB: 03luciash r50419 10branches/12.x/ 10styles/fivealive/options/orange.css 10styles/fivealive.css * [FIX] fivealive theme: some color fixes for menu items
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) lukeg: joined #tikiwiki Telesight: joined #tikiwiki marclaporte: + 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
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 Jyhem_laptop: Is there something wrong in footnote indexing ?
it seems to bring over plenty of extra references 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
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 lukeg: joined #tikiwiki Tiki-KGB: 03lphuberdeau r50427 10trunk/templates/tracker/replace.tpl * [ENH] Bootstrap classes on tracker replace form
03lphuberdeau r50428 10trunk/ 10(6 files in 4 dirs) * [ENH] Bootstrap classes on import/export/todo forms Tiki|bot: New Forum Posts: Slider plugin adds to URL? - http://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=51557 Robert___: joined #tikiwiki
Hola
alguien habla español?
or english?
necesito hacer unas preguntas
i need to make some questions
hi
please
hello?
someone online?
hi lphuberdeau: don't ask to ask, just ask 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 Jyhem: xavi ?