More Problems

[techguy84]

OK, I fell like broken record now. Anyhow, earlier today, I had my server up and running and everything went off with-out a hitch, but it wasnt the cleanest install. I had used WAMP to get Apache, PHP and Mysql all in one package because I was going to try out the PEQ Editor. When I sourced the CVS of Peq, and booted up world and company, everything was fine minus the fact that I had to log in twice in order to get through. But once I was in I was so happy to see that starting items were finally working. I thought ok, all i need now is 5.0.27 of mysql, and 992 of the emu, and we should be set. Peq Editor doesnt work so I can just remove Wamp and put the things I need back on.

Anyhow I did this and now starting items are gone again, plus I still have to log in twice to get through to character select. Anyhow, here is my current problem, if anyone knows a solution.

The time frame on each one of these next code boxes to look at is between 23:57 and 23:58

[04.14. - 23:47:23] Starting Log: logs/eqemu_error_world_2856.log
[04.14. - 23:47:23] Could not load EQTime file eqtime.cfg
[04.14. - 23:57:26] StoreCharacter inventory failed. Query '(null)' #1264: Out of range value adjusted for column 'color' at row 1
[04.14. - 23:57:26] StoreCharacter inventory failed. Query '(null)' #1264: Out of range value adjusted for column 'color' at row 1
[04.14. - 23:57:26] StoreCharacter inventory failed. Query '(null)' #1264: Out of range value adjusted for column 'color' at row 1
[04.14. - 23:57:26] StoreCharacter inventory failed. Query '(null)' #1264: Out of range value adjusted for column 'color' at row 1


These errors are what I can see in World right after I create a character. Now keep in mind that it still wont let me log on into zone. World acts like its sending me to the zone, as zone goes online and list 7005:qeynos 0 clients.

EQ just freezes up, or times out, dont know as I dont wait for a message from it.

Here is a snipet from a zone log dump:

---------------------------------------------
[04.14. - 23:48:12] Starting Log: logs/eqemu_zone_4060.log
[04.14. - 23:48:12] Using database 'peq' at localhost:3306
[04.14. - 23:48:12] EMuShareMem loaded
[04.14. - 23:57:28] Booting qeynos
[04.14. - 23:57:28] Loading spawn conditions...
[04.14. - 23:57:29] Loading static zone points...
[04.14. - 23:57:29] Loading spawn groups...
[04.14. - 23:57:32] Loading spawn2 points...
[04.14. - 23:57:32] Loading player corpses...
[04.14. - 23:57:32] Loading traps...
[04.14. - 23:57:32] Loading ground spawns...
[04.14. - 23:57:32] Loading Ground Spawns from DB...
[04.14. - 23:57:32] Loading World Objects from DB...
[04.14. - 23:57:32] Loading Objects from DB...
[04.14. - 23:57:32] Loading doors for qeynos ...
[04.14. - 23:57:32] Loading Doors from database...
[04.14. - 23:57:32] Loading AA information...
[04.14. - 23:57:32] Loading Merchant Lists...
[04.14. - 23:57:32] Loading Temporary Merchant Lists...
[04.14. - 23:57:34] Successfully loaded Zone Config.
[04.14. - 23:57:34] Loading timezone data...
[04.14. - 23:57:34] Init Finished: ZoneID = 1, Time Offset = 0
---------------------------------------------
[04.14. - 23:57:34] Starting Log: logs/eqemu_zone_4060.log
[04.14. - 23:57:34] ---- Zone server qeynos, listening on port:7005 ----
[04.14. - 23:57:34] Zone Bootup: qeynos (1)
[04.14. - 23:58:35] Zone Shutdown: qeynos (1)
[04.14. - 23:58:35] Zone shutdown: going to sleep

As you can see there are no errors in this log, but I did find this one in another debug log file,

[04.14. - 23:48:12] [ZONE__INIT] Starting EQ Network server on port 7005
[04.14. - 23:57:28] The next weather check for zone: qeynos will be in 11940 seconds.
[04.14. - 23:57:34] Zone: qeynos has weather of type 1.
[04.14. - 23:57:34] Zone: qeynos(1) has weather type = 1. The weather timer has been enabled.
[04.14. - 23:57:36] [WORLD__CLIENT] New connection from 127.0.0.1:1651
[04.14. - 23:57:36] [NET__IDENTIFY] Unable to identify stream from 127.0.0.1:1651 before it closed.

Judgeing by this last code, and the begining of the first string of errors in the first box, the exact time that the errors started was 23:57:36 which was the moment that I clicked next at the end of the Character Creation screen. Once this happend it tried to submit the information to the database. I can only assume that this caused my client to disconnect, and I didnt know about it, would explain why I was going to time out.

Anyhow, I have kinda figured out the problem, but I dont know how to solve it. This happens with every database, emu combination I have tried. Angelox's Classic, Peq Final Luclin, Emu 845 985 991 992, serveral combinations, all to no avail.

Thanks for any help anyone can give me.

[Angelox]

Here's a few ideas;
- if you are not useing the PEQ from CVS and don't know/want to update the PEQ you downloaded from their site, then stick with mine (ax_peq, ax_classic) untill you learn more. The big difference between peq and my database is, PEQ has more "packet-spawned" zones; By this i mean the zones are spawned from live-capture packets, but need public-servant volunteers like Cavedude, me, and a few others, to get these zones working properly (drops, aggro, named, etc.). This is not hard work, it's sort of like a "database entry" job with no pay. ANYONE can easily learn how to do this.

If you downloaded PEQ editor and didn't update it from CVS , this might have messed up your database and you need to re-download (the database). When I verify mine (I am working off a PEQ Editor restore from Nov,96), I will post it somewhere safe, so others can benefit from it,

[techguy84]

Ok, maybe I wasnt super clear on that last post... anyhow.

I was using the PEQ via CVS. Newest one as of 3/12. I had sourced it in to the database peq in MySql 5.0.27.

I installed and configured the Emu v0.7.0.992. When I first tried to play, everthing worked fine, except I had to log in twice. I then tried to experiment with the PEQ Editor v1.0. I had too much trouble getting Apache and PHP5 working by installing each on seperately, so I went and installed WAMP5, this automatically set up all those components and also PhPMyadmin and things like that.

I tinkered with PEQ Editor only to give up on it because I am not fluent in PHP.

I then tried to log into the game just to look at something when all of a sudden, the starting items were working now. By starting items I mean food, water, and weapon, (I had only tried a Human Paladin and a Wood Elf Ranger).

I figured that I may have struck a perfect note and now I can start working with the database to add some custom content and things.

So I figured that I could remove WAMP5, reinstall MySQL 5.0.27 since I wont be using the PHP and Apache components at the moment.

I did this, re sourced in the PEQ CVS database from the beginging(fresh install), and I logged in. I noticed that I still had to make at least two attempts to log in, but once I made it in, and I started a new character, those starting items were gone again.

Angelox, this happens with your database also. I dont think it is the database, but more a conflict between MySql and the database. I use Navicat to work with the DB and I can reproduce that same error that the emulator gives me the "#1264 Out of Range for 'color" error by removing the "unspecifed" check box while designing the table.

I am just really at a lost for words. I though that maybe there was a item with the id of 1264 that was cause the issue, but thats not the case.

Anyhow, I think that I am just going to try and fix the error with having to log in twice and just add my own starting items. Seems like the only route that I can take.

But for aurgument sake. What version of the Emu and Mysql do you use for your database and server Angelox?

[Zard]

With minilogin I always have to log on twice, the first attempt after world start up will always freeze for me prior to showing the server list. I just CTRL+ALT+DEL, shut down EQ and restart the game. It always works for me the second time around.

A minor annoyance compared to the fun the emulator brings.

[techguy84]

This isnt the minilogin, this is public. Anyhow, the logging in twice bug seems to be gone now that I switch to 991, but still leaves the starting items error.

I have went through the starting items table and all the information is there, ie Short Sword*, but none of this will load with the emu. Im gonna try going back one more emu to see what happens

[Angelox]

I use MySql5x under Linux but also have a MySql5x windows version that works fine too.
Sometimes the smallest/dumbest things will throw you, and the error you see is not really the error at hand.
In my Linux, EqEmu wasn't seeing my Perl as it should, and also , I had some Libs missing.
For windows, EqEmu likes mySql to be installed in c:\mysql\ (MySql4x installs to c:\mysql\)
MySql5 install defaults to c:\program files\mysql\, so I just force the install to c:\mysql\ . This might help, mostly if you use the cavedude installer. Probably not a matter, but I'm just telling you how I have mine running.
Also, make sure your Perl is properly installed.
Did you update the *.conf files? the newest ones are always in the source/utils directory , but probably already updated in the windows package.

[techguy84]

Well, someone here can just slap me for all I care. Im just at a loss for words.

Anyhow, I went on a hunch to reinstall WAMP5. It uses the same 5.0.27 Mysql as I was trying to use...... and guess what. Starter Items are back. I dont know what the difference is between the two, (I do know that WAMP defaults Mysql to Root User with No password, but thats changed when running the set passowrd command).

The logging in twice thing was because of the two lines in the eqemu_config file:

<!-- Only specify these two if you really think you need to. -->
<!-- <address>Serving Machines IP</address> -->
<!-- <localaddress>127.0.0.1</localaddress> -->

not being canceled out and the emu trying to use them. Dont know what they are for, but apprently Im better off without them.

Anyhow, almost where I want to be now, but for some reason the launcher is not working. World goes to transfer to it, and it boots up the designated zone but my client drops instead of logging in. Running zones manually fixes this, but still curious about the launcher though.


p.s. Wamp installs mysql to c:\wamp\mysql\ Dont know if maybe not having the space like C:\Program Files\Mysql seems to fix some of the issues.

Anyhow, I'm glad I know a somewhat better installation, now to look into what you said Angelox about putting mysql in c:\mysql

Thanks for all the help you guys.

[techguy84]

Anyhow, no go on installing MySql to c:\Mysql. Still get the errors about the starting items. I'm thinking it something to do with the way Mysql configures it self during setup. I dont know the differnce between It and Wamp, but for now, there is no problem using wamp so away I go....