server will not start

**Bazito** · 21-06-2012, 12:11

Code:

2012-06-21 10:58:39.658591|INFO    |ServerLibPriv |   | TeamSpeak 3 Server 3.0.6 (2012-06-21 04:43:35)
2012-06-21 10:58:39.659129|INFO    |DatabaseQuery |   | dbPlugin name:    SQLite3 plugin, Version 2, (c)TeamSpeak Systems GmbH
2012-06-21 10:58:39.659202|INFO    |DatabaseQuery |   | dbPlugin version: 3.7.3
2012-06-21 10:58:39.659526|INFO    |DatabaseQuery |   | checking database integrity (may take a while)
2012-06-21 10:58:39.742884|ERROR   |DatabaseQuery |   | db_exec failed duplicate column name: complain_hash
2012-06-21 10:58:39.742967|ERROR   |DatabaseQuery |   | db_exec() ALTER TABLE complains ADD COLUMN complain_hash varchar(255); error: duplicate column name: complain_hash
2012-06-21 10:58:39.743002|ERROR   |SQL           |   | database update to revision: 20 failed!

a solution?

**dante696** · 21-06-2012, 12:46

Is this a new server or an udpeated and please provide more informations.

**Bazito** · 21-06-2012, 12:53

It's update.
Debian server x64
What's more?

**dante696** · 21-06-2012, 13:07

Can you send me your database file in a private message?
A backup of your database would be helpfull too.

Maybe i can reproduce this then.

**Betaman2k** · 23-06-2012, 07:51

confirmed same problem on
Debian server x64

**Betaman2k** · 23-06-2012, 08:35

fixed himself

modify the sql file: update_20.sql

DROP TABLE IF EXISTS complain_hash;
--ALTER TABLE complains ADD COLUMN complain_hash varchar(255);

ts started without problems

oh 2 warnings, but why ?

Edit:
Ok i change the antiflood points and restart the server all fine now

**outbreaker84** · 23-06-2012, 12:08

hi,

when i fixed it with

DROP TABLE IF EXISTS complain_hash;
--ALTER TABLE complains ADD COLUMN complain_hash varchar(255);

then i become this error :

pls help ! thanks so much

**Betaman2k** · 23-06-2012, 12:47

Heya

please post your first error, without the temp fix ( listening on 0.0.0.0:10011 ) why listening on 0.0.0.0 ( u need a IP from your server or ) ?

**outbreaker84** · 23-06-2012, 13:21

same error as in your post #5

i have no other settings changed

**SilentStorm** · 23-06-2012, 14:01

@Betaman2k
0.0.0.0 is just fine it basicly just means "all available IPs".

@outbreaker84
looks like you completely trashed your Database. It seems to be missing a vital column in at least one vital Table of the Database. Unless you have a backup of your Database before messing with it you are out of luck and need to start with a fresh Database.

This is what a proper 3.0.6 Database should look like:

Code:

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Table structure for table `bans`
--

DROP TABLE IF EXISTS `bans`;
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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ban_name` varchar(2048) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ban_uid` varchar(255) COLLATE utf8_unicode_ci 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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ban_invoker_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ban_reason` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ban_enforcements` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`ban_id`),
  KEY `index_bans_serverid` (`server_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

-- --------------------------------------------------------

--
-- Table structure for table `bindings`
--

DROP TABLE IF EXISTS `bindings`;
CREATE TABLE IF NOT EXISTS `bindings` (
  `binding_id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `type` int(11) DEFAULT NULL,
  PRIMARY KEY (`binding_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

-- --------------------------------------------------------

--
-- Table structure for table `channels`
--

DROP TABLE IF EXISTS `channels`;
CREATE TABLE IF NOT EXISTS `channels` (
  `channel_id` int(11) NOT NULL AUTO_INCREMENT,
  `channel_parent_id` int(10) unsigned DEFAULT NULL,
  `server_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`channel_id`),
  KEY `index_channels_id` (`channel_id`),
  KEY `index_channels_serverid` (`server_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

-- --------------------------------------------------------

--
-- Table structure for table `channel_properties`
--

DROP TABLE IF EXISTS `channel_properties`;
CREATE TABLE IF NOT EXISTS `channel_properties` (
  `server_id` int(10) unsigned DEFAULT NULL,
  `id` int(10) unsigned DEFAULT NULL,
  `ident` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `value` varchar(8192) COLLATE utf8_unicode_ci DEFAULT NULL,
  KEY `index_channel_properties_id` (`id`),
  KEY `index_channel_properties_serverid` (`server_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `clients`
--

DROP TABLE IF EXISTS `clients`;
CREATE TABLE IF NOT EXISTS `clients` (
  `client_id` int(11) NOT NULL AUTO_INCREMENT,
  `server_id` int(10) unsigned DEFAULT NULL,
  `client_unique_id` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `client_nickname` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `client_login_name` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `client_login_password` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `client_lastconnected` int(10) unsigned DEFAULT NULL,
  `client_totalconnections` int(10) unsigned DEFAULT '0',
  `client_month_upload` int(10) unsigned DEFAULT '0',
  `client_month_download` int(10) unsigned DEFAULT '0',
  `client_total_upload` int(10) unsigned DEFAULT '0',
  `client_total_download` int(10) unsigned DEFAULT '0',
  `client_lastip` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`client_id`),
  UNIQUE KEY `client_login_name` (`client_login_name`),
  KEY `index_clients_id` (`client_id`),
  KEY `index_clients_serverid` (`server_id`),
  KEY `index_clients_lastconnectedserverid` (`client_lastconnected`,`server_id`),
  KEY `index_clients_uid` (`client_unique_id`,`server_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

-- --------------------------------------------------------

--
-- Table structure for table `client_properties`
--

DROP TABLE IF EXISTS `client_properties`;
CREATE TABLE IF NOT EXISTS `client_properties` (
  `server_id` int(10) unsigned DEFAULT NULL,
  `id` int(10) unsigned DEFAULT NULL,
  `ident` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  KEY `index_client_properties_id` (`id`),
  KEY `index_client_properties_serverid` (`server_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `complains`
--

DROP TABLE IF EXISTS `complains`;
CREATE TABLE IF NOT EXISTS `complains` (
  `server_id` int(10) unsigned DEFAULT NULL,
  `complain_from_client_id` int(10) unsigned DEFAULT NULL,
  `complain_to_client_id` int(10) unsigned DEFAULT NULL,
  `complain_message` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `complain_timestamp` int(10) unsigned DEFAULT NULL,
  `complain_hash` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  KEY `index_complains_serverid` (`server_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `custom_fields`
--

DROP TABLE IF EXISTS `custom_fields`;
CREATE TABLE IF NOT EXISTS `custom_fields` (
  `server_id` int(10) unsigned DEFAULT NULL,
  `client_id` int(10) unsigned DEFAULT NULL,
  `ident` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  KEY `index_custom_fields_serverid` (`server_id`),
  KEY `index_custom_fields_client_id` (`client_id`),
  KEY `index_custom_fields_ident` (`ident`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `groups_channel`
--

DROP TABLE IF EXISTS `groups_channel`;
CREATE TABLE IF NOT EXISTS `groups_channel` (
  `group_id` int(11) NOT NULL AUTO_INCREMENT,
  `server_id` int(10) unsigned NOT NULL,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `type` int(11) NOT NULL,
  PRIMARY KEY (`group_id`),
  KEY `index_groups_channel_id` (`group_id`),
  KEY `index_groups_channel_serverid` (`server_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

-- --------------------------------------------------------

--
-- Table structure for table `groups_server`
--

DROP TABLE IF EXISTS `groups_server`;
CREATE TABLE IF NOT EXISTS `groups_server` (
  `group_id` int(11) NOT NULL AUTO_INCREMENT,
  `server_id` int(10) unsigned NOT NULL,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `type` int(11) NOT NULL,
  PRIMARY KEY (`group_id`),
  KEY `index_groups_server_id` (`group_id`),
  KEY `index_groups_server_serverid` (`server_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

-- --------------------------------------------------------

--
-- Table structure for table `group_channel_to_client`
--

DROP TABLE IF EXISTS `group_channel_to_client`;
CREATE TABLE IF NOT EXISTS `group_channel_to_client` (
  `group_id` int(10) unsigned NOT NULL,
  `server_id` int(10) unsigned NOT NULL,
  `id1` int(10) unsigned NOT NULL,
  `id2` int(10) unsigned NOT NULL,
  KEY `index_group_channel_to_client_id` (`group_id`),
  KEY `index_group_channel_to_client_serverid` (`server_id`),
  KEY `index_group_channel_to_client_id1` (`id1`),
  KEY `index_group_channel_to_client_id2` (`id2`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `group_server_to_client`
--

DROP TABLE IF EXISTS `group_server_to_client`;
CREATE TABLE IF NOT EXISTS `group_server_to_client` (
  `group_id` int(10) unsigned NOT NULL,
  `server_id` int(10) unsigned NOT NULL,
  `id1` int(10) unsigned NOT NULL,
  `id2` int(10) unsigned NOT NULL,
  KEY `index_group_server_to_client_id` (`group_id`),
  KEY `index_group_server_to_client_serverid` (`server_id`),
  KEY `index_group_server_to_client_id1` (`id1`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `instance_properties`
--

DROP TABLE IF EXISTS `instance_properties`;
CREATE TABLE IF NOT EXISTS `instance_properties` (
  `server_id` int(10) unsigned DEFAULT NULL,
  `string_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `id` int(10) unsigned DEFAULT NULL,
  `ident` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  KEY `index_instance_properties_id` (`id`),
  KEY `index_instance_properties_string_id` (`string_id`),
  KEY `index_instance_properties_serverid` (`server_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `messages`
--

DROP TABLE IF EXISTS `messages`;
CREATE TABLE IF NOT EXISTS `messages` (
  `message_id` int(11) NOT NULL AUTO_INCREMENT,
  `server_id` int(10) unsigned DEFAULT NULL,
  `message_from_client_id` int(10) unsigned DEFAULT NULL,
  `message_from_client_uid` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `message_to_client_id` int(10) unsigned DEFAULT NULL,
  `message_subject` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `message_msg` text COLLATE utf8_unicode_ci,
  `message_timestamp` int(10) unsigned DEFAULT NULL,
  `message_flag_read` int(11) DEFAULT '0',
  PRIMARY KEY (`message_id`),
  KEY `index_messages_serverid` (`server_id`),
  KEY `index_messages_msgidtoclid_read` (`message_to_client_id`,`message_flag_read`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

-- --------------------------------------------------------

--
-- Table structure for table `perm_channel`
--

DROP TABLE IF EXISTS `perm_channel`;
CREATE TABLE IF NOT EXISTS `perm_channel` (
  `server_id` int(10) unsigned NOT NULL,
  `id1` int(10) unsigned NOT NULL,
  `id2` int(10) unsigned NOT NULL,
  `perm_id` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `perm_value` int(11) DEFAULT NULL,
  `perm_negated` int(11) DEFAULT NULL,
  `perm_skip` int(11) DEFAULT NULL,
  KEY `index_perm_channel_serverid` (`server_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `perm_channel_clients`
--

DROP TABLE IF EXISTS `perm_channel_clients`;
CREATE TABLE IF NOT EXISTS `perm_channel_clients` (
  `server_id` int(10) unsigned NOT NULL,
  `id1` int(10) unsigned NOT NULL,
  `id2` int(10) unsigned NOT NULL,
  `perm_id` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `perm_value` int(11) DEFAULT NULL,
  `perm_negated` int(11) DEFAULT NULL,
  `perm_skip` int(11) DEFAULT NULL,
  KEY `index_perm_channel_clients_serverid` (`server_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `perm_channel_groups`
--

DROP TABLE IF EXISTS `perm_channel_groups`;
CREATE TABLE IF NOT EXISTS `perm_channel_groups` (
  `server_id` int(10) unsigned NOT NULL,
  `id1` int(10) unsigned NOT NULL,
  `id2` int(10) unsigned NOT NULL,
  `perm_id` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `perm_value` int(11) DEFAULT NULL,
  `perm_negated` int(11) DEFAULT NULL,
  `perm_skip` int(11) DEFAULT NULL,
  KEY `index_perm_channel_groups_serverid` (`server_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `perm_client`
--

DROP TABLE IF EXISTS `perm_client`;
CREATE TABLE IF NOT EXISTS `perm_client` (
  `server_id` int(10) unsigned NOT NULL,
  `id1` int(10) unsigned NOT NULL,
  `id2` int(10) unsigned NOT NULL,
  `perm_id` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `perm_value` int(11) DEFAULT NULL,
  `perm_negated` int(11) DEFAULT NULL,
  `perm_skip` int(11) DEFAULT NULL,
  KEY `index_perm_client_serverid` (`server_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `perm_server_group`
--

DROP TABLE IF EXISTS `perm_server_group`;
CREATE TABLE IF NOT EXISTS `perm_server_group` (
  `server_id` int(10) unsigned NOT NULL,
  `id1` int(10) unsigned NOT NULL,
  `id2` int(10) unsigned NOT NULL,
  `perm_id` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `perm_value` int(11) DEFAULT NULL,
  `perm_negated` int(11) DEFAULT NULL,
  `perm_skip` int(11) DEFAULT NULL,
  KEY `index_perm_server_group_serverid` (`server_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `servers`
--

DROP TABLE IF EXISTS `servers`;
CREATE TABLE IF NOT EXISTS `servers` (
  `server_id` int(11) NOT NULL AUTO_INCREMENT,
  `server_port` int(10) unsigned DEFAULT NULL,
  `server_autostart` int(10) unsigned DEFAULT NULL,
  `server_machine_id` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `server_month_upload` int(10) unsigned DEFAULT '0',
  `server_month_download` int(10) unsigned DEFAULT '0',
  `server_total_upload` int(10) unsigned DEFAULT '0',
  `server_total_download` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`server_id`),
  KEY `index_servers_serverid` (`server_id`),
  KEY `index_servers_port` (`server_port`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

-- --------------------------------------------------------

--
-- Table structure for table `server_properties`
--

DROP TABLE IF EXISTS `server_properties`;
CREATE TABLE IF NOT EXISTS `server_properties` (
  `server_id` int(10) unsigned DEFAULT NULL,
  `id` int(10) unsigned DEFAULT NULL,
  `ident` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `value` varchar(2048) COLLATE utf8_unicode_ci DEFAULT NULL,
  KEY `index_server_properties_id` (`id`),
  KEY `index_server_properties_serverid` (`server_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tokens`
--

DROP TABLE IF EXISTS `tokens`;
CREATE TABLE IF NOT EXISTS `tokens` (
  `server_id` int(10) unsigned DEFAULT NULL,
  `token_key` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `token_type` int(11) DEFAULT NULL,
  `token_id1` int(10) unsigned DEFAULT NULL,
  `token_id2` int(10) unsigned DEFAULT NULL,
  `token_created` int(10) unsigned DEFAULT NULL,
  `token_description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `token_customset` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

**outbreaker84** · 23-06-2012, 14:19

ok thanks

**Betaman2k** · 24-06-2012, 08:27

problem fixed ?

**outbreaker84** · 24-06-2012, 11:05

no

i started with a new database

Thread: server will not start

Thread Tools

Rate This Thread

Display

server will not start

Thread Information

Users Browsing this Thread

Similar Threads

Teamspeak Server, Ubuntu Server 10.04.2 x86 LTS Start on boot, problem?

Cannot start server from start menu

[Outdated] Start/stop TS3 Server in Debian Linux start-stop-daemon (not screen)

Server Won't Start

Posting Permissions