Jump to content
  • 0

Upgraded Sql Error


PapaZola

Question


  • Group:  Members
  • Topic Count:  318
  • Topics Per Day:  0.07
  • Content Count:  925
  • Reputation:   32
  • Joined:  12/05/11
  • Last Seen:  

 

: DB error - Unknown column 'bank_vault' in 'field list'
[Debug]: at account_sql.c:558 - SELECT `account_id`,`userid`,`user_pass`,`sex`,`email`,`group_id`,`state`,`unban_time`,`expiration_time`,`loginco                   unt`,`lastlogin`,`last_ip`,`birthdate`,`character_slots`,`pincode`, `pincode_change`, `bank_vault`, `last_mac` FROM `login` WHERE `account_id` =                    1

[Notice]: Unknown account (account: AllStarRO, received pass: WeAreAwesome, ip: 192.184.93.248)

[Notice]: Connection of the char-server 'AllStar RO' 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.

 

anyone can help me?

Link to comment
Share on other sites

5 answers to this question

Recommended Posts


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

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  318
  • Topics Per Day:  0.07
  • Content Count:  925
  • Reputation:   32
  • Joined:  12/05/11
  • Last Seen:  

 

: DB error - Unknown column 'unban_time' in 'field list'
[Debug]: at char.c:1140 - SELECT `char_id`,`char_num`,`name`,`class`,`base_level`,`job_level`,`base_exp`,`job_exp`,`zeny`,`str`,`agi`,`vit`,`int`,`dex`,`luk`,`max_hp`,`hp`,`max_sp`,`sp`,`status_point`,`skill_point`,`option`,`karma`,`manner`,`hair`,`hair_color`,`clothes_color`,`weapon`,`shield`,`head_top`,`head_mid`,`head_bottom`,`last_map`,`rename`,`delete_date`,`robe`,`moves`, `unban_time` FROM `char` WHERE `account_id`='2000024' AND `char_num` < '12'
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:  

ALTER TABLE `char` ADD COLUMN  `unban_time` INT(11) AFTER `moves`;

=='' what you have did to your sql table...why so many stuff missing from your sql table.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  318
  • Topics Per Day:  0.07
  • Content Count:  925
  • Reputation:   32
  • Joined:  12/05/11
  • Last Seen:  

fix thanks emistry

before this im used svn 17072

just update the rathena trunk and i need use my sql backup

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  318
  • Topics Per Day:  0.07
  • Content Count:  925
  • Reputation:   32
  • Joined:  12/05/11
  • Last Seen:  

@emistry i got 1 more error when trying register used _M _F

1k97e4h6gg.png

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...