Windows Need help modern aac

[ruttie239]

Hello Otlanders

A Database Error Occurred
Error Number: 1054

Unknown column 'nickname' in 'field list'

SELECT `id`, page_access, nickname FROM `accounts` WHERE `name` = '1' AND `password` = sha1('1')

If i login i get this error /\

can someone help me?

thank you

 

[Icy]

Unknown column 'nickname' in 'field list'

K, well first off, do you understand what this means?

 

[ruttie239]

yea i think
the nickname could not loaded from my database right?

Can u help me please

 

[Icy]

Sure.

To start off, you don't have a column entitled "nickname", so you must make one.

 

[ruttie239]

Already got it but thanks

ALTER TABLE `accounts` ADD `nickname` VARCHAR(255) NOT NULL DEFAULT '';

this i needed