[Zope] portal_catalog or TextindexNG bug?

[BALTUS Jean]

Hi Andreas, I think I've found the reason...

I have the name 'country' in our metadata lists. On our website, I
noticed we also have a ZSQL method named 'country' in a subfolder
somewhere.

It seems that the portal_catalog tries to call this ZSQL method when
retrieving items with a 'country' attribute.

If I delete the ZSQL method and update the Catalog, everything goes back
to normal.

Seems like a bug to me... If you name a ZSQL method with a name
registered in your metadata list, the portal_catalog produces the
traceback.
I don't know whether it's a portal_catalog bug or a TextIndexNG bug.

Regards,

-- Jean

-----Original Message-----
From: Andreas Jung [mailto:lists at andreas-jung.com]
Sent: 14 July 2004 10:13
To: BALTUS Jean; Andreas Jung; zope at zope.org
Subject: RE: [Zope] portal_catalog crashes from time to time

hm...sorry, no clue...currently I would blame ZCatalog since the error
occurs their...but I have no idea.

-aj

--On Mittwoch, 14. Juli 2004 10:09 Uhr +0200 BALTUS Jean
<jean.baltus at africamuseum.be> wrote:

> In general, also when I search in our Plone Site...
>
> The error came suddenly a few days ago... No clue why ... No
significant
> changes has occurred ....
>
> -- Jean
>
> -----Original Message-----
> From: Andreas Jung [mailto:lists at andreas-jung.com]
> Sent: 14 July 2004 10:03
> To: BALTUS Jean; Andreas Jung; zope at zope.org
> Subject: RE: [Zope] portal_catalog crashes from time to time
>
>
> Sorry, no bells ringing...I don't see anything evil in the
TextIndexNG2
> concerning your report.
> The crash only happens when you test through the ZMI or in general?
>
> -aj
>
>
> --On Mittwoch, 14. Juli 2004 9:27 Uhr +0200 BALTUS Jean
> <jean.baltus at africamuseum.be> wrote:
>
>>
>> Here is the full traceback:
>>
>> Site Error
>> An error was encountered while publishing this resource.
>>
>> SystemError
>>
>> Sorry, a site error occurred.
>>
>> Traceback (innermost last):
>>
>> Module ZPublisher.Publish, line 134, in publish_module
>> Module Products.Localizer, line 55, in new_publish
>> Module ZPublisher.Publish, line 49, in publish
>> Module Zope.App.startup, line 137, in zpublisher_exception_hook
>> Module ZPublisher.Publish, line 49, in publish
>> Module ZPublisher.mapply, line 32, in mapply
>> Module ZPublisher.Publish, line 38, in call_object
>> Module Shared.DC.Scripts.Bindings, line 250, in __call__
>> Module Shared.DC.Scripts.Bindings, line 270, in _bindAndExec
>> Module App.special_dtml, line 110, in _exec
>> Module DocumentTemplate.DT_Util, line 175, in eval
>> __traceback_info__: operator
>> Module <string>, line 0, in ?
>> Module Products.TextIndexNG2.TextIndexNG, line 716, in
testTextIndexNG
>> Module Products.ZCatalog.Lazy, line 137, in __getitem__
>> Module Products.ZCatalog.Catalog, line 530, in getScoredResult
>> Module ZODB.Connection, line 534, in setstate
>> Module ZODB.Connection, line 585, in _set_ghost_state
>> SystemError: Failed to import class r from module Record (Also, an
> error
>> occurred while attempting to render the standard error message.)
>>
>> -- Jean
>>
>> -----Original Message-----
>> From: Andreas Jung [mailto:lists at andreas-jung.com]
>> Sent: 13 July 2004 19:07
>> To: BALTUS Jean; zope at zope.org
>> Subject: Re: [Zope] portal_catalog crashes from time to time
>>
>> What means "crashes". Your bugreport does not contain any useful
>> traceback.
>>
>> -aj
>>
>> --On Dienstag, 13. Juli 2004 17:05 Uhr +0200 BALTUS Jean
>> <jean.baltus at africamuseum.be> wrote:
>>
>>> Hi all,
>>>
>>>
>>>
>>> We are using Zope with TextIndexNG.
>>>
>>>
>>>
>>> Today, some queries started to crash, here is the error message :
>>>
>>>
>>>
>>>
>>> Site error
>>>
>>>
>>> This site encountered an error trying to fulfill your request. The
>>> errors were:
>>>
>>> Error Details
>>>
>>> Error Type
>>>
>>> SystemError
>>>
>>> Error Value
>>>
>>> Failed to import class r from module Record
>>>
>>> Request made at
>>>
>>> 2004/07/13 16:59:43.850 GMT+2
>>>
>>>
>>>
>>>
>>>
>>> If I go to the ZMI, and select the 'SearchableText' index and then
>> test
>>> a query, it crashes or not depending on which word I enter. In the
>>> vocabulary, everything looks fine.
>>>
>>>
>>>
>>> Does anybody have a clue on where I can start looking ?
>>>
>>>
>>>
>>> Thanks in advance,
>>>
>>>
>>>
>>> *       Jean
>>>
>>>
>>>
>>>
>>>
>>>###########################################
>>>
>>> This message has been scanned by ICT - Africa Museum
>>
>>
>>
>>
>>###########################################
>>
>> This message has been scanned by ICT - Africa Museum
>>
>> _______________________________________________
>> Zope maillist  -  Zope at zope.org
>> http://mail.zope.org/mailman/listinfo/zope
>> **   No cross posts or HTML encoding!  **
>> (Related lists -
>>  http://mail.zope.org/mailman/listinfo/zope-announce
>>  http://mail.zope.org/mailman/listinfo/zope-dev )
>
>
>
>
>###########################################
>
> This message has been scanned by ICT - Africa Museum




###########################################

This message has been scanned by ICT - Africa Museum