Jump to content
  • 0
Sign in to follow this  
noobsee

SQL Log with list of sql files on map-server

Question

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

Share this post


Link to post
Share on other sites

3 answers to this question

Recommended Posts

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

Share this post


Link to post
Share on other sites
  • 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 by noobsee

Share this post


Link to post
Share on other sites
  • 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?

 

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 by Tranquility

Share this post


Link to post
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.   Restore formatting

  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.

Loading...
Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.