Message-ID: <009c01c398f1$602e6760$6601a8c0@HPNOTE> From: "Tommy Cheng" <tommycheng@pcmagic.net> Subject: Re: [Emerald] Error while processing a custom search with version 4.5.5 !!! Date: Wed, 22 Oct 2003 16:08:15 -0700
Looks like your database is upgraded from 2.5. The problem I am having
is Emerald can't display GroupID on Masteraccount (therefore I can't add
or update). But if you login as admin, everything are okay. Maybe you
should grant the radius db user sa permission for now until this GroupID
thingy is figured out.
Tommy
----- Original Message -----
From: Nada
To: emerald@iea-software.com ; emerald@iea-software.com
Cc: support@iea-software.com
Sent: Monday, October 20, 2003 11:46 PM
Subject: RE: [Emerald] Error while processing a custom search with
version 4.5.5 !!!
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)