derek (~dneighbo@ip68-109-180-32.ph.ph.cox.net) joined #gnuenterprise. hmmm got kicked i guess ajmitch: im here if you are still looking for me hi what do you know about ical? planning to use it in gnue? phpgw can act as an ical server, like you requested :) cool um i use ical a bit but haven't :dug: into it too much so I heard google tells many things rofl it is humorous if somehow my name is related to a google search on ical well I remembered you talking about it ;) so I searched for "gnu enterprise ical" derek....google is watching you =-O wendall911: some of the crap for google is scary i know for a while now if you talk about something here and a week later go looking for an "expert" opinion likely the log from here will be in the top ten results :) yep derek is a God, derek is a God <---now you'll have your own Google fan club ;) roflmao http://www.zopp.nl/404.htm best 404 ever lol interesting read: http://www.zopp.nl/404.htm bah Action: ajmitch kicks mozilla or shall I kick xchat for not pasting selected text? hahaha this is funny too http://www.devhome.org/404.html http://docs.axisgroupware.org/index.php?page=AxisWishList guess thats one way to tell the world your webservers use bsd insetad of GNU/Linux that 404 is ironic in that Tux bends over BSD when it comes to php and mysql LAMP is king steveb (~steveb@218-101-45-108.paradise.net.nz) joined #gnuenterprise. hi steveb bbl :) hi ajmitch mdupont (mdupont@p5080E08E.dip0.t-ipconnect.de) left irc: Read error: 60 (Operation timed out) reinhard (~reinhard@M1264P004.adsl.highway.telekom.at) joined #gnuenterprise. Nick change: SachaAway -> SachaS Nick change: thierry_ -> thierry mdupont (mdupont@p5080E5D6.dip0.t-ipconnect.de) joined #gnuenterprise. jbeimler (~john@user-2ivf41c.dialup.mindspring.com) left irc: Connection timed out jbeimler (~john@user-2ivf41c.dialup.mindspring.com) joined #gnuenterprise. Nick change: SachaS -> SachaAway Nick change: mdupont -> md-afk steveb (~steveb@218-101-45-108.paradise.net.nz) left irc: Remote closed the connection md-afk (mdupont@p5080E5D6.dip0.t-ipconnect.de) left irc: Read error: 110 (Connection timed out) chillywilly (danielb@CPE-24-167-193-166.wi.rr.com) left irc: Read error: 54 (Connection reset by peer) ToyMan (~stuq@user-0cevdks.cable.mindspring.com) joined #gnuenterprise. maxy_ (~maxy@OL53-216.fibertel.com.ar) joined #gnuenterprise. maxy__ (~maxy@OL53-216.fibertel.com.ar) left irc: Read error: 110 (Connection timed out) dimas_ (~dimas@195.218.177.46) left irc: Read error: 113 (No route to host) ToyMan (~stuq@user-0cevdks.cable.mindspring.com) left irc: "Client Exiting" R45 (~r45@cuscon317.tstt.net.tt) joined #gnuenterprise. ToyMan (~stuq@smtp.dstoys.com) joined #gnuenterprise. Arturas (~arturas@gsk.vtu.lt) joined #gnuenterprise. Hello morning morning all hello jcater (~jcater@cpe-066-061-071-147.midsouth.rr.com) left irc: "Client exiting" jamest (~jamest@gw.math.ksu.edu) joined #gnuenterprise. jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) joined #gnuenterprise. reinhard_ (~reinhard@M1264P004.adsl.highway.telekom.at) joined #gnuenterprise. reinhard (~reinhard@M1264P004.adsl.highway.telekom.at) left irc: Read error: 111 (Connection refused) Nick change: reinhard_ -> reinhard Nick change: wtg -> wtg`sleep chillywilly (danielb@CPE-24-167-193-166.wi.rr.com) joined #gnuenterprise. mcuria (~maxy@OL53-216.fibertel.com.ar) joined #gnuenterprise. mcuria (~maxy@OL53-216.fibertel.com.ar) left irc: Client Quit mcuria (~maxy@OL53-216.fibertel.com.ar) joined #gnuenterprise. maxy_ (~maxy@OL53-216.fibertel.com.ar) left irc: Read error: 110 (Connection timed out) dimas (~dimas@195.218.177.46) joined #gnuenterprise. thierry (~thierry@musashi.xtensive.com) left irc: Connection timed out Action: dcmwai is away: Sleeping, Good Night Nick change: dcmwai -> dcmwai|AWAY jcater: you here? yes it looks like jbailey is busy these days i think if we (you) want a point release we should/could/might do it now good evening for all i have two questions, both from technical side 1) what is gnue-info mailing list i got letter with this list indication, but i do not find it on the web (address would be info@gnue.org) and 2) GNUe Traffic as i'm not subscribed to that list (if it exists), i do not know what was said on the subject there could someone please update me on it? Arturas: psu sent a mail to that list which you got cc'ed anyway there was no further conversation on that list on that topic brb Arturas: info@gnue.org isn't a "discussion" mailing list it's just a mail alias that forwards email to 4 or so of us to answer people's questions perfect reinhard: I'm ok with a point release then i could try to take all GNUe Traffic but if I need to do it, I can't today Arturas (~arturas@gsk.vtu.lt) left irc: "Bye :)" jcater: no need to hurry just wanted to give you my "ok" for it in case you were waiting for that ah, ok mouns (mouns@kali.mouns.org) joined #gnuenterprise. so we're ready? for a point release i assume we can skip all the pre releases as it's not like anyone ever tests them anyway :) jamest: plus I don't think people download them so let's just *say* we did a point release and move on ok, hope that pre-release worked for everyone it did? good. let's go then did the new setup system make it in everywhere? common, appserver, forms, reports and designer IIRC navigator? let me look yeah looks like i did that, too you guys rock jcater: did you say you were working on masks, now? I worked on them some last weekend and will hopefully follow thru some more this weekend but my gnue time is fast approaching >< cool, wasnt sure if I was dreaming or not. :) yea, hear ya. I go in cycles though spring is when I do the most gnue'n as that's when business is slowest jcater: quick question on gsd files currently there's no boolean type defined does that have a specific reason (other than nobody needed it by now)? well a combination of "nobody needed it" and "how would we do something like that" as few databases actually support boolean data types so how do you handle those and that relates more to tools than gsd directly what kind of db field do you underlay behind a checkbox now? I currently don't use checkboxes because I can't answer that question hrmmm personally, I have Y|N char() fields in oracle would you say that now would be a bad time to implement a boolean type in appserver? well, appserver is a different story i use booleans in postgresql behind checkboxes because appserver can "say" "if the underlying database doesn't support boolean, then all "boolean" fields will really be integers with 1 or 0, or chars with T/F" how do you do that with a multipurpose tool like forms, etc, though appserver doesn't know what type of database is there well, true like all other tools it uses gnue-common's dbdrivers but what I meant was I thought those issues were dealt with in the dbdrivers underlying assumptions could be made by the dbdrviers where with gnue forms, assumptions could not be made mainly because appserver creates its own tables, but forms could be using existing schemas (I think that's true) ok sow so Action: jcater is asking questions... not providing any help if i would want to implement boolean types in appserver and had to expand the gsd definitions by a "boolean" type would that be ok if i did it? well, you could but before the .gsd is usable in datbaases other than postgres (and a few others) we have to define what a boolean field is that was my only point earlier could it be a meaningful definition that we say boolean fields have to accept at least 0 and 1 as possible values and have to return something among 0/1, TRUE/FALSE, T/F and maybe some others ? and null a boolean should allow t/f/null imho I dunno I avoid booleans for this very reason jamest: yes chillywilly (danielb@CPE-24-167-193-166.wi.rr.com) left irc: "bah" btami (~btami@ngprs.pannongsm.hu) joined #gnuenterprise. hello all reinhard: any special reason you want boolens ? hello btami gnue is sql based, and there is no boolean in sql standard IIRC it's logical to have booleans and from what the postgres manual says, boolean is SQL92 standard hmm, i don' think so I'm glad I'm not the only one :) yes googling for SQL92+boolean it looks that it's not standard however i still think it's logical to support a boolean type it was there for years in appserver's whitepaper and nobody did object :) and as i found out meanwhile it's not really a big task to do it yes, python has it now too... unfortunately we won't be able to use python's boolean as it was introduced with 2.3 AFAIK yes yep bat as jbailey sad, 2.3 is the defult in testing now also true i hope it will be stable soon well there's other points to consider like if all rpc protocol bindings for python will support the boolean type Never anyhow, in gnue-forms boolean is 0/1 when was that decided? at least in CheckboxDisplayHandler that was settable in gnue.conf iirc and never worked for me :) maybe reinhard will fix it... Action: btami hides jamest: you said you use boolean in postgres databases do you use these fields with gnue-forms? CREATE DOMAIN "BOOLEAN" AS SMALLINT DEFAULT 0 CHECK (VALUE IN (0,1)) NOT NULL; sorry, i'm using this domain for checkboxes in firebird it works yeah i think so i got this problem with postgres: UPDATE address_person SET address_human='0' WHERE address_human=1 AND gnue_id='00000000000000000000000000001100' ERROR: Unable to identify an operator '=' for types 'boolean' and 'integer' but that "WHERE address_human=1" is built by gnue-common address_human is a boolean field btw reinhard: yes info_validated | boolean | jamest: can you evaluate what SQL statement forms/common generates when you update a boolean db field? yes, this is the main problem with boolean in sql, it's hard to handle it in where close jamest: does it do "where info_validated=0" or "where info_validated='0'" SELECT maddr_1,shome_phone,sortname,zip,spsalutation,maddr_2,notes,mst,mcity,thank_you_print,info_validated,mspous_id,url,cformal,thank_you_last_printed,sbus_phone,mformal,email,mcountry FROM donor WHERE (((info_validated = '1'))) UPDATE donor SET info_validated='0' WHERE ...... WHERE ? that's what I'm after the WHERE clause of the update info_validated='0' can't post the whole thing as it's donor info :) queryDefault="F"/> and Char:y="12" block="blckdonor" field="ntryinfo_validated" style="checkbox"> this form is ancient pre checkbox support which is why the odd upper scary and as for those field names ToyMan (~stuq@smtp.dstoys.com) left irc: "Client Exiting" hmmm they're not mine, they're from a legacy system from across campus nevermind that predates binary I think :) nevermind? chillywilly (danielb@CPE-24-167-193-166.wi.rr.com) joined #gnuenterprise. is something wack with what I'm posting? you are whack yo i know reinhard: are you interested on postgres only? as I haven't banned you from #gnuenterprise somethings is wrong with me I vote on the users anyone know how to make dpkg-reconfigure xservr-xfree86 freakin write a cvonfig file? first it was saying it ws cusotmized which it was so then I mv it then it says it is missing then I read the FAQ and rm some shit from /var/lib/xfree86 try touching it nope looks for that debconf section it's mental after I did the /var/lib crap then it complains the checksums aren't there I can't win I just want it tp write me a config file damnit hmmm chillywilly: istr reading something about that on #debian-devel. Unfortunately, I don't remember the details. maybe XFree86 -configure will work chillywilly: Do you really want to entrust somethiing as important as your X config to dpkg? btami: of course not dsmith: i do dsmith: I don't care about that as how often do you really change it statement=UPDATE UGYFEL SET munkaugy=0 WHERE egyezteto=1 AND halozat=0 AND irsz='6722' AND letszam=1 AND lemez=0 AND tobbceges=1 AND kernev='Gizike' AND verzio='3.41' AND ellenozes=1 AND varos='gnue.png' AND munkaugy=1 AND dsmith: I can tweak to my liking dsmith: but I don't wanna recreate the file in its entirety but while i don't get it to work with postgres (which i use myself) i don't need to try with other db's chillywilly: apt-get --purge remove xserver-xfree86 then reinstall :) Yep should work. that will lots of shit with it pull not apt-get, just dpkg. dpkg -r ? dpkg -p btami: so you get where clause without '' for booleans? so do dpkg -p? yes i think dpkg will ignore dependent packages ok strange the -p is purge isn't it? rm -rf / You might need a --force- too. that works too Action: reinhard is trying to find out what makes gnue-common add '' in the WHERE clause but it wipe the apt cache so it'll take longer to reinstall X bah complained about checksums reinhard: notice my "booleans" are int in firebird Action: dsmith troutslaps jamest for rm -rf / chillywilly: did you force it? no dpkg -r btami: yes, but from what i can tell gnue-common doesn't even look what data type is set in the db what force option should I use? chillywilly: Gotta --force- too. Action: chillywilly uses --help dpkg --force-help --force-help Action: jamest has a habit of --force-all seems to work the most often dewd finally some of the mozilla mirrors have 1.5 bad habit :) jamest: you use pygresql there? Action: dtm has bittorrent going for firebird --force-help is handy yes --force-depends --force-pampers heh heheh for the younger crowd Action: dsmith struggles to keep quiet reinhard: yes chillywilly: I usually just "XFree86 -config" and touch that up. I think I'll go that route that's what I did for gentoo ;P wow, that failed complains about glide driver not being there or something lame Action: chillywilly installs glide is it correct that fetchmany() is defined by the pygresql lib? wait lupo__ (lupo@pD9E685F4.dip.t-dialin.net) joined #gnuenterprise. hi ho i used to use pygresql now I use psycopg but pygresql did have a fetchmany XFree86 has found a valid card configuration. Unfortunately the appropriate data has not been added to xf86PciInfo.h. BAH i'm pretty sure any dbapi2.0 compliant drive has it oh now you use psycopg now let me check yes fetchmany([size=cursor.arraysize]) from http://www.python.org/peps/pep-0249.html well the question is when there's a boolean column will fetchmany return that as a string or as a number um, hang on Action: chillywilly uses lappy la la la oh i use psycopg, too i've got an app i was working on today that does that hmm, I gotta get X 4.3.x bah for me, fetchmany returns numbers for boolean columns and that's the reason why the WHERE clause bombs t very very strange devel=> \set VERSION = 'PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.95.4' wow i thought I ran 7.3 here Action: jamest is now confused er, i do run 7.3 here sigh i am running 7.3 but my psql is a leftover from 7.2 Action: jamest is suprised it works i seem to recall having the issue you're having yes? Action: reinhard hopes jamest also recalls what he did to resolve it :) i'm trying my brain takes a while to warm up get back to me on monday bbiab uzahs sigh ah crap hang on reinhard plucepluce ? reinhard: that program really was using the old _pg module mouns (mouns@kali.mouns.org) left irc: Remote closed the connection btami (~btami@ngprs.pannongsm.hu) left irc: "night all" interesting 0 hang on, lemme try the form that goes to that talbe SELECT zip4,county,school_id,flag_excludeFromMail,grade_level_lowest,entry_date,ceeb_id,state,phone,grade_level_highest,comments,school_name,flag_excludeFromFax,address2,address1,url,zip,usd,fax,city FROM school WHERE (((flag_excludeFromMail = '1'))) ORDER BY school_name (flag_excludeFromMail = '1') is the boolean yeah select is always ok the update statement bombs it's treated as a string there too AND flag_excludefrommail='0' from the update's where i don't get it when fetchall returns an integer ~bahstats dsmith (~dsmith@mail.actron.com) left irc: "Client exiting" i blame derek hehe GACK! it works for me because my dbsig2 driver isn't the latest in cvs and boolean types aren't defined in there so it defaults to string damnit freakin X no worky sigh cvs won't even run for me chillywilly (danielb@CPE-24-167-193-166.wi.rr.com) left irc: "leaving" wxConfig under Windowns Um slightly annoying that I can make a LocalMachine key File "/home/jamest/cvs/gnue/.cvsdevelbase/gnue/common/apps/GConfig.py", line 33, in ? from gnue import paths ImportError: cannot import name paths part of the new setup thing? jamest: yes, please re-run setup.py err setup-cvs.py jamest: make sure you've cvs up'd all things you use first (like reports, common, etc) as part of the setup-cvs.py logic moved into each individual tool Action: jcater is happy w/that change though :) ah, crap i tried to cheat btw - i like the new cvs split ...until it's time to cvs update? :) ensures I'll never forget my cvs password rock! reinhard: i can now reproduce your error ok already working on fix /msg jamest how do you think we can keep reinhard out of appserver and in common? I take that back.. there may be three wrong window ToyMan (~stuq@user-0cevdks.cable.mindspring.com) joined #gnuenterprise. l8r jamest (~jamest@gw.math.ksu.edu) left irc: "Client exiting" mcuria (~maxy@OL53-216.fibertel.com.ar) left irc: Read error: 60 (Operation timed out) mcuria (~maxy@OL53-216.fibertel.com.ar) joined #gnuenterprise. chillywilly (danielb@CPE-24-167-193-166.wi.rr.com) joined #gnuenterprise. Nick change: wtg`sleep -> wtg chillywilly (danielb@CPE-24-167-193-166.wi.rr.com) left irc: Read error: 54 (Connection reset by peer) chillywilly (danielb@CPE-24-167-193-166.wi.rr.com) joined #gnuenterprise. lupo__ (lupo@pD9E685F4.dip.t-dialin.net) left irc: Remote closed the connection jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) left irc: "Client exiting" mdupont (mdupont@p5080E9BA.dip0.t-ipconnect.de) joined #gnuenterprise. dimas (~dimas@195.218.177.46) got netsplit. reinhard (~reinhard@M1264P004.adsl.highway.telekom.at) got netsplit. jamest (~jamest@adsl-65-64-190-227.dsl.tpkaks.swbell.net) joined #gnuenterprise. reinhard (~reinhard@M1264P004.adsl.highway.telekom.at) got lost in the net-split. dimas (~dimas@195.218.177.46) got lost in the net-split. jcater (~jcater@cpe-066-061-071-147.midsouth.rr.com) joined #gnuenterprise. dimas (~dimas@195.218.177.46) joined #gnuenterprise. Nick change: mdupont -> md-bk-0800CET Action: dcmwai|AWAY is back (gone 07:11:37) Nick change: dcmwai|AWAY -> dcmwai R45 (~r45@cuscon317.tstt.net.tt) left irc: Read error: 110 (Connection timed out) Nick change: SachaAway -> SachaS dcmwai (~dcmwai@219.95.209.1) left irc: "Client exiting" jbailey (~jbailey@CPE0060082df811-CM014260028338.cpe.net.cable.rogers.com) joined #gnuenterprise. thierry (~thierry@musashi.xtensive.com) joined #gnuenterprise. dneighbo (~dneighbo@ip68-109-180-32.ph.ph.cox.net) joined #gnuenterprise. derek (~dneighbo@ip68-109-180-32.ph.ph.cox.net) left irc: Read error: 60 (Operation timed out) Nick change: dneighbo -> derek chillywi1ly (danielb@CPE-24-167-193-166.wi.rr.com) joined #gnuenterprise. ToyMan (~stuq@user-0cevdks.cable.mindspring.com) left irc: Remote closed the connection chillywilly (danielb@CPE-24-167-193-166.wi.rr.com) left irc: "Lost terminal" chillywi1ly (danielb@CPE-24-167-193-166.wi.rr.com) left irc: "Lost terminal" chillywilly (danielb@CPE-24-167-193-166.wi.rr.com) joined #gnuenterprise. jamest (~jamest@adsl-65-64-190-227.dsl.tpkaks.swbell.net) left irc: "Client exiting" dcmwai (~dcmwai@219.95.162.116) joined #gnuenterprise. jbailey (~jbailey@CPE0060082df811-CM014260028338.cpe.net.cable.rogers.com) left irc: Remote closed the connection maxy_ (~maxy@OL53-216.fibertel.com.ar) joined #gnuenterprise. mcuria (~maxy@OL53-216.fibertel.com.ar) left irc: Read error: 110 (Connection timed out) --- Fri Oct 17 2003