tikiwiki: 03marclaporte * r31998 10/trunk/robots.txt: adding edit translation page to robot exclusion @SteveC_: No problem with PDFs for my tiki SteveC_: which version do you use? Recent Bug: Tracker item: #3748 - - Unable to find images in gallery when uploaded, using only ID - http://dev.tiki.org/tiki-view_tracker_item.php?trackerId=5&itemId=3748 hi all :-) 02 01@SteveC_ Are you using directory or database? If DB, check the encoding. This is a known issue (see release notes for curupt uploaded files) I am using database I am also using Tiki 6.1 sounds like file corruption due to encoding issues. Great, thanks for the pointer. I had not looked at release notes yet. I do know I migrated the DB to UTF-8 with the last upgrade. 99.99% that is the issue. confirm that 1. all tables in the db are utf-8, that 2. ur mysql connection collation is also utf-8, and 3. that the encoding in your db/local.php is utf-8 (or store file uploads in the file directory instead) the local.php checks out. I'll check the other two as well. I'd considered going to the filesystem, but that will mean the loss of what's in the db though I presume. Tiki can move files from DB < - > directory quite easily. See Admin: File Gallery page hi ricks99 hi luciash hi cgealer chealer r u therE? hi yuchien hi yuchien: are you on Google Talk? I think I added you. Google Talk is XMPP by the way btw, it seems to me that Wysiwyg editor is broken (doesn't show up for me in Opera when i switch from wiki) in trunk (jfyi) + there is no way to switch back to wiki as the whole toolbar is missing too ricks99: In the local.php client_charset='utf8'; and a select from the mysql information_schema shows all tables as utf8 I'm thinking going to filesystem is likely going ot be my best answer at this point. SteveC_: and this problem affects newly uploaded files? could you show us? what is your mysql connection collation set as? Unfortunately the site is supporting my corporate department behind a firewall. How do I check that one? is it for all files, or only certain sizes? I'd be happy to share one of the PDF's in question, but I don't know that would be a big help. I'm not seeing a size distinction, though at the moment we have only identified PDF's with the issue. seems javascript is broken on trunk or something (to me) @SteveC_ on my phpadmin, i have db collation and connection collation. See http://bit.ly/gro8IK uhm, no, sorry how big is the pdf? SteveC_: what are the sizes of the original file and the one fetched from Tiki? Both report as 1.1mb, but let me go check it to the byte. ricks99: The link you sent comes back telling me a "Pufferfish might have eaten the referenced page" I'm using MySQL Workbench to check the DB out. brb, checking exact sizes Interesting, there is about a 100k difference in file size from the originally uploaded file and what comes back down. SteveC_: long URL http://twessentials.keycontent.org/Essential+Installation+Tips there are 2 settings: 1 for the db and 1 for the connection Okay, I just had MySQL Workbench generate a create statement for the database in lieu of being able to find a "connection correlation" specific setting and it comes back with a default character set of latin 1. New Forum Posts: characters replaced with ???????? when saving page - http://tiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=40155 I guess I assumed the tiki migration from latin1 to utf8 during the install handled the DB along with the tables. Man 30 years at this and I still get bit by that assumption thing. your connection is uring the wrong encoding. thats why files are getting corrupt Yep. I understand now, though I would have probably never found it on my own. pls see the upgrade doc for details: http://doc.tiki.org/Upgrade#Fix_the_encoding_issue Actually, I misspoke earlier. I did read the release notes when I was upgrading, just not during this problem investigation. The page your referencing is what started me moving from latin1 to utf8. I did that already. SteveC_: could you show your local.php (leaving out the password if you wish)? Sure. C&P here or by some other means? hm... everything is utf-8 and youre *still* having problems? I'm at a losss :( SteveC_: I don't mind, you can use a pastebin too No no... Maybe I wasn't clear. The database itself is latin1. select * from information_schema.schemata; was very helpful in confirming that. ah. if you change the db to match tiki's local.php and all the tables, should b fine chealer: u r late ;) they already figured out :) lol Oh, I thought chealer was following up another line of thought. So just to confirm, does the "Fix the encoding issue" not update the schema in addition to the tables. If it is supposed to then something went awry. the installer will attempt to fix everything. but ymmv Understood. I thinking adding three verification steps (two information_schema queries, one each for tables and for schema itself) and verifying the local.php setting would be a nice addition to the "Fix encoding" page right before "Congratulations! You are done" I can add this if you like. yes, you are welcome Okay. I'll do it now while it's fresh for me and before I am OBE'ed. I'll actually add it as a "Verification" link so as to not clutter up the instructions. And thank you very much for the assist. glad everything working for you now SteveC_: your issue is solved? I'll verify for certain after updating the doc. Fixed or not, these validation steps are good to have. If I don't update the doc now I'll get lost in something else and never get back. Like my son says, "Dad... FOCUS" :) SteveC_: that's one way to work. SteveC_: the "Fix the encoding issue" should update the schema in addition to the tables. but I believe it can fail quietly I think it did in my case for reasons we will probably never know. SteveC_: probably missing privileges tikiwiki: 03chibaguy * r31999 10/trunk/styles/fivealive.css: tikiwiki: [ENH] Updated Fivealive site header layout rules to retain pre-Tiki 7 appearance tikiwiki: (assumption being that each theme should position the default items according to tikiwiki: its design; overrides are possible on admin-modules page). This file todo: popup tikiwiki: login form, new background image, removal of deprecated rules, etc. Okay, update finished. It's at https://doc.tiki.org/Encode+fix+verification if anyone deeper in the know wants to verify my fix recommendations. tikiwiki: 03chealer * r32000 10/trunk/tiki-contact.php: [FIX] Contact: quiet failure when user lacks tiki_p_messages New Forum Posts: Bare Naked Wikis, Oh My! - http://tiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=40156 Bad news folks. I corrected the schema to be utf8 (and verified) then deleted the previously uploaded file, re-uploaded the file then downloaded the file. It came back as broken. It is in fact the exact same smaller size as the previous broken downloads. I'll probably just drop back to using the filesystem at this point. Seeing as doing so will preclude the ability to troubleshoot further I'll hold off until tomorrow in case this presents an opportunity to investigate. I need to drop off, but I'll check back in the morning to see if anyone wants to dig further before I "destroy the evidence" for to filesystem. Thanks again though all the same. SteveC_: I would still suggest to show your local.php (leaving out the password if you wish) $db_tiki='mysql'; $dbversion_tiki='6.1'; $host_tiki='localhost'; $user_tiki='tikiadmin'; $dbs_tiki='eq_site'; $client_charset='utf8'; SteveC_: that looks good. SteveC_: I'm sending you a non-ASCII file to make sure the issue is encoding chealer: Sorry, was just headed to bed when I heard earlier messages. I'll give that file a try if you send it over. I just uploaded an image and the download worked fine. Then I uploaded an Excel workbook and that downloaded fine. But PDF is still a problem. SteveC_: I was trying to upload with DCC SteveC_: I'm retrying SteveC_: do you get anything? Yes. SteveC_: basically you just need a file with some accent (non English) a plain text file Okay. I'll give this file I go. "Chaîne de caractères" in a .txt file should also work I got your file, but it is zero in size. I'll C&P your characters into a file and upload it. SteveC_: I don't think you got it, my IRC client shows 0% transferred, failure It showed success here. Nope. My bad. Misread it. chealer: A C&P of "Chaîne de caractères" put into a notepad file, saved and then uploaded came back down just fine. I just tried renaming the PDF and then uploading it in case the temp file was just getting reloaded from the server since I made the schema change to udf8 and it is still the same problem. Okay. I really am stepping away for the night. Thanks again. SteveC_: so you got this problem with several PDF files? SteveC_: did you have success with bigger but non-PDF files? New Forum Posts: Daily reports - http://tiki.org/tiki-view_forum_thread.php?forumId=6&comments_parentId=40160 tikiwiki: 03chibaguy * r32001 10/trunk/templates/modules/mod-menu.tpl: [FIX] .clearfix needed to contain contents (so #tiki-top background will display behind menu, etc.). polom hey hey !!! Conishuwa (more or less) konichiwa I think こんにちは Mose long time no see :) indeed Bonjour donc nihao :) Hu ? what is nihao ? nih Assistee par Ordinateur ? it's bonjour in chinese as it's my daily language now Really ? you live in china ? not far, in taiwan for 3 years now MMmm cool ! I have a very good friend that live in china for 3 year now Shanghai taiwan is a bit different but root culture is the same arf… je vous envie a vous balader comme ca…. Children ? none that's why :) that's explain a little :) yes well, all my childrens are in cvs or svn or git repositories hehe LOL… since we talk i have a 19y old, a 3 1/2 girly and one year baby NO WAY i can move like this I can imagine I value my luck But i didn't say my last word… i'm just 47 (in 20 days) after all. Still rock'n'roll... anyway feels good to see you … on irc ???!!!??? lol that's the common way to see people ;) at least in our personal history, isn't it ? yes… there is a Tikifeast in Haifa this august… no way you drop by ?\ hi Yonixxx and mose :-) welcome to this worldwide session ! :) Where are you now ? who me? in chiba, japan, still. Taiwan, Japan, Hong-kong… what a nice trip !… shanghai too... polom all - chibaguy, do you want to chat about themes and stuff? i'm (finally) replying to your mails to the cvs list hi jonnyb hi chibaguy - just back from making more coffee :-) yes, about the themes.... ...what are your thoughts? i was just doing to do an explanation of the fixed_width changes to the devels list - were you happy with how it is now? and that #fixedwidth should be deleted well, the problem is that header isn't getting fixed-widthed. in fivealive, it isn't supposed to. but in other themes it should. yes, but fivealive didn't obey the fixed_width pref anyway? header seems to obey fixed width for me in trunk, not for you? well, fivealive was hardcoded to let header and footer go full-width, but their contents and middle to be fixed width, in line with the original design. re-polom no, it's going full-width for me. I need to check if that's due to something I did, I guess. hi luciash chibaguy: maybe i have some uncommitted stuff locally - also checking footer also is full width. I know I didn't mess with footer yet. in which themes? they're all fixed for me (maybe a browser issue) hi jonnyb, chibaguy, Yonixxx and mose ! :) well, I'm looking at jqui in opera now, arcturus in firefox. seems like they all show the same behavior. I noticed it earlier when working on business and ohia. is it just the background glitch we talk about or something more essential with header and footer in trunk ? hi luciash. I think header and footer aren't getting the fixed-width treatment, at least I don't see it here. but do you mean something even more essential? ;-) luciash: i made some fundamental structural changes in header and footer - just picking up the pieces now... tikiwiki: 03sylvieg * r32002 10/trunk/ (templates/mail/share.tpl tiki-share.php): [FIX]share: change only the mail from if it is the user email or the site email chibaguy: btw, opera is my default "fastest" browser now on my mini again ;) chrome was way too much going nuts with lot of opened tabs and i got annoyed by those "crashed" tabs icons enough ;) yeah, I'm pretty happy with opera now, too. hmmm, opera is just about the only browser i don't "support" fortunately, it works pretty well with tiki now without "support" ;-) chibaguy: yeah, improved a lot, also fonts rendering, tiki css menus issue got fixed "itself" and finally typeface.js works in it now ! yep, and there was a nasty problem with Tiki's textareas in 10.61 or so. tikiwiki: 03sylvieg * r32003 10/branches/6.x/ (templates/mail/share.tpl tiki-share.php): [bp/r32002][FIX]share: change only the mail from if it is the user email or the site email jonnyb: ok, i will make some tests of the fundamental structural changes ;) basically you should be able to set the width for fixed_width mode in look&feel chibaguy: yea, it seems they fixed pretty much everything for us :-p jonnyb: as it was pre-6.x ? jonnyb: ah, u mean in pixels or ems or %, i see no, i don't think there was ever a pref for the width yep, that works but the header is still the same for me just updating http://alcns.net so we can be looking at the same thing - seems to work ok there (fixed width at 900px) i mean i set 75%, middle changes, but header stays at 990px oh, I see, you have div#top_modules made fixed-width. fivealive not div#header hmm yes, we need a container for the whole top area that's full width, and then something inside that's .fixedwidth that's why my theme updates show a header apparently full width. eh, it does 75% for the #top_modules inside the 990px #header :-p yes, becasue that's where you put the stuff to go in the header now - not good? so #top_modules render 742px i'm not sure having a fixed width set to a % will be very reliable - that's sort of fixed but fluid, no? why can't header itself be constrained by fixed-width? I think that would facilitate styling. not good, because #middle renders at 1426px as 75% of the whole browser viewport here which is apparently computing different width compared to header then how would you set a background that needs to be full width? yeah, I was wrestling with that. i thought that #header should be like #middle and #footer stripes going across the whole page yes, fivealive now look broken - was ok yesterday (well, was better, if not perfect) just checking the changes you made chibaguy why not having same layout width css rules for rendering for #header, #middle and #footer ? well, maybe header can be full width, but then there's a shortage a divs for the fixed-width header area. There needs to be two, for eg kubrick and eatlon, IIRC. that's why i added header_container inside it - still need more? header_outer? could do... maybe there are enough. I wasn't understanding the arrangement in my first batch of updates. (was wondering why all the header graphics were full width) looks like you set the width of header in fivealive to be 990px, which will break the new pref won't it? Probably. I didn't know how you had changed the header behavior. sorry, thought i mailed you about it (drowning in emails) I'll have another go, with this info. No problem. can i make the changes i think it needs, then we discuss more? did you add a header_outer div? I see one in trunk. I didn't add any oh right, yes - i see it shall i add an inner one too for bg image positioning? I'm not sure yet, but probably it isn't needed. i'm also going to add a new mode to mod-login_box to do popup properly, so that should appear later today i think the #header needs the same as #middle, so it should be