- Zope - Zope lists

RE: [Zope] Newbie SQL problem: Query Error: Cannot render query t emplate
by Farrell, Troy 01 Sep '00

01 Sep '00

When I try to test my connection (http://jester/profiles/Jet_database_connection/manage_test) SQL is as follows: INSERT INTO test VALUES ( 'line one', 123456) I get an error with the following traceback: Error Type: Query Error Error Value: Invalid Operation Traceback (innermost last): File C:\PROGRA~1\JESTER\lib\python\ZPublisher\Publish.py, line 222, in publish_module File C:\PROGRA~1\JESTER\lib\python\ZPublisher\Publish.py, line 187, in publish File C:\PROGRA~1\JESTER\lib\python\Zope\__init__.py, line 221, in zpublisher_exception_hook (Object: RoleManager) File C:\PROGRA~1\JESTER\lib\python\ZPublisher\Publish.py, line 171, in publish File C:\PROGRA~1\JESTER\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: manage_test) File C:\PROGRA~1\JESTER\lib\python\ZPublisher\Publish.py, line 112, in call_object (Object: manage_test) File C:\PROGRA~1\JESTER\lib\python\Shared\DC\ZRDB\Connection.py, line 180, in manage_test (Object: RoleManager) File C:\PROGRA~1\JESTER\lib\python\Products\ZJetDA\db.py, line 130, in query Query Error: (see above) Testing my SQL inside Access yields expected results. The SQL is fine. If a user tries to access a dtml_document that trys to modify the database, they get the same error. I'm thinking that Zope 2.2.0 and 2.2.1 have some big problems with DA's under Windoze. Unfortunately, my app _MUST_ use Access. I'm not thrilled. Can anyone more familiar with Python clue me in on this? Troy Farrell -----Original Message----- From: Philipp Auersperg [mailto:zope@philosoft.at] Sent: Thursday, August 31, 2000 10:14 AM To: zope(a)zope.org; Stephen Nosal Subject: Re: [Zope] Newbie SQL problem: Query Error: Cannot render query template When starting Zope as a service under Win NT always make sure that the ODBC data sources you use are *system* data sources and not *user* data sources. This could explain why your ODBC connections work when you start Zope from the console and don't work when starting it as service. Anyhow: Zope 2.1.6 is not the best for SQL (problems with recordsets show up when used in <dtml-tree>) Zope 2.2.0 has problems with ZODBC under Windows 2000 (Authorisation dialogs pop up). My hint: Use 2.1.4 or 2.2.1 (does it fine with SQL under Linux and Windows ) phil *********** REPLY SEPARATOR *********** On 31.08.2000 at 06:40 Stephen Nosal wrote: >Troy- > >Have you tried running this from the DOS prompt? I ran into all sorts of problems running 2.1.6 on NT4WS with the ODBCDA. Everything was fine when I used the start and stop scripts from the command line. When I moved to starting zope as a service, my ODBC connections kept failing. Never did find an NT solution, I just moved everything to Linux. > >It's worth a try. > >- Steve > >On Wed, 30 August 2000, "Farrell, Troy" wrote: > >> >> Hello. >> >> I am running Zope as a service on NT4WS. I have multiple MS Access >> databases connected to different ZJetDAs and I am not able to modify the >> data in them with SQL statements. For example, INSERT INTO test VALUES >> (<dtml-sqlvar value_one type=string>, <dtml-sqlvar value_two type=int>) >> returns the error "Query Error: Cannot render query template". Can you tell >> me what the cause is. I think it might be a permissions problem, but I have >> everything wide open and I can't figure it out. >> >> Thanks. >> Troy Farrell >> >> Troy Farrell >> Video Operations Technician II >> Williams VYVX Services >> 918.573.3029 >> 918.573.1441 fax >> mailto:troy.farrell@wilcom.com >> http://www.williams.com

1 0

Getting Zope running on IIS or Apache using PCGI....
by Chris Withers 01 Sep '00

01 Sep '00

Tina Sawyer wrote: > Problem is : I was running Zope on Win 2000 Platform with IIS 5.0 > I could not get zope to run as a pcgi. So.. I set up a Linux server using > Redhat version 6.2, running apache and I still cannot get zope to run as a > pcgi. Any thoughts on this? Might be best to ask on the zope(a)zope.org list instead of the PTK one (I've copeid the message there) You could also do with describing, in detail, what the problem you encoutnered were. Error messages and the like are always helpful, cheers, Chris

1 0

ZPatterns Stability
by Chris Withers 01 Sep '00

01 Sep '00

Tim Cook wrote: > > If you're brave you could try ZPatterns and then realyl not care at all > > ;-) > > > > > Don't you mean; 'If you're insane...' ? No, I really don't! ZPatterns is very cool, but still not documented. It's alpha but seems stable enough for production in a lot of cases. Phil? Steve A? backup? ;-) cheers, Chris

2 1

Re: [Zope] _setObject error - urgent!
by Andy McKay 01 Sep '00

01 Sep '00

Yeah I know, I apologise I was just panicking with a deadline approaching. Sorry. ----- Original Message ----- From: "Chris Withers" <chrisw(a)nipltd.com> To: "Andy McKay" <andym(a)activestate.com> Sent: Friday, September 01, 2000 2:26 AM Subject: Re: [Zope] _setObject error - urgent! > Andy McKay wrote: > > I think I have traced my error with cut and paste, I am getting an error on > > _setObject. If the object is not registered with Zope properly this will be > > a problem. Basic synopsis: > > Well, what you're doing is kindof weird... > > sounds like something for the zope-dev guys. My only comment would be: > > > ** No cross posts or HTML encoding! ** > > I know it's urgent (although putting that in the subject line will lower > it in a lot of people's priorities ;-) but things generally belong in > one list or another... > > Sorry for seeming like a 'list nanny' but it degrades the identity and > the quality of the lists if there are too many cross-posts... > > cheers, > > Chris >

1 1

Re: HappySession
by Hung Jung Lu 01 Sep '00

01 Sep '00

>(Hmmm... multiple SESSION objects... in typical situations usually one >single SESSION object should be enough. Notice that two SESSION objects >mean two separate storage. Although HappySession is designed to handle >multiple SESSION objects sharing the same key cookie, the expiration time >might be a tricky issue... I do not recommend multiple SESSION objects.) Argh, I take back what I said. As long as your SESSION objects have different cookie names, it should be OK to have multiple SESSION objects. They will operate independently. It's OK to have multiple SESSION objects. (They expire independently, too.) regards, Hung Jung _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.

1 0

RE: [Zope] manage
by neeloy_saha 01 Sep '00

01 Sep '00

Hi dieter, Thx for ur reply. The child window pop ups when u do http://localhost:8080/manage . One enters the username and password there. That is validated against the acl_user folders member names or if it is a superuser who installed zope it validates it against the access file. I want to look at the source code and understand the authentication mechanism.That's why i want to know the following:- 1.what is the python file which pops up that child window for entering username and password ? 2.After u give the username and password what is the file / module name against which the username and password is authenticated. 3.what is this 'manage'....? method/module??? Thx in advance -neeloy -----Original Message----- From: Dieter Maurer [mailto:dieter@handshake.de] Sent: Friday, September 01, 2000 1:34 AM To: neeloy_saha Cc: 'zope(a)zope.org' Subject: Re: [Zope] manage neeloy_saha writes: > when i do http://localhost:8080/manage it pops up a login window which asks > for username and password. what is the entry point after that?? That is exactly what one would expect. Enter the username and password that was assigned during installation or that you set with python zpasswd.py access > Is there a way of running zope with debugger?? There is "Test.py" in "lib/python/ZPublisher". It will, however, not help you with the above problem. Dieter

2 1

zope.org
by Bak ＠ kedai 01 Sep '00

01 Sep '00

what's happenng to zope.org? i got this message when i tried accessing it

2 1

Re: [Zope] Re: ZOPE Python edit debug cycle
by Karl Anderson 01 Sep '00

01 Sep '00

"Chui Tey" <teyc(a)bigfoot.com> writes: [quoting someone] > > Then I tried to edit a py file and see the new output. I had to use > > this sequence to see my tiny change: > > > > make the change > > save the change > > Stop the ZOPE service > > Start the ZOPE service > > Refresh the ZOPE Web page > > Inspect the change. > > > > If I had a syntax error, ZOPE throws it away and I never get to read > > it. You can see the error if you try to access the broken product definition in the control panel. I keep a link to the product and the restart button handy to reduce the pain. -- Karl Anderson karl(a)digicool.com

3 2

Re: [Zope] Success in installing ZPoPyDA (after 3 months...)
by Hung Jung Lu 01 Sep '00

01 Sep '00

>From: "Bak @ kedai" <kedai(a)kedai.com.my> >where did you find linux.h that's needed by PoPy? thtt stump me from >continuing. Download postgresql-7.0.2 source (not the RedHat's RPM), unzip and untar it, and the file is located at: postgresql-7.0.2/src/include/port/linux.h What I did was: (1) copy this file into your /usr/include/pgsql (2) delete /usr/include/pgsql/os.h (which is merely a link, not an actual file) (3) rename /usr/include/pgsql/linux.h to /usr/include/pgsql/os.h Oh, I also had to tweak some of the Makefiles at some point, so the include directory becomes pgsql instead of postgresql. regards, Hung Jung _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.

1 0

Re: HappySession
by Hung Jung Lu 01 Sep '00

01 Sep '00

>From: Diego Rodrigo Neufert <diego(a)magicwebdesign.com.br> >... >too... well, in the standard html header I call call a method that do a >call in >all my sessions.... Okie, now I see why you get the Transaction error problem. After an exception is raised, Zope aborts the http request transaction, and any attempt to further use Zope objects that are transaction-aware will cause an error. In the next release of HappySession I will try to detect whether the transaction has ended, and return some meaningless result like None. But the real thing is, after the exception happens, SESSION object should not be called again. If you really need to call SESSION in your standard_html_header, then please do two things: (1) Please use a standard_error_message, and it should start with something like: <dtml-if "not error_message and error_type == 'SessionNotFoundError'"> <dtml-return session_not_found_html> </dtml-if>     .... (2) In your session_not_found_html, please do NOT use <dtml-var standard_html_header>. Instead, write another DTML and call it session_ended_html_header, and use it instead. Inside your session_ended_html_header, please do NOT call the SESSION object. >I have two SESSION objects, one in the root of zope and >other in the opt folder of zope.... look how I call the SESSIONS.... >in standard_html_header ><dtml-call callSession> > >The callSession method: ><dtml-call SESSION> ><dtml-call opt.SESSION> (Hmmm... multiple SESSION objects... in typical situations usually one single SESSION object should be enough. Notice that two SESSION objects mean two separate storage. Although HappySession is designed to handle multiple SESSION objects sharing the same key cookie, the expiration time might be a tricky issue... I do not recommend multiple SESSION objects.) The thing I don't understand is why you need to make explicit call to the SESSION objects. Ohh...! I see, you probably think that SESSION objects need to be initialized? OK, unlike FSSession or SQLSession, HappySession's SESSION objects do NOT need to be initialized! You don't need to make an explicit call to SESSION in your standard_html_header. HappySession is smart enough to initialize itself whenever you touch it the first time using any of its methods. No explicit initialization call needed. (I'll add an observation on this in the help file in the future.) --------------------- In short, I think that by simply removing your callSession method and its reference in standard_html_header, you will be fine and happy! :) regards, Hung Jung _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.

1 0