SQL Log with list of sql files on map-server

[noobsee 0]

Hi, 

 

I just realized that I have this log on my map-server.exe

 

[status]: Event 'OnInit' executed with '2100' NPCs.

: - detected 30 new SQL updates

[Debug]: showmsg: dynamic buffer used, increase the static buffer size to 2251 o

r more.

[sql]: -- 'sql-files/upgrades/2013-02-14--16-15.sql'

[sql]: -- 'sql-files/upgrades/2013-02-15--18-06.sql'

[sql]: -- 'sql-files/upgrades/2013-03-05--01-05.sql'

[sql]: -- 'sql-files/upgrades/2013-03-06--00-00.sql'

[sql]: -- 'sql-files/upgrades/2013-03-09--01-56.sql'

[sql]: -- 'sql-files/upgrades/2013-04-16--01-24.sql'

[sql]: -- 'sql-files/upgrades/2013-10-09--21-38.sql'

[sql]: -- 'sql-files/upgrades/2013-10-10--16-36.sql'

[sql]: -- 'sql-files/upgrades/2013-10-27--16-47.sql'

[sql]: -- 'sql-files/upgrades/2013-10-30--19-53.sql'

[sql]: -- 'sql-files/upgrades/2013-10-30--21-12.sql'

[sql]: -- 'sql-files/upgrades/2013-10-31--07-49.sql'

[sql]: -- 'sql-files/upgrades/2013-11-09--00-03.sql'

[sql]: -- 'sql-files/upgrades/2013-11-15--00-06.sql'

[sql]: -- 'sql-files/upgrades/2013-11-15--19-57.sql'

[sql]: -- 'sql-files/upgrades/2013-11-16--07-49.sql'

[sql]: -- 'sql-files/upgrades/2013-11-18--08-23.sql'

[sql]: -- 'sql-files/upgrades/2013-12-24--00-15.sql'

[sql]: -- 'sql-files/upgrades/2014-01-04--16-47.sql'

[sql]: -- 'sql-files/upgrades/2014-01-06--17-22.sql'

[sql]: -- 'sql-files/upgrades/2014-02-19--17-57.sql'

[sql]: -- 'sql-files/upgrades/2014-03-25--23-57.sql'

[sql]: -- 'sql-files/upgrades/2014-04-07--22-04.sql'

[sql]: -- 'sql-files/upgrades/2014-04-26--10-00.sql'

[sql]: -- 'sql-files/upgrades/2014-05-17--00-06.sql'

[sql]: -- 'sql-files/upgrades/2014-09-01--16-53.sql'

[sql]: -- 'sql-files/upgrades/2014-11-03--00-45.sql'

[sql]: -- 'sql-files/upgrades/2015-07-02--18-14.sql'

[sql]: -- 'sql-files/upgrades/2015-07-08--13-08.sql'

[sql]: -- 'sql-files/upgrades/2015-08-27--20-42.sql'

[sql]: To manually skip, type: 'sql update skip <file name>'

[status]: Server is 'ready' and listening on port '6121'.

 

what does that mean?
Do I have to import the updated data? 

 

Thank you

[Tranquility 12]

If you would use the latest revision of Hercules, you'll need to execute the SQL updates manually on your database.

Depending on which revision you started, you'll have to start updating/upgrading your database with the files that appear to be missing.

The possibility is that you didn't modify too many files yet, in that case, you can start with a fresh clone from the Herc repository and add your modifications that way.

[noobsee 0]

If you would use the latest revision of Hercules, you'll need to execute the SQL updates manually on your database.

Depending on which revision you started, you'll have to start updating/upgrading your database with the files that appear to be missing.

The possibility is that you didn't modify too many files yet, in that case, you can start with a fresh clone from the Herc repository and add your modifications that way.

 

What is the latest revision?

I am using the one from 10/22/2015 5:55PM

 

And I've been trying to update the sql, but I got a lot of errors from duplicate ID to field doesn't exist, 

Also I have a question regarding the:

 

 - item_db.sql

 - item_db2.sql

 - item_db_re.sql

 - mob_db.sql

 - mob_db2.sql

 - mob_db_re.sql

 - mob_skill_db.sql

 - mob_skill_db2.sql

 - mob_skill_db_re.sql

 

From those .sql file, i imported all of them, is that correct?

Edited October 27, 2015 by noobsee

[Tranquility 12]

 

If you would use the latest revision of Hercules, you'll need to execute the SQL updates manually on your database.

Depending on which revision you started, you'll have to start updating/upgrading your database with the files that appear to be missing.

The possibility is that you didn't modify too many files yet, in that case, you can start with a fresh clone from the Herc repository and add your modifications that way.

 

What is the latest revision?

I am using the one from 10/22/2015 5:55PM

 

And I've been trying to update the sql, but I got a lot of errors from duplicate ID to field doesn't exist, 

Also I have a question regarding the:

>> 

 - item_db.sql

 - item_db2.sql

 - item_db_re.sql

 - mob_db.sql

 - mob_db2.sql

 - mob_db_re.sql

 - mob_skill_db.sql

 - mob_skill_db2.sql

 - mob_skill_db_re.sql

 

From those .sql file, i imported all of them, is that correct?

 

You only need to import the SQL databases for your server type. Pre-renewal or Renewal. _re files are for renewal servers, the ones without are for pre-renewal.

I suggest you start over with the installation, once I'm back from work I'll check out if anything is missing in the main script that's causing you to miss all those SQL updates.

 

If you use main.sql, it should contain the sql_updates up till the latest date, just verified this.

You should import main.sql & logs.sql into your database. The item_db, mob_db and mob_skill_db are mainly for your control panel as Hercules doesn't utilise this function for servers anymore, a deprecated functionality that remains for web-based purposes.

Kindly take a look at the Installation of SQL on the Hercules Wiki. It contains all the information you need and how to do it.

 

 

Edited October 27, 2015 by Tranquility