March 2001 - Zope - Zope lists

ETA on Zope 2.3.1 (stable i.e.non beta)?
by Daniel Rusch 14 Mar '01

14 Mar '01

Is there an ETA on Zope 2.3.1 (stable i.e.non beta)? Thanks, Dan

4 4

newbie
by Dennis Pabalan 14 Mar '01

14 Mar '01

Hi to all!!! I am a zope newbie and I just installed zope and zope-server package on my linux box. I could not logged on to mydomain:8080. I used superuser and a 123 password, how will i solve the problem? Thanks in advance :) Demic -- .--. Demic Pabalan mobile://+63.917.345.1692 ( () ) Q Linux Solutions, Inc. office://+63.2.894.3592/ `--\\ A Philippine Open Source Solutions Co. http://www.q-linux.com/

1 0

Re: [Zope] ZSQL method LAST_INSERT_ID() error
by paul_s_johnson＠urscorp.com 14 Mar '01

14 Mar '01

Thanks for the all tips; it's getting me down the right road. I also learned I need to include my LAST_INSERT_ID in the same ZSQL method as my INSERT statement and join them together with a <dtml-var sql_delimiter> inside the method. That said, it's still not working. Here's what's returned when I test my method: There was no data matching this sql_add_deliverable query. SQL used: INSERT INTO Deliverables ( DeliverableID, ProjectID, DeliverableTypeID, UserID, Abstract, DateEntered, CategoryRequest) VALUES ( NULL, 1, 2, 3, 'some text blah blah', NOW(), '5') ------------------------------------------------------------ SELECT LAST_INSERT_ID() AS TheLastID The INSERT part of the above works and inserts the data into the table. The DeliverableID field of the Deliverables table is really an AUTO_INCREMENT field. I tested the above at the MySQL command line and the LAST_INSERT_ID () function returns the correct ID. Why is no data returned? I should be getting the last ID and I'm getting nothing. Help! P. Johnson http://www.zope.org/Members/adustman/Tips/no_limits On Tue, 13 Mar 2001 paul_s_johnson(a)urscorp.com wrote: > This ZSQL query: > > SELECT LAST_INSERT_ID() AS ID > > Is returning this error: > > Error, _mysql.OperationalError: (1064, "You have an error in your SQL > syntax near 'LIMIT 1000' at line 1") > > It apparently automatically adds a LIMIT clause to the end of my SQL query > that MySQL does not like in this context. Is there any way to shut the > limit clause off? Anybody have any ideas for a workaround? -- Andy Dustman PGP: 0xC72F3F1D @ .net http://dustman.net/andy "Normally with carbonara you use eggs, but I used lobster brains instead." -- Masahiko Kobe (Iron Chef Italian): 30-year-old Giant Lobster Battle

2 1

Items disappear from Catalog when updated
by Joel Burton 14 Mar '01

14 Mar '01

I have a ZClass (JBook) which is CatalogAware as its first class inheritance. When JBooks are added, they are added to the Catalog (default name, root level). However, if I request an update, the books are removed. Only the documents that were present when I did the last manual 'Find Objects' are kept. Can anyone shed any light on this? Many thanks, -- Joel Burton <jburton(a)scw.org> Director of Information Systems, Support Center of Washington

1 0

ZClass property sheets and permissions
by John Morton 14 Mar '01

14 Mar '01

I'm working on a simple TODO list ZClass product which has a pair of property sheets, Basic and Complete, which cover the standard properties and the properties relating to when the item is completed. I'd like to bind the management of each sheet to a particular permission - 'Change TODO item properties' and 'Mark TODO Item As Complete'. So I've created those two permissions at the product level (as it appears you can't create them in the ZClass itself). When it comes to binding a particular property sheet's 'Manage Properties' permission to one of these permissions, they don't appear on the list of possibilities, yet the Add permission for the ZClass does appear. Does anyone know how I can solve this problem? John

1 0

Xron problems
by Chris Muldrow 14 Mar '01

14 Mar '01

I'm getting the following errors when I try to run a Xron as scheduled task. I can trigger the Xron method manually and it will work. The method is at the bottom of this message. Any ideas what is happening? Thanks-- Chris ------ 2001-03-13T19:11:49 ERROR(200) ZODB Couldn't load state for '\000\000\000\000\000\012\220r' Traceback (innermost last): File F:\CONNEC~1\lib\python\ZODB\Connection.py, line 490, in setstate ConflictError: êr ------ 2001-03-13T19:11:49 (302) Products.Xron.Loggerr Cannot access catalog. Suspending operation. Traceback (innermost last): File "F:\CONNEC~1\lib\python\Products\Xron\Dispatcher.py", line 123, in Timer (atime, aurl)=Schedule.armed_event() # Get next armed event File "F:\CONNEC~1\lib\python\Products\Xron\Schedule.py", line 215, in armed_event for event in self._catalog.searchResults( File "F:\CONNEC~1\lib\python\ZODB\Connection.py", line 490, in setstate if invalid(oid) or invalid(None): raise ConflictError, oid ConflictError: êr Traceback (innermost last): File F:\CONNEC~1\lib\python\Products\Xron\Dispatcher.py, line 123, in Timer File F:\CONNEC~1\lib\python\Products\Xron\Schedule.py, line 215, in armed_event (Object: Traversable) File F:\CONNEC~1\lib\python\ZODB\Connection.py, line 490, in setstate ConflictError: êr ------ 2001-03-13T19:11:49 PROBLEM(100) Products.Xron.Loggerr Dispatcher thread is terminating. Content-type: text/plain <dtml-try> <dtml-let thisyear="_.str(ZopeTime().year())" thismonth="ZopeTime().mm()" thisday="ZopeTime().dd()"> <dtml-with Test> <dtml-in expr="objectIds('Folder')"> <dtml-var sequence-item> is item </dtml-in> <dtml-comment>See if the folder for the year exists. If not, make it</dtml-comment> <dtml-if expr="thisyear not in objectIds('Folder')"> Can't find <dtml-var thisyear><br> <dtml-try> <dtml-call expr="manage_addFolder(thisyear, thisyear)"> <dtml-except> Can't add year </dtml-try> <dtml-else> Year exists </dtml-if> <dtml-with expr="_.getitem(thisyear)"> <dtml-if expr="thismonth+thisyear not in objectIds('Folder')"> Can't find <dtml-var "thismonth+thisyear"><br> <dtml-try> <dtml-call expr="manage_addFolder(thismonth+thisyear, thismonth+thisyear)"> <dtml-except> Can't add monthyear </dtml-try> <dtml-else> Month exists </dtml-if> <dtml-with expr="_.getitem(thismonth+thisyear)"> <dtml-if expr="thismonth+thisday+thisyear not in objectIds('Folder')"> Can't find <dtml-var "thismonth+thisday+thisyear"><br> <dtml-try> <dtml-call expr="manage_addFolder(thismonth+thisday+thisyear, thismonth+thisday+thisyear)"> <dtml-except> Can't add monthdayyear </dtml-try> <dtml-else> Day exists </dtml-if> </dtml-with> </dtml-with> </dtml-with> </dtml-let> <dtml-except> Can't add folder </dtml-try>

2 2

CGI Question
by Network Administrator 14 Mar '01

14 Mar '01

Hi, I checked the how to, and maybe I just making this harder than it is, but how do I run a simple cgi script from Zope without using Apache? Thanks ahead of time for any help, Luis.

6 7

Namespace confusion
by Joel Burton 14 Mar '01

14 Mar '01

I have a ZClass _add method (for JBook), which adds an instance of the class. This instance should automatically have an instance of another class (JDiscussFolder) added as a child. I am handling this as <dtml-with "JBook.createInObjectManager(REQUEST['title'], REQUEST)"> <dtml-call "propertysheets.common.manage_editProperties(REQUEST)"> <adtml-call "REQUEST.set('id', 'discuss')"> <adtml-call "REQUEST.set('title', 'Discussion Area')"> <dtml-with "manage_addProduct['JDiscuss']"> <dtml-call "JDiscuss_Folder_add( _.None, _)"> </dtml-with> </dtml-with> which adds the JBook (using the form-derived title as the id), and adds the properties filled out on the add form. It also adds the JDiscussItem, where I want to set the id and title to something else. I've done this by REQUEST.set, which works fine. The problem is that it overwrites the current values of title and id, so I can refer later to the book title and id. I've tried to do this like wrap the JDiscuss_add in <dtml-let> or <dtml-with> bands to supply a namespace for the title and id, but haven't been successful. For example, I thought that <dtml-with " { 'id': 'discuss', 'title': 'Discussion area' }" mapping> .. call to add the discuss folder </dtml> would work, but it doesn't. (No error, just doesn't use the new id or title.) How can I pass in these variables w/o resorting to the overwriting REQUEST.set calls? Thanks! -- Joel Burton <jburton(a)scw.org> Director of Information Systems, Support Center of Washington

1 0

RE:Manage
by Daniel Rusch 13 Mar '01

13 Mar '01

Yes it is in the acquistion path, it is a root level property! I know that is what the problem appears to be, but how can changing a password cause it not to find a root level password??????? Your problem is that it cant find BoxName, is that visible in the Acquistion? -- Andy McKay. ----- Original Message ----- From: "Daniel Rusch" <drusch(a)globalcrossing.com> To: <zope(a)zope.org> Sent: Monday, March 12, 2001 3:28 PM Subject: [Zope] Manage > All, > > Zope 2.3.0 (binary release, python 1.5.2, solaris-2.6-sparc) > Python Version 1.5.2 (#8, Nov 16 1999, 10:05:41) [GCC 2.8.1] > System Platform sunos5 > > We have a page that allows users to change their password it executes > the following: > > > <dtml-call "REQUEST.set('name', login_name)"> > <dtml-call "REQUEST.set('password', password)"> > <dtml-call "REQUEST.set('confirm', confirm)"> > <dtml-call "REQUEST.set('roles', > acl_users.getUser(login_name).getRoles())"> > <dtml-call "acl_users.manage_users(submit='Change', REQUEST=REQUEST)"> > > > The password is changed and the user is taken to a page that notifies > them that their password was changed, but when the user tries to > navigate to any page instead of getting an Authentication dialog, they > get a NameError for a variable that is (or should be) there. > > It is as if the Name Space is lost? Any thoughts? > > Dan > > > Zope Error > > Zope has encountered an error while publishing this resource. > > NameError > > Sorry, a Zope error occurred. > > Traceback (innermost last): > File /home/newZope/lib/python/ZPublisher/Publish.py, line > 222, in publish_module > File /home/newZope/lib/python/ZPublisher/Publish.py, line > 187, in publish > File /home/newZope/lib/python/Zope/__init__.py, line 221, in > zpublisher_exception_hook > (Object: Traversable) > File /home/newZope/lib/python/ZPublisher/Publish.py, line > 171, in publish > File /home/newZope/lib/python/ZPublisher/mapply.py, line > 160, in mapply > (Object: index_html) > File /home/newZope/lib/python/ZPublisher/Publish.py, line > 112, in call_object > (Object: index_html) > File /home/newZope/lib/python/OFS/DTMLDocument.py, line 189, > in __call__ > (Object: index_html) > File /home/newZope/lib/python/DocumentTemplate/DT_String.py, > line 538, in __call__ > (Object: index_html) > File /home/newZope/lib/python/OFS/DTMLMethod.py, line 182, > in __call__ > (Object: standard_html_header) > File /home/newZope/lib/python/DocumentTemplate/DT_String.py, > line 538, in __call__ > (Object: standard_html_header) > File /home/newZope/lib/python/DocumentTemplate/DT_Util.py, > line 334, in eval > (Object: BoxName=='devo') > (Info: BoxName) > File <string>, line 0, in ? > NameError: BoxName >

1 0

Resolving nvarchar fields via ZmxODBCDA
by Capesius, Alan 13 Mar '01

13 Mar '01

This query works under ZODBCDA. It allows searching of SQL7 tables for specific field names or search strings. e.g. %NAME% will find any field name containing 'NAME' NAME will find any field named 'NAME' SELECT table_catalog,table_name,column_name,data_type FROM INFORMATION_SCHEMA.COLUMNS where column_name like <dtml-sqlvar search_string type=string> order by ordinal_position It fails under ZmxODBC the following example shows how to convert the nvarchar fields to char type fields within an SQL query so that ZmxODBC can deal with them: SELECT table_catalog = CONVERT(char(30),table_catalog), table_name = CONVERT(char(30),table_name), column_name = CONVERT(char(30),column_name), data_type = CONVERT(char(30),data_type) FROM INFORMATION_SCHEMA.COLUMNS where column_name like <dtml-sqlvar search_string type=string> order by ordinal_position The same technique should apply to other unsupported types. Alan Capesius, MCSE/NTCIP+20 Technical Support Engineer Sysmex Corporation of America capesiusa(a)sysmex.com http://twsite.bizland.com/zopetips.htm

1 0