Windows help me :)

[Muciz]

the problem is :

Error Number: 1146

Table 'hellfire.posts' doesn't exist

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` <= '0' AND `requireLogin` != '1' AND `b`.`guild` IS NULL GROUP BY `b`.`id` ORDER BY `b`.`order` ASC;

Thank you for helping//

 

[Cronox]

why not have table
posts go to phpmyadmin - SQL
and execute this query

CREATE TABLE IF NOT EXISTS `posts` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(120) ,
  `text` text,
  `time` INT(11),
  `author` VARCHAR(64),
  `board_id` INT(11),
  `thread_id` INT(11),
  PRIMARY KEY (`id`),
  FOREIGN KEY (`board_id`) REFERENCES `forums` (`id`) ON DELETE CASCADE,
  FOREIGN KEY (`thread_id`) REFERENCES `threads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

[Loney]

The table POSTS does not exists in your PMA, (i think that posts is 4 the forum), you need to execute the query of the posts that can be founded in the ModernAAC

 

[Muciz]

Cronox ---> #1005 - Can't create table 'hellfire.posts' (errno: 150)