February 2001 - Zope-Dev

Re: [Zope-dev] Zope dumping core
by Dieter Maurer 08 Feb '01

08 Feb '01

Dario Lopez-Kästen writes: > I am runing zope 2.2.5 on a Solaris box, and it is dumping core (suspect: > SQL MEthods with oracle, FTP server). > > I am using it in conjunction with oracle. Could this be the culprit? We have had that behaviour when we used an old DCOracle to connect to an Oracle 8.1.6 server: The oracle client library cause a memory corruption that brought our Zope down about every 5 to 10 minutes. Our problem disappears after we installed a newer DCOracle. Dieter

1 0

Re: [Zope-dev] ZSQL using LIKE operator
by Dieter Maurer 08 Feb '01

08 Feb '01

Schmidt, Allen J. writes: > .... how to resolve a query which I need to read: > > SELECT * FROM table WHERE keywords LIKE '%keywords_variable%' > > <dtml-sqltest> has 'op=like' and when set to 'type=string' produces the LIKE > operation in the query, with single quotes, but I cannot get it to 'wrap' > the keywords with the percent characters and THEN the single quotes to > produce that which I have in the query above. <dtml-sqltest expr="'%%%s%%' % keywords_variable" column=keywords_variable ...> Dieter

1 0

Re: [Zope-dev] Zope newbie question
by Dieter Maurer 08 Feb '01

08 Feb '01

Bryan Baszczewski writes: > Within my dtml, I am retrieving a text field from a database and passing > this field to a javascript function. However, the text field can be any > length of characters and dtml keeps cutting the text off at no pre-set limit > making it impossible to pass this field to javascript. The javascript is > going to take this text and pop it up in another window for the user to > read. DTML does not cut text, unless you tell it to do with the "size" attribute. > I checked the html source and everything looks fine, but when I execute it > gives an "unterminated string" error. Could Zope be causing this? That sounds strange. Unterminated string errors might be non local. Maybe, the problem is much earlier in your code, a missing or extraneous quote. Are you sure your text from the database does not contain unescaped quotes? Dieter

1 0

manage_options in 2.3
by Andy McKay 08 Feb '01

08 Feb '01

Thanks for the new management interface guys I happily wrote a product last night and did a quick interface using the standard Folder interface and fiddled with filtered_meta_types list and dontAllowCutandPaste and so on. A quick How-To will be on its way. I got a wierd error trying to fiddle with manage_options though, in the olden days something like this worked: manage_options = ( ( Folder.manage_options[0], ) + ( {'label':'View', 'action':'my_index_html', ) + ( Folder.manage_options[2:], ) ) But I kept getting this error in 2.3: (Object: manage_tabs) File E:\Zope23\lib\python\App\special_dtml.py, line 236, in _exec (Object: manage_tabs) File E:\Zope23\lib\python\DocumentTemplate\DT_With.py, line 133, in render (Object: _(manage_options=filtered_manage_options())) File E:\Zope23\lib\python\DocumentTemplate\DT_Util.py, line 334, in eval (Object: _(manage_options=filtered_manage_options())) (Info: filtered_manage_options) File <string>, line 0, in ? File E:\Zope23\lib\python\App\Management.py, line 119, in filtered_manage_options (Object: Traversable) AttributeError: (see above) Error Type: AttributeError Error Value: 'tuple' object has no attribute 'get' It seems its looking for a tuple of dicts? But looking at Folder on other classes their manage_options hasn't changed. I then found this hack worked (looking at this morning it could be improved): _m = list(Folder.manage_options) _m[1] = {'label':'View','action':'my_index_html'} manage_options = (_m) Whats going on? -- Andy McKay.

5 8

RE: [Zope-dev] ZSQL using LIKE operator
by Schmidt, Allen J. 08 Feb '01

08 Feb '01

Yup...You're right. I found an item that had a single quote in it. I tried it and the query blew up. then I added parts you suggest, and bingo...works fine. Thanks! To get around another problem I noticed... I have a keywords text field to search through everything in every category. On the same page, I have links which pass on the category number to the ZSQL method. The keywords FORM uses a hidden category field which I set to ="" -- worked fine. But if I used the URL to jump right to the category listings, there was no keyword to pass. I just set an empty property named 'keywords' and then if the URL search is used, keywords has a 'value'. I am sure there is a more elegant way to do this..but it works fine. Thanks again guys! Allen -----Original Message----- From: Casey Duncan [mailto:cduncan@kaivo.com] Sent: Thursday, February 08, 2001 11:11 AM To: Jens Vagelpohl Cc: Schmidt, Allen J.; zope-dev(a)zope.org Subject: Re: [Zope-dev] ZSQL using LIKE operator Jens Vagelpohl wrote: > > just write it out like: > > SELECT * FROM table WHERE keywords LIKE '%<dtml-var name="my_var">%' > > jens > > on 2/8/01 7:17, Schmidt, Allen J. at aschmidt(a)nv.cc.va.us wrote: > > > I have been through the docs, searched a variety of locations, and cannot > > find anything on how to resolve a query which I need to read: > > > > SELECT * FROM table WHERE keywords LIKE '%keywords_variable%' > > > > <dtml-sqltest> has 'op=like' and when set to 'type=string' produces the LIKE > > operation in the query, with single quotes, but I cannot get it to 'wrap' > > the keywords with the percent characters and THEN the single quotes to > > produce that which I have in the query above. > > > > Ideally what I need to produce would be the query to search through some > > text in several fields by the keyword_variable (IF any keywords are > > provided) AND/OR within a specific category of information. If I can get > > the syntax to solve the above situation I think I can get <dtml-sqlgroup> to > > sort out what information is provided and construct the query accordingly. > > > > Sorry for the length of this newbie question but I am stumped on this one. > > And, so ends my lurking status. > > > > Thanks! > > Allen > > SELECT * FROM table WHERE keywords LIKE '%<dtml-var name="my_var" sql_quote>%' would be a safer bet. Otherwise a value of my_var with a single quote in it wouldn't work. -- | Casey Duncan | Kaivo, Inc. | cduncan(a)kaivo.com `------------------>

1 0

ZSQL using LIKE operator
by Schmidt, Allen J. 08 Feb '01

08 Feb '01

I have been through the docs, searched a variety of locations, and cannot find anything on how to resolve a query which I need to read: SELECT * FROM table WHERE keywords LIKE '%keywords_variable%' <dtml-sqltest> has 'op=like' and when set to 'type=string' produces the LIKE operation in the query, with single quotes, but I cannot get it to 'wrap' the keywords with the percent characters and THEN the single quotes to produce that which I have in the query above. Ideally what I need to produce would be the query to search through some text in several fields by the keyword_variable (IF any keywords are provided) AND/OR within a specific category of information. If I can get the syntax to solve the above situation I think I can get <dtml-sqlgroup> to sort out what information is provided and construct the query accordingly. Sorry for the length of this newbie question but I am stumped on this one. And, so ends my lurking status. Thanks! Allen

3 2

Profiling Products
by Andy Dawkins 08 Feb '01

08 Feb '01

People I have a desire to be able to profile my Python Product so that I can benefit from the advantages of profiling. Has anybody done this? Does anybody know how to do this? I have tried profiling Z2.py but of course that doesn't drop down to the level of the python product (Possibly running in a different thread - or something :( ) General Comments Welcomed. Cheers -Andy

4 8

Zope dumping core
by Dario Lopez-K�sten 08 Feb '01

08 Feb '01

Hello! I am runing zope 2.2.5 on a Solaris box, and it is dumping core (suspect: SQL MEthods with oracle, FTP server). I am using it in conjunction with oracle. Could this be the culprit? Any help is appreciated. If we cannot get Zope to be stable we'll have to abandon it; this is not on my list of preferred actions, but we have very little in zope at the moment, jet it is unstable. We'll soon need to start moving to production and more heavy testing. DC: what do you charge for technical support? Contact me off list, please. Do any of you have any hints on how to track down the source of the failing. AFAIK I have set up everything to log as much as possible, but there is no hint of anythin in the logs. Also I don't know how to read the logs. I'll poke around the sources, but if anyone has some info they'd like to share, i'd appreciate it a lot. Sincerely, /dario - -------------------------------------------------------------------- Dario Lopez-Kästen Systems Developer Chalmers Univ. of Technology dario(a)ita.chalmers.se ICQ will yield no hits IT Systems & Services

2 1

strange problem with LoginManager
by Tim McLaughlin 08 Feb '01

08 Feb '01

I am using LoginManager as specified by by dlpierson's HOWTO and everything works fine unless somebody connects via AT&T Worldnet (using a dialup). In this case, the browser displays a 404 error when the login page should be shown. Same machine connected through a LAN works fine, but again connected through Worldnet is a no go. I suspect this has something (maybe) to do with Worldnet's proxies (if they have them) not handling the headers which zope may (or may not) send. Ok, so it's a guess.... please help. Thanks. Tim McLaughlin

1 0

DAV locking in management interface
by Steve Alexander 08 Feb '01

08 Feb '01

Now that DAV locking has landed, how about integrating it with the TTW management interface. For example, when editing a DTML Method, have a button that says "Lock to make changes". Pressing this locks the method you want to edit. It gets unlocked when you press the "change" button. -- Steve Alexander Software Engineer Cat-Box limited http://www.cat-box.net

1 0