Error please help me

[Dev Blaze]

i can't Login my account please ...

 

 

: DB error - Unknown column 'mac' in 'field list'
[Debug]: at loginlog_sql.c:75 - INSERT INTO `loginlog`(`time`,`ip`,`user`,`rcode`,`log`,`mac`) VALUES (NOW(), '0.0.0.0', 'login server', '100', 'login server shutdown', '')

 

 

[Microsoft]

You can see the answer now, that means at the login table (All accounts are in here) the user 'mac' is not exist, it's either deleted.

 

If I am wrong, please provide a screen shot in your login table, if user mac exist then we can answer it in other way.

Edited May 31, 2013 by Microsoft

[chatterboy]

same to my server file

 

[Status]: Memory manager initialised: log/login-server_sql.exe.leaks


                   rAthena Development Team presents
                      ___   __  __
                _____/   | / /_/ /_  ___  ____  ____ _
               / ___/ /| |/ __/ __ \/ _ \/ __ \/ __ `/
              / /  / ___ / /_/ / / /  __/ / / / /_/ /
             /_/  /_/  |_\__/_/ /_/\___/_/ /_/\__,_/

                     http://rathena.org/board/

[Info]: SVN Revision: '17480'
[Info]: Server supports up to '4096' concurrent connections.
[Status]: Harmony Version: 3.3.11
[Harmony]: Harmony is alive.
[Info]: Finished reading conf/msg_conf/login_msg.conf.
[Info]: Finished reading conf/import/inter_conf.txt.
[Info]: Finished reading conf/inter_athena.conf.
[Info]: Finished reading conf/import/login_conf.txt.
[Info]: Finished reading conf/login_athena.conf.
[Status]: The login-server is ready (Server is listening on the port 6935).

[SQL]: DB error - Unknown column 'mac' in 'field list'
[Debug]: at c:\besprenro server file\src\login\loginlog_sql.c:75 - INSERT INTO `
loginlog`(`time`,`ip`,`user`,`rcode`,`log`,`mac`) VALUES (NOW(), '0.0.0.0', 'log
in server', '100', 'login server started', '')
[Info]: Connection request of the char-server 'Kanluran' @ 192.168.0.177:23738 (
account: 'bespren', pass: 'bespren123', ip: '192.168.0.177')
[SQL]: DB error - Unknown column 'mac' in 'field list'
[Debug]: at c:\besprenro server file\src\login\loginlog_sql.c:75 - INSERT INTO `
loginlog`(`time`,`ip`,`user`,`rcode`,`log`,`mac`) VALUES (NOW(), '192.168.0.177'
, 'bespren', '100', 'charserver - [email protected]:23738', '')
[Notice]: Authentication accepted (account: bespren, id: 1, ip: 192.168.0.177)
[Status]: Connection of the char-server 'Kanluran' accepted.

Edited August 29, 2013 by Emistry
changed to code bbcode.

[Emistry]

i believe Harmony should have provided you a file that used to update your SQL table.

find that file and execute it in your database.