Authserver emucoach repack v3 problem
- Thread starter T-rav
- Start date
The error is gone but authserver closes right as it opens. I copied msvcp120.dll, msvcr120.dll, libeay32.dll and ssleay32.dll into the folder with authserver and its just no wanting to stay open. I think it would be really cool if you guys could make v3 into an installer like v2 makes it a little easier to get things working.
Auth logs say:
EmuCoach V.3 - Deathwings Madness rev. 0000-00-00 00:00:00 +0000 (Archived) (Win32, Release) (authserver)
<Ctrl-C> to stop.
Using configuration file authserver.conf.
OpenSSL 1.0.1c 10 May 2012 (Library: OpenSSL 1.0.1h 5 Jun 2014)
Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.
MySQL client library: 5.5.9
MySQL server ver: 5.5.9-log
Connected to MySQL database at 127.0.0.1
In mysql_stmt_prepare() id: 8, sql: "INSERT INTO account_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, '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)"
Column count doesn't match value count at row 1
MySQL client library: 5.5.9
MySQL server ver: 5.5.9-log
Connected to MySQL database at 127.0.0.1
DatabasePool auth NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to database
Auth logs say:
EmuCoach V.3 - Deathwings Madness rev. 0000-00-00 00:00:00 +0000 (Archived) (Win32, Release) (authserver)
<Ctrl-C> to stop.
Using configuration file authserver.conf.
OpenSSL 1.0.1c 10 May 2012 (Library: OpenSSL 1.0.1h 5 Jun 2014)
Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.
MySQL client library: 5.5.9
MySQL server ver: 5.5.9-log
Connected to MySQL database at 127.0.0.1
In mysql_stmt_prepare() id: 8, sql: "INSERT INTO account_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, '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)"
Column count doesn't match value count at row 1
MySQL client library: 5.5.9
MySQL server ver: 5.5.9-log
Connected to MySQL database at 127.0.0.1
DatabasePool auth NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to database
I think the problem is me taking auth and character sql backup from v2 to v3. I got a clean v3 here and it starts up no problem, but if i drop the auth and character parts of v3 using Heidisql and add my auth and character from v2 it messes up and cant open authserver or worldserver. Anyone know why?
Whenever I needed to backup my characters and account on v2 I used Heidisql to create a sql file and then I would open the new server and drop the auth and character databases. I execute the sql file into the new database and it worked, but from v2 database to v3 database its a no go.
its a little frustrating lol
Whenever I needed to backup my characters and account on v2 I used Heidisql to create a sql file and then I would open the new server and drop the auth and character databases. I execute the sql file into the new database and it worked, but from v2 database to v3 database its a no go.
its a little frustrating lol
Last edited:
sure thing! I don't know how but I managed to get it working by taking v3 auth and character databases and instead of dropping them and placing the backups in their place I managed to execute the query without dropping so when I finally got the authserver and worldserver to work I ran the game and after running into a worldserver crash managed to actually get into the game haha.
How do you run a query like that in case I run into the same problem again?
I don't know how but I managed to get it working by taking v3 auth and character databases and instead of dropping them and placing the backups in their place I managed to execute the query without dropping so when I finally got the authserver and worldserver to work I ran the game and after running into a worldserver crash managed to actually get into the game haha.How do you run a query like that in case I run into the same problem again?
ExO
Admin
- 5,119
- 2014
- 1,639
Check out this video tutorial:
https://www.youtube.com/watch?v=CLlhAibDN6k
https://www.youtube.com/watch?v=CLlhAibDN6k
i find my solution for this error . if some one have the same error for MSVCP120.dll dowload the version here https://www.microsoft.com/es-es/download/confirmation.aspx?id=40784 my error has fixed whit x86 version . try all version and find who version is ok for you .