[DiscordArchive] are there intemediary commits I need to checkout / build / restart to first?
[DiscordArchive] are there intemediary commits I need to checkout / build / restart to first?
Archived author: MrCeeJ • Posted: 2023-02-05T17:03:11.563000+00:00
Original source
Updating World database...
>> World database is up-to-date! Containing 494 new and 3160 archived updates.
In mysql_stmt_prepare() id: 59, sql: "SELECT joinX, joinY, joinZ, joinO, joinMapId, taxiPath, mountSpell FROM character_entry_point WHERE guid = ?"
Unknown column 'taxiPath' in 'field list'
In mysql_stmt_prepare() id: 191, sql: "INSERT INTO character_entry_point (guid, joinX, joinY, joinZ, joinO, joinMapId, taxiPath, mountSpell) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"
Unknown column 'taxiPath' in 'field list'
Closing down DatabasePool 'acore_characters'.
Archived author: Foe • Posted: 2023-02-05T17:04:14.936000+00:00
Original source
Ah, I guess the base isn't updated then
```DROP TABLE IF EXISTS `character_entry_point`;
CREATE TABLE IF NOT EXISTS `character_entry_point` (
`guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
`joinX` float NOT NULL DEFAULT '0',
`joinY` float NOT NULL DEFAULT '0',
`joinZ` float NOT NULL DEFAULT '0',
`joinO` float NOT NULL DEFAULT '0',
`joinMapId` int unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
`taxiPath` int unsigned NOT NULL DEFAULT '0',
`mountSpell` int unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System';```
Archived author: MrCeeJ • Posted: 2023-02-05T17:04:50.914000+00:00
Original source
> RealmID: 1
[1146] Table 'acore_world.version_db_world' doesn't exist
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.
Archived author: MrCeeJ • Posted: 2023-02-05T17:04:57.150000+00:00
Original source
I think my db agrees with you
Archived author: MrCeeJ • Posted: 2023-02-05T17:05:13.790000+00:00
Original source
at least we are making progress, I guess :p
Archived author: Kitzunu • Posted: 2023-02-05T17:05:45.911000+00:00
Original source
the easiest thing you can do, as you have a medieval core to begin with, is to just drop everything and then create chars etc manually.
Archived author: Kitzunu • Posted: 2023-02-05T17:05:59.337000+00:00
Original source
version_db_world this was dropped like a year ago
Archived author: Kitzunu • Posted: 2023-02-05T17:06:05.544000+00:00
Original source
so your core is still outdated
Archived author: Kitzunu • Posted: 2023-02-05T17:06:15.991000+00:00
Original source
since the core is looking for it
Archived author: Foe • Posted: 2023-02-05T17:06:23.217000+00:00
Original source
Are you using the old binary or something?