Error running MySQL queries from file 'eq2-updates.sql' (1067)

[Headpants]

Hey guys,

First off, I hope everyone had a very Merry Christmas - or a Joyous Festivus, if you're into the whole "Feats of Strength" thing...

So I've been logging into the "Stitch PVP" server to check things out (still cannot log into the "eq2emulator" server), and I decided to try setting up a server for myself. I've been running a ton of Minecraft servers/worlds for my son and all his friends now for quite a while, but since most of them have moved on to Fortnite, I find myself with tons of unused server space and a need to do something, destructiv... er, I mean constructive...

So I followed along with the directions laid out for Ubuntu in the Wiki here: https://www.eq2emulator.net/wiki/index. ... ver:Ubuntu , and I had no issues right up to the point of "starting your world". I entered "./eq2world" and saw a LOT of red! the initial error message was as follows:

Error running MySQL queries from file 'eq2-updates.sql' (1067): Invalid default value for 'created_date'

And pretty much all additional error messages said things like "#1146: Table 'eq2world.opcodes' doesn't exist" - I tried running the "./eq2world" command a few times, wanted to grab a screen capture of the errors, but I got locked out (sorry for trying too many times in a short period of time!)

I'm assuming I missed a step or two pertaining to setting up the database properly, so I'm going to wipe and start again. Any suggestions as to what step(s) I may have missed?

Also, I'm running this on a Ubuntu 16.04.5 LTS VM with 16GBs of RAM, 120GBs of HDD space & 4 Virtual CPUs with 1 core per socket - I just wanted to confirm that those settings would be enough to run a server.

Thanks again in advanced...

[Headpants]

Here's a screen capture of the latest installation I'm attempting right from when I run "sudo ./eq2world":



Pretty much every error beyond what is shown in the picture above is just a different variation of "#1146: 'eq2world.BLAH-BLAH' doesn't exist"

[Jabantiz]

The first error is the important one as it results in your DB not updating and as a result the tables don't exist so when it continues on to load stuff you get those other errors.

The thing is this is really odd as the last time I ran from a linux vm it worked fine, it was an ubuntu 16 as well. Do you use MySQL or MariaDB? Assumin it is MySQL then it could be one of those minor differences as we mostly use MariaDB now but they were suppose to be compatible with each other but every now and then we find something that isn't.

[Headpants]

Jabantiz,

I was starting to think it might be an issue/quirk with MySQL. I used MySQL over MariaDB for no other reason except that I didn't even think about it as an option, even after reading in numerous other threads that MariaDB was used instead of MySQL.

I will try out another installation using MariaDB later today and update this thread...

[Headpants]

So I started with a clean Ubuntu 16.04 VM, installed MariaDB, created the database, followed along with everything else in the wiki and when it got to updating the database, everything worked perfectly until...



Unsure what "Bad Password" it is talking about at this point - any ideas?

[Jabantiz]

So it was a MariaDB vs MySQL issue, good to know in case this pops up again in the future.

You need to set up a login account (different from your forum username) here. Once you set one up and log in there will be a tab for your world accounts you need to set up a world and this again will have a different username and password. The user name and password you set up here is what you will want to use in the configs, if they don't match what the login server has then it will reject your worlds to attempt to connect.

[Headpants]

Jabantiz,

Thanks for the info, that fixed the issue right away. No Problem getting the server up and running...

So I have "The Rusted Scrolls" up now, Yippie!

However...

Just like when I tried logging into the "EQ2Emulator" server, I cannot get onto my server - I go to log into the server and get booted to the desktop instead of entering the game. I mentioned this before in another thread and Cynnar replied back on Dec 19th with:

"Latest client is not working on all servers except StitchPvP. Still have not figured out why."

I'm assuming this is still the case, so I'm unsure what to do from this point. Any suggestions from anyone would be most welcomed at this point. In the meantime, I'm going to start poking around the database, very curious as to the process of things like spells, quests & tradeskills...

[Jabantiz]

DoV box is supported if you have that, otherwise the client from steam is an AoM client and I believe that works.

As for live some one will need to investigate all the packets to see what is causing it but I personally don't have the free time for that.

[tyrbo]

Just to chime in on the MySQL/MariaDB topic.

At some point my zones started taking like 2 minutes to load. Worse with the number of spawns, so two minutes for Commonlands, or practically no delay at all with an empty zone.

Turns out it was the swap from the MySQL library to the MariaDB client library that was causing it. As soon as I swapped my MySQL server for something running MariaDB, the issue went away and zones were loading super fast again.

re: the live client being busted on other servers, planning to try to look into that some more but no ideas at the moment. Always a ton to do on Stitch as well, so kinda pulled in multiple directions.

[Headpants]

Tybro, thanks for the information...

As for my logging in issues, I switched to the Steam client (AoM), made a few DUMB mistakes, but I finally got the client set up correctly and was able to log into the EQ2 Emulator server with minor issues (on 1/2/2019 @ 3pm EST to around 8pm EST I got kicked to the desktop like before about 4 times), was able to log in late last night and this morning with no issues.

So I have a toon named "Hawkins" on the EQ2 Emulator server (/wave to everyone) that I'll be kicking around doing tradeskills and sometimes actually hunting / killing stuff...

As for my server "The Rusted Scrolls", I logged a toon into that server with no login issues except that he went directly to a zone called "GM Hall" - cool looking zone, but there are no NPCs or anything I can interact with at all in the zone. Well, nothing but the parking lot pigeons (seagulls) that fly off when I run at them. It was entertaining for about a minute or two, next time I think I might catch one...

I made a 2nd toon for my server and was able to start him in Halas, but like the GM Hall, there was nothing in the zone to interact with.

I'm assuming in my zeal to create a server I must have skipped a part with uploading/updating all the content, lol. I'm going to read over everything again and take another shot at it, if I continue messing that up I'll post it to a new thread on that topic...

Thanks again guys for the help so far, much appreciated - and glad that I can run around doing tradeskills again, lol

[Jabantiz]

All content on the emulator server (minus the characters) is dumped weekly and put on the content svn, so you can get everything we currently have.