Community Forums Today's Posts     Member List     Archive    
Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2007
    Location
    Phoenix
    Posts
    18

    ERROR,Info,server, EInvalidField: OpenSQL Error: EDatabaseError.Table 'ts2_bans'

    Hello,

    I've setup TS on a Linux CentOS 4.5, with MySQL5. When I try to start up the service I get the following error in the log file.
    ERROR,Info,server, EInvalidField: OpenSQL Error: EDatabaseError.Table 'ts2_bans' already exists in query: CREATE TABLE `ts2_bans` (
    Server.ini file has the following info

    Code:
    [DBEXPRESS]
    sqldir=mysql_sql/
    Drivername=mysql
    Database=TeamSpeak
    Hostname=localhost
    User_name=xxxxxx
    Password=xxxxx
    GetDriverFunc=getSQLDriverMYSQL
    VendorLib=/usr/lib/mysql/libmysqlclient_r.so.10.0.0
    LibraryName=./libsqlmy.so
    Active=1
    And I've deleted and recreated a new DB as well. But, needless to say that every time I start the service, I get this error. The tables are created each time as well (everytime I delete them that is.) I've also done a fresh install of ts and the db at the same time, still same issue.

    Any help will be welcomed!

    Quinntum

  2. #2
    Join Date
    Jul 2006
    Posts
    1,573
    What serverversion do you use?

  3. #3
    Join Date
    Aug 2007
    Location
    Phoenix
    Posts
    18
    Quote Originally Posted by maxi1990 View Post
    What serverversion do you use?
    ts2_server_rc2_202319.tar.bz2

  4. #4
    Join Date
    Aug 2007
    Location
    Phoenix
    Posts
    18
    Issue resovled. New issue new post coming forth.

    gggrrrrrr

    Quinntum

  5. #5
    Join Date
    Jul 2006
    Posts
    1,573
    Could you please tell us how u solved the problem?

  6. #6
    Join Date
    Aug 2007
    Location
    Phoenix
    Posts
    18
    Quote Originally Posted by maxi1990 View Post
    Could you please tell us how u solved the problem?
    recreated the DB user... all permissions given, but grant. same setting as before, but didnt change anything else.

    Very well could have been an Id10T error as well. 10 hours of work and such who knows.

    New issue tho... see if ya can come up with something on that one.

    Quinntum

Thread Information

Users Browsing this Thread

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

Posting Permissions

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