[Help] application configuration is incorrect

[b!atch]

Snip! Scroll down to see the actual problem;b

[2dgreengiant]

there was a problem with the rev but it works now

[b!atch]

Ok thx, ill try again

[b!atch]

OH SHIZZLE MAH NIPPLE!..
MAJOR ERROR/WARNING:
One of your creature_spawns has the wrong column count
Ascent has skipped loading this table in order to avoid crashing
Please correct this, if you do not, no spawns will show..
whaaaaaaat? xE ;s

[2dgreengiant]

in creature_spawns and gameobject_spawns delete the row called id2 for both of them and it will work

[b!atch]

thx.., ur the perfect teacher:b

[roflstomp15]

2D, first of all I just want to say thanks for helping me out so much, it says I can't give you any more rep ;[

Anyway, it says that 0 accounts has been preloaded because its being muted from the DB.. halp?

[b!atch]

I lost my net connection for liek. almost 2 days.. how exactly do i find that "row"?^^ ima complete nub with navicat..or well... actually not, just never worked with rows:P

[2dgreengiant]

roflstomp15 use this sql query:

alter table accounts add column muted int(30) not null default 0;

b!atch post ur con files


edit: change these b!atch

<LogonDatabase Hostname = "custom-world.game-server.cc"
Username = "root"
Password = "root"
Name = "ascentlogon"
Port = "3306"
Type = "1">

change whats in red to 127.0.0.1

[b!atch]

Saw that error, fixed it.. the problem is that i cant find the row u told me to delete. actually i didnt know what u were talking about

in creature_spawns and gameobject_spawns delete the row called id2 for both of them and it will work

[2dgreengiant]

in the tables in your db called gameobject_spawns and creature_spawns and delete the coulomb id2

[b!atch]

How do i do that exactly? DELETE FROM `gameobject_spawns` WHERE (`id`='2') deletes the record.. that has entry id 2.. how do i find the column?.. thats the whole problem. i have no clue at all about how i find it and delete it? could u tell me a query to delete it?:P that would be sooo much easier, sorry for beeing so un-understanding^^

[2dgreengiant]

ALTER TABLE creature_spawns DROP id2

and

ALTER TABLE gameobject_spawns DROP id2

[b!atch]

THX! i love you so much lol:P.. Would rep you.. But cant;d

[b!atch]

Argh.. 1091 Can't DROP 'id2'; check that column/key exists happens for both. >.< and ascent still gives me the old warning..

MAJOR ERROR/WARNING:
One of your creature_spawns has the wrong column count
Ascent has skipped loading this table in order to avoid crashing
Please correct this, if you do not, no spawns will show..
whaaaaaaat? xE ;s