Server Working now Broken

[Bohbo]

I setup a server earlier this summer and had it working fine with underfoot.

I decided to upgrade up to the RoF2 Client and my server started to hang logging in. So i decided it needed an update. I tried the all in one MSI installer.

It used my DB but i was getting hanging. So i dropped my peq DB and remade it and downloaded latest oct 11th build and seemd to build it fine. But when i try and source the subsequent files after (peqbeta and player_tables) I get the following errors. Along with the world.exe server error you can see.

Any help is appreciated, I have been banging my head against this and can't figure it out.

http://i.imgur.com/KPpdQqM.png

http://i.imgur.com/QrUjDWi.png

[Bohbo]

Any direction would be GREATLY appreciated. I don't know what i need to uninstall / wipe or update to get this going.

MySQL Ver 5.1.73-community

[Scorpious2k]

You are missing tables in your DB.

The first window you show where you are sourcing the "updates"... the source file looks like an HTML file and not SQL.

[Bohbo]

Thanks for the reply Scorp,

I got the sql update files from here.
https://github.com/EQEmu/Server/tree/master/utils/sql/git

Starting with required
Day of build i downloaded.
2014_10_11_RaidMOTD.sql

[Scorpious2k]

This is what it should say:
ALTER TABLE `raid_details` ADD `motd` varchar(1024);

Try opening the one you have with a text editor and see what it says.

[Bohbo]

This is what it should say:
ALTER TABLE `raid_details` ADD `motd` varchar(1024);

Try opening the one you have with a text editor and see what it says.

I think I see what is going on now. The HTML comment gave me a clue.

when i left click the 2014_10_11_RaidMOTD.SQL I see that line, however I was right clicking and saying save link as (it defaulted to SQL extension) i guess since its a link to the git code and not really an attachment it was saving the git page or HTML and not a sql file.

I used the github client to download the files. USER ERROR!

[Scorpious2k]

Or you could copy the line I pasted into the file replacing the HTML or copy/type it into mysql (get it exactly the same, including the cases used and the trailing semicolon.

[Bohbo]

I figured for one that was easier, but if i am going to apply a bunch and stay up to date a github sync makes sense i think.