DB errors in console while starting up

[ScriptingPhailure 3]

So I have no idea what I did wrong or why all these errors are popping up. I was just trying to set up hercules.

[evilpuncker 504]

apply the 21 sql updates that you are missing, btw are u using a new db or migrated from a rA db to hercules db?

[ScriptingPhailure 3]

I just pulled the herc git and tried to compile and run it as is. Also, I tried executing the updates but it just spat out more errors in the sql manager.

Edited March 9, 2014 by ScriptingPhailure

[evilpuncker 504]

well, you need to set up a new db for it, or use the upgrade like I've said here in this post:

http://herc.ws/board/topic/4669-is-rathena-db-compatible-with-hercules-bd/#entry30183

[ScriptingPhailure 3]

I did set up a new db. I just don't know how to apply these upgrades other than "open sql" file and then execute, which spat out some errors.

[jaBote 438]

As I said elsewhere:

@Topic Starter:

 

I'm the creator and main maintainer of these upgrader scripts. That upgrader is way too outdated and needs update prior to applying. I have an experimental newer upgrader but can't test on my machine since my MySQL engine is broken. I could send you the newer, untested version so that you can test (on a backup, obviously) and tell me if it works.

 

Sorry for the trouble.

Last time I tried sending it to somebody else I got no feedback so I couldn't get the guarantee it worked or the user simply gave up.

 

My MySQL is still broken and I can't seem to be able to fix that one.

 

I can send it to you and hope I'll get tour feedback. Be warned though, I haven't been able to figure out vending reconstruction data and I've opted out to remove that.

[ScriptingPhailure 3]

Some of them work just fine, It went from 21 updates, to 7. I assumed they all didn't work since the first 4 didn't apply. I went through it one by one. So 14/21are applicable.

Edited March 9, 2014 by ScriptingPhailure

[Samuel 83]

Some of them work just fine, It went from 21 updates, to 7. I assumed they all didn't work since the first 4 didn't apply. I went through it one by one. So 14/21are applicable.

 

Well, not all the updates goes to main sql, some belongs to logs.. unless you made the database for both the same..

 

And did you run the updates by date? descending to ascending?

[ScriptingPhailure 3]

I'm an sql newb so everything is in 1 schema, both logs and main. Also yes, I did run in from descending to ascending.

[AnnieRuru 958]

sql-updates can be found in these 2 files

https://github.com/HerculesWS/Hercules/blob/master/sql-files/main.sql#L636

https://github.com/HerculesWS/Hercules/blob/master/sql-files/upgrades/rAthena-main-upgrade.sql#L37