EInvalidField.field error

[rhohan]

okay. i have struggled and struggled to get this running.

i have: mysql-server-4.0.24
i have: freebsd 4.7 (it is a vps server with a company called verio, i have root access, but i can not upgrade the version, so please don't just coop out and say "upgrade freebsd)
i have: ts server, the latest on the goteamspeak.com page

problem:

i FINALLY got ts to connect to my mysql database. i am using different mysql driver. i created a blank database called teamspeak. so i launch ts. it gives me a pid. THANK GOD. but not clear yet. try to log into web interface as admin. nothing. just sits. so i check server.log, and see this:

27-07-05 13:21:16,ERROR,All,WEBINTERFACE, Progress_COMMAND Exception: EInvalidField.field b_server_clan_server not found

so i stop the server and restart. now i see this:

---------------------------------------------------------------
-------------- log started at 27-07-05 13:28 -------------
---------------------------------------------------------------
27-07-05 13:28:08,ALL,Info,server,      Server init initialized
27-07-05 13:28:08,ALL,Info,server,      Server version: 2.0.20.1 Linux
27-07-05 13:28:08,ERROR,Info,server,    EInvalidField: field b_server_active not found
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 27-07-05 13:28 --------------
---------------------------------------------------------------

okay. so i am assuming that this means it can not read the b_server_active field. so i check if the database is corrupt, nope, mysqlcheck shows fine. so see if the database is there. sure enough, it is. so i run the command in read_active_servers.sql, which is:

select i_server_id from ts2_servers where b_server_active=-1

in a mysql console window. works:

# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 369 to server version: 4.0.24

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use teamspeak
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select i_server_id from ts2_servers where b_server_active=-1
    -> \g
+-------------+
| i_server_id |
+-------------+
|           1 |
+-------------+
1 row in set (0.00 sec)

mysql>

so it works. so i tried deleting the database, and remaking it. it creates the tables again, but again, has these invalid field errors.

i have been trying this for 2 solid weeks now. i wasn't able to get the sqlite to work. it gave me some weird error. unfortunately the freebsd how to isn't clear. i am at a loss. it finally connects to mysql, but it just won't friggin read the tables.

edit: sorry forgot to add my server.ini:

[DBEXPRESS]
sqldir=mysql_sql/
Drivername=MySQL Direct (Core Lab)
Database=teamspeak
Hostname=localhost
User_name=root
Password=********
GetDriverFunc=getSQLDriverMySQLDirect
VendorLib=./libmysqlclient_r.so.12
LibraryName=./libsqlmda.so.2.50
Active=1

i have tried using the mysql3 venderlib libmysqlclient_r.so.10.0.0 and the mysql 4 lib libmysqlclient_r.so.12 that comes with my mysql install. both act the same. neither work.



i dont' know how i put this in the windows support, but if an admin could move it that would be super.

[Rooter]

EInvalidField: field b_server_active not found

This message you receive is a direct result of using the trial version of the dbExpress driver from crlab.com.

If you wish to fix this you would need to purchase the driver for $69.95. I can verify this does resolve the problem completely.

Reference:
http://crlab.com/dbx/ (Product Info)
https://secure.element5.com/register...oductid=176190 (Order)
http://crlab.com/dbx/download.html (Trials)

Here is the configuration I am using after installing the paid version of the driver. This is with MySQL 4.0.25, but should work just as well with MySQL 4.1.x except using the newer VendorLib for it.

[DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql
Database=database_name
Hostname=localhost
User_name=database_user
Password=dbuserpassword
GetDriverFunc=getSQLDriverMySQL
VendorLib=/usr/lib/libmysqlclient_r.so.12.0.0
LibraryName=./libsqlmda.so.2.50
Active=1

[jonde99]

Bit shit that a trial driver does not work. I'm not paying for something I have no idea will fix my problem or not.

[Rooter]

Bit shit that a trial driver does not work. I'm not paying for something I have no idea will fix my problem or not.

That is correct to an extent, the trial version for Linux will not work because it is feature limited in the amount of queries it will return an answer for. Only the trial for Windows is a fully functional trial that lasts for 30 days; it is only time-limited. If you run Linux, you will have to purchase the driver; likewise if you run Windows and want to use it past the initial 30 day trial, you will have to purchase the driver. I have purchased it and it has been working flawlessly.

[tillo]

Sorry to recover this old thread, but I feel like an update is necessary.

I'm using dbExpress 4.40 trial library to make sure I can load libmysqlclient_r.15 library and connect to a MySQL 5.0 server.

I've tried to connect with the included dbExpress free library and any precompiled libmysqlclient_r.10 library (password set using OLD_PASSWORD), but it just. won't. work. No workaround written in this forum helped, the login is always failing.

At the first run the tables have been created just fine, records have been inserted.
An attempt to call the web interface ends in timeout with this error in the logs:

09-12-08 17:04:26,ERROR,All,WEBINTERFACE,       Progress_COMMAND Exception: EInvalidField.field b_server_clan_server not found

When restarting tss though I've the same exact error as the first poster:

09-12-08 17:07:04,ERROR,Info,server,    EInvalidField: field b_server_active not found

Is this still related to the trial query volume restrictions?
The license has a ridicolous price now, a purchase is not an option. Anyone got it working somehow?
Or anyone has a solution for the persistent login problem with the old libraries?

Any other hint or idea?

[Robidu]

Here, too, the same old thing... -.-

MySQL: 5.0.51a
SuSE 11.0 running on a dual-core Opteron (dedicated root server)
TS version: 2.0.24.1
Binary location and name: /usr/lib/teamspeak2
Data directory: /opt/teamspeak2
Startup via SysV start script (I have adapted that one from an existing script and modified it accordingly) in conjunction with startproc/killproc

With the libsqlmy.so I have experienced the same thing (I have switched from the libsqlmy.so to the full-fledged DbExpress, and I have tried several versions thereof (2.60, 3.30, and also 4.40), in conjunction with different MySQL client libs (libmysqlclient_r.so.12, libmysqlclient_r.so.14, libmysqlclient_r.so.15).

Upon first start of the TS server everything just looks fine.

---------------------------------------------------------------
-------------- log started at 26-02-09 16:02 -------------
---------------------------------------------------------------
26-02-09 16:02:47,ALL,Info,server,      Server init initialized
26-02-09 16:02:47,ALL,Info,server,      Server version: 2.0.23.19 Linux
26-02-09 16:02:47,WARNING,Info,SQL,     created table ts2_servers
26-02-09 16:02:47,WARNING,Info,SQL,     created table ts2_server_privileges
26-02-09 16:02:47,WARNING,Info,SQL,     created table ts2_channels
26-02-09 16:02:47,WARNING,Info,SQL,     created table ts2_channel_privileges
26-02-09 16:02:47,WARNING,Info,SQL,     created table ts2_clients
26-02-09 16:02:47,WARNING,Info,SQL,     created table ts2_bans
26-02-09 16:02:48,ALL,Info,server,      Starting VirtualServer id:1 with port:8767
26-02-09 16:02:49,ALL,Info,server,      Started VirtualServer id:1 with port:8767
26-02-09 16:02:49,WARNING,Info,SERVER,  Default VirtualServer created
26-02-09 16:02:49,WARNING,Info,SERVER,  admin account info: username: admin password: <bla>
26-02-09 16:02:49,WARNING,Info,SERVER,  superadmin account info: username: superadmin password: <blub>
26-02-09 16:02:55,ALL,Info,server,      Server init finished
26-02-09 16:02:55,WARNING,Info,server,  TeamSpeak Server daemon activated
26-02-09 16:07:05,ALL,Info,server,      Server shutdown initialized
26-02-09 16:07:05,ALL,Info,server,      Stopping VirtualServer id:1 with port:8767
26-02-09 16:07:06,ALL,Info,server,      Stopped VirtualServer id:1 with port:8767

(please note the missing log end marker - somehow the shutdown won't complete, and the pid file remains in /opt/teamspeak2)

When I'm attempting to change any setting of the virtual server I get the message "your selected server is invalid", but the log still looks fine.

However, when I subsequently launch the server, things get screwed up:

---------------------------------------------------------------
-------------- log started at 26-02-09 16:33 -------------
---------------------------------------------------------------
26-02-09 16:33:25,ALL,Info,server,      Server init initialized
26-02-09 16:33:25,ALL,Info,server,      Server version: 2.0.24.1 Linux
26-02-09 16:33:26,ERROR,All,SERVER,     VirtualServer Startup(1) Exception: EInvalidField.field b_sp_AdminEditServerWelcomeMessage not found
26-02-09 16:33:33,ALL,Info,server,      Server init finished
26-02-09 16:33:33,WARNING,Info,server,  TeamSpeak Server daemon activated
26-02-09 16:33:44,ALL,Info,server,      Server shutdown initialized
26-02-09 16:33:44,ALL,Info,server,      Stopping VirtualServer id:1 with port:8

Again, the shutdown is not performed cleanly, and when I attempt to change anything on the server, the process crashes immediately.

Now, I have tried several combinations of DbExpress and libmysqlclient_r, all to no avail.

I have even repeatedly deleted the database and recreated it from scratch (I have also given the db user - teamspeak@localhost, that is, all necessary rights and even set the pw as OLD_PASSWORD), however, that has also been of no use.

Now what do I do to get rid of the problem?

This is my server.ini:

[Main Config]
BoundToIp1=
ExternalIPDectection=1
HTTPServer Port=14534
HTTPServer Enabled=1
DateTimeFormat=dd-mm-yyyy hh:nn:ss
TCPQueryPort=51234
AllowedClientNameChars=
DisAllowedClientNameChars=()[]{}

[debug]
MessageTypes=LMTALL
MessageDepths=LMDALL

[DBEXPRESS]
sqldir=/opt/teamspeak2/mysql_sql/
Drivername=mysql
Database=Teamspeak
Hostname=127.0.0.1
User_name=teamspeak
Password=<guess_what>
GetDriverFunc=getSQLDriverMySQL
VendorLib=/usr/lib/libmysqlclient_r.so.15
LibraryName=/opt/teamspeak2/libsqlmda.so.4.40
Active=1

[WebPost]
AdminEmail=olafmartens********
ISPLinkURL=na
ISPName=Private
ISPCountryNumber=4428
Enabled=0
PostURL=
ListPublic=0
UserAgent=teamspeak

[log]
access_r=0
access_u=0
channel_registerred=0
channel_unregisterred=0
sa=0
chat=0
kick_server=0
kick_channel=0

[Spam]
max_commands=10
in_seconds=2