Myra db update

[jimmy6154]

Hiyas... I must be doing something wrong.


Fresh install

Sourced db.sql from you website - no problem
Sourced dumpeditems.sql - No problem
Sourced myradb.sql - Got a ton of duplicated error. I think it ran for about 6 hours b4 it finished. I would say 90% of it was duplicates
Sourced myraitems - no problem

I log into with no issues, though I got no mobs... I'm forgetting something?

[Conan]

the error I think you were seeing is lastname cannot be null, I sourced this morning with this and that was the error I seen,

[Scorpious2k]

Originally Posted by Lurker_005

The latest dumpeditems.sql has a different structure than the db.sql file. A good reason to dump the table structure with the data.

I didn't know it had changed... only looks like some things got moved around and a couple of new things added.

I also noticed

  revoked tinyint(3) unsigned NOT NULL default '0',

in the accounts table. I don't know if this is needed, or will cause problems.

It will be, that one is just a little ahead of released code.

PS. the Trump, Scorp, Myra exchange gave me a good chuckle, thanks

Trump is a good sport and a great guy.

As for the db: I changed db.sql for her (new one with changes on her download page), since she is in school and won't be home until late because of a field trip.

I think there may still be problems with items, but the rest should be fine.

[jimmy6154]

So if I start from scratch again

souce db downloaded from the her site
source dumpeditems
source myradb
source myra items

I sould be ok then?

[Scorpious2k]

yes, except for the items - the tables are in different order for some reason. Spawns/mobs should be good.

[Trumpcard]

Trump is a good sport and a great guy.

My wife disagrees vehemently... I am the archangel of fury and darkness...

She just doesnt understand me... Maybe I should scream louder and throw more pots....

[Monrezz]

Heh, must be great living with you

Try throwing other things at her as well. The harder it hits the more points you get! :o

Monrezz

[Trumpcard]

I told her a joke the other day, she didnt appreciate it..

'What do you tell your wife when she has 2 black eyes?'

'Nothing, she obviously wasnt listening the 1st 2 times you tried to tell her!'


Poster note: I am no way condoning violence against women in any way, shape or form. I am a firm believer that no man should ever strike a woman in anything other than self defense. I am merely expressing my desire to punch my wife in the face at times (which has never happened, at least as far as the courts are concerned (HAHAHA, J/K) )

[samandhi]

I am no way condoning violence against women in any way, shape or form

Yeah I dont condone or practice violence against women, but I UNDERSTAND it! j/k of course <smile>

[jimmy6154]

whew got this to work with no error...

Great job everything looks great though some of the poair mob locs are a bit off. Everything looks great

here is what I did.

downloaded everything from myra's website.

Sourced the db
sourced myradb
sourced dumpeditems
sourced myraitems

no errors works great!

[hoser2x]

Sorry but I feel kinda lost here. What should be the proper order for sourcing the sql data? I did the following order and now everytime a client connects my world server basicly dumps.

db.sql (Myra's)
MyraDB.sql
dumpeditems.sql
MyraItems.sql

I'm a novice w/ mysql so any help is appreciated!

It appears that my problem may actually be more of an issue during new character creation, as I'm working with the patched to eqlive current version. Going to see if i can insert a precreated character and see if the same problems still exists.

[jimmy6154]

I started from scratch. I had a clean slate. Try that and see if it helps.

[hoser2x]

It's definitely a character creation problem, was able to source the above again w/o any errors. Does anyone have an export of a level 1 character that i can use to to just get back in game? I tried my luck at creating a new one w/o going thru the in game wizard using the eqemu admin tool 5.1 without success. Everytime I sign on the server, the console says "Received unknown opcode: 0x00f0 size:0 bytes".


Not a big deal cause I know these problems won't exist once the latest version is available, but more of a learning experience.

[Monrezz]

[code]DROP TABLE character_;
CREATE TABLE character_ (
id int(11) NOT NULL auto_increment,
account_id int(11) NOT NULL default '0',
name varchar(64) NOT NULL default '',
profile blob,
guild int(11) default '0',
guildrank tinyint(2) unsigned default '5',
timelaston int(11) unsigned default '0',
x float NOT NULL default '0',
y float NOT NULL default '0',
z float NOT NULL default '0',
zonename varchar(30) NOT NULL default '',
alt_adv blob,
zoneid smallint(6) NOT NULL default '0',
pktime int(8) NOT NULL default '0',
inventory blob,
publicnote varchar(100) NOT NULL default '',
groupid int(10) unsigned NOT NULL default '0',
PRIMARY KEY (id),
UNIQUE KEY name (name)
) TYPE=MyISAM;

INSERT INTO character_ VALUES (1,1,'Monrezz','

[hoser2x]

I was able to source it w/o issues, but as soon as I sign on it gives me "Got a bogus character <Monrezz>, deleting it.". Is it possible that it's not pointing to the account I'd logged in with?