[whups] Client Links with Modules
Mike Bydalek
mbydalek at zivix.com
Sun Nov 23 01:07:57 PST 2003
Hello,
My question is in regards to how the Client list is generated for created
modules. Background: I have 3 SQL sources in Turba configured with "Contacts"
being the first listed and "Companies" just under that.
The problem is, if I go ahead and edit a Module and add some clients to
associate with the Module, I get the "Added a client link to soanso" for each
client I chose. Then, when I goto create a Ticket for that Module, I get the
"There are no clients associated with this module."
In digging around, I found that the query "[debug] [whups] SQL Query by
Category_sql::getCategoriesByAttributes():" returns an empty set because a4.
and a5.attribute_name doesn't equal a1.attribute_name. In turn, the turba
query bombs because there's a null value for the "WHERE object_id IN ()" part
of the query.
Is there a bug here, or is somehow the data being stored incorrectly due to my
ignorance in the 'horde_category_attributes' table? Additionally, the
'attribute_name' field for a1-3 is "link_params", but a4 and a5 are each
"from_params".
I'm obviously using SQL for the categories and everything else. I guess what
I'm really looking for is to see if it's a bug in the code, or a "me" error
(might have missed a config setting?)
Appreciate your time,
Mike B.
More information about the whups
mailing list