Apras
New Member
Hey how come modern acc forum dosent work?
i get this error:
A Database Error Occurred
Error Number: 1054
Unknown column 'thread_id' in 'field list'
SELECT `b`.`id`, `b`.`name`, `b`.`description`, `b`.`closed`, `b`.`moderators`, `u`.`name` AS `author`, `p`.`thread_id`, `t`.`name` AS `thread_title`, `p`.`time` FROM `forums` AS `b` LEFT JOIN (SELECT `time`, `thread_id`, `board_id`, `author` FROM `posts` ORDER BY `time` DESC) AS `p` ON `p`.`board_id` = `b`.`id` LEFT JOIN `players` AS `u` ON `u`.`id` = `p`.`author` LEFT JOIN `threads` AS `t` ON `t`.`id` = `p`.`thread_id` WHERE `b`.`access` <= '5' AND (`b`.`guild` IS NULL OR `b`.`guild` IN (SELECT `guild_id` FROM guild_ranks WHERE `id` IN (SELECT rank_id FROM players WHERE account_id = '1'))) GROUP BY `b`.`id` ORDER BY `b`.`order` ASC;
i get this error:
A Database Error Occurred
Error Number: 1054
Unknown column 'thread_id' in 'field list'
SELECT `b`.`id`, `b`.`name`, `b`.`description`, `b`.`closed`, `b`.`moderators`, `u`.`name` AS `author`, `p`.`thread_id`, `t`.`name` AS `thread_title`, `p`.`time` FROM `forums` AS `b` LEFT JOIN (SELECT `time`, `thread_id`, `board_id`, `author` FROM `posts` ORDER BY `time` DESC) AS `p` ON `p`.`board_id` = `b`.`id` LEFT JOIN `players` AS `u` ON `u`.`id` = `p`.`author` LEFT JOIN `threads` AS `t` ON `t`.`id` = `p`.`thread_id` WHERE `b`.`access` <= '5' AND (`b`.`guild` IS NULL OR `b`.`guild` IN (SELECT `guild_id` FROM guild_ranks WHERE `id` IN (SELECT rank_id FROM players WHERE account_id = '1'))) GROUP BY `b`.`id` ORDER BY `b`.`order` ASC;