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