Jump to content
  • 0

i got a problem after i update my SVN to 17181

secondL

Asked by secondL,

 Share

Question

secondL Poring

secondL

Posted
  • Group:  Members
  • Topic Count:  29
  • Topics Per Day:  0.01
  • Content Count:  155
  • Reputation:   1
  • Joined:  02/03/13
  • Last Seen:  
Posted

please look the some error below :

 

[SQL]: DB error - Unknown column 'character_slots' in 'field list'
[Debug]: at c:\documents and settings\amuro ryuzaki\desktop\exia server\src\logi
n\account_sql.c:528 - SELECT `account_id`,`userid`,`user_pass`,`sex`,`email`,`gr
oup_id`,`state`,`unban_time`,`expiration_time`,`logincount`,`lastlogin`,`last_ip
`,`birthdate`,`character_slots` FROM `login` WHERE `account_id` = 1
[Notice]: Unknown account (account: secondL, received pass: 09185033522, ip: 25.
45.88.50)

[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 user
name/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.

can you help me with these error i got?

Link to comment
Share on other sites

9 answers to this question

Recommended Posts

Lighta Poring

Lighta

Posted
  • Group:  Members
  • Topic Count:  16
  • Topics Per Day:  0.00
  • Content Count:  737
  • Reputation:   216
  • Joined:  11/29/11
  • Last Seen:  
Posted

in cli :

mysql -u youruser -p yourdb < /path/to/my/sqlfile

or in mysql shell :
mysql > use yourdb;
mysql > source /path/to/my/sqlfile
 

both command will load file into <yourdb> executing the query in it thus updating your table. (for visual mode idk, open file take the queryand ask to execute it..)

 

Error 17182, did you have modification on skill.c ?, those constant was remove on last version but he's attempting to use them that why he's failling.
Please fix conflict or accept their-full to flush your file and take svn one. You could reput your mod afterward if so. Or take a quick look at changeset and reproduce the step.
Also make sure your doing a clean build.

  • Upvote 1
Link to comment
Share on other sites
Brynner Metaling

Brynner

Posted
  • Group:  Members
  • Topic Count:  118
  • Topics Per Day:  0.03
  • Content Count:  1942
  • Reputation:   197
  • Joined:  01/08/12
  • Last Seen:  
Posted

update your sql database. upgrade_svn17176.sql and upgrade_svn17178.sql

Link to comment
Share on other sites
secondL Poring

secondL

Posted
  • Group:  Members
  • Topic Count:  29
  • Topics Per Day:  0.01
  • Content Count:  155
  • Reputation:   1
  • Joined:  02/03/13
  • Last Seen:  
  • Author
Posted

update your sql database. upgrade_svn17176.sql and upgrade_svn17178.sql

dude how?

 

i just trace them at these path sql-files/upgrades/upgrade_svn17176 and upgrade_svn171788...then right click then SVN update...correct me if i am wrong

 

then i recompile and it not succeed 3/1

when i recompile i got this error on my visual studio

 

LINK : fatal error LNK1104: cannot open file '..\login-server_sql.exe'
Link to comment
Share on other sites
mofo Poring

mofo

Posted
  • Group:  Members
  • Topic Count:  9
  • Topics Per Day:  0.00
  • Content Count:  69
  • Reputation:   4
  • Joined:  07/02/12
  • Last Seen:  
Posted

execute the sql upgrade in mysql then recompile.

Link to comment
Share on other sites
secondL Poring

secondL

Posted
  • Group:  Members
  • Topic Count:  29
  • Topics Per Day:  0.01
  • Content Count:  155
  • Reputation:   1
  • Joined:  02/03/13
  • Last Seen:  
  • Author
Posted

execute the sql upgrade in mysql then recompile.

aw! when we talking about SQL to be honest i dont have any idea how to execute them

please look at my screenshot

 

 

bump! pls pls pls

bumb pls pls pls pls

another error when i update my svn to 17182

 

when during recompile my svn i got error in visual studio

 

c:\documents and settings\amuro ryuzaki\desktop\exia server\src\map\skill.c(13228): error C2065: 'ST_MH_FIGHTING' : undeclared identifier
c:\documents and settings\amuro ryuzaki\desktop\exia server\src\map\skill.c(13228): error C2051: case expression not constant
c:\documents and settings\amuro ryuzaki\desktop\exia server\src\map\skill.c(13233): error C2065: 'ST_MH_GRAPPLING' : undeclared identifier
c:\documents and settings\amuro ryuzaki\desktop\exia server\src\map\skill.c(13233): error C2051: case expression not constant
c:\documents and settings\amuro ryuzaki\desktop\exia server\src\map\skill.c(17691): error C2065: 'ST_MH_FIGHTING' : undeclared identifier
c:\documents and settings\amuro ryuzaki\desktop\exia server\src\map\skill.c(17692): error C2065: 'ST_MH_GRAPPLING' : undeclared identifier

/sob its become messy now my SVN

post-14794-0-00724400-1362729364_thumb.jpg

Link to comment
Share on other sites
secondL Poring

secondL

Posted
  • Group:  Members
  • Topic Count:  29
  • Topics Per Day:  0.01
  • Content Count:  155
  • Reputation:   1
  • Joined:  02/03/13
  • Last Seen:  
  • Author
Posted

in cli :

mysql -u youruser -p yourdb < /path/to/my/sqlfile

or in mysql shell :

mysql > use yourdb;

mysql > source /path/to/my/sqlfile

 

both command will load file into <yourdb> executing the query in it thus updating your table. (for visual mode idk, open file take the queryand ask to execute it..)

 

Error 17182, did you have modification on skill.c ?, those constant was remove on last version but he's attempting to use them that why he's failling.

Please fix conflict or accept their-full to flush your file and take svn one. You could reput your mod afterward if so. Or take a quick look at changeset and reproduce the step.

Also make sure your doing a clean build.

/sob ok  i will flush my svn away thank you dude...huhuhu

Link to comment
Share on other sites
kyeme Poring

kyeme

Posted
  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  164
  • Reputation:   12
  • Joined:  03/08/12
  • Last Seen:  
Posted

please look the some error below :

 

[SQL]: DB error - Unknown column 'character_slots' in 'field list'
[Debug]: at c:\documents and settings\amuro ryuzaki\desktop\exia server\src\logi
n\account_sql.c:528 - SELECT `account_id`,`userid`,`user_pass`,`sex`,`email`,`gr
oup_id`,`state`,`unban_time`,`expiration_time`,`logincount`,`lastlogin`,`last_ip
`,`birthdate`,`character_slots` FROM `login` WHERE `account_id` = 1
[Notice]: Unknown account (account: secondL, received pass: 09185033522, ip: 25.
45.88.50)

[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 user
name/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.

can you help me with these error i got?

Tip: Always and always check the uprades folder everytime you update your SVN.  :)

Link to comment
Share on other sites
secondL Poring

secondL

Posted
  • Group:  Members
  • Topic Count:  29
  • Topics Per Day:  0.01
  • Content Count:  155
  • Reputation:   1
  • Joined:  02/03/13
  • Last Seen:  
  • Author
Posted

please look the some error below :

 

[SQL]: DB error - Unknown column 'character_slots' in 'field list'
[Debug]: at c:\documents and settings\amuro ryuzaki\desktop\exia server\src\logi
n\account_sql.c:528 - SELECT `account_id`,`userid`,`user_pass`,`sex`,`email`,`gr
oup_id`,`state`,`unban_time`,`expiration_time`,`logincount`,`lastlogin`,`last_ip
`,`birthdate`,`character_slots` FROM `login` WHERE `account_id` = 1
[Notice]: Unknown account (account: secondL, received pass: 09185033522, ip: 25.
45.88.50)

[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 user
name/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.

can you help me with these error i got?

Tip: Always and always check the uprades folder everytime you update your SVN.  :)

how can i know that my upgrades folder are in the right track?....let me think.....if what is SVN latest it should be also latest?

Link to comment
Share on other sites
JiKeidan Poring

JiKeidan

Posted
  • Group:  Members
  • Topic Count:  2
  • Topics Per Day:  0.00
  • Content Count:  34
  • Reputation:   0
  • Joined:  03/08/13
  • Last Seen:  
Posted (edited)

yah, nevermind

Edited by JiKeidan
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.

×
 Share
Go to question listing
×
×
  • Create New...