[00:05] *** marclaporte has quit IRC (Read error: 110 (Connection timed out)) [00:12] *** danopia_ has joined #tikiwiki [00:12] *** raji1 has left [00:22] *** Morpheus has quit IRC ("KVIrc 3.4.0 Virgo http://www.kvirc.net/") [00:24] *** danopia has quit IRC (Read error: 110 (Connection timed out)) [00:29] *** marclaporte has joined #tikiwiki [00:32] *** Lucymoz has quit IRC (Read error: 104 (Connection reset by peer)) [00:48] *** danopia_ is now known as danopia [01:13] *** Amorphous has quit IRC (Read error: 110 (Connection timed out)) [01:16] *** Amorphous has joined #tikiwiki [01:19] *** Caarrie|away is now known as Caarrie|sleeping [01:41] *** PrezKennnedy has joined #tikiwiki [01:43] heh, great to hear that americans like manual shifting ;) [01:43] I'm in that club also :) [01:45] ( americans like the continent I meant - dunno actually, if canadians are so much into automatics also... but well, off to bed now ) [01:59] *** PrezKennedy has quit IRC (Read error: 110 (Connection timed out)) [02:16] *** pkdille has quit IRC (Remote closed the connection) [02:27] *** chibaguy has joined #tikiwiki [03:05] *** Petjal2 has joined #tikiwiki [03:14] Hi all, if anyone's awake, I'm hitting the style problem while setting up a tw blog and while trying to use {TAG}. I remember seeing it mentioned in IRC, but I couldn't find a fix. Anyone? Thanks. [03:16] Petjal2, what Tiki version is that? [03:17] sorry, tiki-admin general reports 2.0RC4 [03:17] *** Brando753 has joined #tikiwiki [03:17] i may have done an svn up of some sort since then [03:17] Hey does anyone know how to remove the POWERED BY TIKIWIKI sign at the footer of the page [03:19] Brando753, what theme are you using? [03:20] Petjal2, in a site updated to release 2.0, I don't have a problem with style. [03:21] the defult theme :D [03:23] chibaguy: thanks. I'm so afraid to upgrade. I tried an svn up last week and got a bunch of adodb or some such errors. Luckily I was smart enough for that brief moment and made a backup which I had to copy back over. [03:24] Brando753, you can uncheck "Bottom bar" on Admin Look & Feel page (tiki-admin.php?page=look), under the "General Layout" tab. [03:25] This also stops the other things down there from showing. I don't think there's a specific checkbox for the "powered by" line. [03:25] k 1 sec [03:26] If you want the rss icons or translation icons, etc., but not the powered-by line, you'll have to edit templates/tiki-bot_bar.tpl, as far as I know. [03:28] thx worked great :D [03:29] no problem :-) [03:34] chibaguy: any idea which file has the style problem? maybe I can fix just that file? (or, more harder, how to safely upgrade my tw to 2.0 or, egads, 2.1?) [03:35] I just updated a site with ftp to 2.1. I ftp the files (overwrite if source newer), then run the tiki-install.php page to update the db. Smooth as silk. [03:38] sweet i changed the text at the buttom to display my articles copyrights thanks :D [03:40] :-) [03:41] hmm, I didn't run the tiki-install.php after my svn up, maybe that was my problem. [03:42] The install script takes care of database updates. [03:42] (Not content, but table structure, etc.) [03:42] which would maybe explain the adodb errors [03:43] You don't actually need to run tiki-install.php if you manually update the database instead, as long as new db additions, changes, etc. are made. [03:44] But the script is probably the easiest way. [03:44] oh yeah [03:44] In the past I used phpMyAdmin, but it's tedious. [03:46] ...quits at each error. The "errors" reported by tiki-install.php are mostly (all?) about changes that have already been made. [03:47] and so the errors can be ignored. [03:47] as I recall somewhere there was an option to ignore those errors, but I forget where it was [03:49] There's a flag to set for command line mysql access, but I don't know about in phpMyAdmin. I never found it, if so. [03:49] The blog and {TAG} are not high priority now, so, being as exhausted as I am at the moment, I'll think I'll wait... Thanks for the input, chibaguy! [03:50] *** leon007 has joined #tikiwiki [03:52] sure, but there are security issues, so maybe don't wait too long ;-) [03:52] Hi. This is my attempt #3 at the same question :) - any advice would be appreciated. I'd like to collect some info from the users on registration, namely their location (not long, lat, but actual city / country where they live). I want to enable those users to be able to edit that info later on if they wished from their User Preferences under My Tiki. What is the best way of doing it? I looked into trackers - is [03:52] or something else? [03:52] *** ricks99 has quit IRC (Read error: 110 (Connection timed out)) [03:53] leon007, this is what using trackers for additional user information is for, as I understand it. But I haven't tried it myself so don't know the details. [03:55] Did you read http://doc.tikiwiki.org/tiki-index.php?page=User%20Tracker&redirectpage=Registration%20Tracker [03:55] ? [03:58] I did a google search on tiki documentation and somehow didn't see this page. Let me have a look! [03:59] Ok [04:07] I'll try this - sounds somewhat complicated. I am somewhat confused by this step in tracker creation: [04:07] There must be a user selector - with the option feeding=1. This field will be automatically filled with the username. Note what the fieldID is for this one. [04:07] *** Brando753 has quit IRC (Read error: 104 (Connection reset by peer)) [04:17] leon007, maybe you need to go through the steps of making a tracker, if you haven't done that before. [04:18] *** marclaporte has quit IRC (Read error: 113 (No route to host)) [04:20] (but I don't know what "with the option feeding=1" means, either, offhand....) [04:27] hi chibaguy - thanks for the link. I feel like I am almost there... I do now get a query as a second step of registration, but I am doing something wrong with the way I am trying to reference fieldIds of the trackers, [04:27] because I get this: [04:27] Incorrect fieldId: fieldId=3, fieldId=4, fieldId=5, fieldId=6 [04:28] I also tried just 3, 4, 5, 6 [04:31] never mind... "3: 4: 5: 6" works! [04:34] *** franck has left [04:35] nice [04:39] I want to cry :( [04:40] I was premature in my celebration... Now I am getting "Wrong registration code" after I enter all the tracker info... [04:41] Do you use the registration code option normally? [04:41] is this the anti-robot code thingy? [04:42] those funky jumping around numbers? [04:42] *** Paragtim has joined #tikiwiki [04:43] No, similar but in this case it's "Request passcode to register:" option on Admin Login. [04:44] The number isn't random, it's set by admin and people registering have to know it in advance. [04:45] I assume from the message you're getting that it's turned on or something thinks it is. [04:45] no, that was never checked off... Also, if I turn off using trackers on the Group registration (i.e. user is not asked for those fields) then this problem goes away [04:45] I can register just fine, that is [04:47] u r talking about: [04:47] Request passcode to register: [04:47] ? [04:48] it's not checked in the admin [04:49] Yeah, just wanted to eliminate that possibility. [04:50] Seems like there is a bug ID 1505 [04:50] What Tiki version are you using? [04:51] tiki 2.0 [04:51] even closer bug: ID 1818 [04:51] User registration with anti-bot & user tracker for additional information not working [04:52] :( [04:52] Well, there's a 2.1 release out today. I don't know if this bug's been fixed, tho. [04:54] What does this mean: [04:54] Sylvieg checked a fix into trunk (3.0). I've back ported tiki-register.php to my Tiki 2.0 and it seems tow work now. Needs additional testing by others. [04:54] seems like there is a fix floating somewhere, but where is it? [04:56] *** vilisi_t has quit IRC ("Leaving.") [04:57] yeah, it works if I disable the antibot thing also... [04:57] It seems to mean you can save this -- http://tikiwiki.svn.sourceforge.net/viewvc/tikiwiki/trunk/tiki-register.php?revision=14417 -- as tiki-register.php and try using it at your site. Maybe keep the current tiki-register.php around just in case you need to switch back. [05:04] beautiful! it worked... Now I just need to figure out why the value of those trackers don't show up in preferences (just the fields show up) and I'll be on my way... Thanks a lot chibaguy - you've been extremely useful! [05:04] *** franck has joined #tikiwiki [05:05] Heh, sure, no problem. :-) [05:15] *** leon007 has quit IRC ("CGI:IRC") [06:30] *** franck has quit IRC (K-lined) [06:30] *** lq_902 has joined #tikiwiki [06:30] *** lq_902 has quit IRC (Client Quit) [07:08] polomoloq [07:17] *** nkoth3 has left [07:19] *** Wilkins has joined #tikiwiki [07:39] *** djst has joined #tikiwiki [08:11] SVN: Commit by chibaguy :: r 14835 /mods/trunk/themes/ohia/styles/ohia.css: [FIX] Site title color wasn't set for a:visited. [08:13] hi luciash. BTW, your greeting is a kind of visual palindrome, I'd say (http://en.wikipedia.org/wiki/Palindrome) (-- visual because the p is flipped) [08:18] bbl [08:18] *** chibaguy has left [08:54] *** Darklordx11 has joined #tikiwiki [08:54] Yo [08:56] *** Nunya has joined #tikiwiki [08:57] Yo [08:57] Hiya Nunya [08:57] Hello Darklordx11 [08:58] Later [08:58] *** Nunya has quit IRC (Client Quit) [09:26] Hi guys, when I use: {CATEGORY(id=>14,sub=>n,sort=name_asc)}{CATEGORY} on a wiki it shows the contents of the category just fine. But it also shows an annoying headline "Category: ". Can I get rid of that? [09:45] *** ricks99 has joined #tikiwiki [09:46] *** ricks99 has quit IRC (Client Quit) [09:46] *** Darklordx11 has quit IRC () [10:11] *** Morpheus has joined #tikiwiki [10:46] *** ricks99 has joined #tikiwiki [10:52] *** martinalex has joined #tikiwiki [11:04] *** gmc is now known as gmc__ [11:08] *** gmc__ has quit IRC (Remote closed the connection) [11:15] *** xavi has joined #tikiwiki [11:15] hi all [11:16] *** marclaporte has joined #tikiwiki [11:17] I need some help to have the wrong query in tiki-admin_categories.php fixed so that it works back again on mysql 4.0.x sites with Tiki 2... [11:17] sylvieg ? any other mysql standards guru around and willing to help? [11:18] *** Morpheus has quit IRC (Read error: 113 (No route to host)) [11:19] *** Caarrie|sleeping is now known as Caarrie [11:20] ^ lphuberdeau ? marclaporte ? [11:21] *** Darklordx11 has joined #tikiwiki [11:22] I'm in trouble on a production site due to this issue, and I would need to use that site tomorrow with my students... [11:22] hi xavi. sorry, im no mysql guru :( [11:23] hi ricks99, thanks anyways :-) [11:26] polom [11:26] xavi: : no sé [11:26] "no s?" ? [11:27] and what is the query that does not work? [11:28] hi sylvieg, hold on... [11:28] I know the one in fgal - but I have no idea what this query is doing... [11:30] http://uniwiki.sima.ourproject.org/tiki-admin_categories.php [11:30] you can reproduce the error there... sylvieg, you had admin account on that site [11:30] afaik [11:30] Query:SELECT tab.*, tfgp.`name` as `parentName` FROM (SELECT 1 as `isgal`, tfg.`galleryId` as `id`, tfg.`parentId`, tfg.`name`, tfg.`description`, 0 as `size`, tfg.`created`, tfg.`name` as `filename`, tfg.`type`, tfg.`user` as `creator`, '' as `author`, tfg.`hits`, tfg.`votes`, tfg.`points`, '' as `path`, '' as `reference_url`, '' as `is_reference`, '' as `hash`, tfg.`name` as `search_data`, tfg.`lastmodif` as `lastmodif`, '' as `last_user`, '' as `lockedby`, [11:31] Message:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT 1 as `isgal`, tfg.`galleryId` as `id`, tfg.`parentId`, t [11:31] I'm having a problem with categories. When I set them up, and put pages in them, registered users cannot see the pages anymore. Anonymous users have: tiki_p_view_categorized and tiki_p_view_categories. they can see the categories, and the pages, but when they click on the page, it says permission denied....? [11:31] it is the fgal one .... I have no idea what this query is doing [11:32] will find out who wrote this beautiful query and send a mail [11:32] (I think it is nyloth [11:34] Darklordx11: Does registered include Anonymous? [11:34] Darklordx11: just a guess: can you check that your registered group is inheriting permissions from anonymous? (it should, but just in case, did you try adding those perms manually to registered, and to the category) [11:34] Yea, says inherited from when you check under registered for the permissions. [11:35] @Darklordx11: do you have specific permissions assigned to the category? [11:35] try also adding them to the category [11:35] Actually if I add permissions to the category itself, they dissappear for all users except admins... [11:35] btw, thanks sylvieg . [11:36] for the annoying fgal query in mysql 4.0.x [11:36] Also, I found if I added perms to the page itself, it IS viewable. [11:36] but I don't want to have to add perms to every page that gets created... meh. [11:36] page-specific perms will override the category and/or group perms [11:37] Darklordx11: when you add permissions to a category (or any object in tiki), you have to set explicitly all the permissions you want to all groups [11:37] Ok, that makes sense. [11:38] Darklordx11: if this solves your problem, could you please read documentation about categories and permissions, and explain this in clear words, if you consider that it is not clear enough explained there? [11:38] I mean, improve documentation pages if needed: http://doc.tikiwiki.org/Documentation [11:38] When I go to assign permissions to category, I select tiki_p_view_categories to group registered for This category and all its children. [11:38] if you can, please [11:39] And then, its inivible to registered users for some reason. [11:39] Darklordx11: add view_categorized also (needed) [11:39] and add them also to group anonymous! [11:39] xavi, that query requires 4.1 [11:40] Ok, added both, and now user can see the category but not the pages in it. [11:40] lphuberdeau: thanks for info, I deduced that some days ago.... We are just looking for some way to allow Tiki 2 being usable in mysql 4.0.x.... [11:41] ah 4.1.... not 5.0 [11:41] Darklordx11: did you read and understand the new behavior of category permissions in Tiki 2? it's explained in documentation [11:41] I did read it, but it doesn't seem to be working that way.... [11:41] xavi you need to ask your sysadmin to upgrade... [11:41] it's only partial in the chat screen [11:42] I'm at 2.1 [11:42] 4.0 is no longer supported... realy old [11:43] lphuberdeau: the fact is that http://ourproject.org is running 4.0.x, and they are in process of upgrading to higher (mysql 5 probably), but it required hardware upgrade also... and it will take some weeks or months yet, it seems... [11:43] I was told that info by the sys admin of ourproject.org yesterday.... [11:43] but upgrade 4.0 to 4.1 must not be so hard... [11:43] FYI: http://edu.tikiwiki.org is hosted on ourproject.org [11:43] hardware upgrade? [11:44] Let me go re-read the doc for categories, and try again. [11:44] bbl [11:44] buying ans installing new hardware, for some other reason, and they were planning to do both things at once [11:45] sylvieg and lphuberdeau , I'll ask him to upgrade to 4.1 at least, of possible. However, there are other people with the same issue... (I saw people complaining on tw.o forums weeks ago, and no answer about what to do...) [11:46] anyway, thanks for the info and tip, lphuberdeau and sylvieg [11:47] code would have to be rewritten for it to work in 4.0, and it's not so easy to do [11:48] yeh - it is not an easy query ... what about pickink the get_files function from just brfore the change [11:49] sysadmin is on jabber right now and considering the 4.0 to 4.1 upgrade... [11:51] q: new 2.1 install. what perm is needed for switch_theme module? im logged in as admin and says "permission denied"? [11:52] o i see... need 'reg users can change theme' [11:55] otherwise xavi you can pick up the get_files function before rev 11520 http://tikiwiki.svn.sourceforge.net/viewvc/tikiwiki/trunk/lib/tikilib.php?r1=11438&r2=11520 [11:56] sylvieg, and lphuberdeau: in my case, I'll find my way. The sys admin will attempt a mysql upgrade from 4.0.x to 4.1.x (and backups for the hundreds of sites hosted there, etc.). If it succeeds, I'll keep setting up that tiki tomorrow. If for whatever reason the upgrade fails, I'll get an old version of tiki110cvs in the mean time (while the site is successfully upgraded) [11:57] sylvieg: get_files... you mean that I manually revert that change from tikilib.php and that's it? [11:58] yes in tikilib rename get_files get_files_new, pick up the code of the get_files funciton in revision 11438 - and try ... [12:01] thanks sylvieg, I'll try right now [12:04] Hi guys, when I use: {CATEGORY(id=>14,sub=>n,sort=name_asc)}{CATEGORY} on a wiki it shows the contents of the category just fine. But it also shows an annoying headline "Category: ". Can I get rid of that? [12:06] Ok, followed the categories documentation exactly. I have one category, with view permissions to registered and anon. The anon account has both view permissions for categories and categorized. Registered inherits all from anon and also had edit categorized. The registered and anon users can see the category, but cannot see any pages in the category. I have one test page in the category. [12:07] *** raji1 has joined #tikiwiki [12:08] Darklordx11: any specific perms on that page? [12:08] I just created the page, its default. I just checked, and no perms assigned to that page. [12:09] @Darklordx11: did u clear the cache? [12:09] Hrm, no. [12:10] Which Cache should I clear? [12:10] all tiki caches [12:11] @stix: u can modify the cateobjects.tpl template to remove the "Category:" text [12:11] *** MatWho has joined #tikiwiki [12:11] hi xavi [12:11] Still says no records found when I log in as guest (registered user account) [12:12] hi MatWho :-) [12:12] Would it make a difference if its running on windows under apache? [12:13] Darklordx11: "no records found"? could provide the url where you expect to see the categorized page and you don't? [12:13] Unfortunately this is an internal system and will not link externally, but I am going to categories and clicking the category to see any pages contained in it. [12:14] ricks99, okay thanks, I'll have a look at that file [12:14] kb/tiki-browse_categories.php?find=&type=&parentId=0&sort_mode=name_asc [12:14] ok, Darklordx11: did you try with another theme style? like tikinewt.css , or thenews.css ? [12:15] xavi: I can try that. [12:16] xavi: tried thenews, same result. [12:16] Darklordx11: anyway, the url you said is for parentId=0, and I guess your category has an Id differnt from zero... [12:16] yes, id=1 [12:16] sorry, lol. [12:17] Just been working on this for 2 days, getting a bit flustered. [12:17] @ darklordx11: if u uncategorize the page, will it appear in the regular page listing (tiki-listpages.php)? [12:18] Yes, it will. [12:18] Darklordx11: and even if categorized, does it appear on regular page listing? [12:19] on the category's admin page, do you have the "assign permisisons automatically" optin enabled? [12:19] If I remove the permissions on the category itself, the page will show up, but I get a permission denied when I try to view it. [12:20] and u are 110% sure that there are no individual perms on the page? [12:20] OMG. [12:21] Hrm... [12:21] It just worked. [12:21] worked? what? [12:21] I removed the permissions from the category again. So the page would show up, (so I wouldn't catch myself fibbing). [12:21] and went there under my guest account, and it loaded the page. [12:22] I wonder if it was cause I cleared the cache a few mins ago... [12:22] Lemme add some of my real pages to it and see if it works. [12:23] That works now too! Hooray! [12:23] Seems that having permissions on the category itself was not letting me see or view the pages. Which seems backwards to the reason for having permissions. [12:23] yes, cleared cache and recompiling templates did the job, probably [12:24] im confused... do u have specific perms on the >category thanks very much guys. I should go add a NOTE: to the doc pages mentioning that. [12:25] ricks99 I had added tiki_p_view_categorized to the category for both anon and registered. [12:25] When I removed those, it started working. [12:30] *** lphuberdeau has quit IRC (Read error: 113 (No route to host)) [12:30] Darklordx11: afaik, tiki_p_view_categories and tiki_p_view_categorized to anons and registered, if applied to the category itself, should allow the anons and reg. users to see the page [12:33] xavi: seems though, as I just duplicated, if I add those to the category, the pages and the categories become invisible to anon and registered user... I don't know why. But the behaviour I have now, is what I needed. I don't want any restrictions on pages in the categories, just using it as an organization structure. [12:43] Ok, so heres another question, before I upgraded to 2.1 from 2.0 my logo was flush with the top of the window, now its bumping it down as if the search bar has its own row. Is this some option I can change? [12:46] no idea myself. sorry. Try at "site identity" ("look and feel" options) [12:47] Reading it, but it seems that 2.1 changed the behaviour of those options... [12:47] trial and error, I would say [12:47] and if you get the difference, consider adding how it works on documentation pages, please [12:47] Absolutely [12:48] thkx [12:48] *** chibaguy has joined #tikiwiki [12:49] Darklordx11, what theme are you using? [12:49] tikineat [12:49] I was thinking it could be a css thing. [12:51] *** Caarrie is now known as Caarrie|away [12:51] hi chibaguy: congratulations for your new themes.... :-) [12:52] *** navster has joined #tikiwiki [12:52] Darklordx11: try with tikinewt.css or thenews.css, just in case [12:52] tikineat.css was mostly the reference one for tiki 1.9.x sites, but not for 2.x sites, afaik [12:52] Oh, ok. [12:53] hi xavi, thanks. [12:54] welcome [12:54] sylvieg: the url to the diff in tikilib.php you wrote before, it was for trunk, and I'm using tiki 2.0... (soon 2.1) [12:55] should I get the reference file (or diff) elsewhere? [12:56] Darklordx11, I'm not aware of changes in Tikineat. I've been paying more attention to the new themes. [12:57] *** lphuberdeau has joined #tikiwiki [12:57] *** PrezKennnedy has quit IRC ("Leaving") [13:07] *** nkoth3 has joined #tikiwiki [13:08] I don't see any changes in tikineat.css or the templates that would cause this space, in a quick check. But aiming Firefox/Firebug at the page would probably show what's happening there. [13:12] Ok, bbl peeps, thanks for all your help! [13:12] *** Darklordx11 has quit IRC () [13:13] *** marclaporte has quit IRC (Read error: 113 (No route to host)) [13:21] *** VK4MSL has quit IRC (verne.freenode.net irc.freenode.net) [13:21] *** SEWilc1 has quit IRC (verne.freenode.net irc.freenode.net) [13:21] *** CIA-53 has quit IRC (verne.freenode.net irc.freenode.net) [13:21] *** Petjal2 has quit IRC (verne.freenode.net irc.freenode.net) [13:21] *** Sug4r has quit IRC (verne.freenode.net irc.freenode.net) [13:22] *** Petjal2 has joined #tikiwiki [13:22] *** SEWilc1 has joined #tikiwiki [13:22] *** VK4MSL has joined #tikiwiki [13:22] *** CIA-53 has joined #tikiwiki [13:22] *** Sug4r has joined #tikiwiki [13:28] chibaguy: hi, I was listening in, I was wondering, which is the most up-to date (or reference) theme for 2.x and 3.x [13:31] *** ricks99 has quit IRC (Remote closed the connection) [13:42] Sorry MatWho, I was washing dishes. ;-) [13:42] sounds like fun [13:42] Depends on what you like, I guess. ;-| [13:43] Well, I'd say Darkroom, The News, or Feb12. [13:43] These all use the *litecss layout method. [13:44] Tikinewt does, too, but other than that, it contains a lot of CSS from Tikineat, which isn't necessarily modern. [13:44] ok so that is what I will do. Thanks. So I will move over to litecss [13:45] Unless something new/better comes along, this layout method will be default in Tiki 3. [13:45] (as far as I know) [13:45] thanks :) [13:46] Sure. Let me know if you run into any problems or have questions. [13:46] chibaguy, if you indend on it becoming the default in 3.x, you should make the default change as soon as possible so more of us use it [13:46] +1 [13:47] defaults don't change by themselves and I will be more and more against default changes as we move closer to the release [13:48] which reminds me that PDO should also be the default if available [13:50] OK. templates/tiki.tpl, etc. are already *litecss. I didn't think about what else needs to be changed, though I do see tikineat in some lib file. [13:50] (in trunk) [13:55] well, default style should be changed [13:56] SVN: Commit by lphuberdeau :: r 14837 /trunk/ (29 files in 8 dirs): [MOD] Database upgrade script revamp (from branches/experimental/upgrade) [13:57] OK, I've heard different opinions about which theme, of the current ones. Maybe this should be asked on tikiwiki-devel. [13:57] I just sent a mail [13:59] ok [14:01] Hi all, I added some fields to a table in tiki.sql - just done a trial install and it has not worked. The SQL is fine. So how does the installer create the DB tables? [14:01] SVN: Commit by lphuberdeau :: r 14840 /branches/experimental/upgrade/: [KIL] Branch merged in trunk [14:01] tiki-upload_file is again broken for me... nobody else? [14:01] SVN: Commit by lphuberdeau :: r 14839 /branches/experimental/plugin_ui/: [KIL] Branch merged in trunk [14:02] matwho, tiki.sql is used to generate other files through some scripts ... you also need to modify the update script [14:02] http://dev.tikiwiki.org/DatabaseSchemaUpgrade [14:03] reading tx [14:06] lphuberdeau: sorry being a bit slow, the page is about creating a patch - I dont want to patch, I want to ensure a new install has the extra fields. [14:07] yeah, but you need to create a patch too... even beyond new installs, updates need to take that into accound [14:08] tx, hold on reading source code ... [14:10] I confirm version 14771 was uploading correctly file - the latest is broken - has somebody an idea? [14:11] matwho, I need to modify the doc a little bit [14:11] but in fact, with the new code I just merged it, all you need to do is create a patch if it's custom code not to be added to tiki [14:13] SVN: Commit by lphuberdeau :: r 14841 /trunk/installer/schema/ (18 files): [FIX] Oops... missing suffix [14:13] ok, I think I get what you are saying. Hold on still reading .. [14:14] you just happened to ask the questions while I was changing everything [14:17] *** PrezKennedy has joined #tikiwiki [14:18] *** marclaporte has joined #tikiwiki [14:19] Humm, if I look in tiki-installer.php I find a function called load_sql_scripts - it does not put the file tiki.sql on its list for return. Do you know where I am, if so will continue. [14:20] lphuberdeau: sorry I will update from SVS and look again, just seen all you changes [14:21] make sure you are at rev 14842 [14:21] (or higher of course) [14:21] Going up :) [14:22] polom [14:22] pow [14:23] Or dare i say - pickle [14:24] hahahaha [14:26] matwho, doc updated again [14:26] lphuberdeau: tx, reading [14:30] ok, so for my general understanding why if I committed back an update to tiki.sql. Then downloaded a fresh copy from SVN, checked to see my change was in tiki.sql - did it not get run by the installer? [14:31] that's an other issue [14:31] yes [14:31] the installer does not use tiki.sql [14:31] it uses tiki-3.0-*.sql [14:31] those are created by some script we run once in a while [14:32] but from trunk, if you just create a patch, the installer will handle it for you if it does not have _tiki as a suffix [14:33] ok so from what file does the script create the tiki-3* files [14:34] Are you are telling me not to add stuff to tkik.sql [14:35] if that is true it needs to be removed, surly :) [14:38] well, is your change custom or will be integrated back in tiki? [14:38] tiki.sql becomes only for base tiki stuff [14:41] it is bug fixes and enhancements to webmail - needs to be ther in a new 3.0 install. [14:43] so what is the definition of base? I will have to back out my fixes to webmail, because they break a new install. Unless I put the changes in each of the tiki-x.x-x.sql files [14:43] boring - or have I got the wrong end of the stick - again? :) [14:43] *** tomb__ has quit IRC (Read error: 113 (No route to host)) [14:45] * marclaporte is happy MatWho is working on the webmail [14:46] I have decided to get it working a bit better [14:46] :-) [14:46] it needs some love [14:46] I understand we now have group email accounts? [14:47] well not untill I can get my changes to the SQL made, at present it is all broken ;) [14:47] how/why/what for do you use the webmail? [14:48] Its sage 1 of a plan. [14:48] sage = stage [14:48] lphuberdeau : thought out a smart way to deal with the database schemas [14:48] :) [14:49] how many stages? [14:50] matwho, if it's for tiki dist, you need to create a patch and modify tiki.sql ... for installer to work, take a look at db/convertscripts/convertsqls.sh [14:51] (kind of hard to run) [14:51] My first customer for "charity in a box" has the usual help@charity.com. This will allow a group of volunteers to handle the messages as they come in, trackers and wiki to hold the history. Group webmail to allow them all to read off and work on collaboratively the email list. All integrated in to TW. [14:51] got to have lunch back soon... [14:52] MatWho: : good stuff! [15:08] SVN: Commit by sept_7 :: r 14844 /trunk/lib/tikidblib-pdo.php: [FIX] : fix PDO... bad test... :( [15:08] i am back [15:10] SVN: Commit by sylvieg :: r 14845 /trunk/ (4 files in 3 dirs): [MOD]fgal: button to download in a zip a set of files (not working for suggal now) [15:10] lphuberdeau: what problem is convertsqls.sh trying to solve? [15:11] original idea was to deal with differences between database servers... existed long before I joined the project [15:11] lets get rid of it? [15:11] but really, mysql is the only server tiki can run on these days [15:11] +1 [15:11] still a sensible subject... mostly going to happen in 4.0 [15:12] leaving some time for people to jump in and save other databases [15:12] so for now how do I run the script [15:12] you need a shell and a working tiki installation [15:12] (locally) [15:13] there is some doc in the file itself [15:13] ok [15:15] Hang on... the script concatenates tiki.sql with the version.sql files and just copies them around. Why not just read in tiki.sql in the install.php at install time? [15:15] scripts are different for the different servers [15:16] the mysql one is probably extremely simple [15:17] SVN: Commit by sylvieg :: r 14846 /trunk/tiki-download_file.php: [MOD]fgal: button to download in a zip a set of files (not working for suggal now) [15:19] So I run the script on my mac and then commit all the version-database.sql files back to trunk. Or is that not correct? [15:21] SVN: Commit by chibaguy :: r 14847 /mods/trunk/themes/eatlon/styles/eatlon.css: [FIX] Improved layout of category items (li float had clear problem). [15:27] SVN: Commit by lphuberdeau :: r 14848 /trunk/lib/ (3 files in 2 dirs): [FIX] Solve the PDO-AdoDB concat() incompatibility [15:30] chibaguy? [15:33] SVN: Commit by sylvieg :: r 14849 /trunk/styles/darkroom.css: [FIX] no more linkbut [15:34] I am not sure to take away the linkbut class was a good idea. Now in browsing file galleries the watch... have a shadow :-( [15:34] I noticed quite a few buttons lost their box all around too [15:35] yes is a chibaguy commit - but the styles have not been updated ... and it is not simple [15:35] I need a .navbar a :not[img] or something like that [15:39] *** chibaguy has quit IRC (Read error: 110 (Connection timed out)) [15:45] *** chibaguy has joined #tikiwiki [15:45] *** Morpheus has joined #tikiwiki [15:45] I am using tikiwiki 2.0 and have a problem with a multilingual site: if I enable "detect the browser language" and change the language using the switch_lang module it always falls back to German. (u can try it at series60-remote.sf.net ) (bug report 2038) [15:48] sylvieg, I took the class linkbut off of links that were inside a certain span or div, and so the class wasn't needed. If a theme lost the style, it can be put back with the contextual selector (span a or div a -- I don't recall their class name offhand). [15:48] ah chibaguy - I just sent an email on deval as you left [15:48] morpheus, did you enable "show page in user's preferred language"? [15:49] lphuberdeau: yes [15:49] I use that setting all the time and never had that problem [15:49] Right, I felt div.navbar a.linkbut was excessive when div.navbar a will do fine. [15:50] I'll try to disable it [15:50] if you solve easily the problem of darkroom [15:50] it will be great ... bu i do not see an easy solution... [15:51] SVN: Commit by sylvieg :: r 14850 /trunk/styles/darkroom.css: linkbut over [15:51] mmm, some more help needed. I need to delete 500+ wiki pages from a production site. tiki-listpages.php is (was) expected to do it, but it's not on 2.0. The multiple checkboxes work for selection, but when you select "remove" from the drop down, it asks for confirmation, and after confirming, it reloads the page without deleting pages [15:51] I will take a look. My intention was to make the change only where it wouldn't cause a problem. [15:51] lphuberdeau: still the same problem :( (btw, it only doesn't work if i am not registered) [15:52] xavi delete the confiramtion step in tiki-listpages - it is not working [15:53] btw, sylvieg, I tried to manually apply that change to tikilib.php but I didn't succeed (blank page). No worries: hopefully op.o will be using mysql 4.1 from tomorrow morning onwards, and I?m attempting to leave the site as much ready as possible for tomorrow [15:53] check out http://wiki-translation.com/tiki-index.php ... uses 2.x and has all the multilingual stuff enabled [15:53] sylvieg, thanks, I?ll try without confirmation step [15:53] (or temporary uncheck in admin->general_.cross scripting feature [15:55] thanks, sylvieg, this did the trick: multiple deletion is back again working [15:55] lphuberdeau: but this page doesn't use the switch_lang module [15:56] hmm... recent change... used to be there [15:57] and i got the same behaviour on www.opensourcecms.com/cms/tiki [15:59] *** martinalex has quit IRC (Read error: 110 (Connection timed out)) [16:00] I don't really have time to look into it at this time [16:01] never mind ;) [16:08] *** chibaguy has left [16:21] *** WildPikachu has joined #tikiwiki [16:21] any easy way to see what version of tiki i'm running? [16:22] admin->general [16:22] written in there [16:22] if not, it's probably really old [16:23] i want to upgrade to 2.1 .... bit scared as I don't know what version this is, i am very sure its 1.9.6 [16:27] *** danopia has quit IRC (Read error: 101 (Network is unreachable)) [16:27] *** nkoth3 has quit IRC (Read error: 110 (Connection timed out)) [16:30] *** snarlydwarf has joined #tikiwiki [16:33] *** Wilkins has quit IRC (Read error: 104 (Connection reset by peer)) [16:46] 1.9.6 to 2.x isn't a small update [16:47] I would reccommend you set-up a 1.9.6 somewhere else, import your production data in there and test the update before making it live [16:47] in fact, it's probably better to update to 1.9.11 first [16:47] just did it, seems to of worked ok :) [16:47] neat [16:48] again, i have no clue what version it was .... maybe even pre-1.9.6 [16:48] *shrug* :) [16:51] lphuberdeau: just checking I have run the script, now I check back all the files it updated. Do I have to create a patch file as well? [16:51] yes... patch file is for people that upate [16:52] Oh I am starting to get it! :) [16:52] *** raji1 has left [16:53] *** raji1 has joined #tikiwiki [16:53] *** navster has quit IRC (K-lined) [16:53] *** raji1 has quit IRC (K-lined) [16:59] *** Caarrie|away is now known as Caarrie [17:00] SVN: Commit by matwho :: r 14851 /trunk/db/convertscripts/ (5 files): [MOD] Now also runs PHP directly from command line without need to execute php via a server, if no host specified then runs php off comnd line. [17:03] *** marclaporte has quit IRC (Read error: 113 (No route to host)) [17:04] lphuberdeau: Upgrade just failed with 1 sql error SELECT patch_name FROM tiki_schema [17:04] Table 'twdev1.tiki_schema' doesn't exist [17:04] lphuberdeau: I think that is you@! :) [17:05] *** marclaporte has joined #tikiwiki [17:05] *** VK4MSL has quit IRC (Read error: 104 (Connection reset by peer)) [17:05] most likely... when did that happen? [17:05] *** Redhatter has joined #tikiwiki [17:06] just now, I blew my db away, rm local.php and ran tiki-insatll.php [17:08] can see I am missing any important updates from SVN [17:08] can = can not [17:15] *** djst has quit IRC () [17:29] lphuberdeau: any ideas about my install error [17:29] *** martinalex has joined #tikiwiki [17:29] I have to look into it... doing 2 things at the same time already... (soon 3 because I have food coming up) [17:30] :) [17:31] *** SEWilco2 has joined #tikiwiki [17:34] *** Lucymoz has joined #tikiwiki [17:41] *** tomb__ has joined #tikiwiki [17:43] matwho ... convertscripts related I would guess [17:43] tiki_schema was just added to tiki.sql... if you installed before running the thing, it's left in an inconsistent state [17:44] ok I will run it again and report back [17:55] *** djst has joined #tikiwiki [17:56] lphuberdeau: are you there? [17:58] yes [17:59] ok I checked and the table tiki_schema is in my db, but I got the error at install time [17:59] is it your code in the installer? [18:01] here is the thing... when you update, if tiki_schema is missing, it will take that into account and install the patches in the old way [18:01] ok [18:01] however, on clean install, it expects the table to be in, because we control the source [18:01] this is a temporary problem in the transition ;) [18:02] ok I will forget it - basic things on the new istall seem to work fine. :) [18:12] lphuberdeau: Yellow card for blowing my updates away to tiki_2.0to3.0.sql without considering my feelings and letting me know when you did your merge :) [18:13] Problem solved :) :) [18:14] I made it before our discussion this morning [18:14] fixed a few issues during our discussion [18:15] I am very happy :) [18:15] Yes very very happy [18:16] it is much better the new way, tx. Just need to get rid of that silly script for tiki.sql [18:21] do you read the devel list? [18:22] *** hebus has joined #tikiwiki [18:24] * marclaporte is happy that MatWho is happy [18:34] *** CIA-53 has quit IRC (Client Quit) [18:34] *** CIA-53 has joined #TikiWiki [18:38] *** pkdille has joined #tikiwiki [18:39] *** nkoth3 has joined #tikiwiki [18:39] lphuberdeau: the email one? [18:43] yes [18:43] SVN: Commit by matwho :: r 14854 /trunk/ (7 files in 2 dirs): [FIX][MOD] Added fields to tiki_user_mail_accounts and tiki_webmail_messages. Need this to go with previous commits. [18:43] so yes, well I will admit I speed read some of them recently [18:44] ok, because there are some messages about DB interop... which is why we still have that convertscript mess... hope [18:46] but why cant we just run the php db conversion scripts at install time so tiki.sql is always the maste rand the others get created at install time. [18:46] SVN: Commit by lphuberdeau :: r 14855 /trunk/lib/profilelib/ (installlib.php profilelib.php): [NEW] Webservice registration through profiles [18:46] well we dont need to run the scripts, just include the php files the script calls. [18:47] could be an option... I guess it is the way it is because no one bothered for the past 4+ years [18:47] as always, feel free to make tiki a better world [18:47] * marclaporte encourages MatWho! [18:48] There are zillion things to do [18:48] the last one we think about is not always the most important :-) [18:48] I am tempted, but any problem with installs from then on will be "talk to MatWho" ;) [18:48] mat, imagine what tiki would be like if you hadn't spent the last 5 years sailing and partying [18:48] hehe [18:48] hahahahahahahahahah [18:48] +1 lph [18:49] but MatWho, you will do such a good job that people will just find you to thank you [18:49] :-) [18:50] when we forget to run the convertscripts, it causes annoyance [18:51] yes so lets delete it! [18:52] * Caarrie deletes MatWho [18:52] lol [18:53] * Caarrie deletes marclaporte's m [19:06] *** lphuberdeau has quit IRC (Read error: 104 (Connection reset by peer)) [19:09] well, finally I could create my categories by hand through phpmyadmin directly on that mysql 4.0.x server... so for tomorrow, everything I need seems to work. [19:09] thanks for your hints and info in previous hours. [19:10] And I hope you don't end up deleting yourselves on irc or elsewhere :-) [19:10] cheers [19:10] *** xavi has left [19:10] * Caarrie delets xavi :P [19:10] *deletes [19:17] *** marclaporte has quit IRC (Read error: 113 (No route to host)) [19:25] *** WildPikachu has left "Leaving" [19:38] *** Amorphous has quit IRC ("shutdown") [19:39] *** lphuberdeau has joined #tikiwiki [19:52] *** vilisi_t has joined #tikiwiki [19:56] *** raji1 has joined #tikiwiki [19:56] *** raji1 has quit IRC (K-lined) [20:01] *** marclaporte has joined #tikiwiki [20:10] *** Amorphous has joined #tikiwiki [20:19] Say I wanted to add a keyword [20:19] like bug98245 [20:19] and it would go to a database and get stuff for me [20:19] Is ther best way to do that something like {BUG()}98245{BUG}? [20:20] and if it is, what is the name of that syntax "{BUG()}" [20:20] So you want to display stuff from a tracker. [20:20] negative, I want to create a wiki_plugin [20:21] in 3.0 there are plugin aliases for this [20:21] What's the syntax to use that in the wiki page? [20:22] you can mostly define it... {BUG(id=2354)/} [20:24] that's what I was thinking, is that the best way to go about it? [20:24] There also is Trackerlist; I think you could filter on a bug number. http://doc.tikiwiki.org/tiki-index.php?page=PluginTrackerlist [20:25] SEWilco2: I want to stress that I am not talking about the Tiki Trackers [20:25] something like Bugzilla [20:26] *** Lucymoz has quit IRC (Read error: 110 (Connection timed out)) [20:27] http://dev.tikiwiki.org/tiki-index.php?page=WebservicePlugin [20:27] If you want to write a plugin, also see: http://dev.tikiwiki.org/tiki-index.php?page=Hello+World#To_create_a_new_plugin [20:27] http://profiles.tikiwiki.org/Webservice+Handler [20:28] lphuberdeau: Yeah I was looking at that [20:29] That would be nice [20:29] already works in trunk, if you write some script in whichever system to just dump the data in json/yaml [20:29] Oh really? [20:30] I need to check which version we are running [20:30] :( 2.0 [20:30] probably not trunk... that would be a little too bleeding edge for a production environment [20:31] yeah [20:31] cool, thanks for the input [20:32] Narkster: Done for now? Looks like you have some reading to do. [20:32] SEWilco2: I think I am just going to do something like {BUG(id=1)/} with a wiki plugin and log directly into the bugzilla database [20:33] should take long [20:33] *shoun't [20:33] *typoes [20:33] I need to do the opposite: push Images/Articles from my TikiWiki site out to other sites. For example, any scripts for uploading images to Picasa? [20:38] sorry, I have nothing in the background to help you on this one ;) [20:38] I suspect I'll have to write scripts to grab RSS data and use that to grab images for upload. [20:39] uploading has nothing to do with RSS [20:39] picasa probably has APIs you can call, but that's all custom code on tiki side [20:41] I mean using a TW RSS feed from an Image Directory for the script to find uploaded images. The script would probably be a cron job, running outside the TW environment. [20:41] oh that makes more sense [20:42] I was hoping there already was a TW tool someplace which would help with the task, such as by being able to ask which images had been uploaded since a specific one. [20:44] Quick question, when returning data from a wikiplugin_ can I have wiki markup in it? i.e.: Do I need to href a link or can I use the wiki bracket syntax? [20:46] Narkster: I don't know, but you could look at an existing plugin. Offhand I'm not thinking of one which definitely would return a link. [20:50] *** hebus has quit IRC (Remote closed the connection) [20:50] *** marclaporte has quit IRC (Read error: 60 (Operation timed out)) [20:57] *** MatWho_ has joined #tikiwiki [20:59] SEWilco2: oh sweet HREF and markup works [21:00] Good, you have more flexibility at the cost of doing more formatting yourself. [21:01] *** Morpheus has quit IRC (Read error: 113 (No route to host)) [21:02] Someone's been busy: "a new type of spectroscopy that allows scientists to carry out broadband analysis of artificial atoms held at temperatures close to absolute zero" [21:02] Oops, wrong channel. [21:16] *** Lucymoz has joined #tikiwiki [21:18] *** MatWho has quit IRC (Read error: 110 (Connection timed out)) [21:29] *** martinalex has quit IRC (Read error: 110 (Connection timed out)) [21:38] *** MacLeod has joined #tikiwiki [21:45] *** MacLeod has quit IRC ("CGI:IRC (EOF)") [22:03] *** SEWilco2 has quit IRC ("ChatZilla 0.9.83 [Firefox 3.0.1/2008070208]") [22:06] *** marclaporte has joined #tikiwiki [22:14] *** djst has quit IRC ("http://djst.org/blog/") [22:22] *** MatWho has joined #tikiwiki [22:25] *** NefariousC has joined #tikiwiki [22:27] *** Lucymoz has quit IRC (Read error: 110 (Connection timed out)) [22:28] *** djst has joined #tikiwiki [22:31] *** MatWho_ has quit IRC (Read error: 110 (Connection timed out)) [22:34] *** MatWho_ has joined #tikiwiki [22:35] *** Caarrie is now known as Caarrie|away [22:39] *** marclaporte has quit IRC (Read error: 110 (Connection timed out)) [22:51] *** MatWho has quit IRC (Read error: 110 (Connection timed out)) [22:58] *** raji1 has joined #tikiwiki [23:00] *** Caarrie|away is now known as Caarrie [23:08] *** marclaporte has joined #tikiwiki [23:37] *** snarlydwarf has quit IRC (Remote closed the connection) [23:46] *** franck has joined #tikiwiki [23:53] *** djst has quit IRC ("http://djst.org/blog/") [23:53] *** MatWho_ has quit IRC ()