- Zope - Zope lists

unknown authentication requuirement
by Bill Anderson 28 Jul '99

28 Jul '99

Ok, after adding this code, my site insists upon authenticating anyone who accesses it. Without it, it works fine. Any ideas? What am I missing?? ----------------------------------------------------------   &nbsp <a href=>  </a>   ---------------------------------------------------------- Bill

1 1

RE: [Zope] ANNOUNCE: Zope site makeover
by Paul Everitt 28 Jul '99

28 Jul '99

Bill wrote: > Well, I happened to be browsing the Zope site when you made the change > :-) > > One click and all was normal, scrolled down, clicked again > and wondered > what happened until I took a third look at the page. Damn that's cool. Versions _rock_. Amos has been rolling in the changes over the course of about a week. > And, IMNSHO, it looks loads better (the larger font is a plus in my > book)! Ahh, an oft-heard complaint to the info email address. Glad it looks good, and any Linux browsers out there, fire when ready if it still looks awful. --Paul

2 1

Fwd: Re: [Zope] Another hang-up...
by Nick Garcia 27 Jul '99

27 Jul '99

Dont'cha just hate it when you click "Reply" instead of "Reply to All?" :P >Date: Tue, 27 Jul 1999 16:10:24 -0700 >To: Donald Holten <donner(a)biophysics.lanl.gov> >From: Nick Garcia <ngarcia(a)codeit.com> >Subject: Re: [Zope] Another hang-up... > >At 04:39 PM 7/27/99 -0600, you wrote: >> It feels like I'm pulling teeth here. Thanks for all the help so far. >>Okay, here's a better picture of my problem: >> I have a property called numtemp (as suggested by Michel), that is an >>int. >> I have the following call to an SQL method: >> >> >> And I have the update_AccessCounter() SQL method: >> update WRTable >> set numruns =  > >This should be: >update WRTable > set numruns =  >> >> It has the argument numtemp. >> >> I have also tried with: >>  >> >> I get the following error: >> Error Type: SyntaxError >> Error Value: unexpected token sequence.near :: ' set numruns ='*' >> >> What am I doing wrong here? Thanks again for all the help! >> Donner >> >>_______________________________________________ >>Zope maillist - Zope(a)zope.org >>http://www.zope.org/mailman/listinfo/zope >> >>(To receive general Zope announcements, see: >>http://www.zope.org/mailman/listinfo/zope-announce >> >>For developer-specific issues, zope-dev(a)zope.org - >>http://www.zope.org/mailman/listinfo/zope-dev ) Nick Garcia | ngarcia(a)codeit.com CodeIt Computing | http://codeit.com

1 0

Another hang-up...
by Donald Holten 27 Jul '99

27 Jul '99

It feels like I'm pulling teeth here. Thanks for all the help so far. Okay, here's a better picture of my problem: I have a property called numtemp (as suggested by Michel), that is an int. I have the following call to an SQL method: And I have the update_AccessCounter() SQL method: update WRTable set numruns =  It has the argument numtemp. I have also tried with:  I get the following error: Error Type: SyntaxError Error Value: unexpected token sequence.near :: ' set numruns ='*' What am I doing wrong here? Thanks again for all the help! Donner

1 0

Confused about new permissions in ZClasses
by Kevin Dangoor 27 Jul '99

27 Jul '99

Hi, I'm working with some ZClasses in 2.0b1 and I am confused about the new permissions setup. Using the clean Data.fs file, I created a new Product. Then I created a ZClass that inherits from Object Manager. If I go into the ZClass and select the "Permissions" tab, and I see a familiar set of permissions listed as "Inherited permissions": Access contents information Change permissions Delete objects FTP access Import/Export objects Manage properties Undo changes View View management screens Then, I click on the Define Permissions tab. If I click the "Access contents information" drop down menu, it looks like everything *except* the inherited permissions is listed. Shouldn't I be able to select the "Access contents information" permission? Also rather interesting is that if I create another ZClass on the Methods tab of the first one (also inheriting from Object Manager), then go into that ZClass, click the Define Permissions tab. Now, I can select "Access contents information" for that permission. But, if I try to actually save the changes, I get an error ("Waaa", in fact:) : Traceback (innermost last): File C:\Program Files\Byproducts\lib\python\ZPublisher\Publish.py, line 256, in publish_module File C:\Program Files\Byproducts\lib\python\ZPublisher\Publish.py, line 161, in publish File C:\Program Files\Byproducts\lib\python\ZPublisher\mapply.py, line 154, in mapply (Object: manage_setPermissionMapping) File C:\Program Files\Byproducts\lib\python\ZPublisher\Publish.py, line 98, in call_object (Object: manage_setPermissionMapping) File C:\Program Files\Byproducts\lib\python\AccessControl\PermissionMapping.py, line 136, in manage_setPermissionMapping (Object: Otherclass) (Info: (['Add Database Methods', 'Add Documents, Images, and Files', 'Add External Methods', 'Add Folders', 'Add MailHost objects', 'Add User Folders', 'Add Versions', 'Add ZCatalogs', 'Add Zope Drafts', 'Approve draft changes', 'Change DTML Documents', 'Change DTML Methods', 'Change Database Methods', 'Change External Methods', 'Change Images and Files', 'Change Versions', 'Change configuration', 'Change proxy roles', 'Delete objects', 'FTP access', 'Join/leave Versions', 'Manage ZCatalog Entries', 'Manage users', 'Save/discard Version changes', 'Search ZCatalog', 'Use Database Methods', 'Use mailhost services', 'View', 'View management screens'], 'Access contents information', 0)) waaa There must be something fundamental I'm missing here... Thanks, Kevin

1 0

RE: [Zope] Database Updating
by Michel Pelletier 27 Jul '99

27 Jul '99

> -----Original Message----- > From: Michel Pelletier [mailto:michel@digicool.com] > Sent: Tuesday, July 27, 1999 4:39 PM > To: 'Donald Holten'; zope(a)zope.org > Subject: RE: [Zope] Database Updating > > > > > > -----Original Message----- > > From: Donald Holten [mailto:donner@biophysics.lanl.gov] > > Sent: Tuesday, July 27, 1999 3:31 PM > > To: zope(a)zope.org > > Subject: [Zope] Database Updating > > > > > > I'm trying to call an SQL method and pass a variable as > > an argument to > > it, to store the variable's value to the database. Here's > > the line I'm using: > >  > > The variable numtemp is who's value I want to store in > > the database (by > > the update_AccessCounter). This gives me an error about bad > > name or something. > > I'm having some system problems right now and can't copy the > > error. Thanks for > > the help! > > Try:  > Ooops. I mean:  However, if 'numtemp' is in your REQUEST, you can just say:  and all will work fine. -Michel > Note that your ZSQL method must be anticipating the 'numtemp' > argument. > > -Michel > > > Donner > > > > _______________________________________________ > > Zope maillist - Zope(a)zope.org > > http://www.zope.org/mailman/listinfo/zope > > > > (To receive general Zope announcements, see: > > http://www.zope.org/mailman/listinfo/zope-announce > > > > For developer-specific issues, zope-dev(a)zope.org - > > http://www.zope.org/mailman/listinfo/zope-dev ) > > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (To receive general Zope announcements, see: > http://www.zope.org/mailman/listinfo/zope-announce > > For developer-specific issues, zope-dev(a)zope.org - > http://www.zope.org/mailman/listinfo/zope-dev ) >

1 0

RE: [Zope] Database Updating
by Michel Pelletier 27 Jul '99

27 Jul '99

> -----Original Message----- > From: Donald Holten [mailto:donner@biophysics.lanl.gov] > Sent: Tuesday, July 27, 1999 3:31 PM > To: zope(a)zope.org > Subject: [Zope] Database Updating > > > I'm trying to call an SQL method and pass a variable as > an argument to > it, to store the variable's value to the database. Here's > the line I'm using: >  > The variable numtemp is who's value I want to store in > the database (by > the update_AccessCounter). This gives me an error about bad > name or something. > I'm having some system problems right now and can't copy the > error. Thanks for > the help! Try:  Note that your ZSQL method must be anticipating the 'numtemp' argument. -Michel > Donner > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (To receive general Zope announcements, see: > http://www.zope.org/mailman/listinfo/zope-announce > > For developer-specific issues, zope-dev(a)zope.org - > http://www.zope.org/mailman/listinfo/zope-dev ) >

1 0

Database Updating
by Donald Holten 27 Jul '99

27 Jul '99

I'm trying to call an SQL method and pass a variable as an argument to it, to store the variable's value to the database. Here's the line I'm using:  The variable numtemp is who's value I want to store in the database (by the update_AccessCounter). This gives me an error about bad name or something. I'm having some system problems right now and can't copy the error. Thanks for the help! Donner

2 1

RE: [Zope] ZPygreSQL woes
by nathan frund 27 Jul '99

27 Jul '99

Using PyGreSQL 2.4 did the trick. If anyone else has the same problems here's what I did: Of course I downloaded PyGreSQL 2.4 and unarchived it. I copied the contents on top of the DA that bombed out- to $Zope (Where ever you installed Zope)/lib/python/Products/PyGreSQLDA/src Re-ran make. Restarted Zope. Everything worked! Thanks for everyone's help. ---TFE MMS JARVIS JOHN <jarvis.sd082(a)ex.tel.co.jp> wrote: > > I found that getresult in pg.py was dumping core. > It turns out that this is a known bug. > > According to http://www.druid.net/pygresql/ , it > has been fixed in PyGreSQL version 2.4 > > The version that came with the DA is 2.3. > -- > > John Jarvis > > > -----Original Message----- > > From: TFE MMS JARVIS JOHN [SMTP:jarvis.sd082@ex.tel.co.jp] > > Sent: Tuesday, July 27, 1999 10:56 AM > > To: nathan frund; zope(a)zope.org > > Subject: RE: [Zope] ZPygreSQL woes > > > > oh... > > This query outright crashes Zope on my system! > > > <SNIP> > > -- > > John Jarvis > > > > > -----Original Message----- > > > From: nathan frund [SMTP:ndf@rocketmail.com] > > > Sent: Tuesday, July 27, 1999 2:04 AM > > > To: Hannu Krosing > > > Cc: zope(a)zope.org > > > Subject: Re: [Zope] ZPygreSQL woes > > > > > > > > > ---Hannu Krosing <hannu(a)trust.ee> wrote: > > > > > > > > ndf(a)rocketmail.com wrote: > > > > > > > > > > I've run into a problem with Zope with > > > PostgreSQL. The query runs and > > > > > runs and runs till all the memory on the server > > > is used up and Zope > > > > > falls over. > > > > > > > > I'm using it all the time with no major problems. > > > > > > > > Do the same queries run fine from psql ? > > > > > > > > > > > > Yea, even from from 'regular old Python' and with > > > PGaccess. > > > > > > Here is the SQL that I used to create the table. > > > ------------------------------- > > > items.sql > > > ------------------------------- > > > CREATE TABLE items ( > > > prodname char(20), > > > retailPrice money, > > > description char(80), > > > prodVis char(80), > > > IMpartNumber char(20), > > > size float4, > > > speed float4, > > > color char(8), > > > weight int8, > > > height int8, > > > width int8, > > > onhand int8, > > > reorder int8, > > > discontinued boolean, > > > supplier char(20), > > > supplierPartNumber char(20), > > > manufacturer char(16), > > > cost money > > > ); > > > > > > > > > copy items from stdin using delimiters ','; > > > "15"" 5VX 28mm",0,0,0,0,0,0,0,0,0,0,0,0,0,0,9004520,0,200 > > > "17"" 7SP .28mm 1280x1024(1yrs > > warr)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,9004190, > > > 0,250 > > > "17"" 70+ .28mm 1280x1024",0,0,0,0,0,0,0,0,0,0,0,0,0,0,9004120,0,300 > > > ----------------------------------------------------- > > > > > > psql database < items.sql > > > > > > > > > > > > Python code that works. > > > ------------------------------------------ > > > > > > from pg import * > > > > > > cnx=connect('database','localhost',5432) > > > > > > query=cnx.query('select * from items') > > > print "\n" > > > > > > fields=query.listfields() > > > print fields > > > > > > ------------------------------------------ > > > > > > > > > > Schemas, row counts, queries executed ? > > > > > > > > > The query with Zope is the same exact query with the > > > python... "Select * from items" > > > > > > > > > It stops even with only three rows in the database. > > > The SQL above for me stops Zope and Postgres in their > > > tracks. > > > > > > > > > > Also OS, postgres and ZPygreSQLDA versions. > > > > > > > > > I'm running Red Hat Linux 5.2 with kernel 2.2.9 > > > Python 1.5.2 from Oliver Andrich's site. > > > Postgres is version 6.4.2-5. > > > ZPyGreSQLDA version is 0.3. > > > Zope 2.0.0b1 and Zope 1.10.3 > > > > > > I also have python-PyGreSQL-2.3.2.rpm installed. I > > > got it from rufus.w3.org. I removed it thinking that > > > it conflicted or caused the problem. But removing it > > > didn't seem to help so I reinstalled the package. > > > > > > > > > I haven't tried yet but I'm going to write an > > > external method and see if that works. > > > > > > > > > I've put up a lot of info, thanks for your help. > > > _________________________________________________________ > > > DO YOU YAHOO!? > > > Get your free @yahoo.com address at http://mail.yahoo.com > > > > > > > > > _______________________________________________ > > > Zope maillist - Zope(a)zope.org > > > http://www.zope.org/mailman/listinfo/zope > > > > > > (To receive general Zope announcements, see: > > > http://www.zope.org/mailman/listinfo/zope-announce > > > > > > For developer-specific issues, zope-dev(a)zope.org - > > > http://www.zope.org/mailman/listinfo/zope-dev ) > > > > _______________________________________________ > > Zope maillist - Zope(a)zope.org > > http://www.zope.org/mailman/listinfo/zope > > > > (To receive general Zope announcements, see: > > http://www.zope.org/mailman/listinfo/zope-announce > > > > For developer-specific issues, zope-dev(a)zope.org - > > http://www.zope.org/mailman/listinfo/zope-dev ) > _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com

1 0

RE: [Zope] ODBC and Inserting not committed
by Rob Page 27 Jul '99

27 Jul '99

I suspect that this is related to the fact that the DA has not been intergrated with the New and Improved transaction control machinery for ZODB3. I've asked the question internally -- hopefully we'll have a response (note I didn't say solution!) later today... --Rob > -----Original Message----- > From: Graham Chiu [mailto:anon_emouse@hotmail.com] > Sent: Tuesday, July 27, 1999 6:31 AM > To: zope(a)zope.org > Subject: Re: [Zope] ODBC and Inserting not committed > > > In article <58M3aDAI0Wn3Ew48(a)compkarori.co.nz>, Graham Chiu > <anon_emouse(a)hotmail.com> writes > >>Try running Zope in single thread mode ('-t 1' on the z2.py command > >>line) and see if the problem persists. If so, then the > ODBC driver will > >>probably need to be 'thunked' which is a pretty trivial 10 > minute change > >>to the code. > > > >I ran it in single thread mode, and the problem has gone > away. Actually > >I just found that updates also did not commit before. Now > both commit. > > Oops, spoke too soon. Changes are now saved between browser sessions, > but are discarded once Zope2b1 is closed down. > > ------- > Regards, Graham Chiu > gchiu<at>compkarori.co.nz > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (To receive general Zope announcements, see: > http://www.zope.org/mailman/listinfo/zope-announce > > For developer-specific issues, zope-dev(a)zope.org - > http://www.zope.org/mailman/listinfo/zope-dev ) >

2 1