[Opensim-dev] Migration SQL invalid causing server to fail to start

[John Sheridan]

Teravus,
  It looks to me like that patch would fix it.  Going by the last 
parameter missing in each line, I can only guess it was a copy/paste 
error by whoever wrote that section.  To be safe perhaps someone who is 
running sqlite could make a test copy of their opensim folder and test 
it first?

Thanks, ;)
 - John / Orion


Teravus Ovares wrote:
> Hey
>
> A database guy needs to look at a migration that someone added in
> SQLite that causes the server to fail during a migration with the
> following message:
>
> 21:46:38 - [SQLAssetServer]: AssetStorage: Attempting to load
> OpenSim.Data.SQLite.dll
> 21:46:38 - [MIGRATIONS]: Upgrading AssetStore to latest revision.
> 21:46:38 - [MIGRATIONS]: NOTE: this may take a while, don't interupt this proces
> s!
> 21:46:38 - [OPENSIMBASE]: Asset server SQL not loaded (wrong number of
> arguments to function substr())
> 21:46:38 - [APPLICATION]: <Null Reference Exception>
>
> Supposedly TommReady has posted a patch:
> http://opensimulator.org/mantis/view.php?id=3439
>
> However, since I'm not a database guy..     I'm simply raising
> awareness to someone who is a database guy.
>
> Best Regards
>
> Teravus
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev
>