00:15:43 talli has quit 00:42:38 davb has joined #openacs 00:54:28 docwolf has joined #openacs 01:16:23 talli has joined #openacs 01:16:35 hey guys 01:25:45 just can't stay away huh? 01:30:10 nope - i'm a loser 01:30:20 although i'm walking away from my computer now... 01:30:24 i am leaving... 01:30:26 see ya... 01:30:30 talli has quit 01:32:50 bye 01:40:59 mio has joined #openacs 01:42:32 mio has left #openacs 02:37:26 til has quit 03:09:29 docwolf has quit 03:25:45 docwolf has joined #openacs 03:41:45 davb has quit 04:29:05 hazmat has quit 04:35:04 blue has joined #openacs 04:36:23 blue is now known as andrew 04:59:11 hazmat has joined #openacs 05:54:03 [GlobalNotice] T-30 seconds to services implosion 05:59:58 ChanServ has changed the topic to: Welcome to the OpenACS Helpline | http://www.openacs.org/ 05:59:58 This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog 07:55:17 all openprojects staff, please message me for an invite to #willyoutakethisdance... perpare for liftoff! 08:46:57 [GlobalNotice] This is just a warning that in a few minutes we will start to convert the network to dancer-ircd. 09:08:07 Disconnected from irc.openprojects.net (Connection reset by peer) 09:09:30 loggy has joined #openacs 09:09:30 topic is: Welcome to the OpenACS Helpline | http://www.openacs.org/ 09:09:30 Users on #openacs: loggy andrew docwolf rbm shagster chump GEM AaronSw 09:09:30 This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog 09:12:42 rbm has quit 09:12:42 andrew has quit 09:12:42 GEM has quit 09:12:42 AaronSw has quit 09:12:49 GEM has joined #openacs 09:12:55 rbm has joined #openacs 09:14:00 Disconnected from irc.openprojects.net (Connection reset by peer) 09:15:56 Disconnected from irc.openprojects.net (ERROR :Closing Link: loggy[~openacs-l@205.253.219.118] (Ping timeout: 182 seconds)) 09:16:17 loggy has joined #openacs 09:16:17 Users on #openacs: loggy AaronSw chump 09:16:17 month or so. If we have forgotten something, please inform us 09:16:17 soon (due to database drift) especially if important. 09:16:17 09:16:17 For conversion matters please use #Conversion. 09:16:17 09:16:17 We hope you will have a great stay with us! 09:16:17 (Open Projects Net Team) 09:16:17 [#openacs] This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog 09:16:19 blue has joined #openacs 09:17:04 shagster has joined #openacs 09:17:37 blue has quit 09:17:37 AaronSw has quit 09:18:14 rbm has joined #openacs 09:19:00 blueseed has joined #openacs 09:19:34 rbm has quit 09:19:35 rbm_ has joined #openacs 09:21:12 AaronSw has joined #openacs 09:25:18 Welcome to the new Open Projects network. We hope you enjoy 09:25:18 the new quality of service that should be provided. If you 09:25:18 have any questions / comments / concerns, please email 09:25:18 support@openprojects.net or drop by #OpenProjects. 09:25:18 09:25:18 Please note that a few items in the services database have not 09:25:18 been converted into the new database. This includes: 09:25:18 - channel access lists (different complex trust metrics) 09:25:18 - memos sent to channels (time reasons) 09:25:18 - items which have no equivalent in the new database 09:25:18 - things which we have forgotten ;) 09:25:18 If there is any information which has not been converted, 09:25:18 it will be available on a yet unnamed server for the next 09:25:18 month or so. If we have forgotten something, please inform us 09:25:18 soon (due to database drift) especially if important. 09:25:18 09:25:18 For conversion matters please use #Conversion. 09:25:18 09:25:18 We hope you will have a great stay with us! 09:25:18 (Open Projects Net Team) 09:25:18 [#openacs] This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog 09:28:43 rbm_ has quit 09:28:43 shagster has quit 09:28:48 rbm_ has joined #openacs 09:28:53 shagster has joined #openacs 09:38:47 graszew has joined #openacs 09:50:10 hazmat has joined #openacs 10:02:33 rbm_ has quit 10:02:33 AaronSw has quit 10:02:33 chump has quit 10:03:39 rbm_ has joined #openacs 10:03:56 AaronSw has joined #openacs 10:05:36 chump has joined #openacs 10:11:53 hazmat has left #openacs 10:11:56 hazmat has joined #openacs 10:16:05 hazmat has quit 10:22:13 Disconnected from irc.openprojects.net (Connection reset by peer) 10:22:30 loggy has joined #openacs 10:22:30 Users on #openacs: loggy AaronSw @rbm_ 10:22:43 Disconnected from irc.openprojects.net (Connection reset by peer) 10:22:56 loggy has joined #openacs 10:22:56 Users on #openacs: loggy AaronSw 10:23:19 chump has joined #openacs 10:25:15 chump has quit 10:25:15 AaronSw has quit 10:26:16 chump has joined #openacs 10:27:44 graszew has joined #openacs 10:29:25 Disconnected from irc.openprojects.net (Connection reset by peer) 10:29:33 loggy has joined #openacs 10:29:33 Users on #openacs: loggy graszew chump 10:29:33 [#openacs] This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog 10:34:39 AaronSw has joined #openacs 10:46:06 ola has joined #openacs 11:28:54 [UrgentNotice] 11:33:43 :[UrgentNotice] Sorry. Please can you report servers not listening on usual ports ie 6665-7000 to me immediately. 11:36:33 ola has quit 11:36:38 ola has joined #openacs 11:37:08 graszew has quit 11:45:11 :[GlobalSpam] "We have normality. I repeat, we have normality. Anything you still can't cope with is therefore your own problem." But if you do have problems please come to #conversion where your problems will be solved. Thankyou for bearing with us during these difficult times :) 11:52:43 graszew has joined #openacs 12:24:06 Disconnected from irc.openprojects.net (Connection reset by peer) 12:24:21 loggy has joined #openacs 12:24:21 Users on #openacs: loggy graszew 12:26:38 AaronSw has joined #openacs 12:27:08 chump has joined #openacs 12:36:41 til has joined #openacs 12:50:51 graszew has quit 13:21:28 til has quit 13:27:03 [GlobalNotice] Hi all. We're slowly struggling into the new code. If you're having problems, please message me a short detail message describing the problem. That should get us going for now. Thanks. 13:31:20 [GlobalNotice] Hi all. I've gotten surprisingly few messages so far. As other people have mentioned previously, we are aware there are problems. Keep letting us know your needs, we'll respond as quickly as we can. Thanks. 13:34:46 Disconnected from irc.openprojects.net (Connection reset by peer) 13:34:50 loggy has joined #openacs 13:34:50 Users on #openacs: loggy AaronSw chump 13:34:50 [#openacs] This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog 13:38:48 [GlobalNotice] Hi all. Apologies for the global notice. You'll probably see a few more. Be aware that I may not have replied to several messages, but I'm logging and intend to hit each one in turn. Thanks for your patience during the cutover. 13:42:08 Disconnected from irc.openprojects.net (Connection reset by peer) 13:43:56 Disconnected from irc.openprojects.net (ERROR :Closing Link: loggy[~openacs-l@205.253.219.118] (Ping timeout: 181 seconds)) 13:44:01 loggy_1 has joined #openacs 13:44:01 Users on #openacs: loggy_1 @AaronSw 13:49:10 chump has joined #openacs 13:50:11 Welcome to the new Open Projects network. We hope you enjoy 13:50:11 the new quality of service that should be provided. If you 13:50:11 have any questions / comments / concerns, please email 13:50:11 support@openprojects.net or drop by #OpenProjects. 13:50:11 [#openacs] This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog 13:50:34 talli has joined #openacs 13:50:35 whoa. all alone. no one here to love but me. 13:54:47 [GlobalNotice] Hi all. In a few moments we will be reverting to the old servers and stabilize there while we analyze the various issues produced by our conversion attempt. So expect the usual (relatively) stable environment in a few minutes. Please bear with us and thanks again for your patience. 13:56:46 davb has joined #openacs 13:56:59 Good morning. 14:01:38 davb has quit 14:01:38 talli has quit 14:01:38 chump has quit 14:01:38 AaronSw has quit 14:02:05 Disconnected from irc.openprojects.net (Connection reset by peer) 14:06:27 loggy has joined #openacs 14:06:27 Users on #openacs: loggy AaronSw davb talli 14:06:27 This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog 14:06:36 brb 14:07:16 chump has joined #openacs 14:07:29 nevermind. 14:07:46 go loggy! 14:13:07 AaronSw is now known as Aaron 14:13:15 Aaron is now known as Aaron2 14:13:53 * Aaron2 disconnects 14:13:56 * Aaron2 reconnects 14:15:08 Aaron2 is now known as AaronSw 14:19:46 who is this AaronSW guy and why is he always here? 14:20:00 You don't know AaronSw? 14:20:08 I'm a secret spy from Zope. 14:20:10 hey aaron, isn't it time for school? 14:20:27 Ooh, that gets you a smack. 14:20:29 aren't you late for the bus? 14:20:30 * AaronSw slaps talli around a bit with a large trout 14:20:39 train 14:20:51 whatever. get your ass to class, boy! 14:21:25 You east-coasters... I've got a whole 'nother hour still. 14:21:34 oh... right 14:21:36 good point 14:21:54 Heh. 14:21:56 BTW, I'll be in Washington D.C. next week, in case anybody is around there. 14:21:58 well, don't you have any homework to do in this time? 14:22:14 what for? meeting with some alQaeda operative? 14:22:50 http://dabbler.org/stories/storyReader$88 14:22:52 A: http://dabbler.org/stories/storyReader$88 from davb 14:22:59 Homework? Why bother 14:23:03 A:| .NET Signals an Industry Shift 14:23:05 titled item A 14:23:05 DC: P2PCon2 14:23:06 Label DC not found. 14:23:26 AaronSw: do you go to all those things? 14:23:35 all what things? 14:24:28 You seems like you are visiting quite a few conferences. Well more than me anyway :) 14:25:24 Really? I can only think of like 2. 14:25:43 OK, I jsut have no life...:) sorry. 14:25:44 what about parent-teacher-student conferences? 14:25:54 been to many of those lately, aaronsw? 14:26:03 Not for years. 14:26:09 How about you? 14:26:09 truant! 14:26:19 double truant! 14:29:06 A:[OS Independence|http://dabbler.org/stories/storyReader$22] 14:29:07 commented item A 14:29:39 A:[Open Pragmatism|http://dabbler.org/stories/storyReader$23] 14:29:39 commented item A 14:30:22 i hear that C# is an awesome language 14:30:29 much better than java, which isn't saying a whole lot 14:30:40 but C# apaprently is supposed to hold a lot of promise 14:30:43 Interesting. 14:31:13 But will it run on non-MS systems? 14:31:17 i've heard that from many people, even within the open source community (including luke and lars) 14:31:51 i believe so. there were always rumors that the beta versions of some of the .NET IDEs had Linux in their platform choices 14:32:05 also, Mono and dotGNU are trying to build open source CLRs 14:32:22 Right. Did they say what it was good for? 14:32:41 Is it a replacement for C/C++ in other words? 14:34:23 chump has quit 14:34:40 Looks like I still have a memory leak on that server... 14:35:34 it is more of a replacement of java, which i guess is a replacement of C/C++ 14:35:53 chump has joined #openacs 14:35:55 then again, C/C++ still have their considerable place. witness all the work we still do in C to extend AOLserver, 14:36:10 which is still the best fucking web software anyone has written 14:36:12 IMHO 14:36:22 For some things, yes. But for most applications, a nice scripting language is better. FOr low-level stuff, C is more efficient. 14:36:38 on the web, i agree 14:36:59 but all the heavy duty stuff on the server side in aolserver is in C, right? 14:37:10 Right. 14:37:46 C is for the hard stuff. Everything else should be in a high-level language. Most applications can be programmed this way. 14:38:05 right, i agree 14:38:28 I am going to work on the new keyword stuff today. 14:38:36 killer! 14:38:46 What do you think about fixing bboard to use the CR keywords? 14:38:49 that stuff will be awesome. it will be a great addition to the toolkit 14:38:53 i think that would be amazing 14:40:23 ola has joined #openacs 14:41:15 Hi all! 14:41:43 Hi ola. 14:42:13 hey ola 14:44:16 brb-breakfast 15:05:25 chump has quit 15:10:23 chump has joined #openacs 15:17:55 markd2 has joined #openacs 15:22:10 Hi markd2 15:22:27 greetings 15:22:28 * markd2 is back home, and slogging through the work mailbox 15:29:32 yo markd 15:31:47 hiya 15:37:01 Anyone know how I would create a package with no SQL files? 15:39:11 aha, nevermind. 15:39:40 Psychephylax has joined #openacs 15:41:51 hi people 15:41:54 Howdy 15:41:58 hey mark 15:42:15 hey Sporkephylax 15:43:03 I need Oracle help =) 15:47:57 sure 15:47:58 whazzup? 15:48:40 I can't insert stuff into oracle 15:48:40 what happens? 15:48:40 I get a number to string error or sumfing 15:52:40 hold on..I need to get my butt in gear here 15:52:50 multitasking and daylight savings times don't mix 15:53:33 Should I create seperate UI for site-administrators and users to assign keywords to items? 15:53:43 til has joined #openacs 15:58:07 Initialization error: X server not responding 15:58:11 Why is that not working!!! 15:58:55 Oracle doesn't use an X server for insert operations... 15:59:23 :D 16:00:08 ora8.c:3568:ora_tcl_command: error in `OCIStmtExecute ()': ORA-06502: PL/SQL: numeric or value error: character to number conversion error 16:00:08 ORA-06512: at line 1 16:02:14 try the query in SQL*PLUS 16:02:30 it's not a query it's an insert 16:02:42 ok. try the insert... 16:03:38 how do I run a stored function ? 16:05:21 Try select stored.functionname(params); ... 16:05:55 or begin(CR) stored.functionname(args); end; / 16:06:03 spiffy! 16:06:26 CR? 16:06:58 <-ENTER 16:07:01 oh 16:07:05 :) 16:07:51 * Psychephylax tries 16:09:34 if I have defaults for a few of them then I don't need to specify them? 16:10:14 right 16:10:21 aha 16:10:22 Well, wait 16:10:30 say I have something like this 16:10:55 pl/sql proc that takes (sysname, query, sysuptime, syscontact) 16:11:02 where query is sysdate 16:11:17 how will it know to insert that when I have this: 16:11:47 ('OracleBox','10 days','me@oraclebox.com'); 16:11:59 wouldn't it try to insert 10 days as the time? 16:12:09 as sysdate rather 16:16:27 anyone? 16:16:55 talli has quit 16:17:23 What are you trying to accomplish? 16:19:07 i think the problem arrived when I omitted a value 16:19:20 causing oracle think it's inserting something else 16:19:32 everything to shifted by 1 or however many omissions i made 16:19:39 makes sense to me...but I'm no oracle genius 16:19:47 * Psychephylax waves a cookie around 16:20:09 yeah 16:20:54 so how would I signify I want to use a default in the space? 16:20:57 just go , ,? 16:21:54 don't think you can do that 16:22:05 ok 16:22:06 it'll fill in defaults after it uses the existing arguments 16:22:09 you can name them 16:22:20 explain 16:22:26 e.g. somefunction (arg1 => 'value', arg17 => 'value2', give_mark => 'more cookies'); 16:22:33 it'll pass those values for those arguments 16:22:37 and then everything else will take its default value 16:22:38 right 16:22:49 ok this is what I have: 16:23:01 set incident_id [db_exec_plsql insert_info "begin :1 := snmp_incident.new(mac_address => :modem_mac,comments => :comments, 16:23:27 before mac_address I have a incident_id which is calculated from acs_objects 16:23:36 and between modem_mac and comments there's a sysdate 16:28:12 if you don't have any unlabeled paramters, it should then be doing the right thing with the default valus 16:28:30 very odd 16:29:38 then add one 16:29:40 then it becomes very even 16:29:56 i will just fill in the values that don't have defaults 16:31:19 aha 16:32:32 PLS-00306: wrong number or types of arguments in call to 'NEW' 16:33:56 double-check your types 16:34:02 that your'e not passing a character string where a number is expected 16:34:41 I checked 16:34:51 I made it so everything that has a default value is using it 16:34:56 ANd it seems to work 16:34:58 but : 16:35:06 ora8.c:3568:ora_tcl_command: error in `OCIStmtExecute ()': ORA-02291: integrity constraint (MYOPENACS.ACS_OBJECTS_OBJECT_TYPE_FK) violated - parent key not found 16:35:51 that means you're trying to insert a value into a 'references' column, and ther's not a correspnding value in the referenced table 16:36:08 judging from the name of the constraint (ACS_BJECTS_OBJECT_TYPE_FK), you probably don't have a correspnding object type 16:36:16 hmm? 16:37:50 You are trying to create an object of type 'foo' when there is no entry in acs_object_types for that type. 16:39:22 i just did select object_name from user_objects; 16:39:41 and I have snmp_incident x2 and snmp_incidents 16:40:27 blueseed has joined #openacs 16:40:41 I don;t even have a user_objects table. 16:41:28 acs_objects 16:41:37 user_objects is part of the oracle data dictionary 16:42:12 Thats the objects name. Not its type. You need to create a type if you are using a custom type instead of cr_item. 16:42:17 or whatever/ 16:42:28 ummm 16:42:31 i'm confused 16:42:41 what tables are the ones I am going to be playing with 16:42:56 Do you have in your SQL file acs_object.create_type (my type) 16:43:05 let me check 16:43:33 acs_object_type.create_type ( 16:43:33 supertype => 'acs_object', 16:43:33 object_type => 'snmp_incident', 16:43:33 pretty_name => 'SNMP Incident', 16:43:33 pretty_plural => 'SNMP Incidents', 16:43:33 table_name => 'snmp_incidents', 16:43:35 id_column => 'incident_id' 16:43:37 ); 16:43:48 Ok. good. 16:44:04 make sure its there select object_type from acs_object_types; 16:44:05 SQL> select * from acs_objects where object_type = 'snmp_incident'; 16:44:05 no rows selected 16:44:16 ok. 16:44:25 am I missing something?> 16:44:42 The log of when you ran the create script? 16:44:46 :) 16:44:48 ummm 16:44:54 lemme check 16:45:01 Try creating it now maybe... 16:45:19 nope 16:45:43 umm 16:45:46 spool something 16:49:11 that did nothing 16:49:24 no errors? 16:49:53 no 16:51:16 you want the log? :) 16:53:28 Not very verbose is it. 16:53:35 no 16:54:00 What if you try just that acs_object.create_type in SQL*PLUS? 16:55:28 markd2 has quit 16:56:32 it works 16:56:35 it does create my stuff 16:56:37 or so it seems 16:57:42 ok. What is the exact acs_object.new call you are making? 16:58:33 it's very long :) 16:58:38 I'm not pasting it 16:59:32 ok. Check to make sure that you are setting object_type in there to the object type you have created. and make sure that is what is really getting passed to oracle. 17:00:01 aha 17:00:03 wait 17:00:07 I think I found a problem 17:00:29 heh, as I suspected. You should not work before lunchtime on Mondays. :) 17:02:01 heh 17:02:09 that eliminates 10% of my workweek 17:03:05 Ok, maybe not... 17:06:51 i see nothing 17:07:15 darn. 17:09:33 graszew has joined #openacs 17:09:39 how do I do a plain sql block 17:09:47 I'm going to try manually inserting into the thing 17:10:17 markd2 has joined #openacs 17:10:20 geeze 17:10:23 just like this 17:10:23 lol 17:10:26 varley netsplit off, and never rejoined 17:10:31