[DiscordArchive] Is there a username/password?
[DiscordArchive] Is there a username/password?
Original source
Is there a username/password?
rektbyfaith
02-10-2025, 07:56 PM #1Archived author: aloehart • Posted: 2025-02-10T19:56:55.639000+00:00
Original source
Is there a username/password?
Original source
For the db itself that is
rektbyfaith
02-10-2025, 07:57 PM #2Archived author: aloehart • Posted: 2025-02-10T19:57:03.171000+00:00
Original source
For the db itself that is
Original source
found it
rektbyfaith
02-10-2025, 08:01 PM #3Archived author: aloehart • Posted: 2025-02-10T20:01:36.318000+00:00
Original source
found it
Original source
Sorry for the delay. Trying to post a complete list but copy pasting it is uploading a text file.
message.txt
rektbyfaith
02-10-2025, 08:07 PM #4Archived author: aloehart • Posted: 2025-02-10T20:07:50.232000+00:00
Original source
Sorry for the delay. Trying to post a complete list but copy pasting it is uploading a text file.
message.txt
Original source
And for better info (just logged into discord on the system I'm ssh'ing with) here's the container log for ac-db-import
Updating Auth database...
>> Auth database is up-to-date! Containing 4 new and 1 archived updates.
ERROR 1146 (42S02) at line 17 in file: '/azerothcore/data/sql/updates/db_world/2024_12_18_00.sql': Table 'acore_world.smart_scripts' doesn't exist
Applying of file '/azerothcore/data/sql/updates/db_world/2024_12_18_00.sql' to database 'acore_world' failed! If you are a user, please pull the latest revision from the repository. Also make sure you have not applied any of the databases with your sql client. You cannot use auto-update system and import sql files from AzerothCore repository with your sql client. If you are a developer, please fix your sql query.
Could not update the World database, see log for details.
rektbyfaith
02-10-2025, 08:10 PM #5Archived author: aloehart • Posted: 2025-02-10T20:10:38.201000+00:00
Original source
And for better info (just logged into discord on the system I'm ssh'ing with) here's the container log for ac-db-import
Updating Auth database...
>> Auth database is up-to-date! Containing 4 new and 1 archived updates.
ERROR 1146 (42S02) at line 17 in file: '/azerothcore/data/sql/updates/db_world/2024_12_18_00.sql': Table 'acore_world.smart_scripts' doesn't exist
Applying of file '/azerothcore/data/sql/updates/db_world/2024_12_18_00.sql' to database 'acore_world' failed! If you are a user, please pull the latest revision from the repository. Also make sure you have not applied any of the databases with your sql client. You cannot use auto-update system and import sql files from AzerothCore repository with your sql client. If you are a developer, please fix your sql query.
Could not update the World database, see log for details.
Original source
And just to note I did pull the latest after getting this message. I've wiped and started fresh with this process 6 or so times, trying different things. I'm guessing there's supposed to be a smart_scripts table and that's missing.
rektbyfaith
02-10-2025, 08:11 PM #6Archived author: aloehart • Posted: 2025-02-10T20:11:55.423000+00:00
Original source
And just to note I did pull the latest after getting this message. I've wiped and started fresh with this process 6 or so times, trying different things. I'm guessing there's supposed to be a smart_scripts table and that's missing.
Original source
The table is indeed missing! Perhaps try to create it manually with:
```
CREATE TABLE `smart_scripts` (
`entryorguid` int NOT NULL,
`source_type` tinyint unsigned NOT NULL DEFAULT '0',
`id` smallint unsigned NOT NULL DEFAULT '0',
`link` smallint unsigned NOT NULL DEFAULT '0',
`event_type` tinyint unsigned NOT NULL DEFAULT '0',
`event_phase_mask` smallint unsigned NOT NULL DEFAULT '0',
`event_chance` tinyint unsigned NOT NULL DEFAULT '100',
`event_flags` smallint unsigned NOT NULL DEFAULT '0',
`event_param1` int unsigned NOT NULL DEFAULT '0',
`event_param2` int unsigned NOT NULL DEFAULT '0',
`event_param3` int unsigned NOT NULL DEFAULT '0',
`event_param4` int unsigned NOT NULL DEFAULT '0',
`event_param5` int unsigned NOT NULL DEFAULT '0',
`event_param6` int unsigned NOT NULL DEFAULT '0',
`action_type` tinyint unsigned NOT NULL DEFAULT '0',
`action_param1` int unsigned NOT NULL DEFAULT '0',
`action_param2` int unsigned NOT NULL DEFAULT '0',
`action_param3` int unsigned NOT NULL DEFAULT '0',
`action_param4` int unsigned NOT NULL DEFAULT '0',
`action_param5` int unsigned NOT NULL DEFAULT '0',
`action_param6` int unsigned NOT NULL DEFAULT '0',
`target_type` tinyint unsigned NOT NULL DEFAULT '0',
`target_param1` int unsigned NOT NULL DEFAULT '0',
`target_param2` int unsigned NOT NULL DEFAULT '0',
`target_param3` int unsigned NOT NULL DEFAULT '0',
`target_param4` int unsigned NOT NULL DEFAULT '0',
`target_x` float NOT NULL DEFAULT '0',
`target_y` float NOT NULL DEFAULT '0',
`target_z` float NOT NULL DEFAULT '0',
`target_o` float NOT NULL DEFAULT '0',
`comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Event Comment',
PRIMARY KEY (`entryorguid`,`source_type`,`id`,`link`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
```
rektbyfaith
02-10-2025, 08:19 PM #7Archived author: metallinos • Posted: 2025-02-10T20:19:49.377000+00:00
Original source
The table is indeed missing! Perhaps try to create it manually with:
```
CREATE TABLE `smart_scripts` (
`entryorguid` int NOT NULL,
`source_type` tinyint unsigned NOT NULL DEFAULT '0',
`id` smallint unsigned NOT NULL DEFAULT '0',
`link` smallint unsigned NOT NULL DEFAULT '0',
`event_type` tinyint unsigned NOT NULL DEFAULT '0',
`event_phase_mask` smallint unsigned NOT NULL DEFAULT '0',
`event_chance` tinyint unsigned NOT NULL DEFAULT '100',
`event_flags` smallint unsigned NOT NULL DEFAULT '0',
`event_param1` int unsigned NOT NULL DEFAULT '0',
`event_param2` int unsigned NOT NULL DEFAULT '0',
`event_param3` int unsigned NOT NULL DEFAULT '0',
`event_param4` int unsigned NOT NULL DEFAULT '0',
`event_param5` int unsigned NOT NULL DEFAULT '0',
`event_param6` int unsigned NOT NULL DEFAULT '0',
`action_type` tinyint unsigned NOT NULL DEFAULT '0',
`action_param1` int unsigned NOT NULL DEFAULT '0',
`action_param2` int unsigned NOT NULL DEFAULT '0',
`action_param3` int unsigned NOT NULL DEFAULT '0',
`action_param4` int unsigned NOT NULL DEFAULT '0',
`action_param5` int unsigned NOT NULL DEFAULT '0',
`action_param6` int unsigned NOT NULL DEFAULT '0',
`target_type` tinyint unsigned NOT NULL DEFAULT '0',
`target_param1` int unsigned NOT NULL DEFAULT '0',
`target_param2` int unsigned NOT NULL DEFAULT '0',
`target_param3` int unsigned NOT NULL DEFAULT '0',
`target_param4` int unsigned NOT NULL DEFAULT '0',
`target_x` float NOT NULL DEFAULT '0',
`target_y` float NOT NULL DEFAULT '0',
`target_z` float NOT NULL DEFAULT '0',
`target_o` float NOT NULL DEFAULT '0',
`comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Event Comment',
PRIMARY KEY (`entryorguid`,`source_type`,`id`,`link`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
```
Original source
You want to head down to the loggers specifically, so search for "appender config" and "logger config", that's where the comments are
rektbyfaith
02-10-2025, 08:21 PM #8Archived author: metallinos • Posted: 2025-02-10T20:21:42.077000+00:00
Original source
You want to head down to the loggers specifically, so search for "appender config" and "logger config", that's where the comments are
Original source
Tried it, now there's another missing table. So if I understand correctly, it should be going through the data/sql/base/db_world and create everything, then data/sql/updates/db_world/updates and go through applying various updates. Is that how it works?
rektbyfaith
02-10-2025, 08:25 PM #9Archived author: aloehart • Posted: 2025-02-10T20:25:06.948000+00:00
Original source
Tried it, now there's another missing table. So if I understand correctly, it should be going through the data/sql/base/db_world and create everything, then data/sql/updates/db_world/updates and go through applying various updates. Is that how it works?
Original source
yes
rektbyfaith
02-10-2025, 08:25 PM #10Archived author: Kitzunu • Posted: 2025-02-10T20:25:33.713000+00:00
Original source
yes
1 Guest(s)
1 Guest(s)