Ok j'ai réussi à exécuter les requetes SQL demandés dans le fichier "INSTALL" du zip...

#-----[ SQL ]------------------------------------------
#
--
-- Structure de la table `phpwebgallery_news`
--

CREATE TABLE `phpwebgallery_news` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `author` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

-- --------------------------------------------------------

--
-- Structure de la table `phpwebgallery_news_group_access`
--

CREATE TABLE `phpwebgallery_news_group_access` (
  `group_id` smallint(5) unsigned NOT NULL default '0',
  `new_id` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`group_id`,`new_id`)
) ENGINE=MyISAM;

-- --------------------------------------------------------

--
-- Structure de la table `phpwebgallery_news_translation`
--

CREATE TABLE `phpwebgallery_news_translation` (
  `id` smallint(6) unsigned NOT NULL auto_increment,
  `news_id` smallint(5) unsigned NOT NULL default '0',
  `language` varchar(50) default 'fr_FR.iso-8859-1',
  `title` varchar(75) default NULL,
  `content` longtext,
  `status` enum('public','private') default 'public',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

-- --------------------------------------------------------

--
-- Insertion des données`
--

INSERT INTO `phpwebgallery_news` ( `id` , `date` , `author` ) VALUES ('1', NOW(), 'DPDev');

INSERT INTO `phpwebgallery_news_translation` ( `news_id` , `language` , `title` , `content`, `status`  )
VALUES ('1', 'en_UK.iso-8859-1', 'PWG News system installed', 'Congratulation ! The news system for PWG has been installed!', 'public');

INSERT INTO `phpwebgallery_news_translation` ( `news_id` , `language` , `title` , `content`, `status` )
VALUES ('1', 'fr_FR.iso-8859-1', 'Système de News PWG installé', 'Félicitation ! Le système de News pour PWG a été installé!', 'public');

#
#-----[ SQL FIN]------------------------------------------

mais maintenant en page d'aceuil voila ce que j'ai : http://www.bouchery.info/

( SELECT n.id AS news_id
      , n.date
      , n.author
      FROM phpwebgallery_news_group_access AS nga
      INNER JOIN phpwebgallery_news_translation AS ntt ON ntt.id = nga.new_id
      INNER JOIN phpwebgallery_news AS n ON n.id = ntt.news_id
      INNER JOIN phpwebgallery_user_group AS ug ON ug.group_id = nga.group_id
      WHERE ug.user_id = 2
      AND ntt.language = 'fr_FR.iso-8859-1'
    )
    UNION DISTINCT
    ( SELECT n.id AS news_id
      , n.date
      , n.author
      FROM phpwebgallery_news_user_access AS nua
      INNER JOIN phpwebgallery_news_translation AS ntt ON ntt.id = nua.new_id
      INNER JOIN phpwebgallery_news AS n ON n.id = ntt.news_id
      WHERE nua.user_id = 2
      AND ntt.language = 'fr_FR.iso-8859-1'
    )
    UNION DISTINCT
    ( SELECT pn.id AS news_id
      , pn.date
      , pn.author
      FROM phpwebgallery_news_translation AS nt
      INNER JOIN phpwebgallery_news AS pn ON pn.id = nt.news_id
      WHERE nt.status = 'public'
      AND nt.language = 'fr_FR.iso-8859-1'
    )
    ORDER BY date DESC
    LIMIT 3
    ;
[mysql error 1146] Table 'db168098110.phpwebgallery_news_user_access' doesn't exist

UP

please HELP !!! :(

Désolé ...

je viens de revenir de vacances ... c'est pour ca que je n'ai pas pu repondre ! mais la prochaine fois j essayerai de t aider

a+