[Zope] SQL-Session 3.0 -- session won't be writen to database
Hi, I'm playing around with SQLSession-3.0 When I do something like the following: dtml-call Session dtml-call "SESSION.set('foo','bar')" dtml-var "SESSION['foo']" my session variable "foo" renders as I expected. But when I move to another page my session-variable "foo" is not available. Creating a session works perfect and the next page remembers about the created session and gives me the correct name, but no session-variables. I checked the database and there werde no entries in my session-data table. Am I missing something like dtml-call "SESSION.nowWriteItIntoTheDatabase()" or what? Andy Pahne [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] ZClass and Propertysheets
Hi, I have created a ZClass with a propertysheet called "Basic". I added a property "db_id", integer value with a default value of 0. Then I created two instances and changed the value to 1 in the first and 2 in the second instance. When I try to render the property with a dtml-var db_id I get a 1 in both instances. That's not what I expected in the beginning. In particular not because there doesn't seen to be anything wrong when I have a look at the property sheet in the instance's management screen. I have different values there. Am I wrong or is there something wrong with Zope 2.2.1 and ZClasses? Andy Pahne [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] search on www.zope.org
Can anybody please tell me the search on www.zope.org does not find any pages containing? - mod_pcgi2 In fact there are numerous pages including this term. Andy Pahne [EMAIL PROTECTED] net22 GmbH Bad Meinberger Strasse 1 32760 Detmold Tel.: 05231 - 580 640 ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] monitoring the zope-process with daemontools
hi, not really a zope-problem, but maybe someone can help me: I have posted a few days ago that I have problems with my zope dying suddenly. Someone suggested to use D. Bernsteins daemon-tools, not as a solution to my problem, but helpful anyway. I made this tool working on my production system, but there's one problem with it: as long as I start it by hand with the command svscan /service everything works fine. But when I start it automatically at boot time (through an entry in rc.local) then Zope starts up as I wanted it to do, it gets monitored and restarted again in case of a sudden death, but my DCOracle Database Connection tells me "not connected" and when I try to open it, Zope dies. I have trouble connecting to Oracle since month now, it never works as I expect. Is there anybody out there having no problems with Zope and Oracle databases? I'd really like to know that. Yours, Andy Pahne [EMAIL PROTECTED] net22 GmbH Bad Meinberger Strasse 1 32760 Detmold Tel.: 05231 - 580 640 ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] zope 2.2.0 simply dies
I have a Zope-2.2.0 installation running on a Redhat 6.0 Linux Box. It simply dies sometimes. Three times in the last 72 hours?!? There's only DCOracle and ZOracleDA installed, nothing more. I cannot see any other problems on the machine and it does not have that much load. Is there a solution? Has anybody had the same problem? Andy Pahne [EMAIL PROTECTED] net22 GmbH Bad Meinberger Strasse 1 32760 Detmold Tel.: 05231 - 580 640 ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] 2.2 installation problem on Linux
not for me. everything worked fine on my redhat 6.0 box. first I thought upgrading would be a nightmare but after all it took me 10 minutes and all my sites are up and running smoothly :-) andy Hi, this seams to be a bugglet in the final distribution, the pcgi_wrapper is not build by the install script. This worked in beta 4. You can fix it by running it manally in the pcgi-directory like: cd pcgi sh configure make On Sat, 15 Jul 2000, Ragnar Beer wrote: Howdy! Zope 2.2 (linux2) installs and works fine using ZServer but for whatever reason there is no pcgi-wrapper built in the pcgi dir so that I cannot call Zope.cgi. I checked again and again but ./install doesn't give an error message. What am I doing wrong? --Ragnar ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] oracle8 and cursors
hi, there, i've been using oracle8 with zope succesfully for a while. now my database programmer came up with a solution for a certain problem, which "we cannot solve with an easy select statement". he told me, that we are gonna have to use db-cursors instead. i must admit that i have heard the therm cursor before, but i am not sure how to use them with zsql-methods. my question is fairly simple: is there any difference in handling cursors with zsql-methods in comparison to handling 'simple' select-statements? can i use dtml-in "..."/dtml-in to iterate over the result sets? I read DCOracle.txt which comes along with DCOracle-Product, but I do not understand it very well. Any recommended readings? Andy Pahne ap@net22 net22 GmbH Bad Meinberger Strasse 1 32760 Detmold Tel.: 05231 - 580 640 ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] another nice error-message
humor I replaced the standard_error_message whth dtml-fortune. Now I'm havin much fun everytime some obscure error occurs. I highly recommend, you developers do the same, not only for you but for your visitors as well /humor Andy Pahne ap@net22 net22 GmbH Bad Meinberger Strasse 1 32760 Detmold Tel.: 05231 - 580 640 ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] SQL-Query works with MySQL-monitor but not with ZMySQLDA
Hi, there, if I use my mysq-monitor to execute the following query, everything works fine: SELECT YEAR(START_DATE) FROM EVENT; but it doesn't work via the ZMySQLDA!?! Here's the traceback: Error, exceptions.KeyError: unhandled Traceback (innermost last): File /zope/ttl/Zope-2.0.1-src/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /zope/ttl/Zope-2.0.1-src/lib/python/ZPublisher/Publish.py, line 179, in publish File /zope/ttl/Zope-2.0.1-src/lib/python/Zope/__init__.py, line 201, in zpublisher_exception_hook (Object: sql_get_years_unique) File /zope/ttl/Zope-2.0.1-src/lib/python/ZPublisher/Publish.py, line 165, in publish File /zope/ttl/Zope-2.0.1-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_test) File /zope/ttl/Zope-2.0.1-src/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: manage_test) File /zope/ttl/Zope-2.0.1-src/lib/python/Shared/DC/ZRDB/DA.py, line 316, in manage_test (Object: sql_get_years_unique) File /zope/ttl/Zope-2.0.1-src/lib/python/Shared/DC/ZRDB/DA.py, line 297, in manage_test (Object: sql_get_years_unique) File /zope/ttl/Zope-2.0.1-src/lib/python/Shared/DC/ZRDB/DA.py, line 401, in __call__ (Object: sql_get_years_unique) File /zope/ttl/Zope-2.0.1-src/lib/python/Products/ZMySQLDA/db.py, line 191, in query KeyError: (see above) Andy Pahne ap@net22 net22 GmbH Bad Meinberger Strasse 1 32760 Detmold Tel.: 05231 - 580 640 ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] newbie question: parameter passing for ZSQL Object
It's pretty easy: dtml-call "sql_method(argument1=value1, argument2=value2)" There's a problem with your SQL-statement: INSERT INTO plan (field1, field2, field3, field4) VALUES (dtml-var param1, dtml-var param2, dtml-var param3, dtml-var param4) It should be: INSERT INTO plan (field1, field2, field3, field4) VALUES (dtml-sqlvar param1 type=string, dtml-sqlvar param2 type=string, dtml-sqlvar param3 type=string, dtml-sqlvar param4 type=string) Andyman ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )