[SOLVED] worldsercer.exe not work

[Troya]

will I have a problem and do not know how to solve it,I host server 3.3.5 and 4.3.4 server, but we will not work 4.3.4 server right I need to add the auth-account_banned one table called "realm" and I added it and then work 4.3.4, but then 3.3.5 server dont work, idk what to do, cuz i host it on same auth db.

Next i do, it was i was go in src and find command script, i opened it and i change script for ban it is not anymore auth.account_banned, it is auth.cata_account_banned with "realm" columman. but it giv me same error when i try rund worldserver.exe

p.s i have in auth account_banned and cata_account_banned, first is for 3.3.5 realm, onothere is for 4.3.4.

In mysql_stmt_prepare() id: 8, sql: "INSERT INTO account_banned VALUES (?, ?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'OpenCataclysm realmd', 'Failed login autoban', 1)"
Column count doesn't match value count at row 1
In mysql_stmt_prepare() id: 27, sql: "INSERT INTO account_banned VALUES (?, ?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)"


Sorry for my English.

 

[Tommy]

If you're using 3.3.5 and 4.3.4 on the same auth database it obviously won't work because the structures don't match. Secondly, you can't rename an existing table or add a new table and expect the server to load from the new or renamed table. The source code isn't dynamic. They are both still using account_banned, hence the inconsistent column errors.

 

[Troya]

If you're using 3.3.5 and 4.3.4 on the same auth database it obviously won't work because the structures don't match. Secondly, you can't rename an existing table or add a new table and expect the server to load from the new or renamed table. The source code isn't dynamic. They are both still using account_banned, hence the inconsistent column errors.

ok, could you tell me what to do then? how to host it?

 

[Tommy]

ok, could you tell me what to do then? how to host it?

Only way I would think is to edit both 3.3.5 and 4.3.4 auth database source code to work with each other. It makes sense to have one account database for all realms, but the only way to do it is to do what I wrote; doubt there would be any other way since they are different expansions -- otherwise, you'll need to have separate 3.3.5 and 4.3.4 auth databases..

 

[Troya]

Only way I would think is to edit both 3.3.5 and 4.3.4 auth database source code to work with each other. It makes sense to have one account database for all realms, but the only way to do it is to do what I wrote; doubt there would be any other way since they are different expansions -- otherwise, you'll need to have separate 3.3.5 and 4.3.4 auth databases..

if you could explain a little better and more in PM
I appreciate it

 

[Kaev]

Modify your source code, so the auth server will load your tables, so they will use the same names.
Not sure, but file should be this one: https://github.com/TrinityCore/Trin...red/Database/Implementation/LoginDatabase.cpp

 

[Troya]

Fixed. thanks on help.
Admin you can close this post