Need help - SQL db error pls thanks

[BabaVoss]

Edited April 29, 2023 by BabaVoss

[BabaVoss]

hello guys i need help on how do i fix this.

how do i make table for this type of error

[shadowscreen]

So the Message in your console prompts, that you try to read a column that doesn't exist in your given table. Maybe check that out.  "Unknown column account_id in field list"

 

Did you fiddle with the SQL?

[Emistry]

the account_id field has been dropped from the guild_member table, unless you rollback the commits that did this, else no point to re-add it since the field wont have value stored there

alternatively, you could just rewrite the SQL to do a INNER JOIN or LEFT JOIN, to get your data.

but since you're not really using .Options & 4 ... I guess its fine if you do the easier way.

find

SELECT account_id,char_id FROM `guild_member`....

and replace into

SELECT account_id,char_id FROM `char`....