Jump to content
  • 0
Sign in to follow this  
daim

SQL UPGRADE files not exits

Question

Hi,

 

I would like to switch form eathena to herules. Unfortunetly the require UPDATED SQL/ UPGRADE SQL file to uptodate revision of hercules is not included in sql-files/upgrade like it should be. There is only timestamp file.sql

 

any clue?

Share this post


Link to post
Share on other sites

6 answers to this question

Recommended Posts

  • 0

hmm..how did you switch or what did you do? any error something?

Hercules has a capabilities to determine what sql upgrade you are missing unless you did something wrong.. :):

 

 

:meow:

Share this post


Link to post
Share on other sites
  • 0

There you go: https://github.com/HerculesWS/Hercules/commit/7436a70cde2220c42cd249cee6368d308b0bd040 (update your working copy and it'll be in the upgrades folder as eathena-upgrade.sql) -- be aware your sql structure must be up to date with eathena's e.g. if you're using a old eathena go through their upgrade files before using this one.

Share this post


Link to post
Share on other sites
  • 0

so we dont have to upgrade manualy? let say im using eathena version 1430, and i no need to update sql manualy? thats what u mean malufett?

Share this post


Link to post
Share on other sites
  • 0

now when i tried to run server i got this error:

: DB error - Unknown column 'character_slots' in 'field list'
[Debug]: at account_sql.c:528 - SELECT `account_id`,`userid`,`user_pass`,`sex`,`email`,`group_id`,`state`,`unban_time`,`expiration_time`,`logincount`,`lastlogin`,`last_ip`,`birthdate`,`character_slots`,`pincode`,`pincode_change` FROM `login` WHERE `account_id` = 1
 

 

anything i miss ?

Share this post


Link to post
Share on other sites
  • 0

now when i tried to run server i got this error:

: DB error - Unknown column 'character_slots' in 'field list'

[Debug]: at account_sql.c:528 - SELECT `account_id`,`userid`,`user_pass`,`sex`,`email`,`group_id`,`state`,`unban_time`,`expiration_time`,`logincount`,`lastlogin`,`last_ip`,`birthdate`,`character_slots`,`pincode`,`pincode_change` FROM `login` WHERE `account_id` = 1

 

 

anything i miss ?

Yup. Check out these files: https://github.com/HerculesWS/Hercules/tree/master/sql-files/upgrades

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.