Solo Server Package 2021

[Huppy]

Originally Posted by Vire70

I made a totally new eqemu server install, put the quests from solo package in, sourced in your DB & loginaccounts... and yeah, it doesn't work.

I have that solo package installed on mine, has been since I put it together, before I posted the download. Mine is working fine.

Originally Posted by Huppy

I found an older, clean database of mine, vs 9178, which seem to take that sql query for the solo server no problem. Then I updated the whole thing to db version 9200.
You DON'T NEED TO source that sql file in from the solo package here, but you will need the rest of the script files.

Just to clarify, (In that quote above) where I said "you will need the rest of the script files", it's referring to QUEST SCRIPTS, not sql queries. The quest scripts, you just add to your server quests folder.

BUT, if you are using newer code than when I posted that, then it all needs to be updated. (using the update script). Otherwise, you will get a lot of errors. The current (as of today) version for peq is 9212. That db I put together was updated to 9200.

I always advise people not to rely on that update script too much when trying to update an older version database. Best thing you can do is go into the db_version table and knock the version back (for example) 9178 or something, THEN run the update script eqemu_server.pl I have cases where I had to do it a few times, because I have dealt with a lot of older databases, when monkeying around with projects. Afterwards, login to the game, to whatever zone, then look at the server zone logs and it may show you what tables/fields are still missing.

The OP that put that original server package together, never came back to keep it up to date. Myself, I run version 9200 code right now and I'm not updating that at all. I only did this as a one time update and have no plans on continuing to do that, but in the mean time, the db/binary versions from Emu devs will keep upgrading way past this database.

[Vire70]

Huppy, I'm almost embarrassed to admit this but I just ran that check_database_updates in the server .pl, fired the server up and it appears to have fixed everything. All the NPCs are there including the custom added merchants and whatnot. So, thanks for your help. I didn't think it would be that simple, and to be honest I didn't understand what you meant before about the "update script" because I'd never used that particular thing before, but mentioning the actual file name reminded me.

[Huppy]

Originally Posted by Vire70

Huppy, I'm almost embarrassed to admit this but I just ran that check_database_updates in the server .pl, fired the server up and it appears to have fixed everything. All the NPCs are there including the custom added merchants and whatnot. So, thanks for your help. I didn't think it would be that simple, and to be honest I didn't understand what you meant before about the "update script" because I'd never used that particular thing before, but mentioning the actual file name reminded me.

Hey that's awesome, you got it all working. That update script, it can work good, but sometimes not so much with older databases. It should't be problem with the 9200 version db I posted, but try and go way back to something several years old, is a total pita, haha