Can't choose Blood Elves nor Dranei!

[Souljah123]

Okay, i followed a guide and installed everything perfectly.

The server starts up fine and show no signs of error, but when i login to test, the blood elves and draenei are grayed out!



By the way, im using vv@vv TBC v2.0.12!

Thanks.

Server Setup:

Mangos v3452
SDB latest release
Mangoscript 261
Windows XP Pro. SP2
Core 2 Duo e6700
4GB of dual channel RAM

[MentaL]

[xganterx]

You have TBC instaled?? if yes there is 2 ways to make this work.

1.On your Database go to "realmd_bc","realmd"... and open account table,select you account and find "tbc" table if its "0" chance it to "1".

2.on you mangos root folder open "mangosd.conf" open it and find


# BC support.
# Default: 0 (No support)
# 1 (BC needed to logon)
BCSupport = 0

Chance it to:


# BC support.
# Default: 0 (No support)
# 1 (BC needed to logon)
BCSupport = 1

[Souljah123]

I can't find:
# BC support.
# Default: 0 (No support)
# 1 (BC needed to logon)
BCSupport = 0

I want my testers to be able to create TBC characters without me changing the TBC thing.

[xganterx]

what repack you use ?

Edit: there is way to make "tbc" "1" to default to DB but i dont remember where is guide to this

[xganterx]

If found it,but i dont know is this work

ALTER TABLE `account` ADD `tbc` TINYINT(3) UNSIGNED NOT NULL DEFAULT '1' AFTER `online`;

insert this to empty notebad doc and save it whit "tbcfix.SQL" name and then execute it to realmd DB

[Souljah123]

I tried importing the script.sql and it says there is an error with duplicate entries.

Setting account to tbc "1" works, but now i need to know how to make it so that everyone who makes an account will have TBC enabled by default.

[FamineMK]

If found it,but i dont know is this work

ALTER TABLE `account` ADD `tbc` TINYINT(3) UNSIGNED NOT NULL DEFAULT '1' AFTER `online`;

insert this to empty notebad doc and save it whit "tbcfix.SQL" name and then execute it to realmd DB

It doesn't work because he's "Adding" a new column after "online" called TBC. The problem is, your DB already contains this column. What you need to do (If you're using SQLyog) is go into your realmd database, right click on the "Account" table, and go to "Alter" you will see a whole bunch of info about that DB and its columns. Each Column is separated into rows now with the information about it in columns. Look up in the column headers, and find "Default" Scroll down through the list until you find your column. (In this case it's TBC) It should be 0 at this point in time, you want to change that to a 1. Don't forget to save the changes.

[kennythekid]

use this:

Update `account` SET tbc=1 WHERE tbc=0;

this should fix your problem

[Souljah123]

It doesn't work because he's "Adding" a new column after "online" called TBC. The problem is, your DB already contains this column. What you need to do (If you're using SQLyog) is go into your realmd database, right click on the "Account" table, and go to "Alter" you will see a whole bunch of info about that DB and its columns. Each Column is separated into rows now with the information about it in columns. Look up in the column headers, and find "Default" Scroll down through the list until you find your column. (In this case it's TBC) It should be 0 at this point in time, you want to change that to a 1. Don't forget to save the changes.

Thanks, this fixed it for me!

[FamineMK]

use this:

Update `account` SET tbc=1 WHERE tbc=0;

this should fix your problem

Then you have to do it every time you get new accounts. Setting it to be Default works the best way.



Glad I could help.