Updating to Newest Stuff
 

I can see that a lot of new stuff has been added in since I made my server, so I am considering upgrading to the new db and rev. My server has a lot of custom stuff like npc stats, zone requirements, quests, pets, merchants. If I backed up all of those tables and then sourced them back, would there really be a point of going through the whole updating process? I'm inexperienced at upgrading a server and if I wouldn't benefit much from the changes, I don't want to risk screwing up my server.

This thread might help with some info about updating your DB:

http://www.eqemulator.net/forums/showthread.php?t=28245

But, if you just want to update to the latest SVN, all you should have to do is run the extra SQL that comes with it and make sure to get all of the required SQL added before starting your server up on the new code.

Also, it is a very good idea to backup your whole database before making any changes to it. Not worth risking a mistake.

Ok every thread I find seems to be saying to do something contradictory. If I just want to update my server to have the newest stuff thats been added since I created it, what should I really do?

Ok I'm trying to back up all of my custom stuff to an SQL file so then I can just source it back in, but everytime i send stuff to my updates.sql, it just erases what I put in there before it

I'm going to use Rev621 seeing how it's the latest one for example's sake.

1.) Update your database to the latest revision you want. For example, if you're on Rev590 with your custom stuff, update all relevant SQL files up to Rev621.

That would mean you would need to source in:
600_group_leadership.sql
612_instance_changes.sql
615_adventure_assassination.sql
619_Adventure_Recruiter_Flavor.sql
621_LDoNTraps.sql


2.) Then export your custom stuff. This means your custom stuff is up-to-date with Rev621. Now you're all set.

3.) Source in your new database (not your custom stuff yet!). Make sure you keep an eye on the database you're using. For example, the latest PEQ database is peqdb_1129Rev610. This means the database has all updates up until Rev610.

This means you will have to source in any additional SQL files up until Rev621 which has the following SQL updates:
612_instance_changes.sql
615_adventure_assassination.sql
619_Adventure_Recruiter_Flavor.sql
621_LDoNTraps.sql


4.) Source in all of your custom stuff, and you should have no problems at all at this point. Since you made a backup with your custom stuff with Rev621 and you're sourcing in your custom stuff that's Rev621 ready, you should be all set.


The point is to make sure your custom stuff is matching with the revision you're sourcing in so there's no data/table conflicts.

ok well, I just see me trying something like that ending horrbily, so I'm never updating

It's really piss easy. All you're doing is comparing the revision you're using to the revison you want to update to. There's really nothing else to it.

I am trying to get the maps, but it keeps stopping while I am checking them out and then when I try to update it to restart it, it just says I need to run the clean up command, which of course also doesn't work

I just tried to connect to my server with the old maps I have, but I got disconnected when trying to log in from the character selection screen. Is this map-related or did I mess up somewhere in the updating process?

I'm getting these two things in my log

For mail
And idk what this means

I believe that came from your eqlauncher. Did you have "start eqlaunch.exe zone" in your start.bat file?

What version executables are you using?

I did eqlaunch.exe too and I still get disconnected when trying to log in

what does eqlaunch even do? I never used it on my server before

Can someone confirm that the URLs found here are correct? When I copy and paste any of these into the "URL of Repository" I consistently receive an error message; e.g., "Error: PROPFIND of '/svn/trunk/%E2%88%9E': 200 OK (http://projecteqdb.googlecode.com)", followed by a "Finished!" line, but nothing actually downloads.

yeah that's what I used. I still can't figure out why I get disconnected on loging in though

Okay, maybe I'm just misunderstanding something here. The PEQDB URL looks like this:

http://projecteqdb.googlecode.com/svn/trunk/∞

What is the significance of the infinity symbol after the final forward slash? Is it supposed to be there? Is it part of the URL? Does it represent something else? Whether I include it or omit it, I still receive the error message mentioned above.

Yes they are, I just checked them.
Maybe your firewall is blocking TortoiseSVN?

I always go here:

http://code.google.com/p/projecteqdb/source/checkout

And use the svn checkout command given on that page:

svn checkout http://projecteqdb.googlecode.com/svn/trunk/ projecteqdb-read-only

That symbol ∞ denotes a hyperlink in the wiki and is not part of the url.
You will see it alot in the wiki.

Your url for the database would be:
http://projecteqdb.googlecode.com/svn/trunk/

and so on...

I've updated the wiki page:
http://www.eqemulator.net/wiki/wikka...a=ProjectEQSVN

so that the URLs are now showing without the ∞ (hyperlink) symbol.

Now it should be foolproof! :D

anyone know why I get disconnected on logging in? or if theres something I need to check.

Each time I attempt to checkout, I receive the same error message as before. I guess something else is going on.

I am considering restoring a back up of my DB, but will that cause problems since it was on a different revision?

Actually I believe I found what is wrong. I get a message in world.exe saying that the character info cannot be found. I don't want to have to wipe all characters, so is there any way I can fix this?

Is there an alternative location to get all this that doesn't rely on SVN? I began copying the text in each link and manually creating files, till I got to the player_tables and updates folders. There are too many to continue.

Sounds like you have a proxy issue.
You should google your error and you may find a fix.

You should use a subversion (SVN) client. It will download all files in a repository with just one command. I don't run a server under windows so I don't know what clients are good. I'm sure someone else can chime in here with a suggestion.

I've had no problems running RapidSVN under Windows.

http://en.wikipedia.org/wiki/RapidSVN

- Shendare

No cigar with any of the suggestions. I am not using a proxy server, I can access the URLs just fine with a browser, 3 pages of google searches did not yield a solution, and RapidSVN gives me the same errors.

I use TortoiseSVN. Just get rid of the infinity symbol...
http://www.projecteq.net/phpBB2/viewtopic.php?t=7221

Tortoise was the original SVN program I used.

Looks like I'll have to wait till Cavedude decides to update the package on the PEQ website.

SVN problem
 

This is still a problem for me.
I have disabled my firewall and virus protection and even the firewall on my router. I have even attached the computer directly to the cable router, skipping the router that has the firewall on it.
I have tried 3 different SVN programs and I feel like I have exhausted this issue as far as my knowledge goes.
I have of course googled the problem and tried the solutions that I have found.
Has anyone found any fixes to this?

Are you trying to checkout the PEQ source like he was in that quote? If so I can tell you the SVN defiantly works because I just checked out the source this very moment to test. What command (exactly) are you using to check out the source?

tortoise svn issues
 

Thanks for the quick reply.

For the quests, this is the address I use:
http://projecteqquests.googlecode.com/svn/trunk/quests
For the DB i use:
http://projecteqdb.googlecode.com/svn/trunk/peqdatabase

Whats wierd to me is that I was able to checkout everything once on each of my computers, but after that, i got the error.

Edit:
Also using silksvn I used the google command given on the website but got the same error

svn checkout http://projecteqdb.googlecode.com/svn/trunk/ projecteqdb-read-only

oops. Similar error messages, but mine is slightly different. Sorry for the confusion. Still cant figure it out though.

OPTIONS of 'http://projecteqdb.googlecode.com/svn/trunk/peqdatabase': 200 OK (http://projecteqdb.googlecode.com)

Works with both the Subversion client and SlikSVN; just verified initial check out and update.

Make sure you are not trying to use a proxy and that you are running as a user without any strange restrictions - like run svn as administrator if you aren't already.

Tortoaise SVN success
 

Ok, I got it to work. Thank you so much for your help, I appreciate it greatly.
The problem was an internet content filtering program, it had to be removed completely. I also left the router firewall off as well as the windows firewall and anti-virus.