fabricius: cool
so after two days nonstop I have to restart
brb
redflo1: joined #tikiwiki
rodrigoprimo: joined #tikiwiki
Tiki|bot: Recent Bug: Tracker item: #4271 - - Not possible to comment a tracker entry - Tiki 8.4 - http://dev.tiki.org/item4271
goj_killedByISP: joined #tikiwiki
yanick_: joined #tikiwiki
hi, how do I upgrade from 7.1 to 9.x ?
when I check for upgrade, it tells me I'm up-to-date
goj_killedByISP: joined #tikiwiki
CIA-75: tikiwiki: 03chibaguy * r42519 10/branches/9.x/templates/comment/list.tpl: [ENH][bp/r42517] Increased heading size of comment title to distinguish it from body text; moved avatar out of post body. Todo: CSS improvements.
tikiwiki: 03chibaguy * r42520 10/branches/9.x/styles/layout/design.css: [FIX] [bp/r42516, 42517] An ordered list is used to display comments, but they shouldn't be numbered. Article comments don't need to be indented by default.
yanick_: hi, how do I upgrade from 7.1 to 9.x ?
jjgoth: amette: I couldn't send to the devel list
jacmoe: joined #tikiwiki
xavi: joined #tikiwiki
redflo: joined #tikiwiki
dennmans: joined #tikiwiki
wu-lee: joined #tikiwiki
hello, I'm running into encoding issues having upgraded 1.8 ----> 9.0
the Mysql DB appears to be utf-8 encoded correctly now, judging by my checks
but certain characters are rendered in webpages with "garbage" characters prefixing them
local.db says $client_charset='utf-8'
s{local.db}{db/local.php}
oddly if I set it to latin1, it appears to fix the rendering, but this seems reverse to what I'd expect
HTTP and HTML headers both say utf-8
I suspect something inside tiki is double-encoding the utf-8 text from mysql
xavi: wu-lee, see the doc page for upgrade, specially the section about encodin issues
there was a change between 5.0 and 5.1
-: xavi fetching a url for you....
changi_: joined #tikiwiki
panamaus: joined #tikiwiki
xavi: mmmm, the doc page is not loading for me right now: http://doc.tiki.org/Upgrade
vmachine: joined #tikiwiki
jacmoe: joined #tikiwiki
joined #tikiwiki
wu-lee: xavi: thanks, although I've read all that quite carefully
one nit I discovered: one table wasn't being converted to utf8 and it continually triggered the "something is wrong" warning in the tiki-install.php wizard
the tiki_search_stats table contained characters in "term" which create duplicates when the table is converted from latin1 to utf8
which prevented the upgrade from completing the job
I needed to force the issue by doing it manually, using 'ALTER IGNORE TABLE ...'
the warning is gone, but my pages stil render wrongly
CIA-75: tikiwiki: 03chibaguy * r42521 10/trunk/templates/article.tpl: [FIX] Break tag isn't needed because preceding element is block level, and it causes unwanted white space.
wu-lee: I think it may be because my php.ini settings for character_set_client are unset, causing a latin1 default
hunting for ways to override in on a my shared hosting
jacmoe: joined #tikiwiki
xavi: wu-lee: I suggest that you follow at least once, the 3 steps indicated here: http://doc.tiki.org/Upgrade#If_you_need_to_fix_the_encoding_issue
wu-lee: xavi: yep, more than once
xavi: from your 1.8 tiki site (without manually touching anything)
in the same server where the 1.8 site is (in the same mysql, I mean)
wu-lee: the final step (correcting double encoding) didn't seem to be an option offeret to me
marclaporte: joined #tikiwiki
wu-lee: I've actually had to upgrade in several steps
xavi: hack the php installer file if needed to have that option shown for you
wu-lee: 1.8 -> 1.9 -> 3.9 -> 6.7 -> 9.0
because of a bug in the 9.0 installer, I think
xavi: did 6.7 work for y ou?
marclaporte: polom
wu-lee: this worked, yes
xavi: the strong issue used to be between 5.0 (or before) and 5.1 (or after)
wu-lee: (I'm looking for the reference)
xavi: then, no idea. Refer (when asking for help) then to a problem in the upgrade from 6.7 to 9.0
marclaporte: wu-lee: I suggest you use 9.1 from daily build
xavi: to avoid considering many potential source of enconding problem when upgrading to version 6 or so.
marclaporte: Tiki 1.8 (2004-02-08) to 9.1 (http://dev.tiki.org/Daily+Build#x_2)
(quite an upgrade!)
xavi: From 6 to 9, there shouldn't be many (any?) issues regarding wrong encoding chars (there were just some issues with html entities, but apparently fixed)
wu-lee: "Fatal error: Call to a member function query() on a non-object in lib/profilelib/installlib.php
on line 115"
looks like this to me: http://tikiwiki.svn.sourceforge.net/viewvc/tikiwiki?view=revision&revision=42327
that just prevented the installer from completing
xavi: ah, ok
wu-lee: the encoding was another issue
RobertPlummer: joined #tikiwiki
xavi: so follow marclaporte 's advice
marclaporte: wu-lee: what happens if you go directly from 1.8 to 9.1?
wu-lee: ok, I did look for a newer release but it wasn't on the downloads page
marclaporte: 9.1 will be released this month
wu-lee: i didn't know where else to go offhand, but decided that anything newer was potentially adding risks to something already problematic
the upgrade docs say explicitly that 1.8 can't be upgraded to anything above 1.9
so I first tried 1.8 -> 1.9 -> 9.0
marclaporte: ah? do you remember which page?
wu-lee: and hit the "non-object" error above
marclaporte: Let's prove that doc incorrect and we'll fix it :-)
wu-lee: yes, it's here: http://doc.tiki.org/Upgrade#Determine_the_version_of_your_current_Tiki
xavi: well guys, I have to leave (urgent work to finish for today)
cheers
left #tikiwiki
-: marclaporte checks
marclaporte: That sentence seems illogical (and I have a feeling I am the author!)
"If your current Tiki is less than 1.9.0Tiki 1.9.0 was released on 2005-04-27 so it's highly unlikely that you still are running one. Older data upgrades scripts were removed from Tiki but are still available to download.
: You need to upgrade to 1.8 first: Upgrade 1.7 to 1.8 and then, Upgrade 1.8.x to 1.9.y (do not upgrade directly from 1.7.x to 1.9.x or later)"
wu-lee: the "fix the encoding issue" here http://doc.tiki.org/Upgrade#If_you_need_to_fix_the_encoding_issue
also ran into a problem in the 9.0 installer (as mentioned above, repeating for marclaport's benefit)
because tiki_search_stats had a duplicated key when converted from latin1 -> utf8
I needed to "ALTER IGNORE TABLE ..." to resolve that, and then I got through the 3 steps without the "something is wrong with your encoding" warning
although there was no option in step three to "fix double encoding"
I'm pretty sure my database is now utf8 both in declaration and content
and HTTP/HTML headers say utf-8 is in use
and phpinfo() tells me I've managed to set al the php.ini parameters described here http://doc.tiki.org/UTF-8#PHP_in_association_with_a_web_server
marclaporte: wu-lee: Tiki 9.x contains SQL code to upgrade from 1.8: http://tikiwiki.svn.sourceforge.net/viewvc/tikiwiki/branches/9.x/db/tiki_1.8to1.9.sql?revision=42521&view=markup
wu-lee: ok - we live and learn I suppose :)
marclaporte: Can I ask you a favor?
wu-lee: although I suspect it'd still run into the "non-object" bug
marclaporte: Can you try an upgrade from 1.8.x to 9.1 (from daily build) in one shot?
wu-lee: ask away, I can always say no :)
marclaporte: hehe
wu-lee: hm, I might try, but i do have to try and fix the encoding
is that likely to help?
marclaporte: yes, fix the encoding as the last step of 9.x upgrade
wu-lee: ok, but I've already completed the last step
marclaporte: sure, just try again on your initial backup
on a copy
and then, you can compare both
-: wu-lee sighs
wu-lee: "oh no not again"
can I ask one question first tho?
marclaporte: sure!
wu-lee: if I set $client_charset = 'latin1' in db/local.php the pages render apparently correctly
marclaporte: right
wu-lee: $client_charset = 'utf-8' doesn't
I suspect tiki's connection to the DB is using latin1
marclaporte: so you can stay in latin1 and not run the converter, or move to utf8 and run the converter
wu-lee: I've run the converter, I'd prefer utf-8
marclaporte: I agree
How many wiki pages do you have (approx)
wu-lee: so what controls the mysql connection encoding setting?
hm
not my wiki, "lots", mostly articles tho
site's been around a long time
marclaporte: ok
dhazel: joined #tikiwiki
wu-lee: marclaporte: I'm going to have to take a short break to eat something, before I do any more upgrading
marclaporte: ok :-)
wu-lee: never mind
I will update the doc to be clearer
vmachine: left #tikiwiki
benoitg: joined #tikiwiki
sandroandrade: joined #tikiwiki
wu-lee: marclaporte: just doing the 1.8 -> 9.0 now... is there anything specific you want to know?
marclaporte: it won't work, sorry
1.8->1.9->9.1 should work
you don't need to install 1.9.x though
wu-lee: oh, ok
marclaporte: you can manually run 1.8.x to 1.9.x though: http://doc.tiki.org/Upgrade+1.8.x+to+1.9.y
wu-lee: I've followed that already, i think
right at the beginning
I started 1.8 -> 1.9.11 -> 9.0
marclaporte: that was perfect
except that it crashed?
wu-lee: there were still encoding issues I think, but the showstopper was the bug I referred to above,
13:58 < wu-lee> "Fatal error: Call to a member function query() on a non-object in lib/profilelib/installlib.php
13:58 < wu-lee> on line 115"
13:58 < wu-lee> looks like this to me: http://tikiwiki.svn.sourceforge.net/viewvc/tikiwiki?view=revision&revision=42327
13:58 < wu-lee> that just prevented the installer from completing
marclaporte: right, so that will be fixed in 9.1
wu-lee: So I tried 1.8 -> 1.9.11 -> 3.9 -> 9.0
ditto
marclaporte: The doc says: "However, if you are having trouble with a database upgrade of anything prior to 3.0 (so including 1.9 and 2.0, especially if it started life before 1.9) it is recommended you upgrade to 3.x (currently 3.8) first, and then to your final version." I want to remove that if it's confirmed
wu-lee: then 1.8 -> 1.9.11 -> 3.9 -> 6.7 -> 9.0
that one finally worked without the error
marclaporte: oh, I see
So you are all good now?
wu-lee: nope
encoding problems
marclaporte: hmmm
is your site public?
wu-lee: old site is here: http://railfuture.co.uk/
new site being built here: http://testing.railfuture.org.uk <-- currently mid install
the first issue I hit is always "Something is wrong with the database encoding. The schema has UTF-8 as default encoding but some tables in the schema have a different collation, latin1_swedish_ci. Converting to UTF-8 may solve this but may also make matters worse."
marclaporte: Site is closed for maintainance; please come back later.
wu-lee: oh yes
marclaporte: Does site have anything else than English?
wu-lee: hm, maint mode should be off. admin panel says it is
The site is in English, ye
s
nothing else
marclaporte: so can I see encoding issues?
wu-lee: not in the old site
the new site does (when I get it back)
symbols like £ and non-ascii quotes, apostrophes, things like that
marclaporte: right
wu-lee: two-trains-each-way ââ¬Åserviceââ¬Â to
is one example
marclaporte: ok, that confirms
so you did the UTF-8 fix in the installer and that didn't fix it?
wu-lee: yes. it tried, but I think it didn't quite complete the job
marclaporte: error message? timeout? blank page?
wu-lee: sorry, just preparing a paste
here are some more detailed notes http://pastebin.com/SL6Z9iFp
basically, no errors shown, but the warning remains, despite clicking the "convert database and tables to utf-8" button several time
the reason is explained in the paste
to summarise I think the UTF-8 conversion worked, bar one table, which was easily fixed
but the output remained broken
http headers state content is utf-8, as does html souce
source
marclaporte: just to confirm that 1.8 -> 9.0 doesn't work, I tried it
it doesn't, but it seems to fail with the same error I had when I upgraded via 1.9 (and 1.9 and 3)
on upgrading I get a blank screen with the error: "Fatal error: Call to a member function query() on a non-object in lib/profilelib/installlib.php on line 115"
marclaporte: the (semi-)successfully upgraded 9.0 site is now back up http://testing.railfuture.org.uk/
an example of a page exhibiting the encoding problems is: http://testing.railfuture.org.uk/tiki-read_article.php?articleId=1293
is there a minimal example of some tiki code which will get some (utf-8) text out of the tiki database anywhere?
(i.e. in the same way tiki does it)
benoitg: joined #tikiwiki
sandroandrade: joined #tikiwiki
Tiki|bot: New Forum Posts: Favicon only works on server - http://tiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=44453
marclaporte: wu-lee: I clarified the docs: https://doc.tiki.org/Upgrade#Determine_the_version_of_your_current_Tiki
wu-lee: check installer/tiki-installer.php function convert_database_to_utf8 and function fix_double_encoding
-: marclaporte reads wu-lee's paste
marclaporte: en_gb: yes, you may very well be right. Someone from that part of the world should look into this :-)
wu-lee: I've noticed my locale seems to revert to plain "en"
marclaporte: "However, the documentedoption to "fix double encoding" isn't an option." -> You should see this at the last last step
wu-lee: do you PHP^
Do you code PHP?
wu-lee: I have a hint
re-run the installer, but go step by step
On the last step, you should see: "Upgrading and running into encoding issues? We can try to fix it, but make sure you have backups, and can restore them."
And if you go the installer but skip some steps, it doesn't appear (that is what I just experienced on http://demo.tiki.org/9x/tiki-install.php)
wu-lee: Hm
I did look for that
I don't think I skipped any steps at all
here's what I'm wondering: the text in the database appears to be utf8, I can access it using MySQL and it looks perfect
and yet the web page, which is also utf8, appears to contain garbage
marclaporte: I am making you a screencast
http://demo.tiki.org/trunk/wu-lee
wu-lee: thanks
-: wu-lee goes to look
marclaporte likes dogfooding/showing off the new Tiki Screencast feature :-)
marclaporte: db/local.php probably needs to be UTTF-8 for this to work
wu-lee: right, so I can tell you I did more or less what you did, and skipped *fewer* steps :)
the upgrade docs say that you should not use the default db connection, I think
..checking
It says "Even if you have a local.php file already there, click on "Modify database connection" instead of "Use Existing Connection". "
here http://doc.tiki.org/Upgrade#If_you_need_to_fix_the_encoding_issue
so I clicked "Modify database connection" and set the information there
I was then told in a warning "something is wrong with your encoding"
marclaporte: ok, can you try what I did?
wu-lee: I don't think I'd be able to even if I tried
because I get a warning you don't
marclaporte: ah
wu-lee: about "something is wrong"
and the suggestion course of action is to convert the database content
which (silently) doesn't completely work
marclaporte: ok, can you try just to rule this out?
wu-lee: the warning won't go away
marclaporte: what is exact warning?
wu-lee: and if I ignore it and continue, there's no option to "fix dobule encoding"
the warnign says: "Something is wrong with the database encoding. The
schema has UTF-8 as default encoding but some tables in the schema
have a different collation, latin1_swedish_ci. Converting to UTF-8 may
solve this but may also make matters worse. You should investigate
what happened or only proceed with backups."
marclaporte: which tables?
wu-lee: it doesn't say, but initially, all of them
they're all latin1
marclaporte: which version of MySQL do you have?
wu-lee: then after clicking "convert..." all but one are utf8
marclaporte: tiki_search_stats
wu-lee: mysql Ver 14.14 Distrib 5.1.63, for unknown-linux-gnu (x86_64) using readline 5.1
marclaporte: any data in tiki_search_stats ?
wu-lee: yep tiki_search_stats
yep, lots
including lots of non-ascii
apparently
marclaporte: Any way we could ignore it for testing purposes?
make a backup DB, and delete that table, and we see if you'll then have double encoding fix available?
wu-lee: ok, I'll try that
marclaporte: also would be interesting to see if you ask MySQL or phpMyAdmin to convert tiki_search_stats
wu-lee: one question: should I create the fresh database with urf8 or latin1 defaults?
I converted tiki_search_stats with MySQL
marclaporte: utf-8 since you aleady converted
wu-lee: and should I start from the tiki-6.7 version?
I guess I have to
marclaporte: sure
http://testing.railfuture.org.uk/tiki-index.php?page=cookies coming to Tiki10: http://tikiwiki.svn.sourceforge.net/viewvc/tikiwiki?view=revision&revision=42231
wu-lee: right, good news, it seems to have worked as your screencast did
thank you
(I copied your steps and didn't modify the DB connection, I am not sure if that is significant)
the main extra thing is that the "something is wrong with your encoding" warning appeared
this time, however, it succeeded and disappeared after I clicked "Covert...."
finally, the option to fix double encoding was there, which I think was what really did the job
result: http://testing.railfuture.org.uk/tiki-read_article.php?articleId=1293
no garbgage
marclaporte: great!
wu-lee: I am wondering why the apparently double-encoded text looked perfect when rendered using the mysql command line?
marclaporte: dunno
wu-lee: (ironically, it now looks encoded)
marclaporte: so what about tiki_search_stats ?
wu-lee: mysql> delete from tiki_search_stats;
Query OK, 536262 rows affected (0.01 sec)
marclaporte: so maybe you can re-instate and see what happens
wu-lee: that's a lot of stats. blown away now. utf8_unicode_ci fields
re-instate tiki_search_stats?
marclaporte: well, do you want to use that data?
it was blocking your upgrade, but maybe tiki_search_stats with messed up accents is better than being empty
wu-lee: I suspect no-one used it and it was a big pile of spambot-generated poo-poo
I'll ask the users
I can re-instate it later i presume? (i.e. nothing else relies on it?)
re. cookies: thanks, hadn't noticed that.
I think the next thing to do is take a pain killer and go lie down for a bit
if only I didn't have to go out.
marclaporte: thank you very much I owe you a drink
ttfn
vmachine: joined #tikiwiki
marclaporte: I'll have a pale ale :-)
vmachine: joined #tikiwiki
joined #tikiwiki
redflo: joined #tikiwiki
Sp4rKy: joined #tikiwiki
mjeanson: joined #tikiwiki
DarkCalf: joined #tikiwiki
changi_: joined #tikiwiki
marclaporte: joined #tikiwiki
redflo: joined #tikiwiki
vmachine: joined #tikiwiki
sandroandrade: joined #tikiwiki
benoitg: joined #tikiwiki
dhazel: joined #tikiwiki
panamaus: joined #tikiwiki
g0th: joined #tikiwiki
Caarrie|away: joined #tikiwiki
goth: joined #tikiwiki
CIA-75: joined #tikiwiki
Tiki|bot: joined #tikiwiki
RobertPlummer: joined #tikiwiki
blast_hardcheese: joined #tikiwiki
vmachine: joined #tikiwiki
blast_hardcheese: joined #tikiwiki
dennmans: joined #tikiwiki
vmachine: joined #tikiwiki
joined #tikiwiki
marclaporte: joined #tikiwiki
Tiki|bot: New Forum Posts: Party Dresses - http://tiki.org/tiki-view_forum_thread.php?forumId=24&comments_parentId=44472
New Forum Posts: tiffany sets online - http://tiki.org/tiki-view_forum_thread.php?forumId=23&comments_parentId=44471
New Forum Posts: Versace - http://tiki.org/tiki-view_forum_thread.php?forumId=22&comments_parentId=44470
vmachine: joined #tikiwiki
Tiki|bot: New Forum Posts: Vacheron Constantin watches - http://tiki.org/tiki-view_forum_thread.php?forumId=16&comments_parentId=44485
New Forum Posts: panerai for sale - http://tiki.org/tiki-view_forum_thread.php?forumId=15&comments_parentId=44484
New Forum Posts: Prada Sunglasses online - http://tiki.org/tiki-view_forum_thread.php?forumId=14&comments_parentId=44483
New Forum Posts: Christian Louboutins Flats cheap - http://tiki.org/tiki-view_forum_thread.php?forumId=23&comments_parentId=44491
New Forum Posts: Paul Smith Briefcases online - http://tiki.org/tiki-view_forum_thread.php?forumId=22&comments_parentId=44490
New Forum Posts: tiffany accessories - http://tiki.org/tiki-view_forum_thread.php?forumId=20&comments_parentId=44489
vmachine: joined #tikiwiki
Jyhem: is there a way of mass-removing forum posts ? Like all from 44454 to 44491 ?
vmachine: joined #tikiwiki
amette: jjgoth: apparantly you managed to write to devel-list - and it didn't take half a day to get quite good answers - looking forward to you testing what Louis-Philippe suggested !! :)
Tiki|bot: joined #tikiwiki