Hi, Who can inform me about the db management and his upgrades during dev (i.e. 7.1, 7.x ->) ?. The reason of this question is again after updating SVN, and a run of installer, that I got a fatal error : new column in table "tiki-plugin-security" "added_by" not updated. I am not sure there are not other bugs in db update. I think that such problems are normal during dev, but the developer, who updates, should be able to check the db (his, new ref, after upgrade). If you think in the chat that this remark is pertinent, I will open a discussion on [tiki-devel] tikiwiki: 03chealer * r37032 10/trunk/ (2 files in 2 dirs): tikiwiki: Admin Cagegories: show less when in no category tikiwiki: [REF] Optimize paths display Man, has anyone played with openlayers at all recently? I know we have an integration in tiki. I'm working on a project where I'm using it, I gotta tell you, it is solid! What's the minimum MySQL requirement for tiki 7.1? help !help You can get a more complete list of commands that work with this bot at http://tiki.org/TikiBot . RobertPlummer, have you come across my ActiveXObject is not defined in http://openlayers.org/api/2.10/OpenLayers..js line 246? something Gears related by my reading dthacker, should be MySql 5 why? Not yet that I know of. I would be glad to look into it while I'm doing the other stuff though. nkoth, 'cos I'm trying my first install in a couple of years. I'm getting more and more into the code and how to manipulate. dthacker; I have it trunk running on 5.0.77 (centos default) so should be ok BTW info.tiki.org is not answering for me. info responds for me nkoth|nelson: I tell you what though, their team is very responsive, you can run it by their IRC channel. I think it is #openlayers ISP DNS, no doubt RobertPlummer it looks like it's in a try catch block, would that trigger firebug? Does it do it in any other browser? I don't think it's a fatal error I mean it's in a try block I've not had any trouble with openlayers and firebug specifically. Is it an error, or a warning? nelson, there is only 1 try in that line. Containing this: "return OpenLayers.Rico.Color.createColorFromBackground(el).asHex();" maybe it's the wring line number then Is there a way I can reproduce the error? I'm going to ignore it, it is just a try catch so I think firebug picks up the catch ok. I'm heading out for the night. email me if you need me. it's mot really an error, just a notification a break notification dthacker: tiki 8 will be much better than 7 (the second one after LTS is always the best) Are you installing it for something specific or just testing it out? nkoth|nelson: I haven't installed anything since 1.9, so I'm just testing. might as well test trunk then :) but anyway, much nicer than 1.9 already how are you doing? hehe, I can see that from the docs and front page. I'm good. Wanting to get back into helping. Need to re-learn the ropes. you're always wecome (and I would say much needed now that there is so much more to document :)) good to hear :) tikiwiki: 03chealer * r37033 10/trunk/lib/core/Search/GlobalSource/CategorySource.php: [REF] getParents(): optimize. untested tikiwiki: 03chealer * r37034 10/trunk/lib/categories/categlib.php: tikiwiki: [REF] reorder get_category_path_string_with_root() tikiwiki: [REF] remove get_category_path(), unused since r37033 tikiwiki: 03chealer * r37035 10/trunk/lib/categories/categlib.php: [REF] CategLib: document that remove_category() also removes descendants tikiwiki: 03chealer * r37036 10/trunk/ (tiki-search_replace.php tiki-theme_control.php): [FIX] Sorry, I apparently didn't commit these in r37028 chealer: categories break for me let be check nkoth|nelson: I played with the cache a lot, so be sure to clear that before anything CategLib->get_category('orphan') leads to Invalid category intier nkoth|nelson: hum. and where is that called from? lib/core/Search/GlobalSource/CategorySource.php nkoth|nelson: could you give me a full backtrace? if it's coming from CategorySource.php:65, that means getParents() is getting called with a string as $categId yes, I am in theat file now, and svn loggin basically the cause is line 42, which then leads to getWithParent then getParents anyway, chealer: http://pastebin.com/r2FHJH0d nkoth|nelson: ah. indeed. one of my earlier commits did reveal these kinds of errors. nkoth|nelson: that comes from http://sourceforge.net/apps/trac/tikiwiki/changeset/31022 could you report? actually i know how to fix it it's pretty obvious excellent (didn't look at the new search yet) tikiwiki: 03nkoth * r37037 10/trunk/lib/core/Search/GlobalSource/CategorySource.php: [FIX] If there are no categories for object, then don't bother to getWithParent, otherwise trying to do so with string 'orphan' is nonsense, which now with more rigid checking in categlib causes error chealer ^ nkoth|nelson: thanks orphan is used to search for items with no category... because you can't search for empty/no values in the unified search tikiwiki: 03chealer * r37038 10/trunk/lib/categories/categlib.php: [REF] get_categorypath(): somewhat document and remove unused parameter include_excluded, despite the nice name hi all, just a quickie question what's the wiki syntax for making a TOC update from the pages I'm editing? say, i have a main page TOC and making a page that has it's own TOC...is there a way for the main page to auto-update from teh pages i'm editing? bonjour :) good morning fabricius, Weren't you mucking around with conditional menus? polom merbster hi. hmmm I did use the words a few time recently fabricius, but you haven't set it up? Merbster: in my mind it belongs to site organisation / structuring Merbster: I did a longer while ago I think, there are two ways -> with categories - what I never got find out , but will try to find out again -> the contextual menu, where you have the same menu twice, but with different parameters sylvieg: did explain that to me a few month ago and I added to one of the menu/module documantations let me check, if I find the link for you Merbster Merbster: http://doc.tiki.org/menu#Creating_a_Custom_Menu -> scroll down to "contextual menu example" and see "three steps to a contextual menu" fabricius, thank you I will take a look at this When I find out how to do with categories, I will add it to this doc aswell one guy (arild or bernard I do not remember) brought me to an idea that could work aswell - it is not really a contextual menu, but may be used for one (and even maybe maintained automatically): using the category list plugin that might be configured to list pages of certain categories under certain conditions but again ... we need the module preference to show/hide a module according to the actual category that would meke things much easier I found somewhere, where it's possible to bind a module display to a perspective. But I can't find it again fabricius, have you noticed that the UI for editing modules that contains menus are different than modules containing something else? hmm. I am confused now hi all ! "one guy (arild or bernard I do not remember)" i vote for Bernard ! :) Does anyone know how to include wiki plugins in smarty templates? good morning & polom tikiverse Merbster: see themes.tiki.org - Template Tricks there is a description on how to include those coaboa, I have been looking at that page but did not find anything, do you remember what heading it is under? mom hi coaboa themes - Tricks - Template Tricks http://themes.tiki.org/Template+Tricks page3 Add wiki Syntax in custom code area (works also in tpl as far as I know) coaboa, I tried it, I get syntax errors oh. I used it. but not recently I get "unrecognized tag: literal" and it complains about my {wiki} tag not being closed, but it is! :S which tiki version 7.1 mom coaboa, I found an error. my literal tag was not closed. :S now I don't get errors, but the JQ stuff I tried to include via. the JQ plugin is just output as plaintext not {JQ()} though. only the actualy JQ code I think that is because of smarty security. But I never tryed to use js in this way I have disabled smarty security coaboa, http://pastebin.com/b6GieT12 <- you can see my module defintion here I have used {JQ()} plugin in wikipages before. I don't think JQ plugin can handle being included from a module :P don't know that coaboa, can JQ access variables in $_REQUEST ? I am thinking to just add the hiding code in the custom area part under look & feel I need to compare on $objectCategoryIds variable. but I don't know how to access it from JS I used {if $objectCategoryIds[0] eq ''}Somethint to do {/if} directly in the template but I'am not a coder ;-) but this works for me coaboa, in the first iteration I used that too. But it did not work with the JS code. So I ghtouhg I would test if I could get JS code running first and then use that trick Hmm. Tiki is not including the JS stuff I am inserting in look and feel Merbster - I just saw, that you asked me a question at 9:11 Don't bother fabricius :P Merbster: "fabricius, have you noticed that the UI for editing modules that contains menus are different than modules containing something else?" Merbster: is that still actual? All user modules doesn't have the nice UI but you can set preferences through text. yupi I often have to put module parameters in manually - if I use the WYSIWYG editor, I have to switch into the source mode for that not nice, but works well an so I relatively often look into the doc.tiki.org - all documentation - wikiplugins ... to find all the parameters listed, I could not remind so you are sorted with that issue? fabricius, I was referring to specifying user modules. Like in what perspective the module should be shown fabricius, on all menus, you need to put the menu in a module that calls the menu, and then assign the module to one of your bars if you in "parameters" text filed type "page=somePage" the module (i.e. the menu in the module) is only shown when page = somePage fabricius, I found a somewhat "userfriendly" solution for page specific menues page specific as several specific pages can use the same menu. not just one (as with the page=pageName) parameter (or does it support several pages?) I think it supports several pages, as most kind of parameters you can put in several divided by comma or by semicolon sadly theses parametersettings seems to be not always reliable for some sorts of parameters there is exclusion missing and again: limitation of categories (inclusion and exclusion) is missing another way should be some smarty filter syntax in an custom_module instead of the module_menu what "userfriendly" solution you have discovered? fabricius, adding 1 line of JS in look and feel that hides the menu. and in all pages that need it I include 1 line of JS to show it again. So the menu is hidden and when the user enters a page that is set to show it. it will do it. Almost the same as page=somePage so the menu appears, when a page is active, that contains thi JS line Yes I am more and more convinced to setup a special documentation area on doc.t.o for structuring Tiki websites all this contextual menus, hide and show menus/modules, perspectives, areas etc. fabricius, It can be a daunting task to find all this information beacuse it is spread around. And when new with tiki it's hard having an overview of what Tiki as capable of and for all these issues some grafical stuff, some pics, step by step HowTo etc. I remember, when I started and after nearly 2 years, I still haven found all that what I needed then for ex this category contextual menu was mentioned a few times, but never found it have an idea now and the perspectives ... even much experienced Tiki users and admins fear to work with them and do not really understand for what it could be used for many people here perspectives are kind of a mystery that is not necessary I am thinking about that since long time and I think, I have now nearly a concept for this part of documentation remember how good the few lines of Luci yestarday have been Alot of the docs needs an overhaul :P th doc revamp, yes Rick is on that I am editing and improving docs as I try restructuring the docs yes, we all should contirbute in that polom hi chibaguy hi coaboa New Forum Posts: Webdav and IIS - what configuration is required? - http://tiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=42201 Ouin ! on a 6.p each time i submit an article i got a database error… how can i track such error ? Bernard1, make sure PHP error level is set correctly. maybe look at tiki-syslog.php (I don't know if failed DB queries are logged by default) k But php error level set to strcit will show the DB erros at the bottom of tikis page in the "PHP errors" tab if($("#itemExist").length > 0) { $("#editItemForm1").parents("td:first").hide(); } else { alert("you suck"); } <- it HTML encodes my > Merbster: tks Bernard1, ? Lost in space… tks for your comments about db error ! :) hi Rick nick /Bernard|Away Bernard1, you solved the problem I take it? arf polom not yet got to run… Thursday is a stressful day in Israel ! :D Bernard|Away, lol. Well have a nice day! ricks99, Good evening sir! :) evening maybe not morning here :-) I don't know what I'm thinking it's afternoon here risks99, you are on our side of the lake, right? (US) yup. NC ah yes, I remember now. I still need to visit america Merbster: You in Europe? RobertPlummer, I am Danish yes. :) Merbster: I've only been to the US, Caribbean, and Mexico, I'd like to visit Europe next. RobertPlummer, nothing really to see.. other then rain rain rain! especially in DK never had so much rain as this yeah year SJ-Jay: WOw Well, I guess the grass is always greener. Does it get very hot there? just kiddin'... u can always take a glance at our famous little mermaid.. oh wait.. no the chinese guys took it :D Here, in the midwest, there is a 100 degree (Fahrenheit) difference in the winter vs the summer. plenty of rain so far this fall in NC (with more on the way) lphuberdeau: You around? chealer: How about you? Merbster: could I use the following code for a contextual menu? Merbster: {if isset($objectCategoryIds) and in_array(2, $objectCategoryIds)} {menu id=43 css=y type=horiz}{else}{menu id=44 css=y type=horiz}{/if} "Sun is shining, the weather is sweet…" (Bob Marley) ;) fabricius, the menues will change yes. but if you need to hide the menu entirely the border of the module will still be there fabricius, Also you need to set "categories in templates" Merbster: If I use only single links to categorized landingpages in the topbar Merbster: but it might be possible to show/hide the menu module with perspectives/areas ricks99, we had more rain in July then we usually have i an entire year! so with or without the perspective binder fabricius, I am not sure. If you can categorize a module (or set it to only show in a specific perspective yes you can do that) Merbster: best would be to have the module parameters show / hide in category (several devided by semicolon), what is not yet coded RobertPlummer, think it's the same in Denmark ;) fabricius, you can show/hide module based on current perspective, it's ALMOST the same as category :P since categories are bound to perspectives. Merbster: for this simple usecase perspective seems to be a usable workaround - BUT like shooting sparrows with am M16 Merbster: and to make it really working with perspectives you need the perspective binder - what is still a hack and not yet natively included in the code fabricius, I agree. :P but then there's the JS way or using page as menu plugin fabricius, you could use the "page as menu plugin" and include ALL menues in that page. and use smarty {if} to show the different modules depending on $objectCategoryIds Merbster: I will try the category method and I will try the JS method - hope you'd give me a hand - in a few days Merbster: then I think I have the necessary stuff to start the structuring documentation fabricius, the JS method has a side effect; ALL menues will show en 2-3 seconds before they are hidden the page as menu probably won't have that side effect So we get a few ways and combinations stacked together, how to structure Tiki in respect of navigation and visibility included with the Areas - your perspective_binder it's gonna to become awesome ok found the edit-submit bug… The form require an author name and is not working when author is not registered and the field is filled manually (submission are open to anonymous). just needs to be put on one page oups sry Torsten. :) oups for what Bernard? :-P i don't like when i jump in the middle of an ongoing discussion... :) hehe no problem - what you should do, if so many people have to sare the same room? and I hope, that this discussion might be interesting for more people and I think, most is said for now anyway Torsten, will you be here tomorrow ? I have to test the areas thing and decide between the options i got for a self creating menu. (today i won;t have enought time) Bernard, definitely NOT tomorrow and mostlikely not before saturday evening But if you want to start before: I did describe everything step by step in a comment in the file you can download the file here: http://dev.tiki.org/Areas open in your editor and follow step by step great i'll do then, a important question does it work with the LST ? Bernard1, why are you using LTS? in the file you need to change the base category Id (if it would not be the category with Id=1, what makes sense at a fresh installation) AND you need to write your database credentials into the file in two lines (around line fiftysomething) in one line all credentials, like localhost, dbname, dbusernam, password and in one line only the dbname Merbster: part of my business is on intranet and off-line website. It is a pain to upgrade them so i stick to 6.x lts as i need extended support and have a few options in case of something is broken. you have to do changes/entries in three lines altogether the an include in tiki-setup.php and some configuration in the Tiki admin panel Bernard1, ok. so there's a service provider that gives support on LTS version of tiki? yes, me :D If you did once before, tha setup will need just five minutes altogether Bernard1, I use tiki for intranet too. But I found out quite fast that Tiki stable gets bugfixes alot faster than LTS version. yes but may be you are in site…. i'm not. And i require several authorizations before i can put a finger on a keyboard there… ^^ ok Torsten… but again did you test it with tw6.x ? 6.x and 7.x cool Any of you that is here now that knows jQuery? Merbster: I've been developing with jQuery for sometime. I wrote jQuery.sheet and jQuery.s5 and a few others. and use it regularly in tiki. RobertPlummer, http://jsfiddle.net/eJ79r/ <- I am trying to select the next link after the #itemExist input Actually the href attribute value. I am still new with JQ and I find the selectors mildly confusing at times :P Updated $(function() {     var someCoolHr = $("#itemExist").next().find("a.tablename").attr("href");     alert(someCoolHr);            }); btw. just to clarify, under no circumstance would I use those var names in production code :P lol RobertPlummer, what's the point of being able to suppluy elements to .next if you need to do find on them anywas? anyways* RobertPlummer, another thing, why wrap it in an anonymous function? Oh yes, another thing. THANK YOU RobertPlummer :) the $(function() {}); probably isn't needed, but is the same as $(document).ready(function() {}); It is just good practice. ok RobertPlummer, Thank you for telling me, I _try_ to abide by good (best?) practices when I can hmm... tiki 6.4 getting Fatal Error: Interface "Zend_Captcha_Adapter" not found..... and WSOD :-( RobertPlummer, does global JS vars persist across postbacks? from 1 page to another? it's the same page if it is an ajax postback, yes. oh I don't know if it is $.ajax() or $.post() or $.get() it's nit not* then Then no, javascript life-cycle is page bound. I am trying to make a nice page with a tracker and a trackerlist You need a server side component. if the trackerlist has 1 item. the tracker should be hidden (always) If it a wiki page or php? (html) wikipage ah trhough JQ plugin ok then we have an "edit button link" that supplies the itemId param hm... so that the tracker entes edit mode (instead of entry mode) Sounds like you should build a plugin for what you are doing. I have 7 days until deadline no time lol, I think you could do it in much less if you did it in php. RobertPlummer, But then we have a "custom" wiki. aren't they all custom ;) I need to learn hwo to do DB queries etc. all the "correct wiki way" Merbster, use Tracker Query lib $trkqrylib->tracker_query("Tracker Name"); and you have all the tracker data you need. Manipulate at will RobertPlummer, I think I can manage with JQ plugin and pretty tracker :P ok I haven't given up yet atleast Just a suggestion, I know that it can be done in wiki what you want, it just seems like a lot of overhead. RobertPlummer, I agree. but we're limited to around 100-150 users and if it doesn't scale well I can optimize by using plugins later after I "finished" for the deadline Merbster: That sounds good. any help for rick's zend fatal error ^^^ pls ricks99, I would love to help you but I have no clue as what's going on tx anyway merbster risks99 What is the problem? 01tiki 6.4 getting Fatal Error: Interface "Zend_Captcha_Adapter" not found..... and WSOD 01 RobertPlummer, Can JS fetch and set variables from $_REQUEST ? Merbster: You should use json if you are going to do that. THere are plugins that allow you to do it, but none that I've used perfectly do it. Merbster: You need a server side component. RobertPlummer, ok. ricks99: What options do you have on that could be leading to this? Have you tried switching them off and on? RobertPlummer, the reason why you think the plugin way is better, is because there's no way to preserve state of the page when clicking the link that feeds the tracker with itemId @RobertPlummer: this is after an upgrade 6.2 -> 6.4 I can't get to any tiki page Merbster: It isn't always that, you can always find a way around that, it is when you are using things in a very custom way, it adds to complexity. Some things can be done much easier and with way fewer lines of code. But it also ads to complexity when upgrading so I can see your point of view. exactly. RobertPlummer, So. to preserve state of the page, I could write something like a smarty plugin (so that I have a server side component) ? Sure The smarty plugin would simply take a json object containing state information. And it would load the json object on page load. Merbster: But you remember that tiki is community driven, if you have a good idea for a plugin, add it. to core, and then it will be updated when you go to upgrade. Merbster: But you may want to generalize it a bit. RobertPlummer, ofcourse. I just haven't had the time to learn SVN properly yet No learning. Merbster: You windows or linux? Windows We live in the age of gui, have a gui manage it. TortoiseSVN, download NOW! RobertPlummer, I know tortoise SVN but getting familiar with it still takes time :P DOwnload, install, checkout, mod, click update, add comment, done. if rick can svn on win, anyone can Yes But I'm afraid I'll comit something nasty and ruin everything :P Merbster: I used to think it was very complex, but seriosly, just install Tortoisesvn, it is VERY easy. And for Linux "PySVN Workbench" might do the job similarly good If you can start you computer, you can use it. Ofcourse. But it still takes 1 hour to sit down and tinker with it. fabricius: RabbitVCS I use with PySVN Workbench. But I have a plan of installing svn and using netbeans interface Merbster: No it doesn't just download it, it is almost self explaining. to have everything nicely integrated Merbster: Tortoise adds contect menu integrtion. Merbster: It is shell integrated. right click on folder, click checkout, supply path, done. RobertPlummer, I know. actually it's allready installed. Merbster: Then go ahead and create your plugin, and I will walk you through committing it later. Merbster: even I understood it (the basic use) after I have been shown once in Strasbourg - you won t need even that But last time I used SVN /tortoise we where 4 IT engineer students that had trouble merging our code without overwriting something important :P Merbster: Tortoise won't let you commit if you do it right if you haven't updated your code. RobertPlummer: I do not know RabbitVCS Merbster: Plus you are creating a new entity, nobody is going to mess with that. fabricius: It is a tortoisesvn clone. for svn and git aye RobertPlummer, You make it sound like I don't even have a choice ;) Merbster: Life is full of choices, I'm simply giving you the path of least resistance. RobertPlummer: and why it would be better to use both tools together (Rabbit and Workbench)? fabricius: lol, rabbit vcs is awesome.... when it works ;) fabricius: it is just too new, and it is pretty slow. But I need Workbench as technical base? fabricius: RabbitVCS gives full folder integration, it makes me lazy. fabricius: Py takes 1-2 extra clicks that my fingers don't want to do ;) fabricius: No they do the same thing, but one is a workbench, and the other is full nautilus integration. or thundar RobertPlummer, yes ofc. I was just trying to be humouristic ;) polom RobertPlummer, smarty pluign should be ok right? - it can be included from wikipages, artciles etc. as long as smarty security is disabled? chealer: polom (no need for a fully fledged wiki plugin) Merbster: Yea I wouldn't touch smarty, that is a big can of worms. I don't wanna edit smarty code itself :P Was more wondering if smarty plugin was ok. compared to wikiplugin you can't include smarty plugins from wiki pages lphuberdeau: Thanks, I didn't know on that one. lphuberdeau, so I have to do a wikiplugin wrapper then I don't know what you want to do, the log is too long for me to read lphuberdeau, I need to persist page state across a postback what? lol ok I take it from the top I have a page with a tracker and a trackerlist, trackerlist has responsibility of showing items in the tracker. I want to hide the tracker when there's 1 item in it because users are not allowed to create more than one item. When clicking an edit link, I want to show the tracker, in edit mode. (by passing itemId in the url) But. When I press the edit link the JS that hides the tracker, is executed So I need to indicate that I am in "editmode" I thouhgt I could do that by adding a click handler on the edit link and setting editmode = 1 but since JS code ends its life when you do a postback that variable will be celared. cleared* lphuberdeau, So RobertPlummer suggested I needed a serverside part. To do that. and that's where the smarty plugin came in. that sounds too detailed for me to comment on Let's just say I am testing the outer bounds of what tiki can do with it's own functionality these days. :P Merbster: My solution wasen't to write a plugin based off that, there were other requirements that you spoke of, and it just sounded a bit more complex than what I'm used to with wikiplugins. RobertPlummer, you suggested a serverside part. And I suggested maybe a smarty plugin (because I have written one of those allready) I just don't get the issue of the edit form hiding seems to me you're trying to patch over a navigation issue agreed lphuberdeau, If I keep the tracker vat all times, I might be in the situation where the user will add an item, instead of editing the item and you should be fixing the navigation issue lphuberdeau, It would take me a week or more to figure out hwo to fix it properly and commit it back to tiki and I have a deadline in 7 days what causes the limit of 1 item? lphuberdeau, business rules. we need to document what kind of contract has been agreed on a certain project. but there's only 1 contract and having a user add more than one will be confusing I don't think I can help you without getting the full picture, and 7 days is too short for me to help anyway BTW: hope everyone saw that Tiki was added to the top 30 cms on cmsreport: http://cmsreport.com/blog/2011/10-new-content-management-systems-cms-focus ricks99: Woohoo! lphuberdeau, getting the full picture how? lphuberdeau, what else do you want to know? I don't see your problem and it lies in details about your business I don't have so I can't help lphuberdeau, problem is. the tracker should only contain 1 item And we want users to only edit that one item never ever add a new one they should not even be able to add a new one because they WILL do it. and then we have to give them support and tell them what they did wrong and they will hate the system don't give them permission to create new items? lphuberdeau, they need to create 1 item if the tracker is empty actually the tracker can contains several items, but they have different categories, those categories are jailed in each of their own perspectives in short, how would you build the UI so that it limits insertion of items to 1. ? ricks99: we need to resolve some issue with the service provider list ? it's killing the server the filter allows for too many options ricks99: hi ricks99: did you see lph answer from our mysql problem on info.to with the consultant page for the moment, could you live with only name, location and type as filters? lphuberdeau: thx i can live with it, but it makes the list un-useful for end users well, we don't have a gazillion consultants now i understand, do what needs to be done. it this a limitation / issue with trackers? or did i build the consultant tracker incorrectly? well, I think there are too many yes/no switches that could be better served with categories but it's a limitation with trackerlist and one of the reason unified search was built Hm... maybe you can rework it, so I can see what you mean. for the record,it tack 400% of CPU for 5 minutes to get a result s/tack/take actually, taking out name and username would help as well Polom ricks99: there are no error when you select any everywhere, you can test switching all checkbox to no ricks99: the query did not end does it return an error, or simply poor performance? take 10 minutes to get the result, when apache does not kill the connection so it is a performance issue... a problem with trackers in general? ricks99: yes a performance issue, too much join in the query : | 7125 | info | doc.tikiwiki.org:53908 | infoto | Query | 153 | statistics | 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_ite sounds like someone needs to fix trackers. ;-) this is not about fixing trackers, it's about making that part of them obsolete, far beyond repair changi, made the change lphuberdeau: you're the best lphuberdeau: thx is there something i need to do? or lph already did it? ricks99: lph already did it I removed most filters, which keeps the query manageable ricks99: it is just that you are now informed that we made some change on the consultant page ok. but that's not a real solution something that could help is removing all the yes/no fields and turning them into a single, multi-select category field can we now all try it, to confirm that it doesn't crash ? :-) ricks99: it's a workaround Jyhem: yes you can i agree a workaround. url ? info.tiki.org/Consultants @lph: could the fileds be converted? or a whole new field and manually moved? yeah, requires a manual transition lphuberdeau, ricks99: I would love to see those huge queries migrate to tracker query lib so we can make it better for 8, and then when we refactor how trackers storage, it will be cake. ricks99: when do you want to switch info.to to 7.x ? I think it would improve usability as well... no more, Do you offer X? Do you offer Y?... just a Services you offer with checkboxes +1 but note that info in on lts -- not tiki7 robert, unified search can already handle that query just fine ricks99: that the point :) lphuberdeau: Is unified search how we plan on storing trackers? changi|work: I think the plan is never but in the mean time, categories would be a lesser evil chealer: hi chealer: ok hey :-) robert, not storing, indexing lphuberdeau: My solution is for storage, not about which can handle it. ricks99: no problem :) storage is not an issue here I'll look at re-vamping the consultants tracker to use categories instead of separate y/n fields. lphuberdeau: Trackers are the issue with all those joins, those joins are there because of how trackers are stored, storage is the issue. Tx lph & changi well, partially, but storage does not need to change to resolve the issue lphuberdeau: i think unified search would be the solution for those query too lphuberdeau: But it is on the map, and it will resole the issue, it was only a suggestion. Or a wish ;) polom all Bernard1 are you here? CodyG: polom re: my still not working group contact form. This should work on 7.1, yes? {MAIL(showgroupdd="y", group="Admins")}{MAIL} New Forum Posts: Left vertical menu not showing new features? - http://tiki.org/tiki-view_forum_thread.php?forumId=14&comments_parentId=42202 and a good morning to you too robert ;) i'm looking for a solution i'm surprised i can't get this to work. {MAIL(showgroupdd="y",showuserdd="n",showrealnamedd="n", group="Admins")}{MAIL}... maybe it's a bug? CodyG: I've never used the mail plugin. oh arildb: yeap ! Bernard1: I guess you send the email: Db upgrade with new stable versions and during development i was thinking of using a tracker solution Bernard1: I was just wondering which OS you are running, and if you are running MySQL in strict mode or not. not sure i can get the permissions right... ie: users in group a send 1 private message to all users in groupb. "Send Message to Strata Council" tracker permissions do you use trackers robert? arildb: not sure about the email you talk about but my server is Debian/Apache2 Bernard1: Send by Bernard TREMBLAY...maybe that's another Bernard? arildb: yes another one. :) Bernard1: OK CodyG: Yes I use trackers, sorry. it's almost 8am here. i'm going to take stella for a walk. bbl. CodyG: I wrote Tracker Query Lib sheesh i'm back ok ... i'm started this tracker for "Send Message to Council". Tracker is actually a better solution than MAIL}. But I don't know if i can finish it because of permissions. owner(user) needs to send a message to group(council) without being able to view all the other owners (users) messages to council. whew. i'd rather use a tracker. but i doubt this permissions thing is doable. is it? if it i'll go back to working on the tracker i started <<<< needs a new keyboard. is there tiki speak for "frustrating?" i think i will take stella for her walk. bbl. ok Hi everyone RobertPlummer, regarding the tracker stuff we were talking about, after considdering the situation on my way home from work I think you are right regarding the plugin. Merbster: polom RobertPlummer, I mean you are right regarding to writing a wikiplugin instead of trying to work magic Merbster: Yea, and once you become familiar with it, we will gain another useful developer ;) RobertPlummer, but it made me think, trackers allready take an itemId and go into "edit mode" like that. Merbster: right so what's needed is to figure out the right itemId depending on the current page's category. :) looks like you are on your way. We're automatically creating Wiki pages in Tiki with an integration script an external consultant wrote. I am thinking that maybe it's easier to do the "resolving of ids" during the creation process Create Wikipage, set categories on this page, create tracker item with correct category fitting the page. and "voila" it will always end up in edit mode Merbster: What verison of Tiki are you on? 7.1 we allready looked into datachannels but the consultant said they had some limitations in regard to our usecase Merbster: You could easily use tracker query lib for what you want to do. (I have not checked what datachannels can by myself) At least obtaining the right data, saving would need to be handled elsewhere. RobertPlummer, Yes because the category ID of the page and the tracker item will be the same. RobertPlummer, I am only using trackerlist as a work around, using tracker directly as both "view" and "edit" will actually make it work better I think very good! tikiwiki: 03sylvieg * r37042 10/trunk/lib/ (setup/javascript.php tiki-js.js): [FIX]textarea: use the default fgal Id when browsing area for File ID do we have a tool that transfers the wiki images from wiki_up to a fgal? sylvieg: WHat is wiki_up? it was directory where in the old days the page loaded in a wiki page were loaded sylvieg: would be very usefull especially for dev /doc / info :) on my list ;-) sylvieg: same for tracker file :) Are you guys talking about moving files from image gal to file gal? no from the img/wiki_up dir to a fgal RobertPlummer: that's another issue :) I have created such a system, it isn't very difficult to do. RobertPlummer: Thx I will probably use it for my purpose +1 on a script to move Gimages->Gfiles tikiwiki: 03chealer * r37043 10/trunk/lib/categories/categlib.php: [REF] getSortedSubTreeNodes(): pass $categories by reference hmmm knock knock who's there? is anybody familiar with the newsletter? I want to include a picture but it is not shown in the recieved e-mail just the word "image" is the path right from the email's point of view? Is it showing the "alt" attribute from the tag? I am not sure how the path must look like http://www.mywebsite.com/path_to_photo.jpg I do not understand, sorry ARe you using wikiplugin img? Or are you using html? WYSIWYG Torsten, i put this at the top of my newsletter : http://example.com/tiki-download_file.php?fileId=1 I get all the time (and i don't use wysiwyg for it) :) sylvieg: didn't you take care about maketoc and newsletter ? I did not have time yet sorry np i just though it was done. not working maybe a certainlinkformat to the picture? ... tikiwiki: 03lphuberdeau * r37044 10/trunk/ (4 files in 4 dirs): [MOD] Moving import I need to save the picture in a folder, than it works I can use the logo in the root but how to use a picture from the filegallery? may be you should use files galleryId= fabricius: dl12&display for example sylvieg: Beat me to it. you need the param display to the tiki-download_file.php Ok sylvieg sylvieg: all not working image is visible before I send andnot in the recieved email ah in the mail.... you need a baseref probably as Bernard1 ex[plained I always try also with http://mywebsite.com/someparameters-or-path-or-both tikiwiki: 03chealer * r37045 10/trunk/ (4 files in 4 dirs): tikiwiki: [REF] listCategs(): Rather than changing categpath elements, add a new relativePathString element to avoid confusion. tikiwiki: Note: I may have missed changing a few usages of the relative path, causing longer paths. What is the name of the tool louis philippe wrote to maintain tiki sites as distance (via ftp or ssh)? found it trim tikiwiki: 03chealer * r37046 10/trunk/lib/categories/categlib.php: tikiwiki: [REF] CategLib: remove get_category_info() tikiwiki: Note: this was unused, but if filtering with several categories is needed, please allow it by extending the $filter argument of getCategories() does anyone know if the search ValueFormatter cannot work on arrays? tikiwiki: 03chealer * r37047 10/trunk/lib/categories/categlib.php: [REF] CategLib: use TikiLib::lib() tikiwiki: 03chealer * r37048 10/trunk/lib/ (articles/artlib.php categories/categlib.php): tikiwiki: [REF] Fold CategLib->approve_submission() into ArtLib->approve_submission(). tikiwiki: Note: Unclear why this was separate except for the link with tiki_objects, probably an old assumption now broken. Untested. tikiwiki: 03mlustenberg * r37049 10/trunk/lib/wiki/editlib.php: [ENH] EditLib::processInlineTag() Modifications to prepare the code for the processing of that produces wiki inline tags. hi all does anyone know how to create a plugin with variable number of parameters? Guest4784: an example ? i want to create a plugin where some text items can be entered. the number depends on one of the other parameters. so i could just estimate a reasonable maximum, but..... this is not too nice. sorry no idea ok, thx. tikiwiki: 03chealer * r37050 10/trunk/lib/comments/commentslib.php: [REF]Comments: remove outdated comment in lock_object_thread() Is RobertPlummer listening? Guest4784: I'm here let me look at the log.... Hi, just another question. Guest4784: ok, go ahead I tried to utilize the new Parser.... Guest4784: lol, yea. Guest4784: If there are any errors in your wiki syntax it will blow up. but got some unexpected results.... Guest4784: They were? Guest4784: Some things like If and group may not work right. my question: what is the state of the parser? Guest4784: Experimental, it needs a bit more tlc. I entered problems with numbered headings...Headings at all, and some other basic syntax. Guest4784: It is a proof of concept that just got past poc. The next step is to make it stable. ok. Guest4784: #tags don't work yet, what were your problems with headings? !Heading? one thing that i want to do (when it is stable :) : create an own generator, i found no way to extend the parser, did i miss any great feature? !Heading in deed, and !!Heading when no newline follows... Guest4784: Yea, those are known bugs and will be addresses soon. fine. Guest4784: The big thing about it is that it will let you create your own syntax. Guest4784: If you want to look into it, it is based around Jison, which is a Bison clone. Jison make lexing and parsing very easy with languages. To extend it, you'd need to download jison to get started. jison is not included in tiki, just the outputs from it. tikiwiki: 03mlustenberg * r37051 10/trunk/lib/ (3 files in 2 dirs): tikiwiki: [FIX] EditLib::parseToWiki() Line break handling of bold and italic text tikiwiki: fixed for tikiwiki: fixed for the thing is, i wanted to not generate HTML but anything else, so i hoped i can simply replace or better extend the parserlib class. Guest4784: Yea, infact take a look at the directory. There is a file in there, called WikiParser.jison It is the language. You mod that, and run it through jison, and your are done. I'd love to get some help on it ;) tikiwiki: 03mlustenberg * r37052 10/trunk/lib/test/editlib/EditLibTest.php: [ENH] More tests for EditLib ok, i will have a look at it and hope my 15 years unused flex/bison skills will help a bit :-) thanks RobertPlummer, did you tranlate the jison output to PHP by hand? tikiwiki: 03mlustenberg * r37053 10/trunk/lib/ (test/editlib/ParseToWiki_CharacterTest.php wiki/editlib.php): [FIX] EditLib::parseToWiki() Handling of line breaks within underlined/strikethrough text. tikiwiki: 03chealer * r37054 10/trunk/lib/ (6 files in 6 dirs): tikiwiki: [REF] declare map_object_type_to_permission() as static. tikiwiki: [REF] move map_object_type_to_permission() away from CategLib. moved it to ObjectLib. bye all tikiwiki: 03chealer * r37055 10/trunk/lib/categories/categlib.php: tikiwiki: [REF] CategLib: tikiwiki: getCategories(): cache and return descendants. Cache roots. tikiwiki: get_category_descendants(): Optimize using caches and document. tikiwiki: 03chealer * r37056 10/trunk/lib/categories/categlib.php: [REF] CategLib: somewhat document findRoots() tikiwiki: 03chealer * r37057 10/trunk/lib/categories/categlib.php: [REF] CategLib: implement "descendants" filter type for getCategories() tikiwiki: 03chealer * r37058 10/trunk/lib/categories/categlib.php: tikiwiki: [FIX] getCategories(): only children in descendants element (oops) tikiwiki: [REF] list_categs(): use getCategories() $filter (I will miss the previous code) tikiwiki: 03nkoth * r37059 10/trunk/tiki-register.php: [FIX] User tracker not preserving the user in the tracker tikiwiki: 03nkoth * r37060 10/trunk/templates/admin/include_login.tpl: [FIX] set value of passcode keeps disappering each time page loads does anyone understand the new events system? who wrote it? lphuberdeau I will ask him later, ok, this works. tikiwiki: 03nkoth * r37061 10/trunk/lib/setup/events.php: [FIX] Language should be updated for trackeritem even on creation, not just update tikiwiki: 03nkoth * r37062 10/trunk/ (4 files in 4 dirs): tikiwiki: [NEW] Allow syncing of user tracker item language to user system lang. I know tikiwiki: there is a preference field but that does not update the tracker item lang and tikiwiki: there is another use case where the preference field is better, for example, tikiwiki: multilingual user profiles where there is one tracker item for multiple lang tikiwiki: user information