Results 241 to 243 of 243
-
14-09-2009, 02:21 #241
-= TeamSpeak User =-
- Join Date
- Apr 2008
- Location
- USA
- Posts
- 17
Here is a copy of my create_servers.sql
The files within the MySQL file are the ones that are modified so C:\Program Files\Teamspeak2_RC2\mysql_sqlCode: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
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
-
14-09-2009, 23:48 #242
-= TeamSpeak Fanatic =-
- 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.
-
15-09-2009, 01:24 #243
-= TeamSpeak User =-
- 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
-
Install: MYSQL: Invalid Username/Password
By Lange in forum [TeamSpeak 2] Server SupportReplies: 4Last Post: 19-10-2005, 17:01 -
Another option for MySQL 4.1
By Cwac in forum [TeamSpeak 2] Server SupportReplies: 5Last Post: 04-10-2005, 04:42 -
Windows TS2 Server to Remote MySQL Server?
By xCav8r in forum [TeamSpeak 2] Server SupportReplies: 4Last Post: 19-02-2005, 15:57 -
Found some problems (and fixed) with a TS2 and MySQL installation
By MaD-Ogre in forum [TeamSpeak 2] Server SupportReplies: 6Last Post: 20-01-2005, 22:21 -
browser install Im only getting 3 out of the 5 tables in mysql
By cactus5 in forum [TeamSpeak 2] Addons & ScriptsReplies: 0Last Post: 30-11-2004, 23:53


Reply With Quote
