Solved SQL error, missing table in DB

[silveralol]

how I can fix it?

[Error - mysql_store_result] Query: SELECT `id`, `account_id`, `group_id`, `deletion`, (SELECT `type` FROM `accounts` WHERE `accounts`.`id` = `account_id`) AS `account_type`, (SELECT `premium_points` FROM `accounts` WHERE `accounts`.`id` = `account_id`) AS `coinbalance`, (SELECT `premdays` FROM `accounts` WHERE `accounts`.`id` = `account_id`) AS `premium_days` FROM `players` WHERE `name` = 'Shaco'
Message: Unknown column 'premium_points' in 'field list'

I need create the correct table at database, but I don't know how make it, please tell me the command.
thanks

 

[HalfAway]

Column premium_points do not exists in database.

ALTER TABLE `accounts` ADD `premium_points` int(11) DEFAULT 0;

 

[silveralol]

Column premium_points do not exists in database.

ALTER TABLE `accounts` ADD `premium_points` int(11) DEFAULT 0;

thank you, I fixed it by myself, Tomorrow I can send you a message about sql commands ? I've got the store module, I need to create some tables and colums to have it working perfectly...
then, you can help?

 

[HalfAway]

thank you, I fixed it by myself, Tomorrow I can send you a message about sql commands ? I've got the store module, I need to create some tables and colums to have it working perfectly...
then, you can help?

Yes, feel free to PM me.