[SQL Syntax errror (New Server)]

What did you do to eliminate the error? I'm having the same error. 

[Help on SQL installation]

5 minutes ago, Cyro said:

Its not loginlog from.logs

Check login table in Ragnarok database

 

Thanks, I cannot find login on the tables only login log. maybe because i got an error when executing main.sql thats why table is not complete. 

This the error i got.

Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`clan_id` int(11) unsigned NOT NULL AUTO_INCREMENT,   `name` varchar(24) NOT NUL' at line 1    0.656 sec
Note: MySqL server version is 5.5

[Help on SQL installation]

I cannot do this step.

"11. Here you'll see existing account information that players can log in with to make characters. If you remember, the first account is the server communication account and it has the default password that you were asked to reset earlier. For our example we chose "FishUser" and "FishPassword". Enter these in the "username" and "password" field. And then create your first GM account by clicking where the word "null" is on the row with a ' * ' and enter "2000000" for the "account_id" field, with a username and password that you like. For this guide we chose a username of "AthenaGM" and a password of "12345" and a sex of "M". To enable full administrator GM, just set the "group_id" to "99". Zero out everything else." 

thanks in advance

[Cmake error on Windows]

Compiling in Windows using ms visual studio 2017 this error appears

 CMake Error at C:\rAthena\rathena\CMakeLists.txt:600 (message):  no targets available        C:\rAthena\rathena\CMakeLists.txt    600   

Severity    Code    Description    Project    File    Line    Suppression State
Warning        CMake Warning (dev) at 3rdparty/mysql/CMakeLists.txt:30 (if):Policy CMP0054 is not set: Only interpret if() arguments as variables or
  keywords when unquoted.  Run "cmake --help-policy CMP0054" for policy
  details.  Use the cmake_policy command to set the policy and suppress this
  warning.

  Quoted variables like "MYSQL_LOCAL_LIBRARIES" will no longer be
  dereferenced when the policy is set to NEW.  Since the policy is not set
  the OLD behavior will be used.
This warning is for project developers.  Use -Wno-dev to suppress it.        C:\rAthena\rathena\3rdparty/mysql/CMakeLists.txt    30   

thanks
 

 

[how to update source code?]

i copy all the refine overhaul. And put each of them  on notepad with its location and file name together with the right file extension but i dont know to update using visual studio 2017.  see file. 

 

thanks

[After changing the exp in the battle folder what is next?]

On 9/24/2017 at 5:08 PM, crazyarashi said:

You have enabled the auction feature in the battle/feature.conf since you're using an old client which doesn't support it which is the cause of the system disabling it automatically :))

THANK YOU I RE EXTRACT IT ALL AND USE A DIFFERENT CLIENT NOW I WANT TO UPGRADE EQUIPMENTS HOW?

[After changing the exp in the battle folder what is next?]

8 minutes ago, crazyarashi said:

After changing anything in the conf/battle folder you need to use @reload battle to reload the changes in the battle folder :))

thanks but this happen

 

[After changing the exp in the battle folder what is next?]

I change the text file of the /battle/exp. but there is  no change in game. im new in rathena and first time programing. I can't seem to find the right answer on how to change configuration. I read about scripts but i don't know how to change the configuration of rathena offline.

[EXP rate and Drop rates rathena offline]

Paano ba mag palit ng exp rate at ng drop rate been searching sa internet di ko makita. thanks in advance. newbie