can't create character

[dominikid07]

i am having a problem everytime i create a character it disconnects me, and i think it's my sql, can someone please let me get a character.sql that does not have this disconnect problem, i have tried 5 and none of them worked. just in case here are my conf files and some pictures of world.exe and login.exe, as well as my character.sql

login.conf

#######################################################################
# ArcEmu Realms Configuration File  
# Last updated at rev.1875
#######################################################################


# LogonDatabase Section
#
#    These directives are the location of the `realms` and `accounts`
#    tables.
#
#    LogonDatabase.Host      - The hostname that the database is located on
#    LogonDatabase.Username  - The username used for the mysql connection
#    LogonDatabase.Password  - The password used for the mysql connection
#    LogonDatabase.Name      - The database name
#    LogonDatabase.Port      - Port that MySQL listens on. Usually 3306.
#    LogonDatabase.Type      - Client to use. 1 = MySQL, 2 = PostgreSQL, 3 = Oracle 10g
#

<LogonDatabase Hostname = "localhost"
               Username = "sa"
               Password = "***********"<-------i purposly put the ***
               Name     = "login"
               Port     = "3306"
               Type     = "1">


# Host Directive
#
#    This is the address that the realmlist will listen on.
#    To listen on all addresses, set it to 0.0.0.0
#    Default: 127.0.0.1 (localhost)
#
#    Note: ISHost is the interserver communication listener.
#

<Listen Host = "0.0.0.0"
        ISHost = "0.0.0.0"
        RealmListPort = "3724"
        ServerPort = "8093">

# Server console logging level
#
#    This directive controls how much output the server will
#    display in it's console. Set to 0 for none.
#    0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
#    Default: 3
#

<LogLevel Screen = "0"
          File = "-1">

# Account Refresh Time
#
#    This controls on which time interval accounts gets 
#    refreshed. (In seconds)
#    Default = 600 
#    600 seconds = 10 minutes - 1 second = 0.0166666667 minutes 300 seconds = 5 minutes, 150 seconds = 2.5minutes
#    
#

<Rates AccountRefresh = "600">

# Accepted Build Range Setup
#
#    These two directives set up which clients will be
#    allowed to authenticate with the realm list.
#
#    Set these to the same builds that the server was
#    compiled for.
#
#    As of the last update, version 3.0.9 was build 9551.
#

<Client MinBuild = "0000"
        MaxBuild = "9999">

# WorldServer Setup
#
#  RemotePassword
#    This directive controls the password used to authenticate with the worldserver.
#    It must be the same between the two configs. If it is not, your server will
#    not register.
#
#    Default: "change_me_logon"
#
#  AllowedIPs
#    This section MUST be completed, otherwise all attempts to link your servers will fail.
#    These "Allowed" fields are a space-seperated list of CIDR-form IP addresses that are allowed
#    to make server connections to your logonserver, and register realms.
#    For example, everything in the 127.0.0.* range would be:
#         127.0.0.0/24, as 24 of the bits must match the 127.0.0.0
#
#    To allow a single IP,
#         1.3.3.7/32, would allow only 1.3.3.7 to connect as 32 of the bits must match.
#
#  AllowedModIPs
#    In the same form as AllowedIPs, these are the IPs that are allowed to modify the database
#    (adding bans, GMs, account permissions, etc)
#

<LogonServer RemotePassword = "ascent"
             AllowedIPs = "127.0.0.1/24"
             AllowedModIPs = "127.0.0.1/24">

Realm.exe

#######################################################################
# ArcEmu Realms Configuration File
# Last updated at revision rev.1875
#######################################################################

#********************************************************************************
#* How to use this config file:                                                 *
#* Config files are in a block->variable->setting format.                       *
#* A < signifies the opening of a block, the block name is expected after that. * 
#* After the block name, a space and then the settings sperated by = / ' '.     *
#*                                                                              *
#* e.g.                                                                         *
#* <block setting="0" someval = "1">                                            *
#*                                                                              *
#* Comments can be in C format, e.g. /* some stuff */, with a // at the start   *
#* of the line, or in shell format (#).                                         *
#********************************************************************************/

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# LogonServer Section
#
#    Address:
#      The address (no port) of the server.
#
#    Port:
#      The port on which the logon server listens. (*** NOT 3724 ***)
#
#    Name:
#      Not really relavant, but name the logon.
#
#    RealmCount:
#      The number of realms in the next section.
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<LogonServer Address = "127.0.0.1"
	Port = "8093"
	Name = "Default Logon"
	RealmCount = "1">

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Realm Section
#
#    Name:
#      The name of the realm.
#    
#    Address:
#      The address (and port) of that realm.
#
#    Icon:
#      The type of realm (PVP, Normal, RPPVP, RP)
#
#    TimeZone:
#      The location of the server (1=Development, 2=United States, 3=Oceanic, 4=Latin America, 
#       5=Tournament, 6=Korean, 8=English, 9=German, 10=French)
#
#    Population:
#      (0 = low, 1 = medium, 2 = high)
#
#   Important information below
#
#     change 127.0.0.1 to your EXTERNAL ip if you wish to have a PUBLIC server.
#     This issues come up a lot!
#
# 	Timezone values :
#	0=Korean				16=China
#	1=Development				17=CN1
#	2=United States				18=CN2
#	3=Oceanic				19=CN3
#	4=Latin America				20=CN4
#	5=Tournament				21=CN5
#	6=Korean				22=CN6
#	8=English				23=CN7
#	9=German				24=CN8
#	10=French				25=Tournament
#	11=Spanish				26=Test Server
#	12=Russian				27=Tournament
#	13=Tournament				28=QA Server
#	14=Taiwan				29=CN9
#	15=Tournament				30=TestServer2
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Realm1 Name = "WoWXtream"
	Address = "wowxtream.gotdns.com:8129" 
	Icon = "PVP"
	Population = "1"
	TimeZone = "8">

character.sql


World.exe and login.exe


hope u guys can help me out, if you need anything else for me to show you please ask.

[Vindicated]

Your character database is probably corrupt.

[alj03]

Or their is nothing in the playercreate info table?

[dominikid07]

lol i don't even have that table in my character sql. can i get a sql query or a character sql link to download a working one

[dominikid07]

lol i don't even have that playercreate table. in my character sql. can i get a sql query for playercreate table, or download one

sorry for double post

[raziel25]

The playercreate_info tables are in the world db, so you wont need them for the char/logon db.

[grandmst20]

Try using the character DB from the ArcEmu SQL folder in the SVN.

[dominikid07]

can you give me a link please i cant find it when i search

[Found]

your characters db is out of date i can get you one just PM me

[dominikid07]

ok i pmed you lost

[dominikid07]

ok now this is the problem when i create a character it gets stuck there and says creating character i have been waiting for 10min now and counting, if i press enter it cancels, and if i press it a second time this screen keeps showing



then if i go back to login screen and login again, as soon as i press enter to create a character i get disconnected from server... any ideas, i have been trying to solve this for about 3 days now

[bryanct]

hohoho, I can answer this question:

use SVN get the latest Arcemu

1. use database client connect to your Mysql
2. delete character database
3. create a new database with whatever name but do remember it, like "char"
4. double click on the new and then right click on it to execute SQL from arcemu\trunk\sql\, a file called ...character structure
5. go to Arcemu\trunk\sql\, go into utilities, there is a bat file that can help you to create tables.

you can check on the forum that there is guide of how to build server from nothing.

or easy way: download norwaign repack but only use it's database. that's what I am doing now.

[dominikid07]

ok even after i get norweigen repack i still get the same error, what do u mean with those steps i am a noob at making my own server like that. is there any other way to fix my problem??

EDITk i got past creating character part now it says create character fail

[TheSpidey]

You know you can just turn on screen logging to see which table/column it's missing

[dominikid07]

how can you turn on screen logging i have no idea what that is