Go Back   EQEmulator Home > EQEmulator Forums > OpenZone > Simple Client

Thread Tools Display Modes
Old 10-29-2008, 02:30 AM
Fire Beetle
Join Date: Mar 2008
Posts: 19
Default Just a little trouble.

First of Windcatcher, great job you've done with this, thank you for the hardwork you've put into this.

I just having on installing issue, likely due to my brain's failure. Hopefully somone could help me clear up a few things. First when I was sourcing in the simpleclient sql file, it started freaking out everytime id tried to create the items table. Error: Duplicate column name 'id', well a quick look inside and I just changed the line PRIMARY KEY (id,id) to PRIMARY KEY (id) in the items table entry. If I wasn't supposed to change that, that would be my first screwup.

So sourced again with the change, and it sourced with out error. So changed the config files, and booted up world and zones, that started right up. Now went to go create account and follow the instructions Cripp gave in the sticky, BTW great instructions Cripp, thank you for those.

Following the directions to create a account mysql gives the error Field 'packencrypt' doesn't have a default value.

So forgive my failure... and thank you for any help.

Using MySQL 4.1.22
and simpleclient
Reply With Quote
Old 12-29-2008, 04:59 AM
Join Date: Jan 2002
Posts: 1,175

Sorry for taking so long to reply. I'm no DB expert by any means, so I can't offer much help there. Is it working okay for you?

Now that I've got everything else released lately I'm working on getting another full release of SimpleClient out. I added over 80 spells tonight and tomorrow I want to take a look at resurrection to see if I can get that working. Then I have a lot more DB work to do (mainly getting the new spells to merchants), reorganizing mobs, some testing, gah, it never ends. The short of it is that I really want to do a release before the end of the coming week (we'll see how it goes).

The spells I added pretty closely match live, though all names are changed, as well as a few numbers. I might go over it with another pass and change things some more. Oh, and I had to create a bunch of new spell icons to accommodate them, too, even more time spent... In case anyone's wondering, I'm not using the live spell file, for one that's illegal and for another it's a hugely disorganized mess anyway. Websites are better sources of information, and a thesaurus is a must when inventing names and placing entire spell lines along different concepts.

One step at a time. At least now, most of the cleric spells up to level 50 are in, barring resurrection spells, strength buffs, and a few odds and ends.
Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -4. The time now is 10:54 PM.


Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
Powered by vBulletin®, Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3