00:04:59 loggy has joined #openacs 00:04:59 topic is: Welcome to the OpenACS Helpline | http://www.openacs.org/ 00:04:59 Users on #openacs: loggy AaronSw chump rzolf jabba_ shagster strainmaker 00:05:16 This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog 00:05:16 rbm has joined #openacs 00:28:27 davb has joined #OpenACS 00:36:50 Psychephylax has joined #openacs 00:37:32 Hey Psychephylax! 00:39:45 hey dave 00:39:52 Gotta love it 00:40:05 redoing the db now with the latest CVS from home 00:40:12 getting 1 hour out of this for whatching TV 00:58:38 dave, you awake? 00:59:42 I think there are some bugs in this CVS 01:02:20 rbm has quit 01:03:17 COuld be. 01:03:19 What kind? 01:03:30 rbm has joined #openacs 01:04:09 I was getting PL/SQL errors in acs-content management I think 01:04:33 acs-content-repository-create.sql... 01:04:45 Warning: Trigger created with compilation errors. 01:04:47 Errors for TRIGGER CR_CLEANUP_CR_FILES_DEL_TRG: 01:04:56 LINE/COL ERROR 01:04:56 -------- ----------------------------------------------------------------- 01:04:56 2/9 PL/SQL: SQL Statement ignored 01:04:56 3/16 PLS-00517: Type mismatch between a select list element 01:04:56 '' and corresponding table column in INSERT statement 01:05:15 with a subquery 01:05:17 Errors for PACKAGE IMAGE: 01:05:18 LINE/COL ERROR 01:05:20 ... 01:05:24 Not going to paste them all 01:05:26 Aha. 01:05:50 Looks like Dan applied some patches someone made to the CR. And they look like they broke it. 01:05:52 hang on. 01:07:02 updating CVS. I'll tell you what happens. 01:07:02 well, just so you guys know 01:10:28 ok 01:11:56 ahhh crud 01:11:59 my SNMP create sql script is broken 01:12:00 Oh well 01:12:04 I'll fix it tomorrow 01:12:08 ick 01:12:10 Yeah. 01:12:25 CR loaded fine for me. 01:12:32 hmmm 01:12:37 It finished 01:12:43 it just had a warning there 01:12:51 In the log or the browser? 01:12:54 browser 01:13:01 I just got the CVS too 01:14:26 me too. 01:15:07 Unless someone realized it and committed the fix right after you tried. weird. 01:15:38 Was it a checkout or update? 01:16:00 i did a checkout 01:16:17 i move the old thing just in case and do a checkout 01:17:01 jabba_ is now known as abbaJ 01:17:17 Interesting. I just did an update on my regular directory. 01:26:47 heh 01:26:50 well, just so you know 01:26:59 now I have to go build some stupid circuits for my ESE class 01:28:38 Sounds like fun. 01:31:25 it's not 01:31:37 i think I'm going to reincarnate my love for Hockey 01:31:47 anything to procrastinate! 01:34:26 heh! 01:38:34 :-/ 01:40:15 rbm has quit 01:42:59 rbm has joined #openacs 02:00:15 rbm has quit 02:08:23 rbm has joined #openacs 02:38:14 [GlobalNotice] Hi all. Services will be back up in a moment, after the usual splits. Thanks for your patience. 02:38:35 rbm has quit 02:38:35 chump has quit 02:38:35 AaronSw has quit 02:38:59 chump has joined #openacs 02:38:59 AaronSw has joined #openacs 02:38:59 rbm has joined #openacs 02:39:05 This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog 03:07:27 davb has quit 05:03:28 rzolf has quit 07:42:51 rzolf has joined #openacs 09:07:04 rzolf has quit 09:49:58 alekhine has joined #openacs 09:59:27 rbm has quit 10:01:12 ola has joined #openacs 10:03:07 rbm has joined #openacs 10:06:37 hey rbm! 10:07:54 doh! 10:16:24 later ola et all 10:16:25 alekhine has left #openacs 10:24:49 ola has quit 10:48:46 davb has joined #OpenACS 10:52:14 mamtom has joined #openacs 10:52:21 mamtom is now known as alekhine 10:57:17 Disconnected from irc.openprojects.net (ERROR :Closing Link: loggy[xcdfddb76.ip.ggn.net] by asimov.openprojects.net (Ping timeout for loggy[xcdfddb76.ip.ggn.net])) 10:58:59 loggy has joined #openacs 10:58:59 topic is: Welcome to the OpenACS Helpline | http://www.openacs.org/ 10:58:59 Users on #openacs: loggy alekhine davb chump AaronSw Psychephylax abbaJ shagster strainmaker rbm 11:14:56 [GlobalNotice] Hi, all. Services will be back up in a moment, after the usual splits. Please bear with us. Thanks. 11:15:28 alekhine has quit 11:15:28 davb has quit 11:15:28 abbaJ has quit 11:15:28 Psychephylax has quit 11:15:28 strainmaker has quit 11:15:28 shagster has quit 11:15:30 ChanServ has changed the topic to: Welcome to the OpenACS Helpline | http://www.openacs.org/ 11:15:37 This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog 11:16:14 strainmaker has joined #openacs 11:16:14 shagster has joined #openacs 11:16:14 abbaJ has joined #openacs 11:16:14 Psychephylax has joined #openacs 11:16:14 davb has joined #openacs 11:16:14 alekhine has joined #openacs 12:55:42 Interesting. The text attribute of the BODY tag is broken in Opera for Linux 13:11:50 davb, still around? 13:15:10 http://blogspace.com/openacs/rss-procs.tcl 13:15:10 A: http://blogspace.com/openacs/rss-procs.tcl from AaronSw 13:15:16 A:|rss-procs.tcl 13:15:16 titled item A 13:15:22 A:Utilities useful in building RSS files 13:15:22 commented item A 13:15:39 A:Contains the core code for [blogify|http://logicerror.com/blogifyyourpage] 13:15:39 commented item A 13:15:54 A:for davb 13:15:54 commented item A 13:18:14 Thanks 13:18:23 (I am always around somewhere.) 13:19:44 Heh. 13:20:16 Now I can automate my blog instead of using your site. I have some work to do, so I can avoid it by doing that instead. 13:21:08 Aha! :-) 13:26:32 I have to fix my weblog though. It has eash day as a seperate item, instead of each entry. I was lazy when I programmed it. 13:32:20 Is your weblog in the database? It might be easier just to write an RSS template for it. 13:33:55 Yeah. what do you mean by RSS template? 13:34:26 You know, like an HTML template except it outputs RSS. 13:35:36 I also have to get the chump's output into RSS. I have the XSL stylesheet but I haven;t hooked it up yet. 13:37:56 Well I don't have ANY templates for my site right now. I have to switch over to 4. 13:38:25 Oh. 13:39:10 Yeah. Like I said I am lazy. I am waiting to see if musea comes up with a weblog content type for Editthispage. 13:39:36 Looks like someone else is patching OpenACS 4 for domain based subsites though. 13:59:30 Cool! It works. The chump is now available via RSS 14:04:20 http://www.thedesignexperience.org/openacs/ircblog/rss.xml 14:04:20 B: http://www.thedesignexperience.org/openacs/ircblog/rss.xml from davb 14:04:41 B:|#openacs Chump-bot output in RSS 14:04:41 titled item B 14:21:04 heh 14:22:04 Morning everyone 14:25:34 Hi 14:25:54 * Psychephylax wishes he wasn't at work 14:26:06 Now I have to figure out what's wrong with my SQL 14:27:59 oooooooh! 14:28:10 * Psychephylax looks for Mark 14:28:34 * Psychephylax lays out cookies in an oddly shaped pentagram.... 14:30:38 * davb gets out the garlic 14:31:30 I think my problem is that I try to reference a table before it's created :) 14:31:48 That is not recommened last time I checked. 14:32:36 I suppose it's not 14:32:46 hmmm..better...less errors now 14:34:03 aha 14:34:12 and this error is because the row is not unique 14:34:17 column rather 14:41:41 now if I only remember the syntax 14:51:38 Is is a primary key? 14:52:06 something like this? emailvarchar(100) not null unique 14:52:34 it's not a primary key it's a candidate key 14:52:53 See, my confusion was stemmed from the fact that I already have a named constraint 14:53:01 cm_ping_id number (10) 14:53:02 constraint snmp_incidents_cm_ping_id_nn 14:53:03 not null 14:53:14 how do you add a second named constraint to that... 14:53:31 But I put the second constraint in the end of the table 14:53:59 Aha, I never tried that before. 14:54:06 yeah 14:54:11 That was my confusion :) 14:54:21 so I put the second constraint at the end of the table 14:54:31 btw...Not sure if this is my fault or ACS: 14:54:33 ERROR at line 1: 14:54:33 ORA-04098: trigger 'MYOPENACS.CR_CLEANUP_CR_FILES_DEL_TRG' is invalid and 14:54:33 failed re-validation 14:55:13 yikes! 14:55:15 hmmmm. 14:55:51 major problemo 14:55:53 :( 14:56:31 that is? 14:57:00 no idea yet 14:57:16 but I did find this (how to use 2 named constraints for one column): incident_id integer 14:57:16 constraint snmp_incidents_incident_id_fk 14:57:16 references acs_objects(object_id) 14:57:16 constraint incidents_incident_id_pk 14:57:17 primary key, 14:59:45 You need to name them? 15:00:16 well, technically, no :P 15:00:26 but hey, might as well do what all the smart people do 15:00:59 Right check this out: Note that when declaring a foreign key constraint at the end of a table 15:00:59 declaration it is always necessary to put the list of referencing attributes in parentheses: 15:00:59 create table foo (... 15:00:59 foreign key () references ()); 15:01:18 from : http://www-db.stanford.edu/~ullman/fcdb/oracle/or-nonstandard.html 15:01:20 http://www-db.stanford.edu/~ullman/fcdb/oracle/or-nonstandard.html 15:01:21 C: http://www-db.stanford.edu/~ullman/fcdb/oracle/or-nonstandard.html from davb 15:01:29 C:|Non-standard SQL for Oracle 8i 15:01:29 titled item C 15:05:42 hmmm 15:05:46 that wasn't my problem 15:05:57 Being stupid and just sticking stuff out of order was 15:07:58 a spelling lesson is also in order 15:08:21 heh 15:08:34 refrences 15:08:35 bah! 15:10:11 don't you have SQL mode? 15:18:31 eh? 15:19:20 In SQL mode for emacs it colorizes the SQL keywords. So if it doesn;t change color, you spelled it wrong. 15:21:40 heh 15:21:47 check this out: http://www.iqtest.com/view/iqtest/sale/000812/966139449906 15:21:57 scale: 15:21:58 Average: 85 - 115 15:21:59 Above average: 116 - 125 15:21:59 Gifted Borderline Genius: 126 - 135 15:21:59 Highly gifted and appearing to be a Genius to most others: 136 - 145 15:21:59 Genius: 146 - 165 15:22:01 High genius: 166 - 180 15:22:03 Highest genius: 181 - 200 15:22:05 Beyond being measurable genius: Over 200 15:23:42 no bad. 15:23:52 not bad. 15:24:09 :-/ 15:24:17 maybe this is why I don't want to do this hehehe 15:24:20 not challenging enough 15:25:10 could be. 15:26:24 :) 15:26:43 shagster has quit 15:27:34 woohooo 15:27:37 create works 15:27:56 shagster has joined #openacs 15:28:11 ORA-04098: trigger 'MYOPENACS.CR_CLEANUP_CR_FILES_DEL_TRG' is invalid and 15:28:14 i don't like that 15:37:51 i think it's time for Dr. Pepper 15:37:51 mmmm....coooold 15:37:52 Disconnected from irc.openprojects.net (ERROR :Closing Link: loggy[xcdfddb76.ip.ggn.net] by benford.openprojects.net (Ping timeout for loggy[xcdfddb76.ip.ggn.net])) 15:38:00 loggy has joined #openacs 15:38:00 topic is: Welcome to the OpenACS Helpline | http://www.openacs.org/ 15:38:00 Users on #openacs: loggy shagster chump AaronSw rbm alekhine davb Psychephylax abbaJ strainmaker 15:38:00 This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog 17:54:12 loggy has joined #openacs 17:54:12 topic is: Welcome to the OpenACS Helpline | http://www.openacs.org/ 17:54:12 Users on #openacs: loggy talli shagster chump AaronSw rbm alekhine davb Psychephylax abbaJ strainmaker 17:54:12 This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog 17:56:37 Dave? 18:00:55 hi (went to mow the lawn for a bit) 18:00:59 lol 18:01:09 that's a rather short lawn mowing time 18:01:16 30 minutes 18:01:20 You must have a small lawn 18:01:24 I just did the front. THe back is the hard part. 18:01:30 hehe 18:01:39 Did you try running the package manager? 18:01:54 i'm getting moved ;( 18:01:57 not yet. 18:02:34 what about deleting a package thing 18:02:37 this is it 18:02:40 OPENACS4.CR_CLEANUP_CR_FILES_DEL_TRG 18:02:46 blah blah blah 18:02:51 where are you getting that? 18:03:07 ora8.c:3908:ora_tcl_command: error in `OCIStmtExecute ()': ORA-04098: trigger 'OPENACS4.CR_CLEANUP_CR_FILES_DEL_TRG' is invalid and failed re-validation 18:03:07 ORA-06512: at "OPENACS4.ACS_OBJECT", line 98 18:03:07 ORA-06512: at "OPENACS4.SITE_NODE", line 55 18:03:08 ORA-06512: at line 4 18:03:14 when I delete the folder. 18:03:26 That trigger is broken for Oracle. 18:03:43 Post it in the testing bboard. THe error from install and when you delete the folder. 18:04:16 ok 18:05:18 try the apm 18:05:31 oh what is wrong with that? 18:05:42 You'll see 18:05:43 lol 18:05:48 OK. 18:05:55 DId you check openacs-4 or acs-core? 18:06:01 Check for what? 18:06:03 I just did that core. 18:06:08 oh 18:06:09 checkout 18:06:11 I checked out openacs-4 18:06:22 YOu get all the packages in CVS. I don't think you need em. 18:06:30 Just checkout the core and then add the packages you need. 18:06:49 I think you encountered a broken optional package. 18:07:07 I s'pose 18:07:18 I can try that: but this isn't a way to solve problems :) 18:07:24 I'd rather see it fixed 18:07:54 I think the APM works fine. It found a bad XQL file in some package that you probably don't need. 18:08:27 Are you using any of the non-core packages? 18:08:35 like bbord or general comments? 18:08:50 I don't think so 18:09:53 rbm: you around? 18:10:40 Psychephylax: so if you install acs-core and don't get the XQL error, you know its in an optional package. The testers will get it. 18:11:31 we'll see 18:11:38 * Psychephylax is getting core now 18:11:54 i'm getting moved 18:11:58 to a diff desk 18:12:04 I don't like that, I like this desk ;( 18:12:21 sorry to hear that. 18:13:13 yeah 18:13:21 now I can't take excessive short breaks while I do my work 18:13:25 Well its a job. 18:13:41 :-/ 18:13:53 i'm more productive when I can bug you guys for syntax help =D 18:14:09 you can't do that from the new desk? 18:16:35 i can but I have more "neighbors" 18:16:52 and I don't know if they're one of them "tell your boss every step you take" type of people 18:17:19 alekhine has quit 18:17:26 ugh 18:17:30 I just lost my package 18:18:00 um thats bad. 18:19:19 no 18:19:23 It's here 18:19:31 i just don't know which oacs_ file it's in 18:19:31 ok thats good. 18:19:42 hehehehehe 18:19:52 but it contains potassium sorbate 18:20:14 * Psychephylax points out it's dave's turn to say "that's bad" 18:20:46 hey dav 18:21:19 ¿oom 18:24:11 rbm: I have a copy of AOLserver 3.3+ad13. It looks like its the one you added the script to, but I can't find the script. The one that makes a distribution suitable for OpenACS 4 installation. 18:24:21 And I never can remember the URL for your web site. 18:28:55 time to do this all from scratch 18:30:38 It's openacs4-core? 18:30:42 acs-core 18:30:49 mind reader? 18:30:50 :) 18:30:57 you answered that waaay too fast 18:31:21 no. just good timing. 18:32:04 :) 18:34:16 heh 18:34:20 my desk is the one with a printer 18:34:23 THat sucks! 18:34:33 yes 18:38:21 ugh 18:39:31 ola has joined #openacs 18:39:58 hi 18:40:02 davb: http://www.brasileiro.net/openacs I think 18:40:02 hola ola! 18:40:19 hola psyche! 18:40:22 davb: You can just look my webpage up at http://openacs.org/directory/ 18:40:27 (when you forget it) 18:40:40 * rbm needs a domain north-americans can spell :-) 18:41:01 like neverhere.com? 18:41:03 Unfortunately, mello.com/org/net is taken by some webmail thingyp. 18:41:03 :)) 18:41:08 HEY! 18:41:12 I'm usually here. 18:41:15 ok 18:41:20 you can get alwayshere.net 18:41:47 jerryasher has joined #openacs 18:41:59 hi jerry! 18:42:03 Hi Roberto? 18:42:18 Or Dave? Or anyone who has an OpenACS 4 implementation around? 18:42:25 <--- 18:42:37 well, in the process of fixing it 18:42:47 rbm: duh I never thought of that. 18:43:07 Well I am here. 18:43:13 Classic ACS 4 has a function in packages/acs-templating/tcl/acs-integration-procs.tcl 18:43:19 I really don't have a site going though. 18:43:23 called adp_parse_ad_conn_file 18:43:41 That function calls ns_return 18:43:58 And Petru tells me that if that ns_return is turned into a call to 18:44:04 nope, don't know that 18:44:32 Jim Wilcoxson's rl_returnz module, that everything that templating 18:44:38 spits out will be suitable compressed. 18:44:54 Does OpenACS 4 templating have a similar function? 18:46:39 hey jerry 18:46:42 adp_parse_ad_conn_file is in there. 18:47:03 it ns_returns a parsed template. 18:47:22 Thats a neat idea. 18:47:29 jerryasher: I'm not familiar with rl_returnz. Why would you want to do that? 18:48:10 Hi Roberto, because since IE 3 and N 3, browsers have been able to accept gzipped 18:48:20 docwolf has joined #openacs 18:48:28 html and automatically decode it. If you're a modem user, or if you pay for your bandwidth 18:48:32 how do I install mp3info perl module? anyone? 18:48:54 or if you have more CPU than network, than you'd prefer gzipped content 18:48:59 whenever possible. 18:49:03 jerryasher: Ah, I see. But you pay a price for that on the server. 18:49:20 IE accepts gzip? 18:49:22 I installed an RPM but it still doesn't work. 18:49:32 yes, you need to have more server cpu than server network 18:49:47 I'm surprised it accepts gzip, as opposed to some proprietary, non-standard, buggy zip program. 18:49:50 or a preference to pay for less bandwidth or help out your modem users 18:50:03 well it accepts that too. 18:50:18 but it also accepts gzip, although jonathan ellis suggests that it does THAT 18:50:23 buggily, so your buggily is in there. 18:50:40 (And jonathan submitted a patch to work around the i.e. bugs) 18:50:58 Petru says that on mydomain, the compression ration is typically 4:1. 18:51:03 I think the best way to provide that feature in OACS 4 would be to create a package that would give that functionality. 18:51:44 It either needs to be built into AOLserver (as a patch perhaps to ns_return), 18:52:01 or placed in any location where ns_return is called. 18:52:29 Can an OACS package overwrite the contents of a core OACS package? 18:53:10 I would think the "easiest" method to implement this would be to use an ACS kernel 18:53:36 jerryasher: I dunno. My guess is that you could replace something in the kernel. 18:53:49 param to dictate the behavior and use then to use [info] to determine at runtime 18:54:00