[Opensim-users] OpenSim.Data.MySQL....

[BoneZ]

Hi all,

I have a grid configured for hypergrid...
Once robust is running I try to create a new user and I get:
OpenSim.Server.Base.ServicesServerBase Command error: 
MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 
'UUID' in 'where clause'

In the OpenSim.Data.MySQL project there is a file... 
"MySQLAuthenticationData.cs"

On line 85:
using (MySqlCommand cmd = new MySqlCommand("select * from `" + m_Realm + 
"` where UUID = ?principalID", dbcon))


Is this an error??
the m_Realm variable seems to be assigned "useraccounts" and this query 
seems to be looking for the column "UUID" in the table... but it does 
not exist.

I've changed it to:

using (MySqlCommand cmd = new MySqlCommand("select * from `" + m_Realm + 
"` where `PrincipalID` = ?principalID", dbcon))

That seems to have satisfied it for another step.. but now 
AuthenticationServiceBase.cs in the 
OpenSim.Services.AuthenticationService project is throwing:
OpenSim.Server.Base.ServicesServerBase Command error: 
MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter 
'?principalID' has already been defined.

I've been chasing this for some time now and wanted to see if anyone 
else can lend an eye??

Thanks.