You can add wiki pages to categories as you edit the page itself. Pls see docs for details: http://doc.tikiwiki.org/category hi everybody :) 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? All korean, japanese characters I input become '???' :( @chahn: what is specified in your ../db/local.php file? hi ricks99, $client_charset='utf8'; not sure what would have changed ur db tables try changing them to utf to match b sure to backup first 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. tikiwiki: 03sept_7 * r29618 10/trunk/tiki-jsplugin.php: [FIX] sanitize input... tikiwiki: 03sept_7 * r29619 10/branches/6.x/tiki-jsplugin.php: [FIX/bp 29618] Sanitize input tikiwiki: 03sept_7 * r29620 10/branches/proposals/5.x/tiki-jsplugin.php: [FIX/bp 29618] Sanitize input hello today I upgraded from 4.x to 5.2, and I am no longer able to edit or create file galleries is this a known issue? did you receive any sql errors during the upgrade? no well, I think not what type of error message do you get when you try to creaet a new file gallery? Unknown column 'show_lastDownload' in 'field list' and other mysql stuff (the query, the values, etc) your db did not get installed/updated properly it seems. try re-running the installer. be sure to selct the UPGRADE option confirm that no sql errors are reported ok I did select the upgrade option and the next screen I remember didn't have any "strange (mysql) output", that I remember but I'll try again from the backup the upgrade will show # of successful and unsucesssful sql queries Upgrade operations executed successfully: 5161 SQL queries. no unsuccessful sql queries are reported hi ttrimm :) Hi chahn_ I couldn't solve my i18n problem so I couldn't make time to visit your site again and send you comment, sorry. ttrimm, did you decide what to write about? not yet. no problem at all. ok :) ricks99: the problem with the file galleries is also present now tikiwiki: 03luciash * r29621 10/branches/6.x/tiki-edit_perspective.php: missing head title @ripero: i'm not sure then. :-( on my 5.2 sites, file galleries work fine. you might want to post in the spport forum ok, thanks for the info ripero, I am sorry if I interrupted you. chahn_: don't worry at all :) ok :) It seems the error had been previously reported in the forums for the 4.3 -> 5.1 upgrade tikiwiki: 03luciash * r29622 10/branches/6.x/tiki-edit_languages.php: missing head title 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 tikiwiki: 03chibaguy * r29624 10/mods/trunk/themes/planetfall_tiki_5/ (26 files in 8 dirs): [NEW] Planetfall theme updated for Tiki 5. tikiwiki: 03chibaguy * r29625 10/mods/trunk/themes/planetfall_tiki_5/styles/planetfall.css: Correct planetfall.css file this time. tikiwiki: 03chibaguy * r29626 10/mods/trunk/themes/planetfall_tiki_5/styles/planetfall.css: [FIX] Text color without bg color caused contrast problem. tikiwiki: 03chibaguy * r29627 10/mods/trunk/themes/planetfall_tiki_5/styles/planetfall.css: [FIX] Another text/bg contrast problem. tikiwiki: 03minger0 * r29628 10/branches/6.x/lib/wiki-plugins/wikiplugin_back.php: [FIX] added ~np~ to the wikiplugin_back tikiwiki: 03sept_7 * r29629 10/trunk/tiki-edit_wiki_section.php: [FIX] sanitize input, dont process inputs before tiki-setup.php ! :( tikiwiki: 03sept_7 * r29630 10/branches/proposals/5.x/tiki-edit_wiki_section.php: [FIX/bp 29629] sanitize inputs... tikiwiki: 03minger0 * r29631 10/branches/6.x/lib/trackers/trackerlib.php: [FIX] import_csv handles the utf8 byte order mark from now on tikiwiki: 03sept_7 * r29632 10/branches/proposals/4.x/tiki-edit_wiki_section.php: [FIX/bp 29629] Sanitize inputs... tikiwiki: 03sept_7 * r29633 10/branches/proposals/3.x/tiki-edit_wiki_section.php: [FIX/bp 29629] Sanitize inputs tikiwiki: 03sept_7 * r29634 10/branches/6.x/tiki-edit_wiki_section.php: [FIX/bp 29629] Sanitize inputs 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"". polom chahn: just here for a few minutes -> check your db allocation, please multilinguarity (and korean would need multilinguarity, I would guess) needs utf8 instead of latin1 somehow or sometimes latin1 would be preselectewd and will "come to tiki" then so some of my installations base on latin1 and it is very helpful, that tiki understands latin1 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 I am looking forward to find a solution for me -> so for you: what allocation you have? fabricius: 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. ->I just talk from the view german-english-french -> do not know if utf8 would match korean I do not know if all phpmySQL control centers look the same ... 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 must be about 6 to 8 TABs the last one on the right would be s.th like "Operations" (it is in my case) if you find that, click there there you would find a pop-up field with the actual allocation in in in my case this specific field shows always "latin1", when I did setup my databease first time At first when I installed tiki phpmysql says it is latin_swedish but now I changed it to utf8_general_ci. even instead in the first TABs utf8 would be suggested in all pop-up, why I thought utf8 would be the pre-setting To do that I used Phpmyadmin again by exporting sql and replace the charset to utf-8 and importing. ah sry made a misstyping -> in the OperationsTAB it is a drop-down field (NOT a pop-up sry) fabricius, I think I experienced the exactly same thing with you. (right drop-down:) 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 => so this mentioned drop-down menu shows you the actual set allocation more specific stuff about MySQL-DB I did not learn by now ... so more I cannot help you in this issue, sorry 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? I suspect tiki-editpage.php reads user's preferences which admin can change and it is affected by that. 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? 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 tion works well. Now I can write in Korean :) I thank you and bye for now. New Forum Posts: To use own PHP snippets in TikiWiki - http://tikiwiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=38698 tikiwiki: 03changi67 * r29635 10/branches/6.x/installer/schema/20100925_fix_some_default_value_tiki.sql: [FIX] one space left tikiwiki: 03sampaioprimo * r29636 10/trunk/comments.php: removing useless code New Forum Posts: Images from the file gallery not recognized? - http://tikiwiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=38699 tikiwiki: 03pkdille * r29637 10/branches/proposals/5.x/templates/tiki-wiki_topline.tpl: [QT] Rollback rejected proposition r29476 tikiwiki: 03pkdille * r29638 10/branches/proposals/5.x/templates/tiki-wiki_topline.tpl: [QT] Rollback rejected proposition r29474 tikiwiki: 03pkdille * r29639 10/branches/5.x/tiki-sheets.php: (log message trimmed) tikiwiki: [QT] Quality Team Backport tikiwiki: r29480 | xavidp | 2010-09-21 12:51:35 +0200 (Tue, 21 Sep 2010) | 1 line tikiwiki: [FIX][bp--] Adding r28752 in proposals/5x from ohertel (thanks Oliver). tikiwiki: "Temporary fix for tiki sheet editing. Sheets are broken for admins of sites tikiwiki: with a large user base, because the complete user base is loaded and assigned to tikiwiki: a variable, causing a memory error most often. Needs to get improvement." There tikiwiki: 03pkdille * r29640 10/branches/5.x/templates/tiki-show_page.tpl: tikiwiki: [QT] Quality Team Backport tikiwiki: r29553 | pkdille | 2010-09-22 19:56:23 +0200 (Wed, 22 Sep 2010) | 1 line tikiwiki: [bp/r29551][FIX] tiki-show_page: if not stripped, the content is never empty and the following test on the captured section fails tikiwiki: 03pkdille * r29641 10/branches/5.x/lib/perspectivelib.php: tikiwiki: [QT] Quality Team Backport tikiwiki: r29558 | chealer | 2010-09-22 20:57:23 +0200 (Wed, 22 Sep 2010) | 1 line tikiwiki: [bp/r29557][FIX] PHP notice "Undefined index: 1" when multidomain_config contains empty lines, breaking sites displaying PHP notices using gzip compression tikiwiki: 03pkdille * r29642 10/branches/5.x/lib/wiki/wikilib.php: tikiwiki: [QT] Quality Team Backport tikiwiki: r29566 | nkoth | 2010-09-23 18:06:59 +0200 (Thu, 23 Sep 2010) | 1 line 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 tikiwiki: 03pkdille * r29643 10/branches/5.x/templates/tiki-view_forum.tpl: tikiwiki: [QT] Quality Team Backport tikiwiki: r29570 | nkoth | 2010-09-23 18:57:38 +0200 (Thu, 23 Sep 2010) | 1 line tikiwiki: [bp/r29569][FIX] Unable to sort by number of attachments (database error) so hide UI. Not useful anyway. tikiwiki: 03pkdille * r29644 10/branches/5.x/lib/commentslib.php: tikiwiki: [QT] Quality Team Backport tikiwiki: r29575 | nkoth | 2010-09-23 19:18:06 +0200 (Thu, 23 Sep 2010) | 1 line tikiwiki: [bp/r29573][bp/r29574][FIX] Prevent ambiguous field database errors on clicking on headings in forum post listing tikiwiki: 03pkdille * r29645 10/branches/5.x/lib/jquery_tiki/tiki-jquery.js: tikiwiki: [QT] Quality Team Backport tikiwiki: r29590 | sdoh | 2010-09-24 08:47:37 +0200 (Fri, 24 Sep 2010) | 1 line tikiwiki: [bp/r29589] [FIX] Solve bugs of variables 'undefined is null or not object' at unloading of the page with IE tikiwiki: 03sampaioprimo * r29646 10/branches/6.x/comments.php: [FIX] second attempt to fix comments listing after replying a comment (see r28688 and r29588) New Forum Posts: API for adding tracker items remotely. - http://tikiwiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=38700 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 that was me... hello ... can anyone answer an install question? 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? ... lol nevermind I appended local.php with $api_tiki='adodb'; New Forum Posts: About, find field, font size, image insertion, etc - http://tikiwiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=38701 tikiwiki: 03changi67 * r29647 10/trunk/css/ (8 files): tikiwiki: ~FIX~ CSS type -> spotted on quality.tiki.org tikiwiki: 1/ CSS colours must be defined in uppercase tikiwiki: 2/ Duplicate class definition found tikiwiki: 3/ There must be no space before a colon in a style definition polom Questino for the experts: Where is $prefs['tikiIndex'] stored? I don't see it in tiki_preferences table