🌍
Français
Si vous voulez installer le MOD NEWS (5.01, 5.02) chez 1 and 1
Faire attention à ceci :
Tout d'abord suivre les instructions d'installation donné dans le ZIP "INSTALL.TXT"
Vous remarquerez qu'il vous est demandé d'exécuter des requetes SQL sur la base de donnée, comme suit :
#-----[ 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) collate latin1_general_ci default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- 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 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Structure de la table `phpwebgallery_news_user_access`
--
CREATE TABLE `phpwebgallery_news_user_access` (
`user_id` smallint(5) unsigned NOT NULL default '0',
`new_id` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`user_id`,`new_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- 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) collate latin1_general_ci NOT NULL default 'en_UK.iso-8859-1',
`title` varchar(75) collate latin1_general_ci default NULL,
`content` longtext collate latin1_general_ci,
`status` enum('public','private') collate latin1_general_ci NOT NULL default 'public',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- 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]------------------------------------------
My admin SQL chez 1and1 est d'une ancienne version (par rapport a free) c'est pourquoi si vous exécuter ces requetes vous obtiendrez un message d'erreur comme suit :
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci' at line 5
PROBLEME DE SYNTAX... (je sais : les boules)
bref pour y remedier voici la bonne syntax :
#-----[ 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) collate latin1_general_ci 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_user_access`
--
CREATE TABLE `phpwebgallery_news_user_access` (
`user_id` smallint(5) unsigned NOT NULL default '0',
`new_id` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`user_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) collate latin1_general_ci NOT NULL default 'en_UK.iso-8859-1',
`title` varchar(75) collate latin1_general_ci default NULL,
`content` longtext collate latin1_general_ci,
`status` enum('public','private') collate latin1_general_ci NOT NULL 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]------------------------------------------
normalement vos requetes (d'un langage plus ancien) seront accepter par my admin SQL
Il ne vous reste plus qu'as suivre le reste des infos dans le fichier "INSTALL.TXT"
Hors ligne