Windows Modern AAC - Page Errors etc.

[Novap]

Hi, need help becaus i got some errors.
Cant create account either, no errors it just freeze's and nothing happends. (Help)
----------------

Login >> User: RANDOM >> Pass: RANDOM

[B]Error Number: 1054

Unknown column 'name' in 'where clause'

SELECT `id`, `page_access`, `nickname` FROM (`accounts`) WHERE `name` = '1242' AND `password` = 'SHA1 PASS'[/B]

Edited the sha1 password (Only in thread)
----------------

Who Is Online?

[B]Error Number: 1054

Unknown column 'world_id' in 'field list'

SELECT `name`, `level`, `world_id`, `vocation`, `promotion` FROM (`players`) WHERE `online` = 1 ORDER BY `level` DESC[/B]

----------------

Guilds

[B]Error Number: 1054

Unknown column 'world_id' in 'field list'

SELECT `id`, `name`, `world_id`, `motd` FROM (`guilds`)[/B]

----------------

Highscores

[B]Error Number: 1054

Unknown column 'promotion' in 'field list'

SELECT name, online, level, experience, vocation, promotion, world_id FROM players WHERE world_id = 0 AND deleted = 0 AND group_id < 3 AND name != "Account Manager" ORDER BY experience DESC[/B]

------------------

Houses

Error Number: 1054

Unknown column 'town' in 'where clause'

SELECT count(id) FROM `houses` WHERE `town` = '1' AND `guild` = 0 LIMIT 10[/b]

------------------

Latest Death(s)

= BLANK PAGE[/b]

------------------

Search Character >> NAME

= BLANK PAGE[/b]

-----------------------------------
Rep++ for helping me.

 

[Sylania]

i also am having the same problem

 

[volitar]

Hi, need help becaus i got some errors.
Cant create account either, no errors it just freeze's and nothing happends. (Help)
----------------

Login >> User: RANDOM >> Pass: RANDOM

[B]Error Number: 1054

Unknown column 'name' in 'where clause'

SELECT `id`, `page_access`, `nickname` FROM (`accounts`) WHERE `name` = '1242' AND `password` = 'SHA1 PASS'[/B]

Edited the sha1 password (Only in thread)
----------------
ALTER TABLE `accounts` ADD `nickname` INT(11) DEFAULT 0;

Who Is Online?

[B]Error Number: 1054

Unknown column 'world_id' in 'field list'

SELECT `name`, `level`, `world_id`, `vocation`, `promotion` FROM (`players`) WHERE `online` = 1 ORDER BY `level` DESC[/B]

----------------
ALTER TABLE `players` ADD `world_id` INT(11) DEFAULT 0;

Guilds

[B]Error Number: 1054

Unknown column 'world_id' in 'field list'

SELECT `id`, `name`, `world_id`, `motd` FROM (`guilds`)[/B]

----------------
ALTER TABLE `guilds` ADD `pmotd` INT(11) DEFAULT 0;

Highscores

[B]Error Number: 1054

Unknown column 'promotion' in 'field list'

SELECT name, online, level, experience, vocation, promotion, world_id FROM players WHERE world_id = 0 AND deleted = 0 AND group_id < 3 AND name != "Account Manager" ORDER BY experience DESC[/B]

------------------
ALTER TABLE `players` ADD `promotion` INT(11) DEFAULT 0;

Houses

Error Number: 1054

Unknown column 'town' in 'where clause'

SELECT count(id) FROM `houses` WHERE `town` = '1' AND `guild` = 0 LIMIT 10[/b]

------------------
ALTER TABLE `houses` ADD `town` INT(11) DEFAULT 0;

Latest Death(s)

= BLANK PAGE[/b]

------------------

Search Character >> NAME

= BLANK PAGE[/b]

-----------------------------------
Rep++ for helping me.

the other i dont know..

it should make it.. it was a while ago you needed it but if someone other need it they can see it now

it workt for me.. so credit dont go to me it goes to Chris he made me understand how to fix it.