[MySQL Error]

[Peroxide]

I don't really understand MySql that well so I was hoping some of you may be able to help me in being able to make donator accounts work.

[02/06/2014 17:12:17] GM Alex has logged in.
[02/06/2014 17:12:17] mysql_real_query(): SELECT `isdonator` FROM `accounts` WHERE `id` = '2' - MYSQL ERROR: Unknown column 'isdonator' in 'field list' (1054)
[02/06/2014 17:12:17] mysql_real_query(): SELECT `id` FROM `shop_items` WHERE `accountid` = 2; - MYSQL ERROR: Table 'thanatos.shop_items' doesn't exist (1146)
[02/06/2014 17:14:29] mysql_real_query(): SELECT `isdonator` FROM `accounts` WHERE `id` = '2' - MYSQL ERROR: Unknown column 'isdonator' in 'field list' (1054)
[02/06/2014 17:14:29] mysql_real_query(): SELECT `isdonator` FROM `accounts` WHERE `id` = '2' - MYSQL ERROR: Unknown column 'isdonator' in 'field list' (1054)
[02/06/2014 17:14:29] mysql_real_query(): UPDATE `accounts` SET `isdonator` = '1' WHERE `id` = '2' - MYSQL ERROR: Unknown column 'isdonator' in 'field list' (1054)
[02/06/2014 17:14:29] mysql_real_query(): UPDATE `accounts` SET `donatorexpire` = '1404278069' WHERE `id` = '2' - MYSQL ERROR: Unknown column 'donatorexpire' in 'field list' (1054)

 

[ribeiiro02]

ADD IN MYSQL.

1: ALTER TABLE accounts ADD isdonator INT(11) NOT NULL DEFAULT 0;
2: ALTER TABLE accounts ADD donatorexpire INT(11) NOT NULL DEFAULT 0;
3:ALTER TABLE shop_items ADD id INT(11) NOT NULL DEFAULT 0;