RE: [Emerald] Error while processing a custom search with version 4.5.5 !!!

New Message Reply Date view Thread view Subject view Author view
Nada (nadas@inco.com.lb)
Tue, 21 Oct 2003 09:46:47 +0300



Date: Tue, 21 Oct 2003 09:46:47 +0300
From: Nada <nadas@inco.com.lb>
Subject: RE: [Emerald] Error while processing a custom search with version 4.5.5 !!!
Message-id: <5.1.0.14.2.20031021094121.00aed758@pop.idm.net.lb>

Hello,

I have just downloaded the new version as you told me but I still have the problem:

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'GroupID'.

SELECT DataTypeID,Description FROM SubAccountDataTypes g WHERE (EXISTS
(SELECT * FROM MetaTables mt, Objects o, OperatorGroupAccess oga WHERE mt.MetaTableID = o.Value AND o.ObjectTypeID = 2 AND mt.TableName =
'SubAccountData' AND oga.OperatorGroupID = 2 AND oga.ObjectGroupID = o.ObjectGroupID AND oga.AccessType & 2 = 2 AND (oga.GroupID = g.GroupID OR oga.GroupID = 1)) OR g.GroupID = 1 OR g.GroupID IS NULL) ORDER BY SortOrder,Description

S0022

I have also installed the patch you have on the ftp site without any success to solve the problem. Can you tell me what is going on. One more thing, since the upgrade all our radius server are sending port not allowed !!! I had to remove the option server port access from the radius admin to allow my customers to log in. But I can not leave it like that in order to disallow abuse of the service. Is this related to the upgrade I made on Emerald ?

Regards, Nada.

At 11:32 AM 10/9/2003 -0700, Dale Reed wrote:
>This issue along with the double search results for non-admin users was
>resolved in Emerald 4.5.5. You can download Emerald 4.5.5 from the
>download center on our website:
>
>http://www.iea-software.com/download/
>
>
>-----Original Message-----
>From: emerald-request@iea-software.com
>[mailto:emerald-request@iea-software.com]On Behalf Of Nada
>Sent: Thursday, October 09, 2003 1:50 AM
>To: emerald@iea-software.com
>Cc: support@iea-software.com
>Subject: [Emerald] Error while processing a custom search
>
>
>Hello,
>
>We have just installed the new version of Emerald 4.5.4. When we perform a
>custom search from the user which is not an admin user we get the below
>error. Please check and reply to us how can we solve it.
>
>Thank you for the support,
>Regards,
>Nada Syriani
>IDM sal.
>
>+++ error +++
>
>[Microsoft][ODBC SQL Server Driver][SQL Server]Ambiguous column name 'Data'.
>
>SELECT CASE WHEN ma.Active = 0 THEN 'inactive.gif' WHEN ma.CancelDate IS NOT
>NULL THEN 'canceled.gif' ELSE 'normal.gif' END AS status, ma.FirstName,
>ma.LastName, Company, adt.Description as Login, ad.Data as AccountType,
>ma.CustomerID FROM MasterAccounts ma, MasterAccountData ad,
>MasterAccountDataTypes adt , MetaTables mt, Objects o, OperatorGroupAccess
>oga WHERE ma.CustomerID = ad.CustomerID AND ad.DataTypeID = adt.DataTypeID
>AND ad.DataTypeID = 1 AND Data LIKE '%DM320%' AND mt.MetaTableID = o.Value
>AND o.ObjectTypeID = 2 AND mt.TableName = 'MasterAccounts' AND
>oga.OperatorGroupID = 3 AND oga.ObjectGroupID = o.ObjectGroupID AND
>oga.AccessType & 1 = 1 AND oga.GroupID IN (ma.GroupID,1)



New Message Reply Date view Thread view Subject view Author view
This archive was generated on Mon Oct 20 2003 - 23:53:55 Pacific Daylight Time