Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0004607opensim[GRID] User Servicepublic2010-03-03 10:322011-08-25 22:59
ReporterFernando Oliveira 
Assigned To 
StatusclosedResolutionno change required 
PlatformOSOS Version
Product Versionmaster (dev code) 
Target VersionFixed in Version 
Summary0004607: userfriends table not being created on first run
DescriptionOn this new version the 'userfriends' table is not being created;
OpenSim.Data.Migration [MIGRATIONS]: Creating migrations at version 1
INSERT INTO `Friends` SELECT `ownerID`, `friendID`, `friendPerms`, 0 FROM `userfriends`;

DEBUG - OpenSim.Data.Migration [MIGRATIONS]: An error has occurred in the migration no such table: userfriends.
Additional Informationand on this starting gives this error

ERROR - OpenSim.Server.Base.ServerUtils Error loading plugin from OpenSim.Services.InventoryService.dll, exception System.Exception: Could not find a storage interface in the given module

I dont know if it's related;
TagsNo tags attached.
Git Revision or version numberLatest one;
Run ModeStandalone (1 Region) , Standalone (Multiple Regions)
Physics EngineBasicPhysics
Script Engine
Environment.NET / Windows32
Mono VersionNone
Attached Files

- Relationships
related to 0004604closedjohndrellwolf Unable to login to region 

-  Notes
Fernando Oliveira (developer)
2010-03-03 10:51

I created the table by hand and it ran ok;

DROP TABLE IF EXISTS `opensim3`.`userfriends`;
CREATE TABLE `opensim3`.`userfriends` (
  `ownerID` varchar(37) NOT NULL DEFAULT '',
  `friendID` varchar(37) NOT NULL DEFAULT '',
  `friendPerms` int(11) NOT NULL DEFAULT '0',
  `datetimestamp` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `ownerID` (`ownerID`,`friendID`)
Diva (administrator)
2010-03-03 10:51

Looks like you don't have a userfriends table from the past, so no data is migrated over to the new table Friends.
Diva (administrator)
2010-03-03 10:52

userfriends is obsolete. You should not create one.
Fernando Oliveira (developer)
2010-03-03 10:59

But someway it was related, because the second error stoped after the table creation;
Diva (administrator)
2010-03-03 14:05
edited on: 2010-03-04 14:31

Obviously -- you created the table that the migration was assuming existed. But what you did is wrong, and should not be repeated by anyone.

An IF TABLE EXISTS directive is missing from the migration code -- adding it will fix this bug. I'll do that later.

Just for the public record what you did is wrong and should not be done.
(people look at these issue reports to find answers to the problems they encounter)

makopoppo (manager)
2011-08-25 22:59

Since there is no further feedbacks from the reporter, closing it as by design.

- Issue History
Date Modified Username Field Change
2010-03-03 10:32 Fernando Oliveira New Issue
2010-03-03 10:32 Fernando Oliveira Git Revision => Latest one;
2010-03-03 10:32 Fernando Oliveira SVN Revision => 0
2010-03-03 10:32 Fernando Oliveira Run Mode => Standalone (1 Region) , Standalone (Multiple Regions)
2010-03-03 10:32 Fernando Oliveira Physics Engine => BasicPhysics
2010-03-03 10:32 Fernando Oliveira Environment => .NET / Windows32
2010-03-03 10:32 Fernando Oliveira Mono Version => None
2010-03-03 10:50 Diva Relationship added related to 0004604
2010-03-03 10:51 Fernando Oliveira Note Added: 0015083
2010-03-03 10:51 Diva Note Added: 0015084
2010-03-03 10:53 Diva Note Added: 0015085
2010-03-03 10:59 Fernando Oliveira Note Added: 0015086
2010-03-03 14:05 Diva Note Added: 0015087
2010-03-04 14:31 Diva Note Edited: 0015087
2011-08-25 22:59 makopoppo Note Added: 0019705
2011-08-25 22:59 makopoppo Status new => closed
2011-08-25 22:59 makopoppo Resolution open => no change required

Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker