<!-- Some styling for better description lists --><style type='text/css'>dt { font-weight: bold;float: left;display:inline;margin-right: 1em} dd { display:block; margin-left: 2em}</style> ***: mike_hurley_1 has quit IRC (Quit: Page closed) <br> Caarrie is now known as Caarrie|sleeping <br> goj|ghost has joined #tikiwiki <br> goj has quit IRC (Ping timeout: 272 seconds) <br> goj|ghost is now known as goj <br> chahn has joined #tikiwiki chahn: hi everybody :) <br> I think that the brocken character problem in my tiki's i18n was caused by collation of the table. Why did my tiki tables'collation become latin1_swedish_ci? <br> All korean, japanese characters I input become '???' :( ***: coaboa_ has joined #tikiwiki <br> coaboa has quit IRC (Ping timeout: 245 seconds) ricks99: @chahn: what is specified in your ../db/local.php file? chahn: hi ricks99, $client_charset='utf8'; ricks99: not sure what would have changed ur db tables <br> try changing them to utf to match <br> b sure to backup first chahn: ricks99, Thanks for letting me see the local.php file. I did'nt know it tells about UTF related link (http://doc.tiki.org/UTF-8). I will read and try to change tables after reading mysql manual. CIA-69: tikiwiki: 03sept_7 * r29618 10/trunk/tiki-jsplugin.php: [FIX] sanitize input... ***: chahn_ has joined #tikiwiki <br> chahn has quit IRC (Ping timeout: 252 seconds) <br> ripero has joined #tikiwiki CIA-69: tikiwiki: 03sept_7 * r29619 10/branches/6.x/tiki-jsplugin.php: [FIX/bp 29618] Sanitize input <br> tikiwiki: 03sept_7 * r29620 10/branches/proposals/5.x/tiki-jsplugin.php: [FIX/bp 29618] Sanitize input ripero: hello <br> today I upgraded from 4.x to 5.2, and I am no longer able to edit or create file galleries <br> is this a known issue? ricks99: did you receive any sql errors during the upgrade? ripero: no <br> well, I think not ricks99: what type of error message do you get when you try to creaet a new file gallery? ripero: Unknown column 'show_lastDownload' in 'field list' <br> and other mysql stuff (the query, the values, etc) ricks99: your db did not get installed/updated properly it seems. try re-running the installer. be sure to selct the UPGRADE option <br> confirm that no sql errors are reported ripero: ok <br> I did select the upgrade option <br> and the next screen I remember didn't have any "strange (mysql) output", that I remember <br> but I'll try again from the backup ***: ttrimm has joined #tikiwiki ricks99: the upgrade will show # of successful and unsucesssful sql queries ripero: Upgrade operations executed successfully: 5161 SQL queries. <br> no unsuccessful sql queries are reported chahn_: hi ttrimm :) ttrimm: Hi chahn_ chahn_: I couldn't solve my i18n problem so I couldn't make time to visit your site again and send you comment, sorry. <br> ttrimm, did you decide what to write about? ttrimm: not yet. no problem at all. chahn_: ok :) ripero: <u>ricks99</u>: the problem with the file galleries is also present now ***: ricks99 is now known as ricks99|away CIA-69: tikiwiki: 03luciash * r29621 10/branches/6.x/tiki-edit_perspective.php: missing head title ricks99|away: @ripero: i'm not sure then. :-( on my 5.2 sites, file galleries work fine. <br> you might want to post in the spport forum ripero: ok, thanks for the info chahn_: ripero, I am sorry if I interrupted you. ripero: <u>chahn_</u>: don't worry at all :) chahn_: ok :) ripero: It seems the error had been previously reported in the forums for the 4.3 -> 5.1 upgrade CIA-69: tikiwiki: 03luciash * r29622 10/branches/6.x/tiki-edit_languages.php: missing head title ***: ttrimm has quit IRC (Quit: Later Folks!) <br> chahn__ has joined #tikiwiki <br> ripero has left <br> chahn_ has quit IRC (Ping timeout: 264 seconds) <br> fabricius has joined #tikiwiki <br> fabricius has quit IRC (Ping timeout: 276 seconds) <br> lucks has quit IRC (Ping timeout: 240 seconds) <br> lucks has joined #tikiwiki <br> lucks has quit IRC (Excess Flood) <br> lucks has joined #tikiwiki <br> lucks has quit IRC (Ping timeout: 240 seconds) <br> lucks has joined #tikiwiki <br> ricks99 has joined #tikiwiki <br> ricks99|away has quit IRC (Ping timeout: 245 seconds) CIA-69: tikiwiki: 03pkdille * r29623 10/branches/6.x/lib/jquery_tiki/tiki-jquery.js: [bp/r29589] [FIX] Solve bugs of variables 'undefined is null or not object' at unloading of the page with IE <br> tikiwiki: 03chibaguy * r29624 10/mods/trunk/themes/planetfall_tiki_5/ (26 files in 8 dirs): [NEW] Planetfall theme updated for Tiki 5. ***: redflo has joined #tikiwiki CIA-69: tikiwiki: 03chibaguy * r29625 10/mods/trunk/themes/planetfall_tiki_5/styles/planetfall.css: Correct planetfall.css file this time. <br> tikiwiki: 03chibaguy * r29626 10/mods/trunk/themes/planetfall_tiki_5/styles/planetfall.css: [FIX] Text color without bg color caused contrast problem. ***: fabricius has joined #tikiwiki <br> chahn__ has quit IRC (Quit: Leaving) CIA-69: tikiwiki: 03chibaguy * r29627 10/mods/trunk/themes/planetfall_tiki_5/styles/planetfall.css: [FIX] Another text/bg contrast problem. ***: Andurino has joined #tikiwiki <br> chahn has joined #tikiwiki CIA-69: tikiwiki: 03minger0 * r29628 10/branches/6.x/lib/wiki-plugins/wikiplugin_back.php: [FIX] added ~np~ to the wikiplugin_back <br> tikiwiki: 03sept_7 * r29629 10/trunk/tiki-edit_wiki_section.php: [FIX] sanitize input, dont process inputs before tiki-setup.php ! :( <br> tikiwiki: 03sept_7 * r29630 10/branches/proposals/5.x/tiki-edit_wiki_section.php: [FIX/bp 29629] sanitize inputs... <br> tikiwiki: 03minger0 * r29631 10/branches/6.x/lib/trackers/trackerlib.php: [FIX] import_csv handles the utf8 byte order mark from now on <br> tikiwiki: 03sept_7 * r29632 10/branches/proposals/4.x/tiki-edit_wiki_section.php: [FIX/bp 29629] Sanitize inputs... <br> tikiwiki: 03sept_7 * r29633 10/branches/proposals/3.x/tiki-edit_wiki_section.php: [FIX/bp 29629] Sanitize inputs <br> tikiwiki: 03sept_7 * r29634 10/branches/6.x/tiki-edit_wiki_section.php: [FIX/bp 29629] Sanitize inputs chahn: If there is no problem when I input Korean character into tiki DB using phpmyadmin and there is problem (truncated characters) when I do that using tiki-editpage.php. It must be not a problem of my Mysql or Webserver or PHP (right?). Then which can cause such problem? I checked two form's encoding type. They were all "form enctype="multipart/form-data" method="post"". ***: lucks has quit IRC (Read error: No route to host) <br> lucks has joined #tikiwiki <br> fabricius has quit IRC (Read error: Connection reset by peer) <br> fabricius has joined #tikiwiki fabricius: polom <br> <u>chahn</u>: just here for a few minutes -> check your db allocation, please <br> multilinguarity (and korean would need multilinguarity, I would guess) needs utf8 instead of latin1 <br> somehow or sometimes latin1 would be preselectewd and will "come to tiki" then <br> so some of my installations base on latin1 and it is very helpful, that tiki understands latin1 <br> but I now have the problem to switch the allocation from latin1 to utf8 - not so much in my Tiki5 installation, but actually in a Tiki3 installation where the installer has no converting tool <br> I am looking forward to find a solution for me -> so for you: what allocation you have? chahn: <u>fabricius</u>: Hi, thanks again. fabricius, I thought my tiki DB is utf-8. But how can I check it? In my phpMyadmin it says mysql charset is utf-8. fabricius: ->I just talk from the view german-english-french -> do not know if utf8 would match korean <br> I do not know if all phpmySQL control centers look the same ... <br> in my one you have to click on the DB-name to get some TABs on the horizontal top of the main screen of the phpmyAdmin <br> must be about 6 to 8 TABs <br> the last one on the right would be s.th like "Operations" <br> (it is in my case) <br> if you find that, click there <br> there you would find a pop-up field with the actual allocation in in <br> in my case this specific field shows always "latin1", when I did setup my databease first time chahn: At first when I installed tiki phpmysql says it is latin_swedish but now I changed it to utf8_general_ci. fabricius: even instead in the first TABs utf8 would be suggested in all pop-up, why I thought utf8 would be the pre-setting chahn: To do that I used Phpmyadmin again by exporting sql and replace the charset to utf-8 and importing. fabricius: ah sry made a misstyping -> in the OperationsTAB it is a drop-down field (NOT a pop-up sry) chahn: fabricius, I think I experienced the exactly same thing with you. (right drop-down:) fabricius: ok, you might have changed the allocation from latin1_swedish to utf8_general_ci in this "Operations TAB while changig the allocation in the mentioned drop down menu <br> => so this mentioned drop-down menu shows you the actual set allocation <br> more specific stuff about MySQL-DB I did not learn by now ... so more I cannot help you in this issue, sorry chahn: fabricius, you helped so much thank you. I wonder why I can input Korean words to the table of tiki using phpmyadmin and I can't do that by using tiki-editpage.php. Do you think this is caused by mysql setting? <br> I suspect tiki-editpage.php reads user's preferences which admin can change and it is affected by that. <br> The way I added DB in phpmyadmin is that I added a user and click the radio button to choose 'make DB with the same name'. Do you think it might have caused the problem? ***: fabricius has quit IRC (Read error: Connection reset by peer) <br> lucks has quit IRC (Ping timeout: 240 seconds) <br> lucks has joined #tikiwiki <br> Caarrie|sleeping is now known as Caarrie|away <br> olinuxx has joined #tikiwiki <br> lucks has quit IRC (Ping timeout: 240 seconds) <br> lucks has joined #tikiwiki <br> Andurino has quit IRC (Remote host closed the connection) <br> rodrigo_sampaio has joined #tikiwiki chahn: I followed the instruction that fabricius told me and finally solved my i18n brocken character problem :) Till now I usually created DB by using phpMyadmin and when I made DB for tiki I used it too by adding a user (such as tiki) and at the same time chose the option of making DB of the same name. I think that caused a problem. Few minutes ago this time I first created a DB selecting 'utf8-general_ci' for Collation and add a user for that DB. Then i18n func <br> tion works well. Now I can write in Korean :) I thank you and bye for now. ***: chahn has quit IRC (Quit: Leaving) Tikiwiki|bot: New Forum Posts: To use own PHP snippets in TikiWiki - http://tikiwiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=38698 ***: lucks has quit IRC (Ping timeout: 240 seconds) CIA-69: tikiwiki: 03changi67 * r29635 10/branches/6.x/installer/schema/20100925_fix_some_default_value_tiki.sql: [FIX] one space left <br> tikiwiki: 03sampaioprimo * r29636 10/trunk/comments.php: removing useless code ***: rodrigo_sampaio has quit IRC (Ping timeout: 265 seconds) <br> rodrigo_sampaio has joined #tikiwiki <br> FrankP has joined #tikiwiki <br> rodrigo_sampaio has quit IRC (Quit: Leaving.) Tikiwiki|bot: New Forum Posts: Images from the file gallery not recognized? - http://tikiwiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=38699 CIA-69: tikiwiki: 03pkdille * r29637 10/branches/proposals/5.x/templates/tiki-wiki_topline.tpl: [QT] Rollback rejected proposition r29476 ***: MacLeod has joined #tikiwiki CIA-69: tikiwiki: 03pkdille * r29638 10/branches/proposals/5.x/templates/tiki-wiki_topline.tpl: [QT] Rollback rejected proposition r29474 <br> tikiwiki: 03pkdille * r29639 10/branches/5.x/tiki-sheets.php: (log message trimmed) <br> tikiwiki: [QT] Quality Team Backport <br> tikiwiki: r29480 | xavidp | 2010-09-21 12:51:35 +0200 (Tue, 21 Sep 2010) | 1 line <br> tikiwiki: [FIX][bp--] Adding r28752 in proposals/5x from ohertel (thanks Oliver). <br> tikiwiki: "Temporary fix for tiki sheet editing. Sheets are broken for admins of sites <br> tikiwiki: with a large user base, because the complete user base is loaded and assigned to <br> tikiwiki: a variable, causing a memory error most often. Needs to get improvement." There <br> tikiwiki: 03pkdille * r29640 10/branches/5.x/templates/tiki-show_page.tpl: <br> tikiwiki: [QT] Quality Team Backport <br> tikiwiki: r29553 | pkdille | 2010-09-22 19:56:23 +0200 (Wed, 22 Sep 2010) | 1 line <br> tikiwiki: [bp/r29551][FIX] tiki-show_page: if not stripped, the content is never empty and the following test on the captured section fails <br> tikiwiki: 03pkdille * r29641 10/branches/5.x/lib/perspectivelib.php: <br> tikiwiki: [QT] Quality Team Backport <br> tikiwiki: r29558 | chealer | 2010-09-22 20:57:23 +0200 (Wed, 22 Sep 2010) | 1 line <br> tikiwiki: [bp/r29557][FIX] PHP notice "Undefined index: 1" when multidomain_config contains empty lines, breaking sites displaying PHP notices using gzip compression <br> tikiwiki: 03pkdille * r29642 10/branches/5.x/lib/wiki/wikilib.php: <br> tikiwiki: [QT] Quality Team Backport <br> tikiwiki: r29566 | nkoth | 2010-09-23 18:06:59 +0200 (Thu, 23 Sep 2010) | 1 line <br> tikiwiki: [bp/r29565][FIX] Prevent non-link words from being changed when page is being renamedw hen page contains both links and non-links of that pagename being renamed <br> tikiwiki: 03pkdille * r29643 10/branches/5.x/templates/tiki-view_forum.tpl: <br> tikiwiki: [QT] Quality Team Backport <br> tikiwiki: r29570 | nkoth | 2010-09-23 18:57:38 +0200 (Thu, 23 Sep 2010) | 1 line <br> tikiwiki: [bp/r29569][FIX] Unable to sort by number of attachments (database error) so hide UI. Not useful anyway. <br> tikiwiki: 03pkdille * r29644 10/branches/5.x/lib/commentslib.php: <br> tikiwiki: [QT] Quality Team Backport <br> tikiwiki: r29575 | nkoth | 2010-09-23 19:18:06 +0200 (Thu, 23 Sep 2010) | 1 line <br> tikiwiki: [bp/r29573][bp/r29574][FIX] Prevent ambiguous field database errors on clicking on headings in forum post listing <br> tikiwiki: 03pkdille * r29645 10/branches/5.x/lib/jquery_tiki/tiki-jquery.js: <br> tikiwiki: [QT] Quality Team Backport <br> tikiwiki: r29590 | sdoh | 2010-09-24 08:47:37 +0200 (Fri, 24 Sep 2010) | 1 line <br> tikiwiki: [bp/r29589] [FIX] Solve bugs of variables 'undefined is null or not object' at unloading of the page with IE <br> tikiwiki: 03sampaioprimo * r29646 10/branches/6.x/comments.php: [FIX] second attempt to fix comments listing after replying a comment (see r28688 and r29588) Tikiwiki|bot: New Forum Posts: API for adding tracker items remotely. - http://tikiwiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=38700 ***: MacLeod has quit IRC (Ping timeout: 252 seconds) <br> ripero has joined #tikiwiki Tikiwiki|bot: Recent Bug: Tracker item: #3561 - - File galleries broken after 4.3 to 5.x upgrade - http://dev.tiki.org/tiki-view_tracker_item.php?trackerId=5&itemId=3561 ***: coaboa has joined #tikiwiki <br> coaboa_ has quit IRC (Ping timeout: 245 seconds) ripero: that was me... ***: Andurino has joined #tikiwiki <br> ssquirrel has joined #tikiwiki ssquirrel: hello ... can anyone answer an install question? <br> I can't connect to my database? First it says there is no driver and then I do the manual install and it still can't connect ... what can I do? <br> ... <br> lol nevermind I appended local.php with $api_tiki='adodb'; Tikiwiki|bot: New Forum Posts: About, find field, font size, image insertion, etc - http://tikiwiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=38701 ***: ssquirrel has left <br> lucks has joined #tikiwiki <br> lucks has quit IRC (Ping timeout: 252 seconds) <br> lucks has joined #tikiwiki CIA-69: tikiwiki: 03changi67 * r29647 10/trunk/css/ (8 files): <br> tikiwiki: ~FIX~ CSS type -> spotted on quality.tiki.org <br> tikiwiki: 1/ CSS colours must be defined in uppercase <br> tikiwiki: 2/ Duplicate class definition found <br> tikiwiki: 3/ There must be no space before a colon in a style definition luciash: polom ***: lucks has quit IRC (Ping timeout: 245 seconds) <br> FrankP has quit IRC (Read error: Connection reset by peer) <br> lucks has joined #tikiwiki ricks99: Questino for the experts: Where is $prefs['tikiIndex'] stored? <br> I don't see it in tiki_preferences table ***: Andurino has quit IRC (Remote host closed the connection) <br> chealer has joined #tikiwiki <br> chealer has quit IRC (Remote host closed the connection) <br> chealer has joined #tikiwiki <br> ripero has quit IRC (Ping timeout: 245 seconds) <br> goj has quit IRC (Ping timeout: 250 seconds) <br> goj|ghost has joined #tikiwiki <br> goj|ghost is now known as goj <br> ripero has joined #tikiwiki <br> ripero has left <br> ripero has joined #tikiwiki <br> ripero has left