I tryed to install the new V1 but it gave me an error. So I've uninstalled the V0,5 and still not working with the same error : :S
* JInstaller::install: Erreur SQL. DB function failed with error number 1054
Unknown column 'pst.created_user_id' in 'field list' SQL=CREATE OR REPLACE VIEW jos_ninjaboard_view_forums AS SELECT f.*, `pst`.`subject`, `pst`.`created_user_id`, IF(usr.username, usr.username, 'Anonymous') as last_post_username, `pst`.`created_time` AS `last_post_date`, `pst`.`ninjaboard_topic_id` AS `last_topic_id` FROM jos_ninjaboard_forums AS f LEFT JOIN `jos_ninjaboard_posts` AS `pst` ON `pst`.`ninjaboard_post_id` = f.`last_post_id` LEFT JOIN `jos_users` AS `usr` ON `usr`.`id` = `pst`.`created_user_id`;
SQL =
CREATE OR REPLACE VIEW jos_ninjaboard_view_forums AS
SELECT f.*,
`pst`.`subject`,
`pst`.`created_user_id`,
IF(usr.username, usr.username, 'Anonymous') as last_post_username,
`pst`.`created_time` AS `last_post_date`,
`pst`.`ninjaboard_topic_id` AS `last_topic_id`
FROM jos_ninjaboard_forums AS f
LEFT JOIN `jos_ninjaboard_posts` AS `pst` ON `pst`.`ninjaboard_post_id` = f.`last_post_id`
LEFT JOIN `jos_users` AS `usr` ON `usr`.`id` = `pst`.`created_user_id`;
* Composant Installation: Erreur SQL ou fichier sql absent ou illisible. DB function failed with error number 1054
Unknown column 'pst.created_user_id' in 'field list' SQL=CREATE OR REPLACE VIEW jos_ninjaboard_view_forums AS SELECT f.*, `pst`.`subject`, `pst`.`created_user_id`, IF(usr.username, usr.username, 'Anonymous') as last_post_username, `pst`.`created_time` AS `last_post_date`, `pst`.`ninjaboard_topic_id` AS `last_topic_id` FROM jos_ninjaboard_forums AS f LEFT JOIN `jos_ninjaboard_posts` AS `pst` ON `pst`.`ninjaboard_post_id` = f.`last_post_id` LEFT JOIN `jos_users` AS `usr` ON `usr`.`id` = `pst`.`created_user_id`;
SQL =
CREATE OR REPLACE VIEW jos_ninjaboard_view_forums AS
SELECT f.*,
`pst`.`subject`,
`pst`.`created_user_id`,
IF(usr.username, usr.username, 'Anonymous') as last_post_username,
`pst`.`created_time` AS `last_post_date`,
`pst`.`ninjaboard_topic_id` AS `last_topic_id`
FROM jos_ninjaboard_forums AS f
LEFT JOIN `jos_ninjaboard_posts` AS `pst` ON `pst`.`ninjaboard_post_id` = f.`last_post_id`
LEFT JOIN `jos_users` AS `usr` ON `usr`.`id` = `pst`.`created_user_id`;
What can I do ? Help !