00:01:33 vinod (~vinod@207-172-255-116.s1132.apx1.sbo.ma.dialup.rcn.com) has joined #openacs 00:06:42 davb (~chatzilla@alb-24-58-161-172.nycap.rr.com) has joined #openacs 00:27:36 All mIRC users should upgrade to mIRC 6.0 at once (apologies to non-mIRC users). This is available from http://www.mirc.co.uk. A serious vulnerability has been discovered in all versions of mIRC up to version 5.91 which could allow malicious users to gain unauthorized access to your system - it is particularly serious for those using IE as their browser. 00:45:31 davb has quit ("ChatZilla 0.8.5 [Mozilla rv:0.9.7/20011221]") 01:02:49 davb (~chatzilla@alb-24-58-161-172.nycap.rr.com) has joined #openacs 01:42:40 davb has quit (Read error: 104 (Connection reset by peer)) 01:50:14 davb (dave@alb-24-58-162-46.nycap.rr.com) has joined #openacs 02:00:25 til has quit (Read error: 110 (Connection timed out)) 02:08:04 * davb upgrades to mozilla 0.9.8 02:08:16 or not... 02:08:48 i'm using it now 02:08:49 oops, I had the ximian apt sources in there. 02:08:50 it's not bad 02:08:58 Its seems snappier on windows. 02:09:01 no crashes 02:09:06 than 0.9.7 02:09:18 yeah, it seems pretty OK 02:09:45 darn. its not available on debian yet. I guess I have to wait a little. 02:16:09 vinod has quit ("changing universes") 02:34:34 markd2 (~Snak@166.102.30.111) has joined #openacs 02:36:19 http://www.acme.com/heartmaker/ayc/ 02:36:19 A: http://www.acme.com/heartmaker/ayc/ from markd2 02:36:27 A:|All your candy are belong to us 02:36:28 titled item A 02:37:14 lol 02:37:32 well, not really 3-year-old fell asleep in th emiddle of the floor, 02:39:21 jim (~jim@12-233-187-5.client.attbi.com) has joined #openacs 02:39:27 re 02:40:44 hi 02:40:52 heya davb 02:41:35 question me this... if you create a content item, make some revisions and then delete just the item, will it call delete on the revisions? 02:41:48 yes, it should. 02:42:01 if ou use cr_item__delete that is. 02:42:12 the API is your friend :) 02:42:13 yes, that's what I mean 02:42:39 not yet it isn't :) 02:42:55 ah. yes. 02:43:17 I am fooling around with CSS to make my templates spiffy. 02:44:14 now, that delete script for wp-slim, it gets that referential integrity constraint violation when it goes to remove the item... 02:44:18 looking... 02:49:39 from content_item__delete: 02:49:41 raise NOTICE ''Deleting content item...''; 02:49:41 PERFORM acs_object__delete(delete__item_id); 02:54:29 let me look at static-pages, I know I had this problem... 02:56:37 it deletes all permissions attached to the item, then all comments. 02:57:08 it also deletes from the static_pages table itself. then runs content_item__delete. 02:57:16 does wp-slim have its own table? 02:58:57 ah, I think you need to unregister the content_types before deleting them. 02:59:17 otherwise their is a fk violation on the content_type object. 02:59:54 it looks like the actualy presneation and attachement deletions should be last... 03:00:15 yeah, it tried to delete the presentations before the slides... 03:01:30 wait, nevermind on the content types... oops. 03:02:12 so if I re order some of those loops, probably fix it right up? 03:02:16 maybe... 03:02:22 I talk too much :) 03:02:39 why? :) 03:02:45 Before I think :) 03:02:48 enough. 03:02:56 I mean, why do you think that? :) 03:03:33 I'm able to follow what you did, as an exploration that took a turn on a discovery 03:03:37 btw 03:03:53 I have no idea if you know anything about this... 03:03:55 it gives loggy something to do 03:03:59 what is the referential integrity viloation that you get anyway? 03:04:00 heh 03:04:19 but I sent a check to Chris Crick to get the drive with the aduni stuff... 03:05:02 * markd2 has been meaning to do that too 03:05:28 but he hasn't sent the drive (however, the check wasn't cashed either...) 03:05:34 darnies. 03:06:41 I suspect just someone with no time. They are all volunteers. 03:07:08 yes, ok... I should see if I can get ahold of chris... 03:08:18 (I emailed chris, and he got back to me in a coupla days tho... wonder if he got the check) 03:08:30 ok, the error is... 03:09:53 ERROR: acs_obj_context_idx_anc_id_fk referential integrity violation - key in acs_objects still referenced from acs_object_context_index 03:09:53 Label ERROR not found. 03:10:05 chumpy! 03:11:10 and that's in the middle of running the drop-all-of-wp-slim script 03:11:23 right after running inline_5() 03:11:30 ok 03:11:59 (there are errors yet to come :) 03:12:04 loop 03:12:05 update acs_objects set context_id = null 03:12:05 where context_id = del_rec_a.item_id; 03:12:05 PERFORM content_item__delete(del_rec_a.item_id); 03:12:05 end loop; 03:12:12 I think this is the problem. 03:12:50 this migh need to be two steps, set context_id to null, in one pl/pgsql begin/end block, and delete the content items next. 03:17:11 I am not sure that wp-slim should be using context_id in that way in the first place... 03:19:50 ok, that's the last loop in inline_5()? 03:21:54 " In postgresql a data-change violation is triggered when a column that is a foreign key is changed more than once in the course of a transaction. " 03:22:07 maybe this is not your error... 03:22:09 darn. 03:22:32 in the course of a -transaction-... 03:23:00 does it really mean a column of a given particular row? 03:23:03 a pl/pgsql begin/end block is a transaction :) 03:23:20 yes I think so 03:23:41 can you have nested transactions? 03:25:11 * jim assumes no... 03:25:37 yes. 03:25:48 I can?? 03:26:56 I think so. I am not an expert. 03:28:13 jim: can you tell which loop it is failing on? 03:28:52 no, but I suppose I could instrument the code the way content_item__delete is 03:29:04 ah, I bet its the last one... 03:29:54 would I use the raise NOTICE ? 03:30:02 wait, its in acs_context_index 03:30:09 yes, good idea, to see how far you get :) 03:30:59 which is a table... and its not deleting from there. 03:31:09 I wonder if there is a trigger to soemthing to update it. 03:31:51 triggers... computed comefroms... 03:33:14 do you think I could just run the rest of the delete script, and then run the create script? 03:33:16 ok. there is, a trigger on acs_objects that shoudl update the context_index when the context_id is changed in the acs_objects table. 03:33:22 jim: nope. 03:33:31 I never could anyway.... 03:33:33 :) 03:34:07 so I would have to poke around and undo the damage 03:34:23 yeah. 03:34:31 or drop entire database and reinstall oacs data model 03:34:50 that is usually my method, but I was just testing. 03:35:37 andyn (~andy@12-254-190-230.client.attbi.com) has joined #openacs 03:35:58 I am pretty sure its the context_id triggers. there are multiple deletes and inserts in the update trigger. 03:37:00 well, it's trying to set the context id to null... 03:37:35 right but the trigger deletes all the old rows referring to that id. 03:37:39 but it's not commited yet so the trigger triggers and gets the pre-altered data? 03:38:02 so let's see... 03:38:06 actually the other way around. 03:38:27 deletes the thing the context id is referring to? 03:39:16 yes, content_item__delete sees the valyes still in the context_index table referrign to the items it is trying ot delete. I think. :) 03:40:56 at least it will be good exercise to pull this apart and put it back together correctly :) 03:41:04 yes. 03:41:30 the perceived job size increases every time it's examined :/ 03:42:08 would it be worth it to experiment with the cr for a few days first? 03:42:39 probably, if you plan on developing or using other packages you will need it :) 03:42:40 I mean, I want to see it delete a content item with a buncha revisions :) 03:42:49 right. 03:43:12 see,,, I'm a musician... and I want to create a jam list 03:43:13 jim: I don't think other packages use context_id like that. 03:43:30 so yes, I'm planning on making a package or 10 :) 03:43:35 ah cool. 03:43:55 jim: you might be able to use the new-improved super-etp in my head. :) 03:43:55 they shouldn't use anything reserved for other purposes 03:44:11 ah. 03:44:42 if they do, it should be for the exact purpose originally intended 03:45:10 right. I think it was a misunderstanding at aD what context_id was for :) 03:45:11 (the preceding mantra copied shamelessly from the bootcamp :) 03:46:08 I am trying to do something really simple in CSS, but its not flying... maybe I'll just use a table :) 03:46:09 (if this were an actual mantra, you would have gotten instructions from the higher plane where to tune your psychic abilities0 03:47:54 bbiaw 04:13:53 bah 04:13:55 baaaaah 04:14:01 * Psychephylax repeatedly kicks stuff 04:14:33 sorry to hear that. 04:14:38 me too 04:14:40 I tackled my CSS problem. 04:14:47 now its time for bed. 04:14:51 noooo 04:14:59 you can't leave me without listening to my angerment 04:15:16 ok go ahead... 04:15:18 :) 04:15:23 * Psychephylax gives dave some popcorn 04:15:46 So I call my dad at 10 am and tell him..."Dude, I'm getting a FedEx package...can you be home and sign for it" 04:15:52 My dad says "suuure" 04:16:15 So I am all excited and stuff...I look online at 3pm and it says..."Delivery attempt made, nobody on premises" 04:16:33 Had to drive out and about to the FedEx station to get my hard drives 04:17:02 I get home...and start fiddling with stuff 04:17:07 Of course my computer stops working 04:17:13 I finally got it to work 04:17:29 Installing windows XtracraPtacular on it 04:20:04 cool. 04:20:07 good luck. 04:20:17 :) 04:21:06 unfortunately for us "fiddling with stuff" is often followed by "stops working" 04:21:44 well now that I spent 2 hours learnign how to duplicate a 1 row table in css, its time for me to go :) 04:21:46 have fun! 04:21:49 davb has quit ("Client Exiting") 04:24:04 vinod (~vinod@207-172-255-116.s1132.apx1.sbo.ma.dialup.rcn.com) has joined #openacs 04:33:05 hey it's vinod 04:33:13 * Psychephylax gives vinod a cookie 04:34:54 mmm cookies 04:36:10 :-D 04:36:15 I hate computers 04:36:36 cookies! 04:36:50 they're mine - all mine! 04:36:52 I really need to get some sleep 04:37:00 Heh 04:37:01 it's mark 04:37:05 * Psychephylax gives Mark a cookie 04:37:10 yay! 04:37:10 thank you 04:37:17 you're welcome you cookie monster you 04:37:27 * markd2 brushes his blue fur 04:37:45 hehehehe 04:37:46 * markd2 knows vinod is thinking something perverted 04:37:52 so I won't even say anything 04:37:56 you're nuts 04:38:00 * vinod stops thinking 04:38:22 i'm too busy coughing to think 04:38:30 sounds like me 04:38:34 I get a headache when I cough 04:38:44 And my Xtra crapPy install is failing 04:54:16 markd2 has quit ("nite all") 05:15:08 vinod has quit ("changing universes") 09:55:44 dlk (dlk@walter.ita.chalmers.se) has joined #openacs 10:19:32 rdobbs (~rd@user-2iveaju.dialup.mindspring.com) has joined #openacs 10:19:54 hello all - i'm looking at openacs for creation of an online store, does anyone have experience with the ecommerce package? 10:23:04 echarp (manu@r38m112.cybercable.tm.fr) has joined #openacs 11:15:21 echarp is now known as ecMiam 11:30:38 rdobbs has left #openacs 11:36:59 ola (~ola@as3-1-3.mal.s.bonet.se) has joined #openacs 12:14:38 ecMiam is now known as echarp 13:41:32 davb (~dave@cm-208-136-23-203.nycap.rr.com) has joined #openacs 13:57:30 davb has quit () 14:16:51 docwolf has quit ("What happens if i press this bu") 15:03:27 davb (~dave@cm-208-136-23-203.nycap.rr.com) has joined #openacs 15:03:45 hello 15:21:57 Hi davb! 15:24:09 there's a fundamental flaw with the parameter code I adde to clickthrough:-( 15:24:44 ack 15:24:47 :) 15:24:56 Hey, it was your first try :) 15:25:02 I must try to come up with a solution for that too- 15:25:06 yes:-) 15:25:30 also if noone ever tried it, the issue would not have come up. 15:25:38 There are ALOT of things like that in the toolkit. 15:26:07 that's true. 15:26:45 I think I will have to write a little howto on building templates with CSS 15:27:36 it would be awesome.. 15:28:05 yeah, first I have to learn it :) 15:28:25 of course.:-) 15:28:28 I have to be careful because alot of developers still use Netscape 4 :) 15:29:08 ahem. that was before... 15:29:34 :) 15:30:18 nowadays I use Debian and upgrading is a snap... 15:30:29 ola: do you know if there is a proc to encode entities in HTML in OpenACS 4? 15:30:44 wow, arsdigita.com is REALLY slow today... 15:31:06 encode entities? explain. 15:31:18 turn & into & etc... 15:31:39 aha. no I've never seen one... 15:31:41 I need to stuff some database data into XML 15:31:45 ad_quotehtml 15:31:47 :) 15:31:58 it does that? 15:32:02 I am not sure if it is enough though. 15:32:03 yes. 15:32:07 cool 15:33:01 oops, I am not writing this for OpenACS 4. :) 15:33:11 I think its util_quotehtml for OpenACS 3. 15:33:26 ok 15:33:29 hmmmm. 15:35:21 firewalls are a PITA. 15:35:40 now it's stopping me from testin courier. 15:36:31 I think it's a question of reading logs. ;-) 15:36:47 yes, I find that help alot 15:36:50 open port 143 15:36:58 and knowing what logs to read 15:37:04 :) 15:37:23 are you using svscan to start courier? 15:37:41 port 143 is open, well, portforwarded to the mailserver... 15:37:46 nope 15:37:51 ok. 15:40:21 since I'm forwarding I'm not really sure where to expect the error log (can't find it on *any* machine) 15:40:49 oh, well 15:41:53 you working on your secret project, dave? 15:42:48 ola: nope, I am hacking RSS into my personal site because I don't have time to upgrade to OpenACS 4. 15:43:02 actually the guy with the secret project seems to have disappeared this week... 15:43:23 oh. 15:51:45 hmm.. I wonder if the protocol name for IMAP is imap2 or if it is imap4rev1 (or something totally different)... 15:52:03 the firewall must know. 15:55:58 its imap :) 16:01:29 aha its imap! great, thanks! 16:24:08 dave: the mail I sent to unknown@deepsky... was bounced from MAILER-DAEMON@server1.thedesign... 16:24:25 yeah. that looks right :) 16:24:37 It just grabs the hostname of the machine because I don't have me set. 16:26:14 I wonder if it's possible to make it show the "right" domain. 16:26:54 I can't think of a way, except running a seperate qmail for each one. 16:30:32 til (~tils@port-212-202-128-195.reverse.qsc.de) has joined #openacs 16:43:37 docwolf (~docwolf@adsl-34-25-113.mia.bellsouth.net) has joined #openacs 16:44:02 hola 16:46:07 hi docwolf, til 16:46:15 hi 16:46:35 yeah it works! 16:47:05 what works? 16:47:22 my rss hack. 16:47:33 congrats. 16:47:35 except there is no at the top... 16:48:01 I am not sure if it needs it or not :) 16:51:15 yes it does :) 16:55:00 hmm.. /var/log/messages says "Feb 6 18:56:27 hal -- MARK --" all of the time I'm connecting with an IMAP client... 16:56:14 aha. I think I need to open up xinetd 16:57:12 * davb recommends tcpserver instead. 16:58:14 ok. 16:58:37 hmmm. 16:58:41 I don't use that either. 16:59:00 courier-authdaemon runs all the time, when it gets a request it starts up courier-imapd 16:59:47 I had the most trouble getting that setup. the authdaemon 17:01:28 I see. well I ended up with the debian package of courier-imap. All the requests from the clients goes to authdaemon, is that it? 17:02:19 yes, where they are authenitcated, then passed on if they are valid. 17:02:47 thanks 17:06:59 I intend to migrate to daemontools later, if I can get it running. 17:07:25 :) 17:10:16 There are like 10 people suscibed to my RSS channel which I used to manually build using Syndicate your Page by AaronSw, but I got lazy. Now its automagically generated when I update the page. 17:10:47 spiffy! :-) 17:11:45 what are you broadcasting? the chat log? 17:16:01 that is down with XSLT magic I got from the chump's author. 17:16:07 This is my boring and pointless weblog. 17:16:09 :) 17:16:31 actually alot of people grab the chump RSS file also. 17:18:19 hmmmm. they are having a online-learning initiative at my work. Hoepfully I can sneak in dot-lrn. We don't have any money so its perfect :) 17:19:23 yes, it should be released any week... 17:21:28 talilee (~talli@204.120.52.1) has joined #openacs 17:21:34 hey guys 17:21:40 hi talilee: 17:22:18 sorry to have missed all the fun gossip from yesterday 17:22:20 how was the OACS social? 17:22:41 great! 17:22:50 hi talilee! can you type straight? ;-) 17:23:05 i can almost type straight... the hang over is killing me! 17:23:11 heh 17:23:13 heh, so donb won? 17:23:43 any new people at the social? 17:24:07 there were a lot of OACS members: tom jackson, carl coryell martin, donb, jade rubick and torben and also 5 or 6 new people coming to find out and hang out 17:24:10 so it was really nice 17:24:20 and the lucky labrador is an awesome bar! great beer! 17:24:36 wow. 17:25:30 yeah, it was a great social 17:25:54 ok, talk to you guys later 17:26:01 ok bye 17:26:07 gotta meeting to go to ... 17:26:07 talilee has left #openacs 17:27:21 http://radio.userland.com/stories/storyReader$9889 17:27:21 B: http://radio.userland.com/stories/storyReader$9889 from davb 17:27:50 B:|Simple-Cross Network Scripting in Radio Userland 17:27:50 titled item B 17:28:02 B: wow, this is neat. at first I didn't see how it worked. 17:28:02 commented item B 17:28:40 B: it runs an XMLRPC call when it renders a page. 17:28:40 commented item B 17:35:18 til has quit (Read error: 113 (No route to host)) 17:51:59 A: 17:51:59 http://www.acme.com/heartmaker/ayc/ 17:52:00 All your candy are belong to us 17:58:13 echarp is now known as ecGoHome 18:10:50 what are child types in the content repository? 18:11:12 inheritance? or structure? 18:11:36 good question :) 18:12:51 it looks like wp is defining a structure with children objects 18:13:11 ok, I understand the questions better. I think that is OK. 18:13:24 I am going to reread the CR docs :) 18:14:09 check this out: http://developer.arsdigita.com/doc/acs-content-repository/guide/object-relationships.html 18:14:32 I am not sure if wp uses this, but it should :) 18:14:46 I think I need this for the stuff I am building too. 18:15:56 haha :) someone can't count :) 18:16:05 An article divided into 18:16:05 sections, or a news story with an associated photo are one example of this. 18:16:55 ok, and that shows that the parent/child thing is for structure 18:17:31 right. The object_type system is from acs_objects... I am looking for something to explain how it should be used. 18:18:46 I think this is an important statement "This last point cannot be over-stressed: the object model is not meant to be used for large scale application data storage. It is meant to represent and store metadata, not application data." 18:22:45 well, it's also used to allow the application of permissions... 18:22:56 object system or type system/ 18:22:57 ? 18:23:44 well, objects... 18:24:07 yeah, thats the metadata, about the object. 18:25:05 so they're just saying you should arrange your own storage that refers to the objects (if you're choosing to use objects)? 18:25:16 yes. 18:25:20 I think so. 18:25:33 Ie. the CR keeps the actualy content in the cr_items and cr_revisions tables. 18:26:46 and uses the object system primarily for typing 18:27:15 right. I just never thought about it :) 18:53:32 ecGoHome is now known as echarp 19:00:00 docwolf has quit ("What happens if i press this bu") 19:03:30 this is interesting: "pe Visitor with visitor registration group. 19:03:30 4. I try to assign user Luis to the group Visitor registration. I 19:03:30 said to openacs4 19:03:33 oops 19:03:45 "You can easily create topics, tag one or more of them onto your postings, and even--this is wildly powerful--make each topic into its own RSS feed. " 19:03:49 refering to Radio Userland. 19:04:23 davb: do you remember what IP you told imapd to listen on? 19:04:26 I think this would be a neat way to use RSS with OpenACS. Whenever a new item is added to the content_keyword_map, add it to an RSS feed that that topic. 19:04:39 ola: I don't recall telling it any ip.. 19:04:50 ok 19:04:51 probably just listens on all of them 19:05:07 you didn't edit the conf file? 19:05:17 let me look :) 19:05:40 default is: ADDRESS=0 which probably is all.. 19:05:46 yeah that is what I have 19:05:52 what authdaemon are you using? 19:05:52 thanks, dave 19:06:07 np 19:06:29 userdb first, then authpam... 19:06:38 Ah. ok. that is what I used. 19:06:48 cool 19:07:02 ola: I fixed mine by telnetting to 127.0.0.1 port 143 and typing in IMAP commands :) 19:07:26 aha! 19:07:47 any examples of IMAP commands? 19:07:50 first see if you can even connect to port 143... if its not running correctly you can't. 19:07:56 like this: 19:08:08 A001 (this is a sequence number for the command) 19:08:14 I don't have telnet...:-( 19:08:18 A001 login username password I think. 19:08:29