Guild Creation DB Error
My players can make guilds and invite others. They need to zone or relog to get it to register them or their bots, but this keeps popping up on the GM account and I cannot figure it out for the life of me.
https://i.ibb.co/9Gqk6nP/Guild-Error.png The guild windows aren't populating and some of the guild features aren't working but they do seem to be forming correctly and added the players to the database. I assume something is missing from the database tables but I wouldn't know where or what to add as the current table for guilds seems populated correctly. Thoughts? |
|
Quote:
These columns already exist in the database for character_data. |
Ok, so that is bots. Looks like the deleted_at would need to apply to those tables/views.
|
Quote:
My understanding is that the table "vw_bot_character_mobs" is missing the "deleted_at" column. Running the following should fix this? Code:
ALTER TABLE `vw_bot_character_mobs` ADD COLUMN `deleted_at` datetime NULL DEFAULT NULL; |
Quote:
|
I don't run bots, but it looks like those two views. Adding that column wouldn't break anything.
|
Quote:
My database has 4 tables under this heading "vw_bot_character_mobs", "vw_bot_groups", "vw_groups", and "vw_guild_members". You only need to add the deleted_at to "vw_bot_character_mobs". |
Quote:
I am under the impression that the view pulls that information from the table. When I attempted to add the 'deleted_at' to the 'vw_bot_character_mobs' view it told me it couldn't add it. I was going to add 'deleted_at' to the 'bot_data' table as it seems that is where it's pulling the info from. Either I'm trying to add it to the wrong location or I'm using the wrong syntax to edit the view. I appreciate the hell out of the information and help you're all providing! |
All times are GMT -4. The time now is 01:00 PM. |
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.