modern acc forum dosent work?

[TKO]

hey how come modern acc forum dosent work?
i get this error:

Error Number: 1054

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

 

[chojrak]

You gotta create thread_id field in database.

 

[TKO]

well how do i do that?:S there is no import file for that?

 

[TKO]

bump?

 

[Alyhide]

CREATE TABLE IF NOT EXISTS `thread_id` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `param1` varchar(255) NOT NULL,
  `param2` varchar(255) NOT NULL,
  `param3` varchar(255) NOT NULL,
  `param4` varchar(255) NOT NULL,
  `param5` varchar(255) NOT NULL,
  `param6` varchar(255) NOT NULL,
  `param7` varchar(255) NOT NULL,
  `delete_it` int(2) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 ;

idk, It might work

 

[TKO]

What you mean if it dont work nice that you dont test it...

 

[TKO]

Dosent work....

 

[Alyhide]

What you mean if it dont work nice that you dont test it...

well I don't have that problem, so I never did that, But i'm pretty sure it will work.

 

[Perex]

Help i need help how to create a web?

 

[Alyhide]

Help i need help how to create a web?

If you already have a server running, then look in the tutorials section.

 

[TKO]

No idea why i got this error really. Still need help some one can post the forum sql for me then?

 

[TKO]

bump i need help!

 

[TKO]

help plox!

 

[TKO]

self bump

 

[TKO]

bump still need help...

 

[TKO]

Come one any one?:S

 

[TKO]

Hey i need help i still havent got the forum to work still have this database error:

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

 

[TKO]

i keep bumping then can any one help me with this?:S

 

[stian]

SQL:

ALTER TABLE posts ADD (thread_id int(16) NOT NULL);

 

[TKO]

Error Number: 1054

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

I still have this error...