[Archive] Issue Starting up Auth and world server after Migration to V4 MoP
[Archive] Issue Starting up Auth and world server after Migration to V4 MoP
Original source
Getting this error when i start up my auth server
(EDIT) IF YOU GET THIS ERROR GO HERE AND FOLLOW STEPS 12 AND 13!!!!!!!!!!!
[GUIDE] How to migrate accounts & characters to latest VIP Version /Save accs & chars
[GUIDE] How to migrate accounts & characters to latest VIP Version /Save accs & chars This guide shows you the exact steps to save your characters and accounts from a previous version of Emucoach Cataclysm Repack, for example the free version or an older VIP version, to the newest offered VIP...
![[Image: ec-favicon.png]](https://www.emucoach.com/forums/ec-favicon.png)
www.emucoach.com
Using configuration file authserver.conf.
OpenSSL 1.1.1n 15 Mar 2022 (Library: OpenSSL 1.1.1s 1 Nov 2022)
Opening DatabasePool 'mop_auth'. Asynchronous connections: 1, synchronous connections: 1.
MySQL client library: 5.6.17
MySQL server ver: 5.5.9-log
Connected to MySQL database at 127.0.0.1
In mysql_stmt_prepare() id: 71, sql: "SELECT ba.id, UPPER(ba.email), ba.last_ip, ba.failed_logins, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, bab.unbandate = bab.bandate, ba.sha_pass_hash, ba.v, ba.s, a.id, a.username, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, ab.unbandate = ab.bandate, aa.gmlevel FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account a ON ba.member_id = a.member_id LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID = -1 WHERE ba.email = ?"
Unknown column 'ba.member_id' in 'on clause'
In mysql_stmt_prepare() id: 74, sql: "SELECT ba.id, UPPER(ba.email), ba.last_ip, ba.failed_logins, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, bab.unbandate = bab.bandate, ba.sessionKey, a.id, a.username, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, ab.unbandate = ab.bandate, aa.gmlevel FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account a ON ba.member_id = a.member_id LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID = -1 WHERE ba.email = ? AND a.username = ?"
Unknown column 'ba.member_id' in 'on clause'
In mysql_stmt_prepare() id: 89, sql: "REPLACE INTO member_settings (member_id, setting, value) VALUES (?, ?, ?)"
Table 'mop_auth.member_settings' doesn't exist
In mysql_stmt_prepare() id: 90, sql: "DELETE FROM member_settings WHERE member_id = ? AND setting = ?"
Table 'mop_auth.member_settings' doesn't exist
In mysql_stmt_prepare() id: 92, sql: "INSERT INTO member_rewards (member_id, character_guid, account_id, realmid, source_type, source_id, reward_amount, reward_date, reward_day) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"
Table 'mop_auth.member_rewards' doesn't exist
MySQL client library: 5.6.17
MySQL server ver: 5.5.9-log
Connected to MySQL database at 127.0.0.1
In mysql_stmt_prepare() id: 0, sql: "SELECT id, shortname, address, port, icon, flag, timezone, allowedSecurityLevel, population, gamebuild FROM realmlist WHERE flag <> 3 ORDER BY name"
Unknown column 'shortname' in 'field list'
In mysql_stmt_prepare() id: 1, sql: "SELECT shortname FROM realmlist WHERE id = ?"
Unknown column 'shortname' in 'field list'
In mysql_stmt_prepare() id: 21, sql: "SELECT id, username FROM account WHERE hwid = ?"
Unknown column 'hwid' in 'where clause'
In mysql_stmt_prepare() id: 56, sql: "SELECT a.username, aa.gmlevel, a.email, a.last_ip, DATE_FORMAT(a.last_login, '%Y-%m-%d %T'), a.mutetime, a.failed_logins, a.locked, a.OS, a.hwid, ba.email, a.online_mute_timer, a.active_mute_id FROM account a LEFT JOIN account_access aa ON (a.id = aa.id AND (aa.RealmID = ? OR aa.RealmID = -1)) LEFT JOIN battlenet_accounts ba ON a.member_id = ba.member_id WHERE a.id = ?"
Unknown column 'a.hwid' in 'field list'
In mysql_stmt_prepare() id: 67, sql: "SELECT id, weight, text FROM autobroadcast WHERE realmid = ? OR realmid = -1"
Unknown column 'weight' in 'field list'
In mysql_stmt_prepare() id: 86, sql: "SELECT unsetdate FROM member_premiums WHERE (member_id = ? OR member_id = 0) AND active = 1 ORDER BY unsetdate DESC"
Table 'mop_auth.member_premiums' doesn't exist
In mysql_stmt_prepare() id: 87, sql: "SELECT 1 FROM account WHERE member_id = ? AND verified LIMIT 1"
Unknown column 'member_id' in 'where clause'
In mysql_stmt_prepare() id: 88, sql: "SELECT setting, value FROM member_settings WHERE member_id = ?"
Table 'mop_auth.member_settings' doesn't exist
In mysql_stmt_prepare() id: 91, sql: "SELECT source_id FROM member_rewards WHERE member_id = ? AND source_type = ? AND reward_day = ? AND realmid = ?"
Table 'mop_auth.member_rewards' doesn't exist
DatabasePool mop_auth NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to database
rektbyfaith
11-04-2025, 05:11 PM #1Archived author: Gnarlsbarkly • Posted: 2025-11-04T18:11:13.069544
Original source
Getting this error when i start up my auth server
(EDIT) IF YOU GET THIS ERROR GO HERE AND FOLLOW STEPS 12 AND 13!!!!!!!!!!!
[GUIDE] How to migrate accounts & characters to latest VIP Version /Save accs & chars
[GUIDE] How to migrate accounts & characters to latest VIP Version /Save accs & chars This guide shows you the exact steps to save your characters and accounts from a previous version of Emucoach Cataclysm Repack, for example the free version or an older VIP version, to the newest offered VIP...
www.emucoach.com
Using configuration file authserver.conf.
OpenSSL 1.1.1n 15 Mar 2022 (Library: OpenSSL 1.1.1s 1 Nov 2022)
Opening DatabasePool 'mop_auth'. Asynchronous connections: 1, synchronous connections: 1.
MySQL client library: 5.6.17
MySQL server ver: 5.5.9-log
Connected to MySQL database at 127.0.0.1
In mysql_stmt_prepare() id: 71, sql: "SELECT ba.id, UPPER(ba.email), ba.last_ip, ba.failed_logins, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, bab.unbandate = bab.bandate, ba.sha_pass_hash, ba.v, ba.s, a.id, a.username, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, ab.unbandate = ab.bandate, aa.gmlevel FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account a ON ba.member_id = a.member_id LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID = -1 WHERE ba.email = ?"
Unknown column 'ba.member_id' in 'on clause'
In mysql_stmt_prepare() id: 74, sql: "SELECT ba.id, UPPER(ba.email), ba.last_ip, ba.failed_logins, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, bab.unbandate = bab.bandate, ba.sessionKey, a.id, a.username, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, ab.unbandate = ab.bandate, aa.gmlevel FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account a ON ba.member_id = a.member_id LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID = -1 WHERE ba.email = ? AND a.username = ?"
Unknown column 'ba.member_id' in 'on clause'
In mysql_stmt_prepare() id: 89, sql: "REPLACE INTO member_settings (member_id, setting, value) VALUES (?, ?, ?)"
Table 'mop_auth.member_settings' doesn't exist
In mysql_stmt_prepare() id: 90, sql: "DELETE FROM member_settings WHERE member_id = ? AND setting = ?"
Table 'mop_auth.member_settings' doesn't exist
In mysql_stmt_prepare() id: 92, sql: "INSERT INTO member_rewards (member_id, character_guid, account_id, realmid, source_type, source_id, reward_amount, reward_date, reward_day) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"
Table 'mop_auth.member_rewards' doesn't exist
MySQL client library: 5.6.17
MySQL server ver: 5.5.9-log
Connected to MySQL database at 127.0.0.1
In mysql_stmt_prepare() id: 0, sql: "SELECT id, shortname, address, port, icon, flag, timezone, allowedSecurityLevel, population, gamebuild FROM realmlist WHERE flag <> 3 ORDER BY name"
Unknown column 'shortname' in 'field list'
In mysql_stmt_prepare() id: 1, sql: "SELECT shortname FROM realmlist WHERE id = ?"
Unknown column 'shortname' in 'field list'
In mysql_stmt_prepare() id: 21, sql: "SELECT id, username FROM account WHERE hwid = ?"
Unknown column 'hwid' in 'where clause'
In mysql_stmt_prepare() id: 56, sql: "SELECT a.username, aa.gmlevel, a.email, a.last_ip, DATE_FORMAT(a.last_login, '%Y-%m-%d %T'), a.mutetime, a.failed_logins, a.locked, a.OS, a.hwid, ba.email, a.online_mute_timer, a.active_mute_id FROM account a LEFT JOIN account_access aa ON (a.id = aa.id AND (aa.RealmID = ? OR aa.RealmID = -1)) LEFT JOIN battlenet_accounts ba ON a.member_id = ba.member_id WHERE a.id = ?"
Unknown column 'a.hwid' in 'field list'
In mysql_stmt_prepare() id: 67, sql: "SELECT id, weight, text FROM autobroadcast WHERE realmid = ? OR realmid = -1"
Unknown column 'weight' in 'field list'
In mysql_stmt_prepare() id: 86, sql: "SELECT unsetdate FROM member_premiums WHERE (member_id = ? OR member_id = 0) AND active = 1 ORDER BY unsetdate DESC"
Table 'mop_auth.member_premiums' doesn't exist
In mysql_stmt_prepare() id: 87, sql: "SELECT 1 FROM account WHERE member_id = ? AND verified LIMIT 1"
Unknown column 'member_id' in 'where clause'
In mysql_stmt_prepare() id: 88, sql: "SELECT setting, value FROM member_settings WHERE member_id = ?"
Table 'mop_auth.member_settings' doesn't exist
In mysql_stmt_prepare() id: 91, sql: "SELECT source_id FROM member_rewards WHERE member_id = ? AND source_type = ? AND reward_day = ? AND realmid = ?"
Table 'mop_auth.member_rewards' doesn't exist
DatabasePool mop_auth NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to database
Original source
Hi there, I am having this same issue.
Does anyone have any information on this?
Starting up EmuCoach MoP Repack - Authserver
Support, Updates & Information can get found at - www.emucoach.com
Currently running: EmuCoach MoP Repack v3 - PAID VERSION
EmuCoach - World of Warcraft Emulation Forum, providing MoP and Cataclysm repacks!
Using configuration file authserver.conf.
OpenSSL 1.1.1n 15 Mar 2022 (Library: OpenSSL 1.1.0k 28 May 2019)
Opening DatabasePool 'mop_auth'. Asynchronous connections: 1, synchronous connections: 1.
MySQL client library: 5.6.17
MySQL server ver: 5.5.9-log
Connected to MySQL database at 127.0.0.1
In mysql_stmt_prepare() id: 71, sql: "SELECT ba.id, UPPER(ba.email), ba.last_ip, ba.failed_logins, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, bab.unbandate = bab.bandate, ba.sha_pass_hash, ba.v, ba.s, a.id, a.username, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, ab.unbandate = ab.bandate, aa.gmlevel FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account a ON ba.emucoach_member_id = a.emucoach_member_id LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID = -1 WHERE ba.email = ?"
Unknown column 'ba.emucoach_member_id' in 'on clause'
In mysql_stmt_prepare() id: 74, sql: "SELECT ba.id, UPPER(ba.email), ba.last_ip, ba.failed_logins, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, bab.unbandate = bab.bandate, ba.sessionKey, a.id, a.username, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, ab.unbandate = ab.bandate, aa.gmlevel FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account a ON ba.emucoach_member_id = a.emucoach_member_id LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID = -1 WHERE ba.email = ? AND a.username = ?"
Unknown column 'ba.emucoach_member_id' in 'on clause'
MySQL client library: 5.6.17
MySQL server ver: 5.5.9-log
Connected to MySQL database at 127.0.0.1
In mysql_stmt_prepare() id: 0, sql: "SELECT id, emucoach_shortname, address, port, icon, flag, timezone, allowedSecurityLevel, population, gamebuild FROM realmlist WHERE flag <> 3 ORDER BY name"
Unknown column 'emucoach_shortname' in 'field list'
In mysql_stmt_prepare() id: 1, sql: "SELECT emucoach_shortname FROM realmlist WHERE id = ?"
Unknown column 'emucoach_shortname' in 'field list'
In mysql_stmt_prepare() id: 21, sql: "SELECT id, username FROM account WHERE emucoach_hwid = ?"
Unknown column 'emucoach_hwid' in 'where clause'
In mysql_stmt_prepare() id: 56, sql: "SELECT a.username, aa.gmlevel, a.email, a.last_ip, DATE_FORMAT(a.last_login, '%Y-%m-%d %T'), a.mutetime, a.failed_logins, a.locked, a.OS, a.emucoach_hwid, ba.email, a.online_mute_timer, a.active_mute_id FROM account a LEFT JOIN account_access aa ON (a.id = aa.id AND (aa.RealmID = ? OR aa.RealmID = -1)) LEFT JOIN battlenet_accounts ba ON a.emucoach_member_id = ba.emucoach_member_id WHERE a.id = ?"
Unknown column 'a.emucoach_hwid' in 'field list'
In mysql_stmt_prepare() id: 67, sql: "SELECT id, schedule, text FROM autobroadcast WHERE realmid = ? OR realmid = -1"
Unknown column 'schedule' in 'field list'
DatabasePool mop_auth NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to database
rektbyfaith
11-04-2025, 05:11 PM #2Archived author: Gnarlsbarkly • Posted: 2025-11-04T18:11:13.069544
Original source
Hi there, I am having this same issue.
Does anyone have any information on this?
Starting up EmuCoach MoP Repack - Authserver
Support, Updates & Information can get found at - www.emucoach.com
Currently running: EmuCoach MoP Repack v3 - PAID VERSION
EmuCoach - World of Warcraft Emulation Forum, providing MoP and Cataclysm repacks!
Using configuration file authserver.conf.
OpenSSL 1.1.1n 15 Mar 2022 (Library: OpenSSL 1.1.0k 28 May 2019)
Opening DatabasePool 'mop_auth'. Asynchronous connections: 1, synchronous connections: 1.
MySQL client library: 5.6.17
MySQL server ver: 5.5.9-log
Connected to MySQL database at 127.0.0.1
In mysql_stmt_prepare() id: 71, sql: "SELECT ba.id, UPPER(ba.email), ba.last_ip, ba.failed_logins, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, bab.unbandate = bab.bandate, ba.sha_pass_hash, ba.v, ba.s, a.id, a.username, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, ab.unbandate = ab.bandate, aa.gmlevel FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account a ON ba.emucoach_member_id = a.emucoach_member_id LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID = -1 WHERE ba.email = ?"
Unknown column 'ba.emucoach_member_id' in 'on clause'
In mysql_stmt_prepare() id: 74, sql: "SELECT ba.id, UPPER(ba.email), ba.last_ip, ba.failed_logins, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, bab.unbandate = bab.bandate, ba.sessionKey, a.id, a.username, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, ab.unbandate = ab.bandate, aa.gmlevel FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account a ON ba.emucoach_member_id = a.emucoach_member_id LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID = -1 WHERE ba.email = ? AND a.username = ?"
Unknown column 'ba.emucoach_member_id' in 'on clause'
MySQL client library: 5.6.17
MySQL server ver: 5.5.9-log
Connected to MySQL database at 127.0.0.1
In mysql_stmt_prepare() id: 0, sql: "SELECT id, emucoach_shortname, address, port, icon, flag, timezone, allowedSecurityLevel, population, gamebuild FROM realmlist WHERE flag <> 3 ORDER BY name"
Unknown column 'emucoach_shortname' in 'field list'
In mysql_stmt_prepare() id: 1, sql: "SELECT emucoach_shortname FROM realmlist WHERE id = ?"
Unknown column 'emucoach_shortname' in 'field list'
In mysql_stmt_prepare() id: 21, sql: "SELECT id, username FROM account WHERE emucoach_hwid = ?"
Unknown column 'emucoach_hwid' in 'where clause'
In mysql_stmt_prepare() id: 56, sql: "SELECT a.username, aa.gmlevel, a.email, a.last_ip, DATE_FORMAT(a.last_login, '%Y-%m-%d %T'), a.mutetime, a.failed_logins, a.locked, a.OS, a.emucoach_hwid, ba.email, a.online_mute_timer, a.active_mute_id FROM account a LEFT JOIN account_access aa ON (a.id = aa.id AND (aa.RealmID = ? OR aa.RealmID = -1)) LEFT JOIN battlenet_accounts ba ON a.emucoach_member_id = ba.emucoach_member_id WHERE a.id = ?"
Unknown column 'a.emucoach_hwid' in 'field list'
In mysql_stmt_prepare() id: 67, sql: "SELECT id, schedule, text FROM autobroadcast WHERE realmid = ? OR realmid = -1"
Unknown column 'schedule' in 'field list'
DatabasePool mop_auth NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to database
Original source
@Gnarlsbarkly did you make any progress?
rektbyfaith
11-04-2025, 05:11 PM #3Archived author: Gnarlsbarkly • Posted: 2025-11-04T18:11:13.069544
Original source
@Gnarlsbarkly did you make any progress?
Original source
Quote:Sikuri said:yes go here https://www.emucoach.com/forums/thr...s-to-latest-vip-version-save-accs-chars.6562/
@Gnarlsbarkly did you make any progress?
Click to expand...
and follow steps 12 and 13. worked for me
![[Image: 1f642.png]](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
rektbyfaith
11-04-2025, 05:11 PM #4Archived author: Gnarlsbarkly • Posted: 2025-11-04T18:11:13.069544
Original source
Quote:Sikuri said:yes go here https://www.emucoach.com/forums/thr...s-to-latest-vip-version-save-accs-chars.6562/
@Gnarlsbarkly did you make any progress?
Click to expand...
and follow steps 12 and 13. worked for me
Original source
Quote:Gnarlsbarkly said:could you maybe explain like im five how to execute it into the database? is there just a setting/tab/option in heidisql that just says "execute"? im really hung up on the execute it part im just not sure where to/how to enter those last steps and i think im just over complicating things at this point
yes go here https://www.emucoach.com/forums/thr...s-to-latest-vip-version-save-accs-chars.6562/
and follow steps 12 and 13. worked for me
Click to expand...
Cheers!
rektbyfaith
11-04-2025, 05:11 PM #5Archived author: Gnarlsbarkly • Posted: 2025-11-04T18:11:13.069544
Original source
Quote:Gnarlsbarkly said:could you maybe explain like im five how to execute it into the database? is there just a setting/tab/option in heidisql that just says "execute"? im really hung up on the execute it part im just not sure where to/how to enter those last steps and i think im just over complicating things at this point
yes go here https://www.emucoach.com/forums/thr...s-to-latest-vip-version-save-accs-chars.6562/
and follow steps 12 and 13. worked for me
Click to expand...
Cheers!
Original source
Yeap, Step 12 and 13 are necessary to save the chars and accounts.
@reptargx97 - You paste the SQL into the editor and play on the "Play" icon at the top left
The one that is greyed out
rektbyfaith
11-04-2025, 05:11 PM #6Archived author: Gnarlsbarkly • Posted: 2025-11-04T18:11:13.069544
Original source
Yeap, Step 12 and 13 are necessary to save the chars and accounts.
@reptargx97 - You paste the SQL into the editor and play on the "Play" icon at the top left
The one that is greyed out
Original source
Quote:ExO said:I knew i was just overlooking something! Thanks!
Yeap, Step 12 and 13 are necessary to save the chars and accounts.
@reptargx97 - You paste the SQL into the editor and play on the "Play" icon at the top left
View attachment 2683
The one that is greyed
Click to expand...
rektbyfaith
11-04-2025, 05:11 PM #7Archived author: Gnarlsbarkly • Posted: 2025-11-04T18:11:13.069544
Original source
Quote:ExO said:I knew i was just overlooking something! Thanks!
Yeap, Step 12 and 13 are necessary to save the chars and accounts.
@reptargx97 - You paste the SQL into the editor and play on the "Play" icon at the top left
View attachment 2683
The one that is greyed
Click to expand...
1 Guest(s)
1 Guest(s)