Jump to content
  • 0

SQL Login databse error


donkeyg

Question


  • Group:  Members
  • Topic Count:  344
  • Topics Per Day:  0.08
  • Content Count:  1060
  • Reputation:   1
  • Joined:  02/13/12
  • Last Seen:  

i had move all my eathena files to rathena SVN, but then , i set all the IP inside conf/ files, but it comes out error with this after compile and restart my server.. is it i didnt set anything inside my SQL query?? because i dont know how to executable files, so .. could someone please teach me and tell me the guide? thank you

77346916.jpg

Uploaded with ImageShack.us

87830578.jpg

Uploaded with ImageShack.us

Edited by donkeyg
Link to comment
Share on other sites

5 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  7
  • Topics Per Day:  0.00
  • Content Count:  113
  • Reputation:   5
  • Joined:  06/06/12
  • Last Seen:  

eathena files is pretty much different from rathena files specially when it comes to database, merging them together requires a lot of work not just doing copy and paste.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  344
  • Topics Per Day:  0.08
  • Content Count:  1060
  • Reputation:   1
  • Joined:  02/13/12
  • Last Seen:  

fixed, now the problem is this client crash=.=

asdasdmu.png

Uploaded with ImageShack.us

Edited by donkeyg
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  17
  • Topics Per Day:  0.00
  • Content Count:  382
  • Reputation:   38
  • Joined:  01/17/12
  • Last Seen:  

Seems like you are using a different packet version than the one set in your mmo.h

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  344
  • Topics Per Day:  0.08
  • Content Count:  1060
  • Reputation:   1
  • Joined:  02/13/12
  • Last Seen:  

just modify the src/column/mmo.h right?

now my problem is my player's 4th ~ 6 th slot character missing wat happen?

Edited by donkeyg
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  20
  • Topics Per Day:  0.00
  • Content Count:  213
  • Reputation:   109
  • Joined:  05/21/12
  • Last Seen:  

How many character slots were you using? (prior to rAthena, on eAthena).

Also, do me a favor and run this query on your DB for the account you're logging in with. Post the results after.

USE (databasename);
SELECT * FROM `char` WHERE `account_id` = (the account id you're trying to login with);

Fill in the query () (removing the parenthesis.

In your mmo.h in the [rArootfolder]/src/common/, search for the following line without the // in front of it:

#define PACKETVER

Based on your client version date, you'll need to set the #define PACKETVER. For example, if my client is 20100707 you'd reflect to the following:

#define PACKETVER 20100707

Also, in your packet_db.txt in the [rArootfolder]/db/, what packet_db_ver are you using? This will not have // in front of it.

In the clientinfo.xml either in your client's GRF or /data/ folder, what <version>xx</version> are you using?

Reflect the packet_db.txt and the client <version></version> for me please. Then, update your PACKETVER in mmo.h and make clean/clean build then recompile.

Thanks,

-Cookie

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