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

[Justin Clark-Casey]

John Sheridan wrote:
> 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?

According to

http://www.sqlite.org/lang_corefunc.html

sqlite does contain a two arg substr() function and so the sql worked on the sqlite 3.5.9 on my Ubuntu 8.10 system.  So 
I'm guessing that older sqlite versions only implement the 3 arg function.

Thanks very much to RemedyTomm for spotting and supplying a patch to fix this.  Anybody who encountered this problem can 
safely just start OpenSim again after updating and the migration should occur correctly.

> 
> 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.

I'm not a database guy - I just play one on TV.

>>
>> Best Regards
>>
>> Teravus
>> _______________________________________________
>> Opensim-dev mailing list
>> Opensim-dev at lists.berlios.de
>> https://lists.berlios.de/mailman/listinfo/opensim-dev
>>   
> 
> 
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev
> 


-- 
justincc
Justin Clark-Casey
http://justincc.wordpress.com