Forum


Notice to all users

We are migrating towards a new forum system located at community.teamspeak.com, as such this forum will become read-only on January 29, 2020

Results 1 to 3 of 3
  1. #1
    Join Date
    February 2013
    Posts
    47

    db trasfer and error

    hi, Today I transferred on the same server ts the mysql db. However, risk making to this problem. I basically copied and put in the new db data. I also found an error on a server that is practically reset (no channel it permits)


    Code:
    2013-11-05 10:18:42.743659|WARNING |PermGroupMgr  |   | permsid: b_serverinstance_help_view(1), double assigned to sgid: 1, removing!
    2013-11-05 10:18:42.743792|WARNING |PermGroupMgr  |   | permsid: b_serverinstance_version_view(2), double assigned to sgid: 1, removing!
    2013-11-05 10:18:42.743855|WARNING |PermGroupMgr  |   | permsid: b_virtualserver_select(22), double assigned to sgid: 1, removing!
    2013-11-05 10:18:42.743915|WARNING |PermGroupMgr  |   | permsid: i_group_auto_update_type(146), double assigned to sgid: 1, removing!
    2013-11-05 10:18:42.743974|WARNING |PermGroupMgr  |   | permsid: b_channel_create_child(82), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.744034|WARNING |PermGroupMgr  |   | permsid: b_channel_create_modify_with_codec_celtmono48(93), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.744094|WARNING |PermGroupMgr  |   | permsid: b_channel_create_modify_with_codec_opusmusic(95), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.744153|WARNING |PermGroupMgr  |   | permsid: b_channel_create_modify_with_codec_opusvoice(94), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.744213|WARNING |PermGroupMgr  |   | permsid: b_channel_create_modify_with_codec_speex16(91), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.744273|WARNING |PermGroupMgr  |   | permsid: b_channel_create_modify_with_codec_speex32(92), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.744332|WARNING |PermGroupMgr  |   | permsid: b_channel_create_modify_with_codec_speex8(90), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.744391|WARNING |PermGroupMgr  |   | permsid: b_channel_create_permanent(83), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.744450|WARNING |PermGroupMgr  |   | permsid: b_channel_create_private(86), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.744508|WARNING |PermGroupMgr  |   | permsid: b_channel_create_semi_permanent(84), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.744568|WARNING |PermGroupMgr  |   | permsid: b_channel_create_temporary(85), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.744628|WARNING |PermGroupMgr  |   | permsid: b_channel_create_with_default(101), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.744687|WARNING |PermGroupMgr  |   | permsid: b_channel_create_with_description(88), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.744746|WARNING |PermGroupMgr  |   | permsid: b_channel_create_with_maxclients(98), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.744806|WARNING |PermGroupMgr  |   | permsid: b_channel_create_with_maxfamilyclients(99), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.744866|WARNING |PermGroupMgr  |   | permsid: b_channel_create_with_needed_talk_power(102), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.744925|WARNING |PermGroupMgr  |   | permsid: b_channel_create_with_password(89), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.745020|WARNING |PermGroupMgr  |   | permsid: b_channel_create_with_sortorder(100), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.745081|WARNING |PermGroupMgr  |   | permsid: b_channel_create_with_topic(87), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.745141|WARNING |PermGroupMgr  |   | permsid: b_channel_delete_flag_force(128), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.745202|WARNING |PermGroupMgr  |   | permsid: b_channel_delete_permanent(125), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.745261|WARNING |PermGroupMgr  |   | permsid: b_channel_delete_semi_permanent(126), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.745320|WARNING |PermGroupMgr  |   | permsid: b_channel_delete_temporary(127), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.745379|WARNING |PermGroupMgr  |   | permsid: b_channel_info_view(81), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.745439|WARNING |PermGroupMgr  |   | permsid: b_channel_join_ignore_maxclients(135), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.745499|WARNING |PermGroupMgr  |   | permsid: b_channel_join_ignore_password(134), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.745558|WARNING |PermGroupMgr  |   | permsid: b_channel_join_permanent(131), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.745617|WARNING |PermGroupMgr  |   | permsid: b_channel_join_semi_permanent(132), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.745677|WARNING |PermGroupMgr  |   | permsid: b_channel_join_temporary(133), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.745736|WARNING |PermGroupMgr  |   | permsid: b_channel_modify_codec(114), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.745795|WARNING |PermGroupMgr  |   | permsid: b_channel_modify_codec_latency_factor(116), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.745855|WARNING |PermGroupMgr  |   | permsid: b_channel_modify_codec_quality(115), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.745915|WARNING |PermGroupMgr  |   | permsid: b_channel_modify_description(112), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.745975|WARNING |PermGroupMgr  |   | permsid: b_channel_modify_make_default(106), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.746034|WARNING |PermGroupMgr  |   | permsid: b_channel_modify_make_permanent(107), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.746094|WARNING |PermGroupMgr  |   | permsid: b_channel_modify_make_semi_permanent(108), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.746153|WARNING |PermGroupMgr  |   | permsid: b_channel_modify_make_temporary(109), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.746213|WARNING |PermGroupMgr  |   | permsid: b_channel_modify_maxclients(117), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.746272|WARNING |PermGroupMgr  |   | permsid: b_channel_modify_maxfamilyclients(118), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.746331|WARNING |PermGroupMgr  |   | permsid: b_channel_modify_name(110), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.746391|WARNING |PermGroupMgr  |   | permsid: b_channel_modify_needed_talk_power(120), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.746451|WARNING |PermGroupMgr  |   | permsid: b_channel_modify_parent(105), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.746510|WARNING |PermGroupMgr  |   | permsid: b_channel_modify_password(113), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.746570|WARNING |PermGroupMgr  |   | permsid: b_channel_modify_sortorder(119), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.746629|WARNING |PermGroupMgr  |   | permsid: b_channel_modify_topic(111), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.746689|WARNING |PermGroupMgr  |   | permsid: b_client_avatar_delete_other(186), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.746749|WARNING |PermGroupMgr  |   | permsid: b_client_ban_create(210), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.746897|WARNING |PermGroupMgr  |   | permsid: b_client_ban_delete(212), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.746960|WARNING |PermGroupMgr  |   | permsid: b_client_ban_delete_own(211), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.747020|WARNING |PermGroupMgr  |   | permsid: b_client_ban_list(209), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.747080|WARNING |PermGroupMgr  |   | permsid: b_client_channel_textmessage_send(217), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.747140|WARNING |PermGroupMgr  |   | permsid: b_client_complain_delete(208), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.747200|WARNING |PermGroupMgr  |   | permsid: b_client_complain_delete_own(207), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.747260|WARNING |PermGroupMgr  |   | permsid: b_client_complain_list(206), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.747321|WARNING |PermGroupMgr  |   | permsid: b_client_create_modify_serverquery_login(230), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.747381|WARNING |PermGroupMgr  |   | permsid: b_client_custom_info_view(195), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.747441|WARNING |PermGroupMgr  |   | permsid: b_client_delete_dbproperties(229), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.747500|WARNING |PermGroupMgr  |   | permsid: b_client_ignore_antiflood(181), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.747560|WARNING |PermGroupMgr  |   | permsid: b_client_ignore_bans(180), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.747619|WARNING |PermGroupMgr  |   | permsid: b_client_ignore_sticky(188), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.747677|WARNING |PermGroupMgr  |   | permsid: b_client_info_view(189), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.747738|WARNING |PermGroupMgr  |   | permsid: b_client_issue_client_query_command(182), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.747798|WARNING |PermGroupMgr  |   | permsid: b_client_modify_dbproperties(228), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.747858|WARNING |PermGroupMgr  |   | permsid: b_client_modify_description(226), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.747919|WARNING |PermGroupMgr  |   | permsid: b_client_modify_own_description(227), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.747979|WARNING |PermGroupMgr  |   | permsid: b_client_offline_textmessage_send(218), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.748039|WARNING |PermGroupMgr  |   | permsid: b_client_permissionoverview_own(191), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.748099|WARNING |PermGroupMgr  |   | permsid: b_client_permissionoverview_view(190), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.748159|WARNING |PermGroupMgr  |   | permsid: b_client_remoteaddress_view(192), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.748219|WARNING |PermGroupMgr  |   | permsid: b_client_request_talker(185), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.748278|WARNING |PermGroupMgr  |   | permsid: b_client_server_textmessage_send(216), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.748339|WARNING |PermGroupMgr  |   | permsid: b_client_set_flag_talker(223), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.748398|WARNING |PermGroupMgr  |   | permsid: b_client_skip_channelgroup_permissions(178), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.748459|WARNING |PermGroupMgr  |   | permsid: b_client_use_channel_commander(184), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.748519|WARNING |PermGroupMgr  |   | permsid: b_client_use_reserved_slot(183), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.748578|WARNING |PermGroupMgr  |   | permsid: b_ft_ignore_password(231), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.748637|WARNING |PermGroupMgr  |   | permsid: b_ft_transfer_list(232), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.748715|WARNING |PermGroupMgr  |   | permsid: b_group_is_permanent(145), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.748776|WARNING |PermGroupMgr  |   | permsid: b_icon_manage(144), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.748837|WARNING |PermGroupMgr  |   | permsid: b_permission_modify_power_ignore(168), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.748897|WARNING |PermGroupMgr  |   | permsid: b_serverinstance_binding_list(5), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.748957|WARNING |PermGroupMgr  |   | permsid: b_serverinstance_help_view(1), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.749016|WARNING |PermGroupMgr  |   | permsid: b_serverinstance_info_view(3), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.749076|WARNING |PermGroupMgr  |   | permsid: b_serverinstance_log_add(17), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.749135|WARNING |PermGroupMgr  |   | permsid: b_serverinstance_log_view(16), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.749195|WARNING |PermGroupMgr  |   | permsid: b_serverinstance_modify_querygroup(20), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.749254|WARNING |PermGroupMgr  |   | permsid: b_serverinstance_modify_settings(19), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.749314|WARNING |PermGroupMgr  |   | permsid: b_serverinstance_modify_templates(21), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.749374|WARNING |PermGroupMgr  |   | permsid: b_serverinstance_permission_find(7), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.749434|WARNING |PermGroupMgr  |   | permsid: b_serverinstance_permission_list(6), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.749494|WARNING |PermGroupMgr  |   | permsid: b_serverinstance_stop(18), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.749553|WARNING |PermGroupMgr  |   | permsid: b_serverinstance_textmessage_send(15), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.749612|WARNING |PermGroupMgr  |   | permsid: b_serverinstance_version_view(2), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.749672|WARNING |PermGroupMgr  |   | permsid: b_serverinstance_virtualserver_list(4), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.749732|WARNING |PermGroupMgr  |   | permsid: b_serverquery_login(14), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.749791|WARNING |PermGroupMgr  |   | permsid: b_virtualserver_change_machine_id(12), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.749851|WARNING |PermGroupMgr  |   | permsid: b_virtualserver_change_template(13), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.749911|WARNING |PermGroupMgr  |   | permsid: b_virtualserver_channelclient_permission_list(158), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.749971|WARNING |PermGroupMgr  |   | permsid: b_virtualserver_channelgroup_client_list(155), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.750031|WARNING |PermGroupMgr  |   | permsid: b_virtualserver_channelgroup_create(160), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.750091|WARNING |PermGroupMgr  |   | permsid: b_virtualserver_channelgroup_delete(170), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.750150|WARNING |PermGroupMgr  |   | permsid: b_virtualserver_channelgroup_list(153), double assigned to sgid: 2, removing!
    2013-11-05 10:18:42.750210|WARNING |PermGroupMgr  |   | permsid: b_virtualserver_channelgroup_permission_list(154), double assigned to sgid: 2, removing!

  2. #2
    Join Date
    February 2012
    Location
    Germany
    Posts
    577
    Drop the database, manually create an empty one (in case your import script doesn't contain a create database statement) and import again into the empty database. You have probably started the Teamspeak server once before you imported the database, so it created its default database for a new server, and you merged this default data with your import.

  3. #3
    Join Date
    February 2013
    Posts
    47
    Quote Originally Posted by Schlumpi View Post
    Drop the database, manually create an empty one (in case your import script doesn't contain a create database statement) and import again into the empty database. You have probably started the Teamspeak server once before you imported the database, so it created its default database for a new server, and you merged this default data with your import.
    i start teamspeak after create a new database

    it's correct ENGINE=InnoDB DEFAULT CHARSET=latin1 ?
    Code:
    CREATE TABLE IF NOT EXISTS `bans` (
      `ban_id` int(11) NOT NULL AUTO_INCREMENT,
      `server_id` int(10) unsigned DEFAULT NULL,
      `ban_ip` varchar(255) DEFAULT NULL,
      `ban_name` varchar(2048) DEFAULT NULL,
      `ban_uid` varchar(255) DEFAULT NULL,
      `ban_timestamp` int(10) unsigned DEFAULT NULL,
      `ban_length` int(10) unsigned DEFAULT NULL,
      `ban_invoker_client_id` int(10) unsigned DEFAULT NULL,
      `ban_invoker_uid` varchar(40) DEFAULT NULL,
      `ban_invoker_name` varchar(255) DEFAULT NULL,
      `ban_reason` varchar(255) DEFAULT NULL,
      `ban_enforcements` int(10) unsigned DEFAULT '0',
      `ban_hash` varchar(255) DEFAULT NULL,
      PRIMARY KEY (`ban_id`),
      KEY `index_bans_serverid` (`server_id`)
    ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
    
    --
    -- Dump dei dati per la tabella `bans`
    --
    
    INSERT INTO `bans` (`ban_id`, `server_id`, `ban_ip`, `ban_name`, `ban_uid`, `ban_timestamp`, `ban_length`, `ban_invoker_client_id`, `ban_invoker_uid`, `ban_invoker_name`, `ban_reason`, `ban_enforcements`, `ban_hash`) VALUES
    (1, 2, '', '', 'te=', 18, 0, 19, '=', '[] ', '', 0, 'C=');

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 16
    Last Post: October 24th, 2012, 01:58 PM
  2. Replies: 0
    Last Post: September 5th, 2011, 07:20 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •