I'm trying to keep my cool here and get these fixed...
 

I have two issues on my server right now that are leading me to drink HARD. Let alone want to blow something up.. I'm usually a pretty cool, calm and collective guy but this has got on my last nerve so bare with my anger.


#1: I have a problem with Guild Management not working or showing rosters or anything on my server AT ALL. I tried running all the latest SQL from 2099 to 2136 and nothing worked. I've went over posts from back to 2010 to 2011 and tried their methods and nothing has worked or I simply have everything they already mention in the post. WTF is going on here?
Does anybody know how to fix this shit at all? Btw I'm running HOT/UF hybrid client and so are most of the people on Varlyndria and they can't do anything with their guilds and even some /guild invites crash people to the desktop and lock them out of the game.


#2: I get an error when I try to run the #Bot Stances SQL and it won't successfully complete.. I have put a "Continue On Error" check and tried to force it through but nothing is happening on the server. Does anybody got a fix for this as well as the guilds.. My two main problems on Varlyndria right now that is making me rip every strand of my hair out in absolute and total frustration. :x


I really appreciate the help in advance.

Wish I had an answer to #1, I have the same problem!

For #2, can you post up what your database editor saying when you try to run the SQL?

I'm on my phone at the moment and can not check, but are you certain you have the new table/columns added related to the looking for guild window?

did you see this post. There was a solution for a guild management window fix for bot servers.

http://www.eqemulator.org/forums/sho...ighlight=guild

In conjunction make sure you have all of the recent opcodes in your server folder.

Opcodes: That's the 5 files from the source/trunk/EQemuServer right? Copy those over again? Do I need to copy anything else and I'm guessing I just take out my config file and put it back in after? This is something I didn't try yet, thanks for the help all.

Are the op codes this stuff here down below? Taken from Huppy's guide. How many do I need again? He states in his guide a total of 22 files.


***WARNING***
If the build was successful, (5 succeeded), you DO NOT have to re-do that just because
you have future problems. The rest of the setup is copying files, sourcing your database
and configuring your server. The database and the server are two seperate things.
Your config files will help connect the two when your server is finally up and running.

10. It's time to start copying files from your source folder to the server folder.

***WARNING** - All of the files I am going to list here NEED to be copied over to your
server folder. you will find them all in different sub folders in the source folder.

First go into /source/trunk/EQEmuServer folder. You will see a folder called Build.
This folder was created when you compiled the server apps.It contains 5 files you
need to copy over to your server folder:
Chatserver.exe, eqlaunch.exe, World.exe, Zone.exe and EMuShareMem.dll

Next, In /source/trunk/EQEmuServer/utils folder, copy these to your server folder also;

mail_opcodes.conf, opcodes.conf, patch_6.2.conf, patch_Anniversary.conf,
patch_HoT.conf, patch_SoD.conf, patch_SoF.conf, patch_Titanium.conf, schema.xml
and patch_Underfoot.conf

Yes this is correct.

Updated both SVN's, got build 2141 and rev 61. Copied all those files over to my server folder, reset the computer and restart the server and the guilds are still broken and so are the bot stances.


When I try to update the SQL for bot stances I get an unsuccessful. Is there a fix for this to make it succeed? I'm guessing that might have something to do with it. I have the table in my database but inside the table is just 2 blank areas.



EDIT: Alright, just did the ALTER TABLE thing and added it into the SQL prompt. Going to restart and see if it worked.

Failed. Guilds are still broken even after those two major things.



Which tables would those be? I see the following in my database, here let me show you.

http://i269.photobucket.com/albums/j...h/Mytables.png



BTW: I've got a test server kinda running but have ran into an issue when trying to run it on the same box. Seems it doesn't show up with Varlyndria live.. I've changed the EQemu config to reflect on test and everything. Any suggestions I might have missed?

EDIT: Nevermind.. can't run two EQemu servers on one IP.. I don't have a test server than yet.

So is your bot stance working ? You said guilds are still broken but never said if bots were ?

You really need to look through your logs. Normally if something that critical is not working your logs will offer a huge clue.

And yes, the table lfguild is there from that screenshot you posted.

Bot Stance is broken and so is the Guild Management.

A few things.

First do the bot help command and see if the command is in the list, should be toward the bottom. Next run the bot stance command and observe your logs.

Bot Stance does not show up on the list.

I open up the logs folder in my server folder and notice there are a bunch of zone files. Which one am I looking for that might show #bot stance

If you are not seeing bot stance, it does not appear you are recently compiled. Did you copy your new executable to the server after you compiled them ?

Alright, I'm lost.. I started my server off with a compiled 2099. I used visual studio C++ 2008 to get the 5 things as success. (took a while) the guide says that to upgrade my server to the newer updates I don't have to do that again. So when you say compiled I'm not sure what you mean exactly. It almost makes me wonder if I need to fully complile 2141 with visual studio.

Did I copy the 22 or so files and add them to my server folder when I was done with SVN updates? Yes. My updates finished at 2141 in my source and 61 in my peqdb.

Am I missing something here? Thanks.

When you upgrade your source code and recompile you need to copy the files from the Build directory to where you run your server from.

This is in addition to applying the sql updates if there are any between your last version of the source code and the new version of the source code.

So you're saying all of these files here? Even the folders and send it to my server's directory? I added the 5 files which are not folders and nothing worked, but I'll try it with the folders if that's what I'm missing.


Also, you mention recompiling. Are you talking about the Visual Studios C++ 2008 compile thing? Do I need to do that again or do you mean compile from the SVN download? Just need to make sure we are on the right page here.
http://i269.photobucket.com/albums/j...Thesefiles.png

1) Update your source code from SVN. Assuming you're using TortoiseSVN you right-click the EQEmuServer directory and choose SVN Update.

2) Open server.sln in Visual Studio and choose Build -> Build Solution

3) Copy the newly built exe and dll files from the build directory to where you run the server from. Only the exe and dll files, not the directories.

From there you should be able to run the server using your batch file or however you have been doing it. If it doesn't work properly you need to look through the most recent logs to see if there are query errors and such. It's generally easier if you delete all of the logs when you update so you don't have any from the old version to confuse you.

You also need to keep up the various patch_XXXXX.conf files in your server directory.

They are located in the \trunk\EQEmuServer\utils folder. They do not update very often. Only when new opcodes are defined and changed. All of them for current clients were updated on April 18th. The UF one was last updated April 29th.

edit: also you should now have 6 projects building not 5.
edit 2: compiling means to open the solution in visual studio and building it to make new .exe files. Updating the SVN is just that, updating the SVN. That simply downloads all the changes since last time you updated the SVN. it does not compile the source code.
edit 3: while we are at it, sourcing in the changes/updates means to run the MySQL scripts in the \trunk\EQEmuServer\utils\sql\svn folder. From the mysql command prompt the mysql command is "source" hence the term. It sounds like you are running them with a SQL editor program which is just fine, just letting you know what the term means.

Sorvani has the compile issue with queryserv been fixed?

a month or so ago, yes.

Recompiled 2141, Guilds are working and so is #bot stance! WOOT! Varlyndria is back in business ladies and gents! Thank you for all the help! :D

Good to hear, I just ignored it on my last few compiles out of habit lol.

Im running into a similar problem with 2142. I just downloaded 2142 and recompiled it. Bot stance works but guilds are broken, apparently...

Im on linux, debian, and the server works wonderfully, except for guilds. What information can I provide you with to be of some help?

Not sure if it's different for Linux but you need to copy over the updated opcode.conf files that are located inside the source/trunk/EQEmuServer/utils/ directory.

You may want to start a new thread as your issue is not the same as was experienced in this thread. Maybe you need to add queryserv to your startup and shutdown scripts, and add a symlink to the queryserv file like you should have done for world/zone/eqlaunch/etc during the initial install. As long as you are up to date on the latest SQL updates, I think it should work fine.