Solved Massive Error mAAC

[keccish]

Hello guys, was trying out my forum and when I was accessing a thread I created I got this error:

Error Number: 1054

Unknown column 'a.avatar' in 'field list'

SELECT `p`.`title`, `p`.`text`, `p`.`time`, `u`.`name` AS `author`, `p`.`board_id`, `p`.`id`, `a`.`avatar` FROM `posts` AS `p` LEFT JOIN `players` AS `u` ON `u`.`id` = `p`.`author` LEFT JOIN `accounts` AS `a` ON `a`.`id` = `u`.`account_id` WHERE `p`.`thread_id` = '1' ORDER BY `p`.`id` ASC LIMIT 0, 10


Using ModernAAC

 

[hodleo]

query in your db

ALTER TABLE `accounts` ADD avatar char(48);

read www or htdocs\install\dbSCHEMA.txt