[Archive] One auth, two different versioned realms.
[Archive] One auth, two different versioned realms.
Original source
you can run those queries against your auth database to bring in add the missing tables for 3.3.5. The account_banned is still not fixed in these queries because I need the table structure in order determine the cause of the error
rektbyfaith
11-04-2025, 05:17 PM #11Archived author: Bizzycola • Posted: 2025-11-04T18:17:43.983763
Original source
you can run those queries against your auth database to bring in add the missing tables for 3.3.5. The account_banned is still not fixed in these queries because I need the table structure in order determine the cause of the error
Original source
you can run the query against your auth database and it should correct the most of the errors with your 3.3.5 server. I still need the database structure for account_banned in order to write a fix for that one.
Here is a query to grab the structure, run it and let me know the results
Code:
-- Table Description
DESC account_banned;
rektbyfaith
11-04-2025, 05:17 PM #12Archived author: Bizzycola • Posted: 2025-11-04T18:17:43.983763
Original source
you can run the query against your auth database and it should correct the most of the errors with your 3.3.5 server. I still need the database structure for account_banned in order to write a fix for that one.
Here is a query to grab the structure, run it and let me know the results
Code:
-- Table Description
DESC account_banned;
Original source
View attachment flap2.png.
View attachment flap3.png
this is what i get
rektbyfaith
11-04-2025, 05:17 PM #13Archived author: Bizzycola • Posted: 2025-11-04T18:17:43.983763
Original source
View attachment flap2.png.
View attachment flap3.png
this is what i get
Original source
easy fix then
Code:
ALTER TABLE `account_banned` DROP COLUMN `realm`;
rektbyfaith
11-04-2025, 05:17 PM #14Archived author: Bizzycola • Posted: 2025-11-04T18:17:43.983763
Original source
easy fix then
Code:
ALTER TABLE `account_banned` DROP COLUMN `realm`;
Original source
I get these two errors when running the first query.
-- Table: logs_ip_ations (create)
CREATE TABLE logs_ip_actions (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Identifier$
`account_id` int(10) unsigned NOT NULL COMMENT 'Account ID',
`character_guid` int(10) unsigned NOT NULL COMMENT 'Character Guid',
`type` tinyint(3) unsigned NOT NULL,
`ip` varchar(15) NOT NULL DEFAULT '127.0.0.1',
`systemnote` text COMMENT 'Notes inserted by system',
`unixtime` int(10) unsigned NOT NULL COMMENT 'Unixtime',
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Timestamp',
`comment` text COMMENT 'Allows users to add a comment',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Used to log ips of individua$
;
/* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Account ID',
`character_guid` int(10) unsigned NOT NULL COMMENT 'Character Gu' at line 5 */
/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 0 of 1 query: 0.000 sec. */
-- Table: account_muted (create)
CREATE TABLE `account_muted` (
`guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Iden$
`mutedate` int(10) unsigned NOT NULL DEFAULT '0',
`mutetime` int(10) unsigned NOT NULL DEFAULT '0',
`mutedby` varchar(50) NOT NULL,
`mutereason` varchar(255) NOT NULL,
PRIMARY KEY (`guid`,`mutedate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='mute List';;
/* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0',
`mutetime` int(10) unsigned NOT NULL DEFAULT '0',
`mutedby` varchar(50' at line 5 */
/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 0 of 1 query: 0.000 sec. */
rektbyfaith
11-04-2025, 05:17 PM #15Archived author: Bizzycola • Posted: 2025-11-04T18:17:43.983763
Original source
I get these two errors when running the first query.
-- Table: logs_ip_ations (create)
CREATE TABLE logs_ip_actions (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Identifier$
`account_id` int(10) unsigned NOT NULL COMMENT 'Account ID',
`character_guid` int(10) unsigned NOT NULL COMMENT 'Character Guid',
`type` tinyint(3) unsigned NOT NULL,
`ip` varchar(15) NOT NULL DEFAULT '127.0.0.1',
`systemnote` text COMMENT 'Notes inserted by system',
`unixtime` int(10) unsigned NOT NULL COMMENT 'Unixtime',
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Timestamp',
`comment` text COMMENT 'Allows users to add a comment',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Used to log ips of individua$
;
/* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Account ID',
`character_guid` int(10) unsigned NOT NULL COMMENT 'Character Gu' at line 5 */
/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 0 of 1 query: 0.000 sec. */
-- Table: account_muted (create)
CREATE TABLE `account_muted` (
`guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Iden$
`mutedate` int(10) unsigned NOT NULL DEFAULT '0',
`mutetime` int(10) unsigned NOT NULL DEFAULT '0',
`mutedby` varchar(50) NOT NULL,
`mutereason` varchar(255) NOT NULL,
PRIMARY KEY (`guid`,`mutedate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='mute List';;
/* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0',
`mutetime` int(10) unsigned NOT NULL DEFAULT '0',
`mutedby` varchar(50' at line 5 */
/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 0 of 1 query: 0.000 sec. */
Original source
Silly me, pasting from terminal is bad (and I know that too.. )
Here is the fixed version (all fixes)
Code:
-- Table: account (fixes)
ALTER TABLE account
ADD COLUMN `lock_country` varchar(2) NOT NULL DEFAULT '00' AFTER `locked`,
ADD COLUMN `reg_mail` varchar(255) NOT NULL DEFAULT '' AFTER `email`,
ADD COLUMN `last_attempt_ip` varchar(15) NOT NULL DEFAULT '127.0.0.1' AFTER `last_ip`;
-- Table: account_banned (fix)
ALTER TABLE `account_banned` DROP COLUMN `realm`;
-- Table: logs_ip_actions (create)
CREATE TABLE logs_ip_actions (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Identifier',
`account_id` int(10) unsigned NOT NULL COMMENT 'Account ID',
`character_guid` int(10) unsigned NOT NULL COMMENT 'Character Guid',
`type` tinyint(3) unsigned NOT NULL,
`ip` varchar(15) NOT NULL DEFAULT '127.0.0.1',
`systemnote` text COMMENT 'Notes inserted by system',
`unixtime` int(10) unsigned NOT NULL COMMENT 'Unixtime',
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Timestamp',
`comment` text COMMENT 'Allows users to add a comment',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Used to log ips of individuals';
-- Table: account_muted (create)
CREATE TABLE `account_muted` (
`guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
`mutedate` int(10) unsigned NOT NULL DEFAULT '0',
`mutetime` int(10) unsigned NOT NULL DEFAULT '0',
`mutedby` varchar(50) NOT NULL,
`mutereason` varchar(255) NOT NULL,
PRIMARY KEY (`guid`,`mutedate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='mute List';
My apologies for the error..
rektbyfaith
11-04-2025, 05:17 PM #16Archived author: Bizzycola • Posted: 2025-11-04T18:17:43.983763
Original source
Silly me, pasting from terminal is bad (and I know that too.. )
Here is the fixed version (all fixes)
Code:
-- Table: account (fixes)
ALTER TABLE account
ADD COLUMN `lock_country` varchar(2) NOT NULL DEFAULT '00' AFTER `locked`,
ADD COLUMN `reg_mail` varchar(255) NOT NULL DEFAULT '' AFTER `email`,
ADD COLUMN `last_attempt_ip` varchar(15) NOT NULL DEFAULT '127.0.0.1' AFTER `last_ip`;
-- Table: account_banned (fix)
ALTER TABLE `account_banned` DROP COLUMN `realm`;
-- Table: logs_ip_actions (create)
CREATE TABLE logs_ip_actions (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Identifier',
`account_id` int(10) unsigned NOT NULL COMMENT 'Account ID',
`character_guid` int(10) unsigned NOT NULL COMMENT 'Character Guid',
`type` tinyint(3) unsigned NOT NULL,
`ip` varchar(15) NOT NULL DEFAULT '127.0.0.1',
`systemnote` text COMMENT 'Notes inserted by system',
`unixtime` int(10) unsigned NOT NULL COMMENT 'Unixtime',
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Timestamp',
`comment` text COMMENT 'Allows users to add a comment',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Used to log ips of individuals';
-- Table: account_muted (create)
CREATE TABLE `account_muted` (
`guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
`mutedate` int(10) unsigned NOT NULL DEFAULT '0',
`mutetime` int(10) unsigned NOT NULL DEFAULT '0',
`mutedby` varchar(50) NOT NULL,
`mutereason` varchar(255) NOT NULL,
PRIMARY KEY (`guid`,`mutedate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='mute List';
My apologies for the error..
Original source
Thanks for all the help.
I am getting some errors I will try to give details soon.
rektbyfaith
11-04-2025, 05:17 PM #17Archived author: Bizzycola • Posted: 2025-11-04T18:17:43.983763
Original source
Thanks for all the help.
I am getting some errors I will try to give details soon.
Original source
This query seems to cause problems for both 3.3.5 and 4.3.4. Neither will start.
-- Table: account_banned (fix)
ALTER TABLE `account_banned` DROP COLUMN `realm`;
4.3.4 works fine
This is the 3.3.5 error I get without it.
In mysql_stmt_prepare() id: 8, sql: "INSERT INTO account_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban', 1)"
Column count doesn't match value count at row 1
In mysql_stmt_prepare() id: 28, sql: "INSERT INTO account_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)"
Column count doesn't match value count at row 1
rektbyfaith
11-04-2025, 05:17 PM #18Archived author: Bizzycola • Posted: 2025-11-04T18:17:43.983763
Original source
This query seems to cause problems for both 3.3.5 and 4.3.4. Neither will start.
-- Table: account_banned (fix)
ALTER TABLE `account_banned` DROP COLUMN `realm`;
4.3.4 works fine
This is the 3.3.5 error I get without it.
In mysql_stmt_prepare() id: 8, sql: "INSERT INTO account_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban', 1)"
Column count doesn't match value count at row 1
In mysql_stmt_prepare() id: 28, sql: "INSERT INTO account_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)"
Column count doesn't match value count at row 1
Original source
DB errors when I run the query
when I run 4.3.4 auth
EmuCoach V2 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()+?, 'EmuCoach 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
4.3.4 world
In mysql_stmt_prepare() id: 8, sql: "INSERT INTO account_banned VALUES (?, ?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'EmuCoach 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
Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.1c 10 May 2012 (library: OpenSSL 1.0.1h 5 Jun 2014)
Using ACE version: 6.1.4
EmuCoach V2 rev. 0000-00-00 00:00:00 +0000 (Archived) (Win32, Release) (worldserver-daemon)
<Ctrl-C> to stop.
Make sure to visit our forum - www.emucoach.com
EmuCoach Repack 434 - V2
In mysql_stmt_prepare() id: 8, sql: "INSERT INTO account_banned VALUES (?, ?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'EmuCoach 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
DatabasePool auth NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to login database 127.0.0.1;3306;root;ascent;auth
3.3.5 errors
In mysql_stmt_prepare() id: 13, sql: "SELECT a.sha_pass_hash, a.id, a.locked, a.lock_country, a.last_ip, aa.gmlevel, a.v, a.s, a.token_key FROM account a LEFT JOIN account_access aa ON (a.id = aa.id) WHERE a.username = ?"
Unknown column 'a.token_key' in 'field list'
In mysql_stmt_prepare() id: 72, sql: "SELECT id, weight, text FROM autobroadcast WHERE realmid = ? OR realmid = -1"
Table 'auth.autobroadcast' doesn't exist
rektbyfaith
11-04-2025, 05:17 PM #19Archived author: Bizzycola • Posted: 2025-11-04T18:17:43.983763
Original source
DB errors when I run the query
when I run 4.3.4 auth
EmuCoach V2 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()+?, 'EmuCoach 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
4.3.4 world
In mysql_stmt_prepare() id: 8, sql: "INSERT INTO account_banned VALUES (?, ?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'EmuCoach 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
Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.1c 10 May 2012 (library: OpenSSL 1.0.1h 5 Jun 2014)
Using ACE version: 6.1.4
EmuCoach V2 rev. 0000-00-00 00:00:00 +0000 (Archived) (Win32, Release) (worldserver-daemon)
<Ctrl-C> to stop.
Make sure to visit our forum - www.emucoach.com
EmuCoach Repack 434 - V2
In mysql_stmt_prepare() id: 8, sql: "INSERT INTO account_banned VALUES (?, ?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'EmuCoach 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
DatabasePool auth NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to login database 127.0.0.1;3306;root;ascent;auth
3.3.5 errors
In mysql_stmt_prepare() id: 13, sql: "SELECT a.sha_pass_hash, a.id, a.locked, a.lock_country, a.last_ip, aa.gmlevel, a.v, a.s, a.token_key FROM account a LEFT JOIN account_access aa ON (a.id = aa.id) WHERE a.username = ?"
Unknown column 'a.token_key' in 'field list'
In mysql_stmt_prepare() id: 72, sql: "SELECT id, weight, text FROM autobroadcast WHERE realmid = ? OR realmid = -1"
Table 'auth.autobroadcast' doesn't exist
1 Guest(s)
1 Guest(s)