EQEmulator Forums - Server Working now Broken

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Server Working now Broken (https://www.eqemulator.org/forums/showthread.php?t=39105)

Bohbo

12-12-2014 11:20 PM

Server Broken after DB update, 1064 source errors

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

12-14-2014 12:47 PM

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

12-14-2014 12:56 PM

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

12-14-2014 01:28 PM

Thanks for the reply Scorp,

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

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

Scorpious2k

12-14-2014 05:32 PM

This is what it should say:

Code:

ALTER TABLE `raid_details` ADD `motd` varchar(1024);

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

Bohbo

12-14-2014 07:11 PM

Quote:

Originally Posted by Scorpious2k (Post 236125)

This is what it should say:

Code:

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

12-14-2014 08:24 PM

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

12-14-2014 08:45 PM

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.

All times are GMT -4. The time now is 06:56 PM.