gamemaster Error

[Calon]

as i know to make Gm account i must chane on Players table on database group_id to 3- and on accounts table group_id to 3- and account type to 5

but in 8.42 servers i cant find account type on accounts table so i cant make Gm account


what i fix it?

the second error:

my_sql_real<>: INSERT INTO 'server_mote' <'id','world_id,'text'> VALUES <1,0, 'Welcome to Forgotten Server~'>- MYSQL ERROR: Duplicate Entry '1-0' For Key 1 <1062>

 

[muffmo]

u dont have to set it in account, in players is enough.

 

[Calon]

i no understand u

 

[Calon]

aha i changed only in players the group id and still cant use any of commands but i can see action ids such as 04:37 You see a magic forcefield.
ItemID: [1387].
Position: [X: 825] [Y: 791] [Z: 7].

 

[Rexxar]

The

my_sql_real<>: INSERT INTO 'server_mote' <'id','world_id,'text'> VALUES <1,0, 'Welcome to Forgotten Server~'>- MYSQL ERROR: Duplicate Entry '1-0' For Key 1 <1062>

Error is easy to solve, simply go into your mysql and execute the following query:

TRUNCATE TABLE server_mote;

the first question is simple, just change the "group_id" column in the accounts table.