[ASK] Ready to use Renewal main.sql

[[ASK] Ready to use Renewal main.sql]

Emistry, on 22 Oct 2015 - 16:37, said:

https://github.com/H...-files/main.sql

It's solved now,

I am gonna try to implement the Renewal and 3rd Job,

 

SOLUTION:

For fresh installation there's no need to import the upgrades files from the folder, just main.sql and log.sql is enough.

But by default you will need to edit the location of loginlog database in trunk/conf/inter-server.conf

Quote

 

// MySQL Log SQL Database

log_db_ip: 127.0.0.1

log_db_port: 3306

log_db_id: ragnarok

log_db_pw: ragnarok

log_db_db: log //<<--- the default value of this was ragnarok

log_codepage:

log_login_db: loginlog

 

[[ASK]Database Structure]

you're doing a fresh installation, there's no need to execute any SQL inside the upgrades folder.

 

both main.sql and log.sql is more than enough.

 

Hi, 

It doesn't seems it work, I got this error when running the server using the default .sql file (main.sql and log.sql):

 

: DB error - Table 'ragnarok.loginlog' doesn't exist

[Debug]: at ..srcloginloginlog_sql.c:84 - INSERT INTO `loginlog`(`time`,`ip`,

 

 

and 

[[ASK] Ready to use Renewal main.sql]

Hi, 

 

I am new in Hercules, and I wanted to installed ti so I can play on LAN with my friends.

I just checked out the Hercules from github, and upon processing the database (from /trunk/sql-files) I met sooo many error when importing the upgrades (/trunk/sql-files/upgrades).

 

So, I wanted to ask are there any main.sql that I can copy to be ready to use (including the latest database update) ?

And if it possible the file ready for Renewal...

 

Thank you

[[ASK]Database Structure]

Hi,
I am using:

 - Windows 8.1 (64 bit)

 - XAMPP (Mysql version 14.14)

I just checked out Hercules from:

https://github.com/HerculesWS/Hercules.git

 

and then I tried to install it and imported most of the .sql files (I didn't import all of them, because it's simply too confusing, too many duplicate and error table).

 

I recompiled the solution using VS 2013, and ran the run-server.bat.
Everything just fine, until I tried to login to character selection...the char server crashed!!. Maybe it's related with my database..

 

So, after imported the sql files:

 

- main.sql

- item*.sql

- mob*.sql

- logs.sql

 

I got this structure on my Ragnarok database:

 

 

- account_data

- acc_reg_num_db

- acc_reg_str_db

- auction

- autotrade_data

- autotrade_merchants

- cart_inventory

- char

- charlog

- char_reg_num_db

- char_reg_str_db

- elemental

- friends

- global_acc_reg_num_db

- global_acc_reg_str_db

- global_reg_value

- guild

- guild_alliance

- guild_castle

- guild_expulsion

- guild_member

- guild_position

- guild_skill

- guild_storage

- homunculus

- hotkey

- interlog

- inventory

- ipbanlist

- item_db

- item_db2

- login

- mail

- mapreg

- memo

- mercenary

- mercenary_owner

- mob_db

- mob_skill_db

- npc_market_data

- party

- pet

- quest

- ragsrvinfo

- sc_data

- skill

- skill_homunculus

- sql_updates

- storage

 

and this as Log database:

 

- atcommandlog

- branchlog

- chatlog

- loginlog

- mvplog

- picklog

- zenylog

 

The latest update in trunk/sql-files/upgrades is this file

 

2015-08-27--20-42.sql

 

along with:

- eathena-upgrade.sql

- rAthena-logs-upgrade.sql

- rAthena-main-upgrade.sql

 

Are those correct structure?

Don't we have a single main.sql with all the latest tables (including their structure) ? So, I don't need to import the sql files updates manually.

Or could anyone give me the dump sql files for working database?