PDA

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


Quinntum
08-08-2007, 15:54
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

[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

maxi1990
08-08-2007, 15:55
What serverversion do you use?

Quinntum
08-08-2007, 15:59
What serverversion do you use?

ts2_server_rc2_202319.tar.bz2

Quinntum
08-08-2007, 16:27
Issue resovled. New issue new post coming forth.

gggrrrrrr

Quinntum

maxi1990
08-08-2007, 16:29
Could you please tell us how u solved the problem?

Quinntum
08-08-2007, 16:39
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.:D

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

Quinntum