[MySQL] INSERT INTO users error

Hello,
I recently made a server and I’m getting these errors in my mysql database, im not sure what resource is causing it.
If anyone came across this errors any help would be appreciated.
Thanks.

[ERROR] [MySQL] An error happens on MySQL for query "INSERT INTO users (accounts, identifier) VALUES (@accounts, @identifier) {@identifier=ca3ccedf11b862e9da555cdd297c605902131e04;@accounts={"bank":50000}}": Unknown column 'accounts' in 'field list'
[ERROR] [MySQL] An error happens on MySQL for query "UPDATE `user_accounts` SET `identifier` = 'Char1:11000011185b88c' WHERE `identifier` = 'steam:11000011185b88c' {=}": Table 'essentialmode.user_accounts' doesn't exist

It tells you the error… the column doesnts exist and the table doesnt exist. So add the column to the users table and create the user_accounts table. Or import the sqls that came with those resources. You can also use notepad++ or visual studio code to quickly search all your resources for that query to see what resource is trying to insert into those columns/tables

Will try thanks!

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.