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?
|