Community Forums Today's Posts     Member List     Archive    
Page 17 of 17 FirstFirst ... 7151617
Results 241 to 243 of 243
  1. #241
    Join Date
    Apr 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
    Dec 2004
    Location
    RF
    Posts
    1,693
    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
    Apr 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. Install: MYSQL: Invalid Username/Password
    By Lange in forum [TeamSpeak 2] Server Support
    Replies: 4
    Last Post: 19-10-2005, 17:01
  2. Another option for MySQL 4.1
    By Cwac in forum [TeamSpeak 2] Server Support
    Replies: 5
    Last Post: 04-10-2005, 04:42
  3. Windows TS2 Server to Remote MySQL Server?
    By xCav8r in forum [TeamSpeak 2] Server Support
    Replies: 4
    Last Post: 19-02-2005, 15:57
  4. Found some problems (and fixed) with a TS2 and MySQL installation
    By MaD-Ogre in forum [TeamSpeak 2] Server Support
    Replies: 6
    Last Post: 20-01-2005, 22:21
  5. browser install Im only getting 3 out of the 5 tables in mysql
    By cactus5 in forum [TeamSpeak 2] Addons & Scripts
    Replies: 0
    Last Post: 30-11-2004, 23:53

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
  •