Jump to content
  • 0

Error please help me


Dev Blaze

Question


  • Group:  Members
  • Topic Count:  68
  • Topics Per Day:  0.02
  • Content Count:  212
  • Reputation:   5
  • Joined:  01/24/12
  • Last Seen:  

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', '')
 
 
Link to comment
Share on other sites

3 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  21
  • Topics Per Day:  0.00
  • Content Count:  244
  • Reputation:   17
  • Joined:  11/19/11
  • Last Seen:  

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 by Microsoft
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  308
  • Reputation:   24
  • Joined:  11/26/12
  • Last Seen:  

same to my server file

 

/panic

[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 by Emistry
changed to code bbcode.
Link to comment
Share on other sites


  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10015
  • Reputation:   2348
  • Joined:  10/28/11
  • Last Seen:  

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...