This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

Fehlende Datenbanktabellen für OpenSim (Gruppenfunktion) manuell nachinstallieren
#1
Probleme bei der Erstellung von Gruppen können bei fehlenden Tabellen innerhalb der Datenbank auftreten.

Fehlende Datenbanktabellen für OpenSim (Gruppenfunktion) manuell nachinstallieren.

Folgende Tabellen manuell hinzufügen:

  • CREATE TABLE os_groups_groups
  • CREATE TABLE os_groups_membership
  • CREATE TABLE os_groups_roles
  • CREATE TABLE os_groups_rolemembership
  • CREATE TABLE os_groups_invites
  • CREATE TABLE os_groups_notices
  • CREATE TABLE os_groups_principals

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 25

Server version: 8.0.27-0ubuntu0.20.04.1 (Ubuntu)

Copyright © 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database          |
+--------------------+
| information_schema   
| mysql                          
| onmaus1  - Datenbank                    
| mausi2                       
| erna3                         
| performance_schema 
| sys                               
+--------------------+
7 rows in set (0.01 sec)

mysql> use onmaus1;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> SHOW TABLES;

+-------------------+
| Tables_in_onmaus1 |
+-------------------+
| Avatars         
| Friends         
| GridUser         
| Presence         
| UserAccounts     
| assets           
| auth             
| bakedterrain     
| classifieds     
| estate_groups   
| estate_managers 
| estate_map       
| estate_settings 
| estate_users     
| estateban       
| hg_traveling_data
| im_offline       
| inventoryfolders 
| inventoryitems   
| land             
| landaccesslist   
| migrations  <-------------------------SELECT * FROM       
| primitems       
| prims           
| primshapes       
| regionban       
| regionenvironment
| regionextra     
| regions         
| regionsettings   
| regionwindlight 
| spawn_points     
| terrain         
| tokens           
| userdata         
| usernotes       
| userpicks       
| userprofile     
| usersettings     
+-------------------+
39 rows in set (0.00 sec)

mysql> select * from migrations;

+-----------------+---------+
| name            | version |
+-----------------+---------+
| migrations              1
| RegionStore          58
| EstateStore           35
| IM_Store               5
| UserAccount         6
| GridStore              10
| AssetStore            10
| AuthStore              4
| GridUserStore       2
| InventoryStore       7
| Avatar                    3
| Presence               4
| os_groups_Store  3
| UserProfiles          5
| HGTravelStore      2
| FriendsStore         4
+-----------------+---------+

16 rows in set (0.00 sec)

Tabellen anlegen:

mysql> CREATE TABLE `os_groups_groups` (
    ->  `GroupID` char(36) NOT NULL default '',
    ->  `Location` varchar(255) NOT NULL default '',
    ->  `Name` varchar(255) CHARACTER SET utf8 NOT NULL default '',
    ->  `Charter` text CHARACTER SET utf8 NOT NULL,
    ->  `InsigniaID` char(36) NOT NULL default '',
    ->  `FounderID` char(36) NOT NULL default '',
    ->  `MembershipFee` int(11) NOT NULL default '0',
    ->  `OpenEnrollment` varchar(255) NOT NULL default '',
    ->  `ShowInList` int(4) NOT NULL default '0',
    ->  `AllowPublish` int(4) NOT NULL default '0',
    ->  `MaturePublish` int(4) NOT NULL default '0',
    ->  `OwnerRoleID` char(36) NOT NULL default '',
    ->  PRIMARY KEY  (`GroupID`),
    ->  UNIQUE KEY `Name` (`Name`),
    ->  FULLTEXT KEY `Name_2` (`Name`)
    -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected, 6 warnings (4.52 sec)

mysql> CREATE TABLE `os_groups_membership` (
    ->  `GroupID`char(36) NOT NULL default '',
    ->  `PrincipalID` VARCHAR(255) NOT NULL default '',
    ->  `SelectedRoleID` char(36) NOT NULL default '',
    ->  `Contribution` int(11) NOT NULL default '0',
    ->  `ListInProfile` int(4) NOT NULL default '1',
    ->  `AcceptNotices` int(4) NOT NULL default '1',
    ->  `AccessToken` char(36) NOT NULL default '',
    ->  PRIMARY KEY  (`GroupID`,`PrincipalID`),
    ->  KEY `PrincipalID` (`PrincipalID`)
    -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected, 3 warnings (1.21 sec)

mysql> CREATE TABLE `os_groups_roles` (
    ->  `GroupID` char(36) NOT NULL default '',
    ->  `RoleID` char(36) NOT NULL default '',
    ->  `Name` varchar(255)  CHARACTER SET utf8 NOT NULL default '',
    ->  `Description` varchar(255) CHARACTER SET utf8 NOT NULL default '',
    ->  `Title` varchar(255) CHARACTER SET utf8 NOT NULL default '',
    ->  `Powers` bigint(20) unsigned NOT NULL default '0',
    ->  PRIMARY KEY  (`GroupID`,`RoleID`),
    ->  KEY `GroupID` (`GroupID`)
    -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected, 4 warnings (1.19 sec)

mysql> CREATE TABLE `os_groups_rolemembership` (
    ->  `GroupID` char(36) NOT NULL default '',
    ->  `RoleID` char(36) NOT NULL default '',
    ->  `PrincipalID` VARCHAR(255) NOT NULL default '',
    ->  PRIMARY KEY  (`GroupID`,`RoleID`,`PrincipalID`),
    ->  KEY `PrincipalID` (`PrincipalID`)
    -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected (1.17 sec)

mysql> CREATE TABLE `os_groups_invites` (
    ->  `InviteID` char(36) NOT NULL default '',
    ->  `GroupID` char(36) NOT NULL default '',
    ->  `RoleID` char(36) NOT NULL default '',
    ->  `PrincipalID` VARCHAR(255) NOT NULL default '',
    ->  `TMStamp` timestamp NOT NULL,
    ->  PRIMARY KEY  (`InviteID`),
    ->  UNIQUE KEY `PrincipalGroup` (`GroupID`,`PrincipalID`)
    -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected (1.11 sec)

mysql> CREATE TABLE `os_groups_notices` (
    ->  `GroupID` char(36) NOT NULL default '',
    ->  `NoticeID` char(36) NOT NULL default '',
    ->  `TMStamp` int(10) unsigned NOT NULL default '0',
    ->  `FromName` varchar(255) NOT NULL default '',
    ->  `Subject` varchar(255) CHARACTER SET utf8 NOT NULL default '',
    ->  `Message` text CHARACTER SET utf8 NOT NULL,
    ->  `HasAttachment` int(4) NOT NULL default '0',
    ->  `AttachmentType` int(4) NOT NULL default '0',
    ->  `AttachmentName` varchar(128) NOT NULL default '',
    ->  `AttachmentItemID` char(36) NOT NULL default '',
    ->  `AttachmentOwnerID` varchar(255) NOT NULL default '',
    ->  PRIMARY KEY  (`NoticeID`),
    ->  KEY  `GroupID` (`GroupID`),
    ->  KEY `TMStamp` (`TMStamp`)
    -> ) ENGINE=InnoDB  DEFAULT CHARSET=latin1;
Query OK, 0 rows affected, 5 warnings (0.98 sec)

mysql> CREATE TABLE `os_groups_principals` (
    ->  `PrincipalID` VARCHAR(255) NOT NULL default '',
    ->  `ActiveGroupID` char(36) NOT NULL default '',
    ->  PRIMARY KEY  (`PrincipalID`)
    -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected (1.03 sec)

mysql> ALTER TABLE `os_groups_invites`
    ->
    -> MODIFY `TMStamp` timestamp NOT NULL default CURRENT_TIMESTAMP;

Query OK, 0 rows affected (0.14 sec)

Records: 0  Duplicates: 0  Warnings: 0

Kontrolle:

mysql> show tables;

+--------------------------+
| Tables_in_onmaus1        |
+--------------------------+
| Avatars                  |
| Friends                  |
| GridUser                |
| Presence                |
| UserAccounts            |
| assets                  |
| auth                    |
| bakedterrain            |
| classifieds              |
| estate_groups            |
| estate_managers          |
| estate_map              |
| estate_settings          |
| estate_users            |
| estateban                |
| hg_traveling_data        |
| im_offline              |
| inventoryfolders        |
| inventoryitems          |
| land                    |
| landaccesslist          |
| migrations              |
| os_groups_groups        |
| os_groups_invites        |
| os_groups_membership    |
| os_groups_notices        |
| os_groups_principals    |
| os_groups_rolemembership |
| os_groups_roles          |
| primitems                |
| prims                    |
| primshapes              |
| regionban                |
| regionenvironment        |
| regionextra              |
| regions                  |
| regionsettings          |
| regionwindlight          |
| spawn_points            |
| terrain                  |
| tokens                  |
| userdata                |
| usernotes                |
| userpicks                |
| userprofile              |
| usersettings            |
+--------------------------+
46 rows in set (0.01 sec)

mysql> exit

Bye
All done!
Zitieren


Nachrichten in diesem Thema
Fehlende Datenbanktabellen für OpenSim (Gruppenfunktion) manuell nachinstallieren - von Lukas - 16.11.2021, 17:57

Gehe zu:


Benutzer, die gerade dieses Thema anschauen: 1 Gast/Gäste