HELP! [SQL] Unknown column 'group_id' in 'field_list'

[sarahhshabrina]

Help!

I found out this problem appears quite often but don't know how to solve this

I didn't change anything in my userid or password in char_athena, or map_athena, or my SQLaccount.

Here my putty said:

[info]: Attempt to connect to login-server...
[status]: Connecting to 127.0.0.1:6950
[info]: Connection request of the char-server 'Amazon Ragnarok' @ 127.0.0.1:6171
[sql]: DB error - Unknown column 'group_id' in 'field list'
[Debug]: at account_sql.c:528 - SELECT `account_id`,`userid`,`user_pass`,`sex`,`email`,`group_id`,`state`,`unban_time`,`expiration_time`,`logincount`,`lastlogin`,`last_ip`,`birthdate` FROM `login` WHERE `account_id` = 1
[Notice]: Unknown account (account: -, received pass: , ip: 127.0.0.1)
[Notice]: Connection of the char-server 'Amazon Ragnarok' REFUSED.
[Error]: Can not connect to login-server.
[Error]: The server communication passwords (default s1/p1) are probably invalid.
[Error]: Also, please make sure your login db has the correct communication username/passwords and the gender of the account is S.
[Error]: The communication passwords are set in map_athena.conf and char_athena.conf
[Warning]: Connection to Login Server lost.

*i change my ip up above to 127.0.0.1*

char_athena:

// Athena Character configuration file.
// Note: "Comments" are all text on the right side of a double slash "//"
// Whatever text is commented will not be parsed by the servers, and serves
// only as information/reference.
// Server Communication username and password.
userid: s1
passwd: p1
// Server name, use alternative character such as ASCII 160 for spaces.
// NOTE: Do not use spaces in the name, or guild emblems won't work client-side!
server_name: eAthena
// Wisp name for server: used to send wisp from server to players (between 4 to 23 characters)
wisp_server_name: Server
// Login Server IP
// The character server connects to the login server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
//login_ip: 127.0.0.1
// The character server listens on the interface with this IP address.
// NOTE: This allows you to run multiple servers on multiple interfaces
// while using the same ports for each server.
//bind_ip: 127.0.0.1
// Login Server Port
login_port: 6900
// Character Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
//char_ip: 127.0.0.1
// Character Server Port
char_port: 6121

map_athena:

//   Configuration Info  
//--------------------------------------------------------------
// Interserver communication passwords, set in account.txt (or equiv.)
userid: s1
passwd: p1
// Character Server IP
// The map server connects to the character server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
//char_ip: 127.0.0.1
// The map server listens on the interface with this IP address.
// NOTE: This allows you to run multiple servers on multiple interfaces
// while using the same ports for each server.
//bind_ip: 127.0.0.1
// Character Server Port
char_port: 6121
// Map Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
//map_ip: 127.0.0.1
// Map Server Port
map_port: 5121

Can anyone help me?

And what is

: DB error - Unknown column 'group_id' in 'field list' about?

How to solve this?

Edited August 9, 2012 by sarahhshabrina

[Emistry]

it is your SQL Table....

if you are running in eAthena / 3Ceam ...then..nothing we can help you about it..

in rAthena we use Group ID as main and not using GM Level anymore ...

but GM Level still can be configure inside the configuration file.

http://rathena.org/board/topic/58877-r15572-new-gm-commands-permissions-system/

[Lighta]

Just change the colum name of your table. That would be enough to fix that error but you may have other issues like incompatible conf file :

atcomand_athena.conf etc...

Take a look closely at the Emistry link for that.

Anyway for just the sql part do this :

ALTER TABLE `login` CHANGE `level` `group_id` TINYINT( 3 ) NOT NULL DEFAULT '0'