evening folks! hi ther heya folks...lost my connection there for a bit...in mysql slow queries, when the list query time, for examples 1.009573 is that in minutes or seconds? so, for example # Query_time: 1.009573 Lock_time: 0.000129 Rows_sent: 1 Rows_examined: 1 probably seconds = 1 minute for 1 row examined would be very slow... k...not sure though? my host has been throttling my account for some reason, and I am trying to find what may be causing the problem...if that is seconds, i cant imagine that being a problem...do you? New Forum Posts: the resources occupy relatively large in tikiwiki!!!! - http://tiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=39508 check the mysql websit for whether it represents seconds? yeah as for throttling, maybe it's number of requests and not the time for each one? well, that doesnt seem to be it...not that many items in the slow query log. yup...looks like it is seconds. something is definitely weird...just opening pages on blogs, anything...taking forever... forever like in over 10 seconds? yeah but that not showing in the log...and they claim their server is not overloaded....that my shared virtual taking too much of others time, so they throttle my site... which is when i think it slows sylvieg: thanks but what difference does it make that the user validates his account (or not)? New Forum Posts: problem with wikipages after upgrade - http://tiki.org/tiki-view_forum_thread.php?forumId=6&comments_parentId=39511 hi all poolom こんにちは good (late today) morning to the tikiverse ;-) HI. I have installed tiki 6.0. I'm now not able to admin the toolbar (drag and drop doesn't work). Someone can help please? second issue: when i want to attach a file to a wiki site and then link to the file from the wiki text, i have to do this manually. Any hints how the link is generated automatically like in older tikis? polom (hi coaboa and chibaguy ) newbie: toolbar: no idea in tiki6... (let me check) newbie: attach a file: it used to work with attachments also. but for sure in tiki6 it works if you upload a file to a file gallery, and click on the link of that file in the file gallery as if it was an image xavi: thanks. so i will save the files in file galleries instead of attaching them to a site the problem is: admin toolbar doesn't work. so i can not create a custom tool Hi gang. Since upgrading to Tiki6, the wiki_plugin( _include doesn't work anymore in smarty templates. Maybe due to the editor parm. The code looks different at the PHP level. Any clue? there is even a plugin tool attach (i can see it) but i can not drag and drop in the admin toolbar .. :( thx for help @newbie should work with firefox and chrome. Worked for me yesterday. Hi i tried with chrome and firefox and ie. admin toolbar doesnt work with any of them. the toolbar doesnt work either if i want to edit a wiki page. I'm not able to use a tool. Any ieas? *ideas? newbie: did you try disabling the minify javascript (if you have it on)? newbie, drag and drop works for me in Tiki 6.x hi. thx for help guys. i will try to solve the problem later. i got a clue now. only encounter the problems with certain themes with default theme, the problem is solved ok, use only themes which are ported to Tiki6 hmm is there a list anywhere? in your tiki :-) well, In a brand new tiki6, I mean i chose from my updated tiki the theme i had already if you installed tiki6 over an existing installation (not recommended), you will have this problem of outdated themes in the list exactly default doesnt show sidebar correctly... but thx for help i have to leave now. cu what's the neame of your default theme? default my selected theme: damian damian didnt work oh, that outdated for sure! :) check http://themes.tiki.org thx alot. the ones in there listed for Tiki5 are known to work weel in tiki6 (Afaik) welcome s/weel/well chibaguy still around? simple.css seems to be missing something to display structure admnistration properly.... hi xavi_ hi Gary what is the url for that? yes, yes, I was copying the url :-) this type of url: tiki-edit_structure.php?page_ref_id=1 how is it in arcturus? with artcturus.css > simple.css ok, checking... this is tiki 6? mmm, apparently, arcturus is displaying it properly yes, tiki6 I'll svn up, just in case it's a few days old I'll try checking. Since upgrading to Tiki6, thewiki_plugin( _include doesn't work anymore in smartytemplates. Maybe due to the editor parm. The code looks different at the PHP level. Any clue? Tiki6 looks awesome BTW. Congrats to all! PhilBack: Maybe chealer or jonnyb would know about that. (chealer did quite a bit of plugin renovating) yeah, looks like this is chealer thing in the header. thanks PhilBack. yes, and you can try in a few hours when people from other time zones are active on irc (not now) I'm not sure about plugins in templates. I am checking out a fresh copy of 6.x and will install it on my local box. Then see if I can fix it myself. chibaguy: I mean the table (it seems) from "Structure layout" from a url like: tiki-edit_structure.php?page_ref_id=1 @chibaguy: yes, there is the block.wikiplugin in the tiki_smarty lib It works, no issue. Just that the new thing appears to have an extra default parm which the "editor" set to false. But this complexifies what gets out and leads to no rendering of an included page. PhilBack: I see. @chibaguy: Cool stuff with the new templates BTW. oh, thanks. chibaguy: I cannot reproduce here: http://themes.tiki.org/tiki-edit_structure.php?page_ref_id=1 :-/ I mean, the table displays properly I wonder if tiki6beta behaves different than current 6x svn Work in progress: http://bit.ly/9CHaEq [new candidate for the sample tikis in decembrer] changi|work: themes.t.o still shows the message as if it's running tiki6beta. Shall we upgrade to latest 6.x? xavi_: in my local branch 6, the structure edit page seems ok in simple, except for the left column (with icons) being kind of compacted. Something seems to be preventing the table cell from expanding to let the icons site side by side. site -> sit I'll check on that. Also some bad text/background color contrast in that table, in arcturus and maybe other themes. yeow, simple's page is worse in firefox than in opera. chibaguy: I saw this: .normal th, th, td.heading, tr.diffheader {width:15px;} in my simple.css and this restriction of width is not in arcturus in general how do I disable that in the "custom css" box of the admin panel? xavi_: I just saw that also. Yes, it isn't needed. I tried with width:100% but then the first column became too wide no width needs to be specified. Oh, to override, maybe try width: auto ah, ok, thanks :-) meanwhile, I'll edit simple.css and commit. thanks yes, that fixed it, thanks, chibaguy I'm guessing that was to cover a specific case, but got applied elsewhere. yes, I guess so tikiwiki: 03chibaguy * r30719 10/branches/6.x/styles/arcturus/options/simple.css: [FIX] Width on th caused narrow cell in structure admin table and probably other places. Thanks to xavi for reporting. tikiwiki: 03chibaguy * r30720 10/branches/6.x/styles/arcturus.css: [FIX] Bad text/bg contrast with a.link and th. tikiwiki: 03chibaguy * r30721 10/branches/6.x/styles/jqui/options/trontastic.css: [FIX] More appropriate background for table headers, etc. Anybody knowing of a drip feed content feature in tiki? (or how to mimic it ?) Sorry, I'm only aware of the medical version of that. (IV) Is it in trunk that Intertiki now allows registering at slave sites? chibaguy: trunk for sure - but I think it is 6 hi sylvieg, thanks. I was just looking again at the ugly "Register" button themes.t.o. It points to tiki.org/tiki-register.php. polom hi jonnyb I'm having trouble with a module in wiki page, and it's getting br tags at the end of every line in the module code (getting parsed). How do you configure wiki (paragraph style?) to let modules display as they do in side columns? In other words, the login module is over twice its normal height, way too much white space vertically, due to injection of many br tags. (in this case, the login module) I've tried wiki paragraph options but still have the problem (maybe caches didn't get cleared or something). anone from the tikifest berlin online? Anyone who attended TikiFest Berlin: how about a little help with http://tiki.org/Upcoming+News#November_2010 Tx! tikiwiki: 03sampaioprimo * r30722 10/mods/trunk/wiki-plugins/r/lib/wiki-plugins/ (wikiplugin_r.php wikiplugin_r2.php wikiplugin_rr.php): wikiplugin_r.php now only works with safe R commands and wikiplugin_rr.php was created for running R unsafe commands hi ricks99 i was at tfbln but have no glue what kind of help you can use? I'm stuck... i have an user short menu (4 main items - one is subbed (5 sub pict gallery links). So i will create a menu. I want to display instead of links, button with 3 states. I figure that CSS using sprites and hiding the real links should do the trick. Someone has ever done this using TW ? ricks99? what should an attende add to the page you mentioned? ricks99: not been there but help possible. is it possible to configure a wiki page using wikiplugins so that I can edit more than one tracker item per time? or there is any other way to edit more than on tracker item per time? @coaboa: how about just a quick lis of some of the items discussed, and worked on? and PhilBack, too. Tx as of wikifestbln.org/projects? yonixxx: probably you could use the method of text replacement with images: give the menu text a large negative text-indent to get it off the screen, and use the image sprite for the menu item bakground. looking more for tiki-specifics. I never tried with Tiki, but if you look at the page source, you can see the css id's and classes that each menu item uses, etc. oki will add something this evening tx! has somebody installed a tiki on ovh personal offer? don't even know what it means sylvieg, sorry guessing it's some sort of shared plan hi lphuberdeau - how are the travels going? could be this http://www.ovh.co.uk/shared_hosting/ all good so far, but I'm still on GMT-5 timezone :P actually, might have made it to GMT-6 in berlin ouch need to introduce ADA (amette daylight avoidance) Hi Chibaguy, what you explain is ok and i got it. But how to link the button/sprites to the correct link... i have no ID or class there. I miss something. sylvieg: already installed tiki on one of their boxes but it was a dedicated server. sylvieg: it worked fine. my friend took the ovh pro hosting - so it is ok.. thx for feedback can someone please help me.. I can't use polls at all right now. I'll put the poll ID in there in the same way I did before when it worked. When I click the "module options" button, the whole page bombs and it tells me that there's no poll ID for the poll. I'm using {poll id=1}. I've also deleted all my polls and created a new one with an ID of 4. That doesn't work either There was one point where my site would not work at all because I had just {poll} in there in order to make a random poll. The only way I could bring the site back was to go into the "tiki_modules" table in the database and delete the poll entry. I tried going into the "tiki_user_modules" and changing the value from {poll from {poll} to {poll id=1}, but this didn't change things at all. No matter what I put in there, even just code to show the date, it would say there's no poll id assigned to the poll I'm trying to use. could you specify which version you are using? 6 and which version were you using before? I upgraded from 5 Is it better to start with a fresh installation of 6? it should be good upgrades are fine tikiwiki: 03marclaporte * r30723 10/trunk/templates/tiki-admin_include_metatags.tpl: duplicate help link tikiwiki: 03marclaporte * r30724 10/trunk/templates/ (tiki-admin_include_metrics.tpl tiki-admin_metrics.tpl): better inline docs for metrics dashboard lo all amette, got your voice back? hi JoernOtt Could I save just my tiki_users table, reinstall a new database and new installation of version 6, can I retain all the users and their passwords? mikebeary1, why would you not want to do a "normal" update? Otherwise I would simply rename the old users table and reimport it into the new database and then do a select into query unless the old and the new tiki is exactly the same version Sinceupgrading to Tiki6, the wiki_plugin(_include doesn't work anymore insmarty templates. Maybe due to theeditor parm. The code looks differentat the PHP level. Any clue? you will however loose all custom groups and the user->group mapping tikiwiki: 03xavidp * r30725 10/mods/trunk/wiki-plugins/r/lib/wiki-plugins/ (wikiplugin_r.php wikiplugin_rr.php): tikiwiki: [FIX]Pref for plugin r is added (besides rr) so that it can be enabled/disabled tikiwiki: again by tiki admin panels. A few strings updated to reflect current behavior, tikiwiki: and wikisyntax hidden at advanced section (hidden by default). Doc page will be tikiwiki: the same for both plugins tikiwiki: 03xavidp * r30726 10/mods/trunk/Packages/wikiplugins-r.info.txt: Updated description of this file with last changes in plugin r and rr tikiwiki: 03marclaporte * r30727 10/trunk/ (6 files in 3 dirs): [NEW] For better SEO, add option for Canonical URLs (only for wiki pages for now) and improve meta-tags and sefurls admin panels. polom hi chealer JoernOtt: something's not working, and I don't know what it is hi jonnyb thanks for the quick reply on dynamic trackers JoernOtt: I can't use polls at all now JoernOtt: can't figure it out can someone please help me.. I can't use polls at all right now. I'll put the poll ID in there in the same way I did before when it worked. When I click the "module options" button, the whole page bombs and it tells me that there's no poll ID for the poll. I'm using {poll id=1}. I've also deleted all my polls and created a new one with an ID of 4. That doesn't work either There was one point where my site would not work at all because I had just {poll} in there in order to make a random poll. The only way I could bring the site back was to go into the "tiki_modules" table in the database and delete the poll entry. I tried going into the "tiki_user_modules" and changing the value to {poll id=1}, but this didn't change things at all. No matter what I put in there, even just code to show the date, it would say there's no poll id assigned to the poll I'm trying to use. mikebeary1: I am currently creating a poll on my test machine Is there anybody who implemented/configured a drip feed for content in tiki? @mikebeary1: I'm able to add polls to a wiki page or a module in tiki 6 -- no issues mikebeary1: In my test environment, I can confirm that the random poll does not work. When I turn on "wiki parsed", it does not work either, but it works when turning off "wiki parsed" but I am working on trunk here something got screwed up I think. My page was down until I went into the database and deleted that line. Are there relationships betweeent the tables that I don't know about that I might have messed up? I may just start from scratch and wipe out the whole site. I hope someone has some insight here and can help mikebeary1: you were upgrading from which version? any programmer here who knows how to set object perms? I could need a short hint on how to set them (for the accounting stuff I'd like to give the creator of a book all rights on it) I was upgrading from 5 to 6 you need to add the permission to the database after the upgrade it worked fine, just after I tried using {poll that's when things stopped working add what permission? oh sorry, that was meant for JoernOtt lphuberdeau: I was wondering, if there is a function in $tikilib or somewhere else to do so. A user whoi has the right to create a new book in accounting should (at the same time) get all necessary permissions on that new book well, to add the permission, you need to modify tiki.sql and add a database patch... annoying, but not enough for anyone to fix that bit I know all that as for verifying the permission, there are quite a few ways I defined the permissions already tiki's permission system does not handle those per-user permissions but at runtime, user "testy" who has tiki_p_acct_create_book via his Group "Accountants" does create a book there are a few cases where being the creator grants certain rights, but those are handled as exceptions I want the creation routine to set object permissions on the newly created book I tend to think more in terms of groups and roles than users, it helps in making features that support collaboration I want to make this user "Admin" on his book you can't make a user admin, only groups can be granted permissions so if you want that per-user type of behavior (which I would really avoid), you can't do it with the global permission system u can have a unique group per user (autmatoically), then assign that user's group as admin can someone tell me if there are table relationships or primary/foreign keys in the mysql database? I haven't used mysql before mikebeary1: mysql supports them in the syntax, inforces them in certain storage engines like innodb, but tiki does not make use of them so, by creating a book, I should simply create a new group for that book book_1_admins or whatever and assign object permissions and put the user who created the book into it what does that mean in Admin tracker fields: "Check the box to re-import in this tracker and change the fields. Uncheck the box to import in another database." need to go AFK for about an hour, sorry for the interruption in which database is it imported if the box is unchecked? lphuberdeau: so by simply manually removing a row from the tiki_modules table shouldn't corrupt anything? mikebeary1: no, at least not a poll hello. i am trying to install tiki on a debian. i have installed php5 (of course) and php5-gd, but tiki says, it cannot find the gd-library. anything missing? i did not restart the webserver after installing php5-gd. before i installed it, tiki said, it cannot find gd-things ok, thanks JoernOtt damn, I wish I knew what was going oin. I can create a poll, but when I try to add it to a page, everything bombs out sash_ please restart apache to reload php and the libraries needed ok mikebeary1: turn on php error reporting @mikebeary1: which poll syntax are you using? {POLL(pollId="1")}{POLL} or {poll id="1"} oh, I think I got it JoernOtt: thats it, thanks no, i see no php errors {poll id="1"} I mean {poll id=1} try using the ful plugin syntax instead. works for me on my wiki pages {POLL(pollId="1")} that one? need to close it properly though either ... /} or {POLL} ok you're awesome ricks you always come to the rescue. Yes, that worked working now? kewl Very nice. mus be a bug in the {poll} somewhere This was such a headache because the documentation doesn't reflect that syntax when they tell you how to create a poll so there's no way to make a random poll for v. 6 now? try using the plugin helper .. it will always (usually) use the correct syntax what would be the proper syntax for that? polom every1 I would appreciate an svn up on doc.tiki.org hi luciash mikebeary1: make sure u don't have parse wiki checked for that module Yes, the plugin helper didn't put the right code in It just gave me {poll id=1} oh, it was the plugin helper, ok that is not correct then plugin help or the use quick URL selctor? I'm guessing that's what you mean by the little + symbol that puts the "correct" code in the data field for you should be {poll pollId=1} at least nope, its just {poll id=1} when I create a user module, and select a poll and hit the plus sign you can if try if that works what's the proper syntax for a random poll? @mikebeary1: no, i mean click the ( ? ) button in the toolbar, then select the PLUGINS tab ah, you mean for modules then ? then it is problem with the wiki syntax parsing of the user module, if unchecked it should work, as it is smarty syntax vs simplified wikiplugin syntax conflict not seeing the ? cant find the (?) button. http://twessentials.keycontent.org/display64&x=450&y=331 on far-right of the toolbar luciash: unchecked the page became blank, checked it said there was no poll id associated with the poll ricks99: thanks for the screenshot mikebeary1: hmm, maybe it should insert {poll id="1"}{/poll} but i am not sure as the syntax e.g. for css menus works fine and it is not necessary to close it as a smarty block ricks99: is that question mark in v 6? I see that the tab in that screenshot says "edit page", but I'm not completely sure what window that is mikebeary1: anyway, using wiki parsing and the wikiplugin POLL syntax is good workaround ricks99: if I edit the wiki page, I see a similar window, but no question mark question mark is in all version 4+ AFAIK are you using wysiwyg? not sure what that is are you using the wiki editor or WYSIWYG editor? luciash: the wikiplugin POLL syntax is this: {POLL(pollId="1")}{POLL} ? yes i dont think the plugin help is available in wysiwyg mode I'm editing just by using the edit button that's standard I wasn't aware there was a wysiwyg mode or tool how do I use the wiki editor? do u have the wysiwyg feature enabled? I dont think so... let me see.. where is that setting? Admin: Features found it it wasn't checked. I checked it aha! yep, the helper worked thanks very much ricks99 and luciash I'm giving a presentation on my wiki in a few hours, I wanted to show the poll feature. ttyl anyone know of a way to get comments on a per-article basis, by using article TYPE and CATEGORY? tikiwiki: 03jonnybradley * r30728 10/branches/6.x/lib/wiki-plugins/wikiplugin_googlemap.php: [FIX] gmaps: JS file needs to be 'external' (not minified) on some servers when JS minify is on. tikiwiki: 03jonnybradley * r30729 10/branches/6.x/tiki-admin_include_gmap.php: [FIX] gmaps: The other JS file needs to be 'external' too ricks99: you can set comments perms per category ricks99: but it must be something more complex, i know you ;) lol i want a way to show all the comments for an article for a specfici category i can use the last_wiki_comments with type=article, but also need a categId=XX (which doesn't seem to exist) you can probably use perspective for that ? maybe or include it in category plugin ? y, but category plugin doesnt find comments looking at a way to add category support to the wiki_last_comments module.... what's the command to say "xxx knows nothing about ..." ? how do you say that? * mikebeary knows nothing about * I like soup mikebeary1: /me nice, thanks ricks, I need to learn perspectives and workspaces very thoroughly before Jan 1. I'll spend an entire month only working on that. When I'm done I'll create a tutorial with screenshots for you to put up on your site if you like that would be great. tx odd. the query for the wiki_last_comments is in the module php -- not a lib looks like rick needs to add a join to the query to check the category of the owning object maybe not too difficult... mikebeary1: torsten (fabricius) already documented something iirc, which might be help for u lucaish whats iirc? where's this thing you've documented? or torsten rather if i remember correctly I read the documentation on workspaces in docs.tiki but it seemed pretty obscure. I didn't grasp it. I think there needs to be alot more youtube videos to explain and describe at least the basic elements of tiki. Like permissions, groups, workspaces, perspectives, etc. I think it would promote the use of tiki overall isnt there already a library funtion to return the category ID? mikebeary1: see http://tiki.org/Torstens+Project+Perspectives mikebeary1: there are some Tiki howtos contributed by teresa, see http://www.google.com/search?client=opera&rls=en&q=Tiki+site:wikihow.com oh yeah! He tried to give me a link in a forum to that, but the link was broken. that looks very descriptive thank you but videos would definitely help too or screencasts mikebeary1: It would be cool if you made some everyone is welcome here to help us I definitely will. I've always liked producing detailed instructions for stuff I'm going to be knee deep in it, so once I have a good understanding, I'll maybe work with Torsten to produce instructions. It says on his site that his goal is to enhance the documentation on the subjects of workspaces and perspectives well. tiki runs now. really nice. but is there perhaps a plugin to have mediawiki-syntax? or a mediawiki to tikiwiki-conversion-script? sash_: so far we are stuck with our own syntax, but have a look at http://doc.tiki.org/Mediawiki+Importer thanks lphuberdeau: I was wondering if it would make sense to use profiles for a book in accounting. After creating a new book, there are no accounts or reports in it, so I need to add them manually. If I have a standard schematics like SKR03 or SKR04 (typical german account schema) this means creating a few hundred accounts by hand and putting them into the right categories for reports etc. So I wonder, if profiles could be used for that (remember ing Marks speech on saturday) data channels? most likely is there any hint on dev on what to do (as a programmer) to allow selecting a datachannel in a