Forum

Page 17 of 17 FirstFirst ... 7151617
Results 241 to 243 of 243
  1. #241
    Join Date
    April 2008
    Location
    USA
    Posts
    17
    Here is a copy of my create_servers.sql

    Code:
    CREATE TABLE IF NOT EXISTS `ts2_servers` (
      `i_server_id` int(11) NOT NULL auto_increment,
      `s_server_name` varchar(40) default NULL,
      `s_server_welcomemessage` varchar(80) default NULL,
      `i_server_maxusers` int(11) default NULL,
      `i_server_udpport` int(11) default NULL,
      `s_server_password` varchar(80) default NULL,
      `b_server_clan_server` int(11) default NULL,
      `b_server_allow_codec_celp51` int(11) default NULL,
      `b_server_allow_codec_celp63` int(11) default NULL,
      `b_server_allow_codec_gsm148` int(11) default NULL,
      `b_server_allow_codec_gsm164` int(11) default NULL,
      `b_server_allow_codec_celp52` int(11) default NULL,
      `b_server_allow_codec_speex2150` int(11) default NULL,
      `b_server_allow_codec_speex3950` int(11) default NULL,
      `b_server_allow_codec_speex5950` int(11) default NULL,
      `b_server_allow_codec_speex8000` int(11) default NULL,
      `b_server_allow_codec_speex11000` int(11) default NULL,
      `b_server_allow_codec_speex15000` int(11) default NULL,
      `b_server_allow_codec_speex18200` int(11) default NULL,
      `b_server_allow_codec_speex24600` int(11) default NULL,
      `s_server_webposturl` varchar(200) default NULL,
      `s_server_weblinkurl` varchar(200) default NULL,
      `b_server_active` int(11) default NULL,
      `dt_server_created` varchar(20) default NULL,
      `s_server_description` varchar(100) default NULL,
      PRIMARY KEY  (`i_server_id`)
    ) TYPE=MyISAM
    The files within the MySQL file are the ones that are modified so C:\Program Files\Teamspeak2_RC2\mysql_sql

    All create tables have that same IF NOT EXISTS but I keep getting

    Code:
    13-09-09 21:14:35,ALL,Info,server,	Server init initialized
    13-09-09 21:14:35,ALL,Info,server,	Server version: 2.0.24.1 Win32
    13-09-09 21:14:35,ERROR,All,SQL,	ExecSQL Error: EDatabaseError.SQL Server Error: Error returned from ODBC function SQLExecDirect
    ODBC Return Code: -1: SQL_ERROR
    
    ODBC SqlState:        42S01
    Native Error Code:    1050
    [MySQL][ODBC 3.51 Driver][mysqld-5.1.38-community]Table 'ts2_servers' already exists
    
    DBMS: "MySQL", version: 5.1.38-community, ODBC Driver: "myodbc3.dll", version: 03.51.27

  2. #242
    Join Date
    December 2004
    Location
    RF
    Posts
    3,004
    Do you have full path to SQL files specified in server.ini?
    Because server can't lie to you. If it is not there, it's not there. Period.

  3. #243
    Join Date
    April 2008
    Location
    USA
    Posts
    17
    [DBEXPRESS]
    sqldir=C:\Program Files\Teamspeak2_RC2servertest\mysql_sql\
    DriverName=openodbc
    Database=DSN=odbcmain;DB=tserver
    User_name=tserver
    Password=anrdeamon
    LibraryName=dbxoodbc-2.0.12.dll
    GetDriverFunc=getSQLDriverODBC
    VendorLib=ODBC32.DLL
    Active=1

    Look at that was pointing at the wrong damn folder.... My Bad

    Case closed

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [Not Supported] How to "properly" install TS3 using a mySQL 5 server on linux...
    By dlcerny in forum Linux / FreeBSD
    Replies: 33
    Last Post: September 20th, 2017, 04:23 PM
  2. Replies: 0
    Last Post: April 1st, 2014, 02:43 AM
  3. DXHook.DLL doesn't install properly
    By Carlislemark in forum Windows
    Replies: 3
    Last Post: February 6th, 2012, 02:25 PM

Tags for this Thread

Posting Permissions

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