woot!! finally got 4.2 to work lol..
here is what i did
just goto the mysql/data folder and do a copy & paste of the folder eq or whatever name you gave it and rename it to like eq41 or zip it up or somthing just incase you goof up the working one.
i just took my working 4.1 database that i was playing with because 4.2 didnt work until now and i only changed a couple things in that database and it was:
1) open up mysql
b) USE EQ; (or db name you gave it)
c) ALTER TABLE variables ADD COLUMN ts timestamp NULL;
d) if you havent done this to your old 4.1 db then add source in the resists table from this link
http://forums.eqemu.net/viewtopic.ph...ht=resists+sql i had already added that to my working 4.1 version before using 4.2 and it didnt seem to hurt it any.
then..
2) open up Admin tool ( i have 3.8 )
b) on accounts tab line 1 drag bottom scroll bar all way to the right
and in the second to the last column called "isaccount_id" if it is blank just click in the box and type zero and HIT enter. there was another line below it with my user name pass and that was blank as well but i left it blank because it seemed that it only stored the char in the first one "eqemu" anyways.
c)click on COMMIT CHANGES
shut down minilogin and world and zones if running and restart it
it should work i even logged into the new version 4.2 with the guys i was playing with on 4.1 hehe
hope this helps atleast one person or i have failed.