polom polom tikiwiki: 03pkdille * r16621 10/trunk/templates/tiki-list_blogs.tpl: [MOD] blog list: Description field is now in "Blog" field with css class subcomment (quite the same as tiki-listpages) Guys, can somebody help me out on the perm system of titki? I'm especially confused about the catagory perms. users go into groups thinks like wiki pages go into categories groups get given permissions to do stuff to categories if you're using 2.2 - you've got to *regularaly* clear the cache - messing with categories *always* needs a cache clear to work Well, I've set up a test group, which can edit and view wiki pages. But if I want to view or edit a catgorized page, I am denied. 1. clear the cache (bottom of the admin menu) 2. check that your user is actually in your "test" group 3. check that the "test" group has permission to do whatever you want in whatever category your chose 4. beware that if you've got 2 or more categories at once - the user will need permission in *all* categories, unless you switch that feature off in the settings. 4. May be a reason. Where can I disable this? (by "2 or more" - I mean - if your wiki page you're trying to view/edit is in 2 or more categories at the same time) Ah ok, acatually, it's not "must have perms in all" or some such thing that is - I'm not sure exactly which page - you might have to hunt around... The pages are only in one catagory. If you're not logged in - then you're in the "Anonymous" category, btw. prolly not relevant to you I expect. What's the name of the category? "Internet-/Online-Entwicklung" The page you're having problems with - Are you trying to view or edit it or both ? Both. You'll need to check that your page itself has not been given it's own individual permissions too I'd expect. The main thing - edit your category, and ensure that your "test" group is given "tiki_p_view_categorized" or whatever permission to that category. I've checked that. It doesn't have any page perms. (and edit etc) So, if I set up a new catagory, I must set up the perms too? Yep - click on the green key icon. Aren't the global persm automatically set for those? Yes - probably - but remeber that "perms in all" thing. Btw, is it normal, that in the category perms I' ve only two permission options? No. clear cache. then the rest will come back. "Tiki Cache/Sys Admin" http://.../tiki-admin_system.php I can only choose from view catagories and admin categories. :-| Clear the cache, otherwise your keyboard will leap up and slap you in the face. :D Ahhhhhhh! Finally my options are back!!! :) LOL - like I only mentioned the cache 6 times... Good luck! Yes, but the problem was, that I've already resetted it - but noit for all handles. yeah - I don't know what they all do - so I just zap each one in turn every time. I thought the last entry "all users prefs sessions" was for all listed above. Might be worth asking someone with access to 2.2 to fix that so any changes to categories will automatically zap all the caches. Indeed, even the labels are a bit misleading. v3 has some nice changes to how all this stuff looks - but I'm struggling to get v3 installed someplace still - been working at it for 3 days now. Grrrrr. Did you compile it on your own or is a precompiled version somewhere around? php is intepreted - but yeah - I'm having to compile apache, php5, and a plethora of support crap to try and get it to run. My fave RedHat distro is PHP4 only, and my 2nd fave (SuSE 11) doesn't "do" some things v3 needs ("mbstring" stuff) - and the WYSIWYG editor doesn't work on SuSE11 either - not sure if it's the mbstring issue or not tho. Caarrie - do you know any distro that v3 work on, "out of the box" - *including* the WYSIWYG editor ? that i think is more a browser issue then server issue cnd i use kubuntu here but bet to ask around ;) *best "browser issue" ? Do you know any more about that? Obviously - I can't tell users to change browsers... some browsers dont seen to work well with the editor i dont know why Ie6 ? have not used it in years fyi: ie6 + tiki3.x works well on my local win setup. What about the FSKEditor thingy (WYSIWYG) ? i have found the 3.x wysiwyg to b a great improvement (still not perfect, but much better) Cool - so it work in IE6 - that's the main reason I'm trying to upgrade - I have lots of users - they need a better editor... and a smarter browser :P Don't get me started!! Took me a week to get IE6 to "play well" with all the other browsers out there. Bloody CSS margins/padding... but there's still XX% of users on IE6 (30% or 20% or something significant - I forget exctly) [i wrote my own theme... it works, y, but not 100% -- nowhere near as well as, say for instance, confluence yeah - but anything I've found that doesn't work - and 10 mintes coding later, it's fixed for me. Or - more to the point - any feature I've needed - 10 mins coding later - it exists. There's a *lot* to be said for how Tiki all fits together, and can be easily improved... Is there any way TikiWiki can differentiate between Table head and body? I don't find anything in the syntax doc about it. use FANCYTABLE plugin instead of regular table syntax Ok, I'll check on it. Thx. And mayn thx to cnd for his assistance before! tikiwiki: 03jonnybradley * r16622 10/branches/experimental/jquery/ (14 files in 8 dirs): [MRG] Automatic merge, trunk 16617 to 16621 q: just svn'ed up on trunk. my browser no longer includes the site name on some pages (such as tiki-listpages.php) anyone know whats up? Any ideas why tiki-editpage.php shows a blank page when I hit save in a wiki page? With the default editor it only shows blank 25% of the time but with the wysiwyg editor it seems to do it almost every time. hitting F5 makes it save the changes and bring me back to the page though. in fact, the settings save either way, I don't have to refresh. it's just VERY annoying to get a blank screen like that. @ScaryLptp: r u using SEFURL? if so, confirm that u are using the correct htaccess Hello, install issue on a UTF8 DB with the trunk iki_sefurl_regex_out Specified key was too long; max key length is 767 bytes I am with marclaporte, he asked me to tell you about this. Sylvie, would you mind looking at this when you have time ? philippeback: I know this problem... Tiki's table definitions are not suitable for utf-8 - utf-8 needs more bytes per character you can still install and run tiki though - not exactly sure what I did to work around I think I modified the tables... but not sure how exactly ( on a related note there were also problems with the used storage engine - but not sure, if directly related to utf-8 ) mlaporte: irc.two tikiwiki: 03pkdille * r16623 10/trunk/templates/tiki-forums.tpl: [MOD] forum list: put admin icon in a column at the right side of the table (as in blog list, wiki list pages, etc...) I don';t think I have SEF enabled. but having trouble finding where that's set :P found it, it's disabled. tikiwiki: 03sylvieg * r16624 10/trunk/templates/tiki-export_tracker.tpl: lost file polom TikiFests Brussels is ending hi all tikiwiki: 03pkdille * r16625 10/trunk/templates/tiki-view_forum.tpl: [MOD] view forum: put action icons in a column at the right side of the table (as in blog list, wiki list pages, forum list, etc...) tikiwiki: 03nyloth * r16626 10/branches/experimental/coe/: [BRANCH] Creation, trunk 0 to 16624 tikiwiki: 03jonnybradley * r16627 10/branches/experimental/jquery/tiki-index.php: tikiwiki: [FIX] Repair after 16617 (producing 404 not found errors on pages not in structure?) tikiwiki: TODO - fix trunk, but i'm not sure this is the best way to do it... that blank tiki-edit.php issue is driving me bonkers! doh. ScaryLptp: is your php memory_limit set high enough? tikiwiki: 03jonnybradley * r16628 10/branches/experimental/jquery/ (14 files in 6 dirs): [MRG] Automatic merge, trunk 16621 to 16625 !help You can get a more complete list of commands that work with this bot at http://tikiwiki.org/TikiBot . .lastspoke Caarrie Caarrie last uttered a word on #tikiwiki less than a minute ago. .lastspoke sylvieg sylvieg hasn't uttered a word since I joined #tikiwiki 19 minutes ago. amette, yes 64MB in fact it only happens when I click save while editing a page. refreshing the page or going back to the root of the site and checking the page I edited shows the changes were saved I just uploaded all the files again and redid the install and it still does it. the page gets saved? yes tikiwiki: 03pkdille * r16629 10/trunk/templates/tiki-list_faqs.tpl: [MOD] list faqs: indent code - no changes hmm... then it isn't post size or such either... sorry, but I can only wildly guess.. .. and give some hints: crank up loggin in apache/php, set levels to debug and try with 128 MB just to make sure tikiwiki: 03nyloth * r16630 10/branches/experimental/ui-revamp2/ (140 files in 61 dirs): [MRG] Automatic merge, trunk 16565 to 16625 tikiwiki: 03pkdille * r16631 10/trunk/templates/tiki-list_faqs.tpl: [MOD] list faqs: move description field under title as a subcomment tikiwiki: 03jonnybradley * r16632 10/branches/experimental/jquery/templates/header_jquery.tpl: [FIX] Easier debugging with non-minified sources (non-debug by default) tikiwiki: 03jonnybradley * r16633 10/branches/experimental/jquery/templates/header_jquery.tpl: [FIX] oops (non-debug by default) tikiwiki: 03sylvieg * r16634 10/trunk/templates/tiki-edit_css.tpl: typo Guys, is there sth. Like an overview page, about all the attachments stored in the wiki? howdy having a little bit of a snafu...wondering if someone can help Did an upgrade of my system from 1.9 to 2.0 on the weekend and everything seemed to be ok. This morning, my mysqld cpu is pegging in the 90% range and slow as molasses. Seems to be especially bad when I have people accessing a tracker that has 2700+ items in it Don't recall seeing this before. I have applied the three indexes that Sylvie put in the 1.9to2.0.sql file. Wondering if there are any other performance things that I'm missing? tikiwiki: 03nyloth * r16635 10/branches/experimental/ui-revamp2/ (13 files in 6 dirs): [MRG] Automatic merge, trunk 16625 to 16634 R|SK: in admin wiki, go to manage attachments A small link, a big change. ^^ Thx. there is also an "attach" plugin which may contain some goodies hey guys afer a fresh svn up in trunk i have a 404 error on all my wiki pages ??? cgcom just has about the same problem - they run setup.php to change the read/write perms on the .php ah i check that :) thx sylvieg sylvieg, rien à faire je suis en 404 mais que sur le wiki ... :-( did you desactivate rewite rules to see? yes I know I've asked this before, but after applying the 3 indexes, is there a performance impact in 2.0 trackers vs. 1.9 trackers? Trying to make sure I'm not overlooking something because it's night and day...2.0 for me seems pretty slow. Bogging mysql down so much that unix commands are taking time to execute nice, people are trying out how well we sanitize our input... ;) doc.tw.o was just bombarded with requests like this one: GET /tiki-view_articles.php?fullscreen=y'%20and%201=2%20union%20select%20CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT (0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f, Anyone know what #sql_3f0a_2.MYI and MYD files are in mysql? 0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x2 7,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c)%20and%20'1'='1 kerrnel: basically MYI and MYD are files for MyISAM tables - so you should have some table named "#sql_3f0a_2" - although that _does_ sound unlikely ;) kerrnel: something to do with a table repair? I dunno, I've never seem them and my dba is asking about them. There's like 40 pairs of them He's wondering if they are temporary tables to support a query? kerrnel: "#sql_....MYI are temporary files. This will be deleted after the execution of the query. " http://forum.parallels.com/showthread.php?t=85213 here's related to indexing: http://bugs.mysql.com/bug.php?id=12166 Question: when I try to save or preview, I get a warning asking me if I really want to navigate away from my page, and telling me that any unsaved input will be lost. Since I have to do this to save, this seems... undesirable. This behavior seems to have arrived when I started using neat.css... those requests would be an attack against your database - probably someone is about to steal everyones usernames and passwords yup, well - good luck ;) tikiwiki: 03sylvieg * r16636 10/trunk/tiki-index.php: [FIX]page: some missing page assign ametta: Thankfully my tables aren't close to 2.7G or 5mil rows. :) However something is causing the system to get bogged down to the point that mysql is using up 97% cpu and we're hitting a load of 30. All of it is related to mysql somehow. I've already rebooted the server but still get these popping up. only tiki running on that database? yes One quick question. Does TikiWiki support IIS? Are there skins that work particularly well or poorly? tikiwiki: 03jonnybradley * r16637 10/trunk/templates/module.tpl: [FIX] Removing whitespace in moduleflip name capture (causing JS error in IE7) Is there something wrong with our configuration such that an attempt to save causes us to navigate away from a page and possibly lose data? someone was doing lots of work on skins in v3 a few days ago not sure who or which skins - but they were happy. @SoCalSig: as long as u meet the min requirements, should be ok. see docs http://doc.tikiwiki.org/tiki-index.php?page=requirements+and+setup also: http://doc.tikiwiki.org/Windows+IIS+Install @ricks99: Thanks I'll look at the links yw tikiwiki: 03jonnybradley * r16638 10/branches/experimental/jquery/ (15 files in 6 dirs): [MRG] Automatic merge, trunk 16625 to 16637 cnd: are you ready to commit? rpg: moreneat has some customized tpls which don't have feature tweaks rpg: go to templates/styles/moreneat and delete any custom tpls tikiwiki: 03sylvieg * r16639 10/trunk/modules/mod-switch_lang.php: notice Is anyone else running 2.0 with a tracker that has over 2500 entries? 2.0 or 2.3? 2.0 Are there any tracker changes between 2.0 and 2.3? there is some missing indexes perhaps I do not remmeber when it was added ALTER TABLE `tiki_tracker_items` ADD index trackerId (trackerId); ALTER TABLE `tiki_tracker_fields` ADD index trackerId (trackerId); ALTER TABLE `tiki_tracker_item_attachments` ADD index itemId (itemId); yeah I've got those :) you can try to activate the sql log to see if thre is some slow queries Is that a tiki thing or mysql thing? admin->general - there is an log slow query - and after you can look at the table adodb_logsql with phpMyAdmin in trunk all this is integrated but why not upgrading to 2.3 now..... Because of reporting...long internal story ah you are not in svn ? I am I'm actually upgrading to kerrnel-2.5 lol Which is based on 2.0. SELECT tti.*, ttif.`value`, ttf.`type`, sttif.`value` as `sortvalue` FROM ( `tiki_tracker_items` tti INNER JOIN `tiki_tracker_item_fields` ttif ON tti.`itemId` = ttif.`itemId` INNER JOIN `tiki_tracker_fields` ttf ON ttf.`fieldId` = ttif.`fieldId`) LEFT JOIN (`tiki_tracker_item_fields` sttif) ON (tti.`itemId` = sttif.`itemId` AND sttif.`fieldId` = 276) WHERE tti.`trackerId` = ? and (`status`=? or `status`=? or This one seems particularly aggregious with 160+ timer. yes this one is a slow one... are you php4 or php5? php4 ah remember now this query ios slow with php4 and ok with php5 I experienced this with dev.tw ugh So I'm going to have to upgrade anyway. lovely tikiwiki: 03jonnybradley * r16640 10/trunk/lib/calendar/calrecurrence.php: [FIX] Missing php directive it is not me who wrote this query ;-) LOL. Actually, I had started looking at doing the Tracker 2.0 from TikiFest in montreal but I've got some other things I really want to add before then. Tracker 2 was supposed to address performance, cut back on queries, and redesign the tables. Enterprise-grade, if you will. Looks like it may come sooner rather than later. :( ooo, kindle 2 announced today