MSSQL Grid - Error updating Regions table Invalid column name 'parcelMapTexture' r/18062

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

MSSQL Grid - Error updating Regions table Invalid column name 'parcelMapTexture' r/18062

Opensimfan
This post was updated on .
opensim dev r/18062
see mantis #5886 for details..

with MSSQL i'm getting an error with updating regions table..
10:28:08 - [MSSQL Grid]: Error updating Regions table: Invalid column name 'parcelMapTexture'., 
UPDATE sql: update [regions] set locX=@posX, locY=@posY, sizeX=@ sizeX, sizeY=@sizeY , 
[serverIP] = @serverIP, [serverHttpPort] = @serverHttpPort, [serverURI] = @serverURI, 
[serverPort] = @serverPort, regionMapTexture] = @regionMapTexture, 
[parcelMapTexture] = @parcelMapTexture, [access] = @access, [regionSecret] = @regionSecret, 
[owner_uuid] = @owner_uuid, [Token] = @Token, [regionHandle] = @regionHandle, 
[flags] = @flags, [last_seen] = @last_seen where uuid = @regionID

Steps To Reproduce
- setup opensim with new emty database using MSSQL..
- add your config files..
- run

Additional Information:
I also can't login to any region, even if i create a new region.
14:11:45 - [GRID SERVICE]: GetNeighbours() called for scope 00000000-0000-0000-0000-000000000000,
            region a02321d1-54e0-11e1-b86c-0800200c9a66 but no such region found

14:11:45 - [INTERGRID]: Informing 0 neighbours that this region is up
14:12:43 - [LLOGIN SERVICE]: Login request for Melnik OpenSim at uri:Within Temptation Island&128&128&0
           using viewer Imprudence 1.4.0.3, channel Imprudence, IP 127.0.0.1,
           Mac 1f0ce52fe6c90aecaa53d9fadd3dcfee, Id0 85587b07e78d2bc2e8a86b9bea554295

14:12:43 - [PRESENCE SERVICE]: LoginAgent a02321d0-54e0-11e1-b86c-0800200c9a66 with session
           d2d3f332-a008-4d40-9771-92226cb27977 and ssession 73b58385-22aa-4497-afa5-30367319a2f4

14:12:43 - [GRID USER SERVICE]: User a02321d0-54e0-11e1-b86c-0800200c9a66 is online
14:12:43 - [LLOGIN SERVICE]: FindDestination for start location uri:Within Temptation Island&128&128&0

14:12:43 - [LLLOGIN SERVICE]: Got Custom Login URI uri:Within Temptation Island&128&128&0,
           can't locate region Within Temptation Island. Trying defaults.

14:12:43 - [GRID SERVICE]: GetDefaultRegions returning 0 regions
14:12:43 - [LLOGIN SERVICE]: Last Region Not Found Attempting to find random region
14:12:43 - [GRID SERVICE]: Fallback returned 0 regions

14:12:43 - [LLLOGIN SERVICE]: Got Custom Login URI uri:Within Temptation Island&128&128&0,
           Grid does not provide default regions and no alternative found.

14:12:43 - [PRESENCE SERVICE]: Session d2d3f332-a008-4d40-9771-92226cb27977 logout
14:12:43 - [LLOGIN SERVICE]: Login failed, reason: destination not found
 
see Attached File or online at:
http://db.tt/V1n0D2xH

_________________________________________
OpenSimFan

My Opensim/Second Life Blog
http://verwijs.wordpress.com

(Dutch, basic hardware/software help windows, Mac, Linux)
http://verwijs-pc.nl

My Twitter Page:
http://twitter.com/OpenSimFan

My Facebook page (be my friend, please )
http://www.facebook.com/andre.verwijs

My Google+ page (follow me please )
André Verwijs - Google+
Reply | Threaded
Open this post in threaded view
|

Re: MSSQL Grid - Error updating Regions table Invalid column name 'parcelMapTexture'

justincc
See the mantis

On 12/02/12 13:36, OpenSimFan wrote:

> *opensim dev r/18062*
> see  http://opensimulator.org/mantis/view.php?id=5886 mantis #5886  for
> details..
>
> with MSSQL i'm getting an error with updating regions table..
>
>
> *Steps To Reproduce *
> - setup opensim with new emty database using MSSQL..
> - add your config files..
> - run
>
> *Additional Information:*
> I also can't login to any region, even if i create a new region.
>
>
> see Attached File or online at:
> http://db.tt/V1n0D2xH
>
>
>
> -----
> _________________________________________
> OpenSimFan
> My Opensim/Second Life Blog
> http://verwijs.wordpress.com
> (Dutch, basic hardware/software help  windows, Mac, Linux)
> http://verwijs-pc.nl
> My Twitter Page:
> http://twitter.com/OpenSimFan
> My Facebook page (be my friend, please )
> http://www.facebook.com/andre.verwijs
>
> --
> View this message in context: http://opensim-users.2152040.n2.nabble.com/MSSQL-Grid-Error-updating-Regions-table-Invalid-column-name-parcelMapTexture-tp7277826p7277826.html
> Sent from the opensim-users mailing list archive at Nabble.com.
> _______________________________________________
> Opensim-users mailing list
> [hidden email]
> https://lists.berlios.de/mailman/listinfo/opensim-users
>


--
Justin Clark-Casey (justincc)
http://justincc.org/blog
http://twitter.com/justincc
_______________________________________________
Opensim-users mailing list
[hidden email]
https://lists.berlios.de/mailman/listinfo/opensim-users
Reply | Threaded
Open this post in threaded view
|

Re: MSSQL Grid - Error updating Regions table Invalid column name 'parcelMapTexture'

Opensimfan
ok, thanks for the fix :)  
_________________________________________
OpenSimFan

My Opensim/Second Life Blog
http://verwijs.wordpress.com

(Dutch, basic hardware/software help windows, Mac, Linux)
http://verwijs-pc.nl

My Twitter Page:
http://twitter.com/OpenSimFan

My Facebook page (be my friend, please )
http://www.facebook.com/andre.verwijs

My Google+ page (follow me please )
André Verwijs - Google+