Ahhh Help! lol

[Auntie Mangos]

What exactly have you done to the database? Please list all the files you used.

I have done everything stated in this post

http://getmangos.eu/community/showthread.php?7318-Guide-Mangos-Windows-Setup

I have followed that guide to a T - so everything stated in there I have done.

and my UDB version is 0.12.0

[Randyman]

I get an error when I try and start up Mangos.. can anyone help me?

2010-07-05 19:57:31 >> Loaded 28607 Item Enchantment definitions

2010-07-05 19:57:31 Loading Items...

2010-07-05 19:57:33 ERROR:Error in item_template table, probably sql file format was updated (there should be 138 fields in sql).

and yes - I do have all the updates.

I just downloaded UDB, so that can't be the issue can it?

It just seems like all my files are current.

[Patman128]

What exactly have you done to the database? Please list all the files you used.

[Randyman]

is there a file that can check my updates auto for me? cause this is a bitch going through all the updates.

there has got to be an easier way.

yeah.. this is starting to piss me off... lol

[Patman128]

Did you make sure to update to the latest UDB patch?

[Randyman]

Did you make sure to update to the latest UDB patch?

Yes - that guide shows the most current one.

[antiroot]

what version does your database say you have currently? knowing this would tell us if you do actually have all the updates installed

Execute the following query in your MySQL client of choice (phpmyadmin, mysql-client, etc)

Edit: this should be done on your mangos database

SHOW COLUMNS FROM db_version;

You should have a column similar to required_10131_01_mangos_spell_bonus_data

EDIT: LOL don't know why I asked this now that i think about it, if your db_version was off then you'd be getting a completely different error, at any rate at least we know what version your running now, and we now know your capable of executing mysql commands

[Randyman]

okay, gimme a sec - re doing everything lol

[Randyman]

Okay sorry it took so long - had something come up that needed taken care of..

when I run that command I get this

required_10148_01_mangos_mangos_string

[antiroot]

Well that's the right db_version for the current revision.

Have you applied any patches (AHBot, etc)?

Did you have to manually change the db_version string at anytime yourself because you thought an update was "missing"

And even tho this will be a large list, can you export your item_template structure

USE mangos;
SHOW COLUMNS FROM item_template;

The column I'm concerned about is NonConsumable added in update 09509_01_mangos_item_template.sql if you used an older UDB before this and then manually tweaked the db_version in order to apply the newer updates or anything like that then that would explain why you have a invalid field count

[Randyman]

Well that's the right db_version for the current revision.

Have you applied any patches (AHBot, etc)?

Did you have to manually change the db_version string at anytime yourself because you thought an update was "missing"

And even tho this will be a large list, can you export your item_template structure

USE mangos;
SHOW COLUMNS FROM item_template;

The column I'm concerned about is NonConsumable added in update 09509_01_mangos_item_template.sql if you used an older UDB before this and then manually tweaked the db_version in order to apply the newer updates or anything like that then that would explain why you have a invalid field count

okay I got it, ty for the help

Now for another question

-I play wow retail as well, is there anyway blizz can tell that Im using a private server as well if I connect back to retail blizz?

[antiroot]

the client will pass the server any info you have in your wtf files, as long you change those back to their defaults they can't tell that way. If you want to be extra cautious tho you could delete your client's cache directories. Aside from those two things MaNGOS does not alter any client files.

Edit: oh and as long as your not using a custom/tweaked client patch, which there's not very much reason to do that in the first place unless your trying to create new features in the client that don't exist, but that is not MaNGOS related

Out of curiosity what was your solution to your database problem?

[Randyman]

the client will pass the server any info you have in your wtf files, as long you change those back to their defaults they can't tell that way. If you want to be extra cautious tho you could delete your client's cache directories. Aside from those two things MaNGOS does not alter any client files.

Edit: oh and as long as your not using a custom/tweaked client patch, which there's not very much reason to do that in the first place unless your trying to create new features in the client that don't exist, but that is not MaNGOS related

Out of curiosity what was your solution to your database problem?

Ya know - Im not sure what I did different I simply re-installed everything again and re applied all of the needed patches..

Maybe the first time around I did something wrong, Im not sure.

anyway thanks for the help