Column Error When Adding Vendors?

[luc1f3rspalm]

If you just copied your old db to the new repack then take the spellfixes table from the new repack and replace the current one you have with it. (if you travel to your mysql data folder you can find all your tables and such there, just copy the files for the spell fixes table from the new repack and paste them over your current tables.)

If i am correct in guessing that you are trying to use your old db on the newer core then you will most likely encounter many other issues as well. Such mounts not working along with vendors and such.

If you know a fair amount of sql, you should be capable of writing a few queries to add any columns you are missing and rename any tables that are named improperly.

Best way to do this is go through and check all the columns in the tables and make sure they match the new db, if they don't just add whats needed (you may be missing some values though.)

[The End]

Yeah, I've been playing around a lot with it for the last 30 minutes, I have a general knowledge of SQL, but not enough to run my own queries.

So... we decided to start fresh... can I just delete my database, and then somehow maker a new one...?

And where is revision 1509? The latest I can find anywhere is 1507, and the download is only around 8MB...

[luc1f3rspalm]

Search around the forums, i believe there are plenty of repacks that contain the 1509 revision.

If you are limited on knowledge when it comes to sql i advise you just use a readily available db from a repack.

If you do decide to just add columns or change column names you can use the two queries below.

Alter table dbname change oldtablename newtablename varchar(255);

(the varchar(255) would be your column definition/type.)

Alter table tablename add columnname varchar(255);

If you wanted the column in a specific position other then the last column you would us "after columnname" if you wanted it to be first just use "first" at the end of your query.

[The End]

I would hate to do this to you, but which guide would you recommend for redoing this? I'm currently looking at this one:
http://www.mmowned.com/forums/emulat...c-3-0-2-a.html

*It's really a 2.4.3 ArcEmu server running r1508

[luc1f3rspalm]

Ac-web repacks work quite well, personally i suggest if you want to build one from the ground up mostly, just find one that's mostly blizzlike and has no extra npcs added and such.

It's not a bother though, i wouldn't be on the forums answering your questions if i didn't feel like it. (not as if someones forcing me to write this post.)

though i don't really like arcemu, i would suggest a ascent server but that all comes down to preference.

Ill see if i can find one that i think would suite you.

(and don't feel bad, currently my server is running on a very old revision, and my team has developed quite a bit on it, so i plan to convert most of the database over to a 1508 or even try my hand at compiling my own.)

[The End]

Well thank you for your help, I really do appreciate it.

I've got quite a bit of experience with websites and their SQL databases and such, and for this WoW server project I had a friend help set it up for me.

Now that i'm doing this myself, I'm kind of understanding the gist of what I need to do...

I'm planning on downloading AC-Web's ultimate repack v7.8.

Which includes ArcEmu Revision 198... so... if I get this right, I'll have revision 198... and right now they're at revision 1508... so I would have to update the ArcEmu part... how would I do so?

Anyways... I think I get this, but need some help along the way.

If you're willing, we can continue this via the boards, or take this over my Vent server/AIM, but thats up to you.

Look forward to your reply.

[Aznex]

I think you're best of compiling stuff yourself

Could take a look at this guide if you decided to start over:
http://www.mmowned.com/forums/emulat...le-arcemu.html Credits to Sounddead.

tells you pretty much everything u need and how to work with it.