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