[00:15] *** Lucymoz has quit IRC (Read error: 110 (Connection timed out)) [00:19] *** sylvieg has left [00:26] franck: thanks again for your help. Those are all potential ideas, thanks. Interesting how I can't seem to do a simple "include" of wiki code into the center column without being constrained by the module dimensions. I'll keep looking... Thanks again. [00:30] franck: this seems to do it: {INCLUDE(page=>Nav)}{INCLUDE} yeah! [00:31] Petjal2: yes that too ;) [00:35] :) [00:39] *** chibaguy has joined #tikiwiki [00:48] *** RobotGuy-OUT is now known as RobotGuy [00:50] *** tomb__ has joined #tikiwiki [01:05] *** NefariousC has joined #tikiwiki [01:28] *** nikhilodeon has joined #tikiwiki [01:31] *** SEWilc1 has left [01:33] *** Caarrie is now known as Caarrie|sleeping [01:37] *** NefariousC has quit IRC ("Read error: 69 (No host to route)") [01:50] *** NefariousC has joined #tikiwiki [02:14] *** nikhilodeon has quit IRC (Read error: 110 (Connection timed out)) [02:38] *** NefariousC has quit IRC () [02:43] Isn't there an on/off switch for the wiki page "saved by" message (2.0)? I can't find it on wiki admin page. [02:43] This message should be optional, I think (not sure what the purpose of it is, really). [02:48] Apart from the version number, it just repeats information that is/can be displayed already at page bottom. [03:01] *** jcyrisse has joined #tikiwiki [03:03] hello all...getting a new database error on stats....http://sh.nu/p/24799 [03:04] *** Lucymoz has joined #tikiwiki [03:04] vers 2.0 [03:07] jcyrisse, It works ok for me. I wonder if your db needs an update. [03:08] i just upgraded...like 2 days ago [03:08] think i need to run scripts again? [03:08] on the db? [03:09] I haven't seen this error in any 2.0 version, so it's not a bug, that I know of. [03:09] So maybe your installation is not complete in some way. [03:10] oh geese [03:10] go figure [03:10] ok...think of me as a 3rd grader...how do i troubleshoot it? rerun the 1.9-2.0 scripts? and the sec db script? [03:11] It isn't clear to me what the db error is. http://sh.nu/p/24799 shows the full error message? [03:13] I don't know what the secdb script is for. I haven't used it, only 1.9-2.0. [03:13] yes...that is all i am seeing [03:13] You could verify that the tiki_stats table structure in tiki.sql file is the same as what's in your db. [03:14] (just look and compare, I mean) [03:14] *** Lucymoz has quit IRC ("Leaving") [03:14] *** Lucymoz has joined #tikiwiki [03:14] Do you have phpmyadmin on your server, to check the db? [03:15] sec...brb [03:25] back [03:25] you mean do a repair? [03:27] No, if a repair was needed, the message would say so. Since it's a query problem, there must be a mismatch between what the stats php file is asking for and what the db has. So maybe the tiki_stats db table is missing something. [03:28] (AFAIK -- I'm no expert.) [03:28] ok...so how would i know if i was missing something? [03:28] heh...think i am missing a programmer brain [03:29] Open tiki.sql in a text editor and find tiki_stats. Then look at you db's tiki_stats table using phpmyadmin. See if the structure is the same. [03:29] ...same column names, etc. [03:29] Or just do an update with the Tiki install file. [03:30] k [03:30] run the 1.9-2.0 update script on that page. [03:30] that probably is easiest [03:30] Well, if it doesn't help, then you can try the other things. [03:31] yes [03:31] ok..will try that [03:36] Hi all. How can I (most easily) program a specific banner image to appear in the top or right panel based upon which tw page is being displayed? Thanks. [03:37] Petjal2: that's a little bit complicated... [03:38] I thought it might be... [03:38] but I suppose you can extract the {$page} name and apply some code... [03:38] *** Timothy has joined #tikiwiki [03:38] oh well, I'll save that one for later. [03:38] how about this one: how do I call an image from my gallery into a banner? I can't seem to get the syntax right. [03:39] Petjal2: I would categorise the pages, and use the category to display a particular image... [03:39] ooh, that might be easier, huh? [03:39] Petjal2: you can use [03:40] I'm not sure about the show_image, but the syntax is displayed when you look at an image in the image gallery [03:40] I'll try putting something like that in the html block... [03:40] for categories, you still need to extract the {$category(?)} variable,,, [03:43] how do i remove db/lock to run the db scripts again? [03:45] jcyrisse: you need to edit tiki-install.php [03:45] k [03:45] or restore it, I think now it is saved with a different extension [03:46] k...there are two files [03:46] one that is tiki-install.php [03:46] and the other tiki-install_disable.php [03:47] yes delete first one , rename and edit second one [03:47] or something like this [03:52] *** RobotGuy has quit IRC ("Nap time - too warm and stuffy here") [03:52] Tiki sounds very complicated, judging from your conversation. I guess I am simple-minded. I often just replace the files with new versions and use phpmyadmin sql input to update the db. [03:53] (actually never used tiki-install until fairly recently) [03:55] *** fane has quit IRC (Read error: 110 (Connection timed out)) [03:55] *** Timoth1 has quit IRC (Read error: 110 (Connection timed out)) [03:57] *** Nightwork has joined #tikiwiki [04:05] well, ok...reran script, and still getting the error [04:06] You do have objects (wiki pages, galleries, etc.) to have stats for, right? [04:06] (Stupid question, I know) [04:06] uhhuh [04:08] I just asked because of the query, and it's good not to make assumptions. [04:09] I'd try replacing tiki-stats.php, tiki-stats.tpl and lib/stats/ with fresh versions. [04:09] when i run the query outside of tw.o i get results [04:10] just to make sure the files are all there and not corrupted, etc. [04:10] i am worried about maybe some corruption in my image files [04:10] checking that [04:11] Have you done any customizing of files? [04:19] no...not that i recall [04:19] i think it has to do with corrupt files [04:19] i had some weird things going on with my images so i am thinking that has someting to do with it [04:20] anyway..hey...any of you have any experience with the 3d browser>? [04:20] i keep getting blank pages [04:20] using moreneat.css [04:20] to view...but see nothing [04:21] It uses a java applet so you need to have java installed on your pc. [04:23] yup...have it [04:23] my mindmaps show up fine [04:23] so, dont think it is a java thing [04:25] 3d browser has worked and not worked at various times, for me. [04:25] Now I'm trying and I'm just getting a blank popup with a busy pointer. [04:26] ...in Opera. In FF3 the popup closed itself. [04:27] hmmm....on the demo site...i was able to view ok...but haven't seen it actually work in my site yet [04:27] *** vilisi_t has left [04:27] Yep, seems to depend on the phase of the moon or solar storms or something. ;-) [04:31] Correction: popup didn't close in FF3, I just lost track of it. But it's empty. [04:31] The applet tag is there, but nothing happened. [04:34] ah...gotta be the solar flares [04:44] *** tomb__ has quit IRC (Read error: 104 (Connection reset by peer)) [04:47] Well, whoever's aware of changes affecting the 3d browser files, etc., would know, but I don't. [04:48] well, maybe someone will read the logs and run across this thread [05:34] *** RobotGuy has joined #TikIWiki [05:40] *** Timothy has left [05:53] *** jcyrisse has quit IRC (Read error: 113 (No route to host)) [06:19] *** jasprit has joined #tikiwiki [06:43] *** fan1 has joined #tikiwiki [06:47] *** RobotGuy has quit IRC (Remote closed the connection) [07:02] *** Nightwork has quit IRC () [07:02] *** PrezKennedy has quit IRC (Read error: 110 (Connection timed out)) [07:34] *** Lucymoz has quit IRC (Read error: 110 (Connection timed out)) [07:36] *** Wilkins has joined #tikiwiki [07:38] SVN: Commit by sept_7 :: r 14123 /branches/experimental/tiki-pdo/ (42 files in 9 dirs): [MRG] Automatic merge, trunk 14089 to 14117 [07:56] *** franck has left [08:08] *** chibaguy has left [08:14] SVN: Commit by sept_7 :: r 14124 /branches/experimental/tiki-pdo/ (48 files in 7 dirs): [MRG] Automatic merge, trunk 14117 to 14122 [08:44] *** ElDios has joined #tikiwiki [09:07] *** PrezKennedy has joined #tikiwiki [09:21] *** ElDios has quit IRC (Read error: 104 (Connection reset by peer)) [09:21] *** ElDios has joined #tikiwiki [09:46] *** ElDios has quit IRC (Read error: 54 (Connection reset by peer)) [09:46] *** ElDios has joined #tikiwiki [10:18] *** fan1 has left [10:26] *** pujib has joined #tikiwiki [10:29] hi there! a question about tw 1.9.11: it is said in docs for drop-down tracker field that 'If the field is optional, an empty value will be automatically added at the top of the values.', but i set Mandatory field checkbox and empty value still appears as first value in list. [10:29] is this a bug or a kind of misunderstanded feature? [10:50] *** NefariousC has joined #tikiwiki [11:07] *** SvenAERTS has joined #tikiwiki [11:08] *** ricks99_ has joined #tikiwiki [11:11] *** Paragtim has joined #tikiwiki [11:13] Hi all, I need some advice on, I think, sessions. I need to set the system so that after a period of time a user is automatically logged out. Any ideas? [11:13] Sorry, period on inactivitly [11:17] i think this is in the php.ini: session.gc_maxlifetime [11:19] Thanks rick - I'll give it a try. Got another 1. How do I stop users logging in with the same u/n from 2 locations at the same time? [11:20] Does the PMwiki Cookbook work with tikiwiki? [11:22] stop logging from 2 locatiosn.... try using cookies [11:22] not sure? [11:24] in Admin home : General Settings, what does Session liftime in minutes" refer to? [11:25] ... session lifetime? [11:25] yeah [11:25] it is the session lifetime. [11:26] use it to override the session.gc_maxlifetime [11:26] see the docs: http://doc.tikiwiki.org/tiki-index.php?page=General%20Admin [11:26] Is that like the inactivity question above? Set the session for 60 mins and at the end it logs out autoatically? [11:27] *** _ElDios_ has joined #tikiwiki [11:27] *** ElDios has quit IRC (Read error: 104 (Connection reset by peer)) [11:28] *** ElDios has joined #tikiwiki [11:29] y, i believe that is correct [11:29] Thanks - I give it a try [11:37] *** lphuberdeau has quit IRC (Remote closed the connection) [11:41] *** martinalex has joined #tikiwiki [11:44] *** _ElDios_ has quit IRC (Read error: 110 (Connection timed out)) [11:46] In the bread crumb feature, can the "Location" (1st entry) be changed? [11:50] *** marclaporte has quit IRC ("Miranda IM! Smaller, Faster, Easier. http://miranda-im.org") [11:56] *** SvenAERTS has quit IRC () [12:02] *** tomb__ has joined #tikiwiki [12:03] SVN: Commit by ricks99 :: r 14125 /trunk/ (2 files in 2 dirs): [FIX]fixed typo "maintenance" [12:05] SVN: Commit by ricks99 :: r 14126 /branches/2.0/ (2 files in 2 dirs): [FIX]fixed typo "maintenance" [12:05] *** Caarrie|sleeping is now known as Caarrie|away [12:11] *** NefariousC has quit IRC () [12:13] *** marclaporte has joined #tikiwiki [12:15] *** trooper has joined #tikiwiki [12:16] hi all [12:17] *** trooper has quit IRC (Client Quit) [12:20] hi trooper, who left [12:21] *** gs has joined #tikiwiki [12:22] *** gs has quit IRC (Client Quit) [12:33] *** lphuberdeau has joined #tikiwiki [12:34] polom [12:40] *** ricks99_ has quit IRC (Read error: 104 (Connection reset by peer)) [12:40] *** ricks99_ has joined #tikiwiki [12:44] *** RobotGuy has joined #TikIWiki [12:45] *** marclaporte has quit IRC (Read error: 110 (Connection timed out)) [12:58] *** marclaporte has joined #tikiwiki [13:09] hi all, i'm trying to get my oracle db working, and it seems that it just might (everything connects fine, theres just some 1450 sql statements that go wrong... :) ). Anyway, what I've run into now is that some of the table names are too long (apparently anything over 30 characters). I was thinking that locally, I can just do that by writing a shell script that searches all the files (I know, a lot) and changes the names of all the table names and su [13:09] ch with tiki_ -> tw_, edit_ -> e_, users_->u_, etc., to save room. Would this be enough to change all of them at once and not break tw? [13:11] tomekkott: : I don't know [13:11] tomekkott: but it would be most interesting to find a solution for Tiki & Oracle :-) [13:12] Are you using latest version of Oracle? [13:12] marclaporte: well, the added problem is that my solution requires an old version of oracle, so even if I get it to work, no guarantee it will work for everyone [13:12] no, oracle 8i [13:12] *sigh* [13:13] you mean they don't only force you to use oracle, but a very old version of it? [13:14] yup [13:14] gotta love universities, huh? [13:17] anyway, what do you all think is the best scripting language to go through entire tw dirs looking for all the permission names and table names and such? [13:18] and is there a list somewhere of all those names and permissions and such? [13:18] PHP, you can use the tokenizer function to parse the files as PHP would [13:19] then you can focus on strings or just pieces that matter [13:21] In the bread crumb feature, can the "Location" (1st entry) be changed? [13:30] *** pujib has quit IRC (Read error: 110 (Connection timed out)) [13:34] here's a question, I somehow got a table name to start with an '_' (which is illegal in Oracle) and now I can't remove it because it is an illegal name [13:37] any ideas how to force that? [13:39] I don't know of any table in tiki starting with _... [13:39] in mysql, you can enclose the token between backquotes and use any name you wish [13:39] havn't used oracle in years [13:43] hmm, yeah, idon't think it was on purpose, something with me trying to install it must've gotten stuck and sent the "_" as a first char [13:43] thanks [13:47] *** marclaporte has quit IRC (Read error: 113 (No route to host)) [14:08] SVN: Commit by lphuberdeau :: r 14128 /trunk/lib/wiki-plugins/ (3 files): [MOD] More info functions [14:11] could someone tell me the difference between KEY and PRIMARY KEY in MySQL? It appears that simply "KEY" isn't supported by oracle 8i, so I'm trying to figure out how best to translate [14:11] *** rodrigo_sampaio has joined #tikiwiki [14:11] KEY is an index [14:11] no unique constraint [14:14] hmmm [14:24] *** martinalex has quit IRC (Read error: 110 (Connection timed out)) [14:25] *** marclaporte has joined #tikiwiki [14:27] *** nkoth3 has joined #tikiwiki [14:29] *** ricks99_ has left [14:34] *** ricks99 has joined #tikiwiki [14:45] *** MacLeod has joined #tikiwiki [14:53] *** nikhilodeon has joined #tikiwiki [14:54] *** Paragtim has quit IRC ("We be chillin - IceChat style") [15:01] *** tomb__ has left "Ex-Chat" [15:05] *** SEWilco2 has joined #tikiwiki [15:21] *** martinalex has joined #tikiwiki [15:38] *** franck1 has joined #tikiwiki [15:38] *** franck1 is now known as franck [15:39] moo [15:39] moo [15:39] *** kerrnel has quit IRC ("CGI:IRC") [16:01] What's with dev.tw.o? Is that appearance due to bad CSS or something? Looks like big table splattered across the page. And... not answering to Refresh. [16:02] *** Wilkins has quit IRC (Read error: 104 (Connection reset by peer)) [16:09] looks fine to me [16:14] dev.tw.o still not answering me. [16:14] fine to me [16:14] info.tw.o is working. My browser is working. [16:15] In case it's a URL issue, I'm trying http://dev.tikiwiki.org/ [16:15] And now it looks fine to me. [16:24] here's a question about databases: if I don't have a KEY, what changes? Speed of access to whatever I'm trying to find? [16:25] and secondly, what does a statement such as "KEY body (body(255))" mean: only use the first 255 characters of the column body (datatype = text) when creating the key? [16:40] probably [16:40] but yes, it would cause major performance issues [16:40] but oracle has indexes, just not named the same way [16:48] dev.tw.o search box for "block list" seems to be displaying non-CSS results. http://dev.tikiwiki.org/tiki-searchresults.php?highlight=block+list&where=pages&search=Go [16:51] *** Strange has joined #tikiwiki [16:52] *** Strange has quit IRC (Client Quit) [16:52] Well, that was strange. [16:54] SVN: Commit by lphuberdeau :: r 14130 /trim/ (6 files in 4 dirs): [NEW] Backup restore/site migration support [16:55] har har [16:55] :) [16:56] lphuberdeau: yes, but oracle can't index "text" datatypes (which get translated as CLOB) [16:57] that can be a problem [16:57] tiki abuses text variables... often should be varchars [16:57] for the body of an article or wiki, I can sure understand using text [16:57] i might just have to pick a size for varchar that works for me [16:58] that shouldn't be indexed... really [16:58] and translate all text -> varchars [16:58] in my conversion script, i might just drop any index that wants to index text [16:58] the problem is the size differences [16:59] *** Lucymoz has joined #tikiwiki [16:59] text can hold more than varchar, which is limited to 256 chars or something like that [17:00] i see [17:00] oh, changed with MySQL 5... limit now 2^16 rather than 2^8 [17:00] UTF-8 characters take up a byte each, right? [17:01] depends on the character [17:01] *** nkoth3 has quit IRC () [17:01] english characters do, because UTF-8 is ASCII compliant [17:01] but accentuated characters often take 2 [17:02] some characters take up to 6 I think [17:02] ok, so 2bytes per character would be a good conservative estimate [17:02] for a large average of chars [17:02] for latin/european languages, average is closer to 1 than 2 [17:02] they wrote the spec ;) [17:03] hehe [17:03] actually, it's mostly because asian languages have thousands of characters and they need at least 3 bytes themselves [17:04] sure, that makes sense [17:04] I think they end up using UTF-32 most of the time [17:05] *** martinalex has quit IRC (Read error: 104 (Connection reset by peer)) [17:05] now i just have to figure out how to strip only key's which reference text variables... [17:05] *** martinalex has joined #tikiwiki [17:05] you know having a rogue installation of MySQL wouldn't be so hard? [17:06] I've been in gov agencies where they did that ;) [17:07] well, here's the kicker: their php HAS MYSQL COMPILED IN [17:07] THEY JUST WON"T LET ME USE IT [17:07] aaaaaarhghasdfhlkasdjfhlaskdjfhaklsdjhfouygole ,mnbv [17:08] hehe [17:08] bribe them [17:08] hmm, bribing university wide webmaster, might send the wrong message... [17:09] or go up... to install the application with their requirements, I need X days of work, alternative is free and takes 5 minutes [17:12] unfortunately for me, i'm just a grad student [17:12] they don't care :( [17:12] that can be a problem [17:13] but then you are not bound to university hosting [17:13] it takes me about an average of 4 days to get a response by email, and emails the only option [17:13] i am if our org wants a university subdomain [17:13] *it is, rather [17:14] Worse: If you are able to bribe your webmaster, you then know you have a webmaster who can be bribed. Could be bribed by someone else. [17:14] too late for me to work on a Friday... taking off [17:14] *** lphuberdeau has quit IRC (Remote closed the connection) [17:14] true [17:15] You only need the university web server if they won't point a subdomain to a server which works better for you. [17:16] tomekkott: Grad student, you are confused. Universities view grad students as workers, so your complaint about having to do work won't make sense. [17:17] i think universities view us more as "peons" [17:17] and "cheap labor" [17:17] not really "workers" [17:18] i swear i'm not a bitter grad student, i love my program, just dealing with stupid webmasters is annoying [17:23] *** NefariousC has joined #tikiwiki [17:23] *** ElDios has quit IRC (".") [17:27] Hmm. No THUMBDIV plugin on RC4, and BOX isn't showing the image I put inside. [17:42] *** marclaporte has quit IRC (Read error: 104 (Connection reset by peer)) [17:45] quick php question, $cols = split(",",$var); If there aren't any commas to begin with, can I still do foreach ($cols as $vars) ? [17:49] nvmd, it was a different problem [18:01] question: when doing the installation for MySQL, each statement that is separated by a ; is written all together to MySQL, not seaprated by lines, right? [18:03] *** ricks99 has quit IRC ("ChatZilla 0.9.83 [Firefox 2.0.0.3/2007030919]") [18:03] or are statements separated via ;\n [18:09] *** martinalex has quit IRC (Read error: 110 (Connection timed out)) [18:11] *** ohertel has joined #tikiwiki [18:11] Hello! :) [18:17] Quite quiet in here. .P [18:17] *** jasprit has quit IRC ("Leaving.") [18:18] *** srishti has joined #tikiwiki [18:20] *** lphuberdeau has joined #tikiwiki [18:23] sweet, down to only 700 sql errors from 1500 in oracle... now we can get down to business... :) [18:23] alright, gonna take a break tho [18:24] haha. :) [18:25] hard work. [19:38] *** MacLeod has quit IRC ("CGI:IRC (EOF)") [19:50] *** ohertel has left [19:55] *** Caarrie|away is now known as Caarrie [20:02] I'm trying to show a captioned image, and keep getting whitespace to left of image: {BOX(title=>"Glass Molds", float=>right,width=160px)}{THUMB(id=208,float=>right,max=160)}{THUMB}{BOX} [20:02] *** marclaporte has joined #tikiwiki [20:04] SVN: Commit by marclaporte :: r 14131 /trunk/templates/tiki-view_articles.tpl: [MOD] Add a tip to add an article if there are none and person is allowed [20:25] *** Caarrie is now known as Caarrie|away [20:50] Hmm.. I'm not seeing the WYSIWYG editor in Wiki. Get a big empty pane. On trunk. [20:50] Maybe that only happens when creating a page... [21:00] ... nope, editing an existing page doesn't show WYSIWYG either, just delays while editor files are loaded and then a blank pane. [21:16] The CATEGORY plugin is emitting ~np~ ~/np~ around its output. Trunk. [21:17] *** franck has quit IRC (Read error: 110 (Connection timed out)) [21:19] *** marclaporte has quit IRC (Read error: 113 (No route to host)) [21:21] BTY: thanks to whoever put the Plugin help in trunk. Good idea. [21:23] always been there, was just hidden a bit [21:29] *** vinux has joined #tikiwiki [21:54] *** RobotGuy has quit IRC (Read error: 104 (Connection reset by peer)) [21:57] *** NefariousC has quit IRC ("Read error: 69 (No host to route)") [21:59] *** mstef has joined #tikiwiki [22:00] hi all, [22:02] is there any way to send an initial value using the tracker plugin, without displaying the input fields for it? [22:02] i know about making a field non-public [22:03] but then on another wiki page i could not have another form where i would like to display/edit the field. [22:03] i guess maybe inserting a hidden input field would help, is this possible? [22:06] *** nkoth3 has joined #tikiwiki [22:12] is it possible to add hidden html form input fields to the tracker plugin? [22:35] *** nikhilodeon has quit IRC (Read error: 110 (Connection timed out)) [22:46] *** rodrigo_sampaio has quit IRC ("Leaving.") [22:46] *** SEWilco2 has quit IRC (verne.freenode.net irc.freenode.net) [22:46] *** niclone has quit IRC (verne.freenode.net irc.freenode.net) [22:46] *** vinux has quit IRC (Remote closed the connection) [22:48] *** SEWilco2 has joined #tikiwiki [22:48] *** niclone has joined #tikiwiki [22:48] *** luciash has quit IRC (Remote closed the connection) [22:49] *** vinux has joined #tikiwiki [22:52] *** vinux has quit IRC (Client Quit) [23:00] *** Caarrie|away is now known as Caarrie [23:13] *** luciash has joined #tikiwiki [23:18] *** CIA-14 has quit IRC (K-lined) [23:23] *** luciash has quit IRC (Remote closed the connection) [23:27] *** CIA-14 has joined #TikiWiki [23:28] *** SEWilco2 has quit IRC ("ChatZilla 0.9.83 [Firefox 3.0.1/2008070208]") [23:29] *** Morphous has quit IRC (Read error: 110 (Connection timed out)) [23:32] *** Morphous has joined #tikiwiki [23:37] *** Caarrie is now known as Caarrie|away [23:37] *** franck has joined #tikiwiki [23:45] *** nightwork has joined #tikiwiki [23:45] Hello all [23:46] *** fane has joined #tikiwiki [23:55] *** luciash has joined #tikiwiki