Author Topic: Que faut il mettre  (Read 20138 times)

0 Members and 1 Guest are viewing this topic.

Offline fix

  • Newbie
  • *
  • Posts: 12
    • View Profile
Que faut il mettre
« on: May 10, 2005, 07:49:10 PM »
j'aimerai savoir ce qu'il faut mettre
je n'ai pas envie de mettre n'importe quoi
merci de votre aide

Veuillez remplir le formulaire ci-dessous.
Configuration de la base de données
Type de serveur de base de données
 mysql
 
Nom (Hostname) du serveur de la base de données
 
 
Nom de la base
 
 
Utilisateur (login) de la base
 
 
Mot de passe de la base
 
 
Prefixes pour la base de données
 
 
Configuration Administrateur
Login Administrateur
 
 
Mot de Passe Administrateur
 
 
Mot de Passe Administrateur (Confirmer)
 

Offline CharlyG

  • Newbie
  • *
  • Posts: 32
    • View Profile
    • Villes-fleuries.com
Re: Que faut il mettre
« Reply #1 on: May 11, 2005, 06:52:56 PM »
ça dépend de beaucoup de chose, et notamment de ton hébergeur .... c'est compliqué de répondre comme ça parce que ça change complètement d'un compte à l'autre ...
donne nous le nom de ton hébergeur par exemple ou si tu ne veux pas mettre ces infos sur le forum contacte moi par mail et je verrai pour t'aider ;)


Offline Alotenango

  • Pre-Newbie
  • Posts: 9
    • View Profile
Re: Que faut il mettre
« Reply #2 on: May 12, 2005, 04:30:47 PM »
Nom (Hostname) du serveur de la base de données
Ici mettre ton hostname très souvent c'est : localhost

Nom de la base
ici mettre le nom de ta base mysql

Utilisateur (login) de la base
ici mettre le login d'acces à ta base mysql

Mot de passe de la base
ici mettre le mot de passe de ta base mysql

Prefixes pour la base de données
ici mettre un prefixe pour les table, exemple "photo_" ainsi dans la base tu pourras identifier facilement les tables de l'album

Configuration Administrateur
Login Administrateur
Mettre ici le login administrateur que tu veux exemple : toto
 

Mot de Passe Administrateur
mettre le mot de passe administrateur que tu veux exemple : moi

 

Mot de Passe Administrateur (Confirmer)
Re-indiquer le mot de passe administrateur le même que celui indiqué ci-dessus en l'occurence : moi


En ce qui concerne toute la première partie les codes ont du t'être transmis par ton hébergeur. Ce sont tous les codes classiques de gestion de ta base de donnée mysql

Offline fix

  • Newbie
  • *
  • Posts: 12
    • View Profile
Re: Que faut il mettre
« Reply #3 on: May 16, 2005, 10:58:51 AM »
 :wink:merci beaucoup

Offline Lintu

  • Pre-Newbie
  • Posts: 6
    • View Profile
Re: Que faut il mettre
« Reply #4 on: July 16, 2005, 06:58:52 PM »
Pourriez vous m'aidez aussi pour remplir ceci:
Nom (Hostname) du serveur de la base de données

Nom de la base

Utilisateur (login) de la base

Mot de passe de la base

Mon hébergeur est free.
Désolé je ne suis pas tres douer en ce qui concerne l'informatique.
Comment peut on savoir quel est le nom de la base, le login et le mot de passe?

Offline Lintu

  • Pre-Newbie
  • Posts: 6
    • View Profile
Re: Que faut il mettre
« Reply #5 on: July 16, 2005, 07:07:50 PM »
j'ai trouver pour le login et pour le mot de passe
mais je ne trouve pas pour:
Nom (Hostname) du serveur de la base de données

Nom de la base

J'ai été sur les pages de free et il y a marquer ceci sql.free.fr mais est pour le nom de la base ou pour le nom du serveur de la base de données?

TheOracle

  • Guest
Re: Que faut il mettre
« Reply #6 on: July 17, 2005, 03:00:54 PM »
Quote

marquer ceci sql.free.fr


Définitivement pour le serveur de mySQL.

Offline Lintu

  • Pre-Newbie
  • Posts: 6
    • View Profile
Re: Que faut il mettre
« Reply #7 on: July 17, 2005, 03:33:41 PM »
j'ai tout bien rempli et j'ai appuyez sur installation et sur la page suivante il y a marquer ca:

Warning: mysql_connect(): Unknown MySQL Server Host 'lintu.sql.free.fr' (2) in /var/www/free.fr/f/5/lintu/4images/includes/db_mysql.php on line 39

DB Error: Could not connect to the database server (sql.free.fr, lintu).

Qu'est ce qu'il faut que je fasse pour que ca marche?

TheOracle

  • Guest
Re: Que faut il mettre
« Reply #8 on: July 17, 2005, 03:35:49 PM »
Le lintu spécifié dans la boîte du serveur est de trop.

Offline Lintu

  • Pre-Newbie
  • Posts: 6
    • View Profile
Re: Que faut il mettre
« Reply #9 on: July 17, 2005, 09:26:22 PM »
J'ai corriger et maitenant ca me marque  8O

DB Error: Bad SQL Query: CREATE TABLE 4images_categories (cat_id int(10) unsigned NOT NULL auto_increment,cat_name varchar(255) NOT NULL default '',cat_description text NOT NULL,cat_parent_id int(10) unsigned NOT NULL default '0',cat_hits int(10) unsigned NOT NULL default '0',cat_order int(10) unsigned NOT NULL default '0',auth_viewcat tinyint(2) NOT NULL default '0',auth_viewimage tinyint(2) NOT NULL default '0',auth_download tinyint(2) NOT NULL default '0',auth_upload tinyint(2) NOT NULL default '0',auth_directupload tinyint(2) NOT NULL default '0',auth_vote tinyint(2) NOT NULL default '0',auth_sendpostcard tinyint(2) NOT NULL default '0',auth_readcomment tinyint(2) NOT NULL default '0',auth_postcomment tinyint(2) NOT NULL default '0',PRIMARY KEY (cat_id),KEY cat_parent_id (cat_parent_id),KEY cat_order (cat_order)) TYPE=MyISAM
Table '4images_categories' already exists

DB Error: Bad SQL Query: CREATE TABLE 4images_comments (comment_id int(10) unsigned NOT NULL auto_increment,image_id int(10) unsigned NOT NULL default '0',user_id int(11) NOT NULL default '0',user_name varchar(100) NOT NULL default '',comment_headline varchar(255) NOT NULL default '',comment_text text NOT NULL,comment_ip varchar(20) NOT NULL default '',comment_date int(11) unsigned NOT NULL default '0',PRIMARY KEY (comment_id),KEY image_id (image_id),KEY user_id (user_id),KEY comment_date (comment_date)) TYPE=MyISAM
Table '4images_comments' already exists

DB Error: Bad SQL Query: CREATE TABLE 4images_groupaccess (group_id int(10) unsigned NOT NULL default '0',cat_id int(10) unsigned NOT NULL default '0',auth_viewcat tinyint(1) NOT NULL default '0',auth_viewimage tinyint(1) NOT NULL default '0',auth_download tinyint(1) NOT NULL default '0',auth_upload tinyint(1) NOT NULL default '0',auth_directupload tinyint(1) NOT NULL default '0',auth_vote tinyint(1) NOT NULL default '0',auth_sendpostcard tinyint(1) NOT NULL default '0',auth_readcomment tinyint(1) NOT NULL default '0',auth_postcomment tinyint(1) NOT NULL default '0',KEY group_id (group_id),KEY cat_id (cat_id)) TYPE=MyISAM
Table '4images_groupaccess' already exists

DB Error: Bad SQL Query: CREATE TABLE 4images_groupmatch (group_id int(10) unsigned NOT NULL default '0',user_id int(11) NOT NULL default '0',groupmatch_startdate int(11) unsigned NOT NULL default '0',groupmatch_enddate int(11) unsigned NOT NULL default '0',KEY group_id (group_id),KEY user_id (user_id)) TYPE=MyISAM
Table '4images_groupmatch' already exists

DB Error: Bad SQL Query: CREATE TABLE 4images_groups (group_id int(10) unsigned NOT NULL auto_increment,group_name varchar(100) NOT NULL default '',group_type tinyint(2) NOT NULL default '1',PRIMARY KEY (group_id)) TYPE=MyISAM
Table '4images_groups' already exists

DB Error: Bad SQL Query: CREATE TABLE 4images_images (image_id int(10) unsigned NOT NULL auto_increment,cat_id int(10) unsigned NOT NULL default '0',user_id int(11) NOT NULL default '0',image_name varchar(255) NOT NULL default '',image_description text NOT NULL,image_keywords text NOT NULL,image_date int(11) unsigned NOT NULL default '0',image_active tinyint(1) NOT NULL default '1',image_media_file varchar(255) NOT NULL default '',image_thumb_file varchar(255) NOT NULL default '',image_download_url varchar(255) NOT NULL default '',image_allow_comments tinyint(1) NOT NULL default '1',image_comments int(10) unsigned NOT NULL default '0',image_downloads int(10) unsigned NOT NULL default '0',image_votes int(10) unsigned NOT NULL default '0',image_rating decimal(4,2) NOT NULL default '0.00',image_hits int(10) unsigned NOT NULL default '0',PRIMARY KEY (image_id),KEY cat_id (cat_id),KEY user_id (user_id),KEY image_date (image_date),KEY image_active (image_active)) TYPE=MyISAM
Table '4images_images' already exists

DB Error: Bad SQL Query: CREATE TABLE 4images_images_temp (image_id int(10) unsigned NOT NULL auto_increment,cat_id int(10) unsigned NOT NULL default '0',user_id int(11) NOT NULL default '0',image_name varchar(255) NOT NULL default '',image_description text NOT NULL,image_keywords text NOT NULL,image_date int(11) unsigned NOT NULL default '0',image_media_file varchar(255) NOT NULL default '',image_thumb_file varchar(255) NOT NULL default '',image_download_url varchar(255) NOT NULL default '',PRIMARY KEY (image_id),KEY cat_id (cat_id),KEY user_id (user_id)) TYPE=MyISAM
Table '4images_images_temp' already exists

DB Error: Bad SQL Query: CREATE TABLE 4images_lightboxes (lightbox_id varchar(32) NOT NULL default '',user_id int(11) NOT NULL default '0',lightbox_lastaction int(11) unsigned NOT NULL default '0',lightbox_image_ids text,KEY lightbox_id (lightbox_id),KEY user_id (user_id)) TYPE=MyISAM
Table '4images_lightboxes' already exists

DB Error: Bad SQL Query: CREATE TABLE 4images_postcards (postcard_id varchar(32) NOT NULL default '',image_id int(10) unsigned NOT NULL default '0',postcard_date int(11) unsigned NOT NULL default '0',postcard_bg_color varchar(100) NOT NULL default '',postcard_border_color varchar(100) NOT NULL default '',postcard_font_color varchar(100) NOT NULL default '',postcard_font_face varchar(100) NOT NULL default '',postcard_sender_name varchar(255) NOT NULL default '',postcard_sender_email varchar(255) NOT NULL default '',postcard_recipient_name varchar(255) NOT NULL default '',postcard_recipient_email varchar(255) NOT NULL default '',postcard_headline varchar(255) NOT NULL default '',postcard_message text NOT NULL,PRIMARY KEY (postcard_id)) TYPE=MyISAM
Table '4images_postcards' already exists

DB Error: Bad SQL Query: CREATE TABLE 4images_sessions (session_id varchar(32) NOT NULL default '',session_user_id int(11) NOT NULL default '0',session_lastaction int(11) unsigned NOT NULL default '0',session_location varchar(255) NOT NULL default '',session_ip varchar(15) NOT NULL default '',PRIMARY KEY (session_id),KEY session_user_id (session_user_id),KEY session_id_ip_user_id (session_id,session_ip,session_user_id)) TYPE=HEAP
Table '4images_sessions' already exists

DB Error: Bad SQL Query: CREATE TABLE 4images_settings (setting_name varchar(255) NOT NULL default '',setting_value mediumtext NOT NULL,PRIMARY KEY (setting_name)) TYPE=MyISAM
Table '4images_settings' already exists

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('site_name', '4images - Image Gallery Management System')
Duplicate entry 'site_name' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('site_email', 'admin@yourdomain.com')
Duplicate entry 'site_email' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('use_smtp', '0')
Duplicate entry 'use_smtp' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('smtp_host', '')
Duplicate entry 'smtp_host' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('smtp_username', '')
Duplicate entry 'smtp_username' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('smtp_password', '')
Duplicate entry 'smtp_password' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('template_dir', 'default')
Duplicate entry 'template_dir' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('language_dir', 'deutsch')
Duplicate entry 'language_dir' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('date_format', 'd.m.Y')
Duplicate entry 'date_format' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('time_format', 'H:i')
Duplicate entry 'time_format' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('convert_tool', 'none')
Duplicate entry 'convert_tool' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('convert_tool_path', '')
Duplicate entry 'convert_tool_path' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('gz_compress', '0')
Duplicate entry 'gz_compress' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('gz_compress_level', '9')
Duplicate entry 'gz_compress_level' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('cat_cells', '2')
Duplicate entry 'cat_cells' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('cat_table_width', '100%')
Duplicate entry 'cat_table_width' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('cat_table_cellspacing', '1')
Duplicate entry 'cat_table_cellspacing' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('cat_table_cellpadding', '3')
Duplicate entry 'cat_table_cellpadding' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('num_subcats', '3')
Duplicate entry 'num_subcats' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('image_order', 'image_name')
Duplicate entry 'image_order' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('image_sort', 'ASC')
Duplicate entry 'image_sort' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('new_cutoff', '10')
Duplicate entry 'new_cutoff' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('image_border', '1')
Duplicate entry 'image_border' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('image_cells', '3')
Duplicate entry 'image_cells' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('default_image_rows', '3')
Duplicate entry 'default_image_rows' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('custom_row_steps', '10')
Duplicate entry 'custom_row_steps' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('image_table_width', '100%')
Duplicate entry 'image_table_width' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('image_table_cellspacing', '1')
Duplicate entry 'image_table_cellspacing' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('image_table_cellpadding', '3')
Duplicate entry 'image_table_cellpadding' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('upload_mode', '2')
Duplicate entry 'upload_mode' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('allowed_mediatypes', 'jpg,gif,png,aif,au,avi,mid,mov,mp3,mpg,swf,wav,ra,rm,zip,pdf')
Duplicate entry 'allowed_mediatypes' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('max_thumb_width', '300')
Duplicate entry 'max_thumb_width' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('max_thumb_height', '300')
Duplicate entry 'max_thumb_height' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('max_thumb_size', '100')
Duplicate entry 'max_thumb_size' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('max_image_width', '1024')
Duplicate entry 'max_image_width' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('max_image_height', '1024')
Duplicate entry 'max_image_height' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('max_media_size', '2000')
Duplicate entry 'max_media_size' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('upload_notify', '0')
Duplicate entry 'upload_notify' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('upload_emails', '')
Duplicate entry 'upload_emails' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('auto_thumbnail', '0')
Duplicate entry 'auto_thumbnail' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('auto_thumbnail_dimension', '100')
Duplicate entry 'auto_thumbnail_dimension' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('auto_thumbnail_resize_type', '1')
Duplicate entry 'auto_thumbnail_resize_type' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('auto_thumbnail_quality', '75')
Duplicate entry 'auto_thumbnail_quality' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('badword_list', 'tra-la-la {tra-la-la}')
Duplicate entry 'badword_list' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('badword_replace_char', '*')
Duplicate entry 'badword_replace_char' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('wordwrap_comments', '50')
Duplicate entry 'wordwrap_comments' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('html_comments', '0')
Duplicate entry 'html_comments' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('bb_comments', '1')
Duplicate entry 'bb_comments' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('bb_img_comments', '0')
Duplicate entry 'bb_img_comments' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('category_separator', ' / ')
Duplicate entry 'category_separator' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('paging_range', '5')
Duplicate entry 'paging_range' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('user_edit_image', '1')
Duplicate entry 'user_edit_image' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('user_delete_image', '1')
Duplicate entry 'user_delete_image' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('user_edit_comments', '1')
Duplicate entry 'user_edit_comments' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('user_delete_comments', '1')
Duplicate entry 'user_delete_comments' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('account_activation', '1')
Duplicate entry 'account_activation' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('activation_time', '14')
Duplicate entry 'activation_time' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('session_timeout', '15')
Duplicate entry 'session_timeout' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('display_whosonline', '1')
Duplicate entry 'display_whosonline' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('highlight_admin', '1')
Duplicate entry 'highlight_admin' for key 1

DB Error: Bad SQL Query: CREATE TABLE 4images_users (user_id int(11) NOT NULL auto_increment,user_level int(11) NOT NULL default '1',user_name varchar(255) NOT NULL default '',user_password varchar(255) NOT NULL default '',user_email varchar(255) NOT NULL default '',user_showemail tinyint(1) NOT NULL default '0',user_allowemails tinyint(1) NOT NULL default '1',user_invisible tinyint(1) NOT NULL default '0',user_joindate int(11) unsigned NOT NULL default '0',user_activationkey varchar(32) NOT NULL default '',user_lastaction int(11) unsigned NOT NULL default '0',user_location varchar(255) NOT NULL default '',user_lastvisit int(11) unsigned NOT NULL default '0',user_comments int(10) unsigned NOT NULL default '0',user_homepage varchar(255) NOT NULL default '',user_icq varchar(20) NOT NULL default '',PRIMARY KEY (user_id),KEY user_lastaction (user_lastaction),KEY user_name (user_name)) TYPE=MyISAM
Table '4images_users' already exists

DB Error: Bad SQL Query: INSERT INTO 4images_users VALUES (-1, -1, 'Guest', '0493984f537120be0b8d96bc9b69cdd2', '', 0, 0, 0, 0, '', 0, '', 0, 0, '', '')
Duplicate entry '-1' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_users VALUES (1, 9, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin@yourdomain.com', 1, 1, 0, 1016023608, '1e3457c0b2052a9633b886fd75ef91e0', 1016023608, '', 0, 0, '', '')
Duplicate entry '1' for key 1

DB Error: Bad SQL Query: CREATE TABLE 4images_wordlist (word_text varchar(50) NOT NULL default '',word_id int(10) unsigned NOT NULL auto_increment,PRIMARY KEY (word_id),UNIQUE KEY word_text (word_text)) TYPE=MyISAM
Table '4images_wordlist' already exists

DB Error: Bad SQL Query: CREATE TABLE 4images_wordmatch (image_id int(10) unsigned NOT NULL default '0',word_id int(10) unsigned NOT NULL default '0',name_match tinyint(1) NOT NULL default '0',desc_match tinyint(1) NOT NULL default '0',keys_match tinyint(1) NOT NULL default '0',UNIQUE KEY image_word_id (image_id,word_id)) TYPE=MyISAM
Table '4images_wordmatch' already exists

Une erreur s'est produite en mettant à jour la base de données:

CREATE TABLE 4images_categories (cat_id int(10) unsigned NOT NULL auto_increment,cat_name varchar(255) NOT NULL default '',cat_description text NOT NULL,cat_parent_id int(10) unsigned NOT NULL default '0',cat_hits int(10) unsigned NOT NULL default '0',cat_order int(10) unsigned NOT NULL default '0',auth_viewcat tinyint(2) NOT NULL default '0',auth_viewimage tinyint(2) NOT NULL default '0',auth_download tinyint(2) NOT NULL default '0',auth_upload tinyint(2) NOT NULL default '0',auth_directupload tinyint(2) NOT NULL default '0',auth_vote tinyint(2) NOT NULL default '0',auth_sendpostcard tinyint(2) NOT NULL default '0',auth_readcomment tinyint(2) NOT NULL default '0',auth_postcomment tinyint(2) NOT NULL default '0',PRIMARY KEY (cat_id),KEY cat_parent_id (cat_parent_id),KEY cat_order (cat_order)) TYPE=MyISAM
CREATE TABLE 4images_comments (comment_id int(10) unsigned NOT NULL auto_increment,image_id int(10) unsigned NOT NULL default '0',user_id int(11) NOT NULL default '0',user_name varchar(100) NOT NULL default '',comment_headline varchar(255) NOT NULL default '',comment_text text NOT NULL,comment_ip varchar(20) NOT NULL default '',comment_date int(11) unsigned NOT NULL default '0',PRIMARY KEY (comment_id),KEY image_id (image_id),KEY user_id (user_id),KEY comment_date (comment_date)) TYPE=MyISAM
CREATE TABLE 4images_groupaccess (group_id int(10) unsigned NOT NULL default '0',cat_id int(10) unsigned NOT NULL default '0',auth_viewcat tinyint(1) NOT NULL default '0',auth_viewimage tinyint(1) NOT NULL default '0',auth_download tinyint(1) NOT NULL default '0',auth_upload tinyint(1) NOT NULL default '0',auth_directupload tinyint(1) NOT NULL default '0',auth_vote tinyint(1) NOT NULL default '0',auth_sendpostcard tinyint(1) NOT NULL default '0',auth_readcomment tinyint(1) NOT NULL default '0',auth_postcomment tinyint(1) NOT NULL default '0',KEY group_id (group_id),KEY cat_id (cat_id)) TYPE=MyISAM
CREATE TABLE 4images_groupmatch (group_id int(10) unsigned NOT NULL default '0',user_id int(11) NOT NULL default '0',groupmatch_startdate int(11) unsigned NOT NULL default '0',groupmatch_enddate int(11) unsigned NOT NULL default '0',KEY group_id (group_id),KEY user_id (user_id)) TYPE=MyISAM
CREATE TABLE 4images_groups (group_id int(10) unsigned NOT NULL auto_increment,group_name varchar(100) NOT NULL default '',group_type tinyint(2) NOT NULL default '1',PRIMARY KEY (group_id)) TYPE=MyISAM
CREATE TABLE 4images_images (image_id int(10) unsigned NOT NULL auto_increment,cat_id int(10) unsigned NOT NULL default '0',user_id int(11) NOT NULL default '0',image_name varchar(255) NOT NULL default '',image_description text NOT NULL,image_keywords text NOT NULL,image_date int(11) unsigned NOT NULL default '0',image_active tinyint(1) NOT NULL default '1',image_media_file varchar(255) NOT NULL default '',image_thumb_file varchar(255) NOT NULL default '',image_download_url varchar(255) NOT NULL default '',image_allow_comments tinyint(1) NOT NULL default '1',image_comments int(10) unsigned NOT NULL default '0',image_downloads int(10) unsigned NOT NULL default '0',image_votes int(10) unsigned NOT NULL default '0',image_rating decimal(4,2) NOT NULL default '0.00',image_hits int(10) unsigned NOT NULL default '0',PRIMARY KEY (image_id),KEY cat_id (cat_id),KEY user_id (user_id),KEY image_date (image_date),KEY image_active (image_active)) TYPE=MyISAM
CREATE TABLE 4images_images_temp (image_id int(10) unsigned NOT NULL auto_increment,cat_id int(10) unsigned NOT NULL default '0',user_id int(11) NOT NULL default '0',image_name varchar(255) NOT NULL default '',image_description text NOT NULL,image_keywords text NOT NULL,image_date int(11) unsigned NOT NULL default '0',image_media_file varchar(255) NOT NULL default '',image_thumb_file varchar(255) NOT NULL default '',image_download_url varchar(255) NOT NULL default '',PRIMARY KEY (image_id),KEY cat_id (cat_id),KEY user_id (user_id)) TYPE=MyISAM
CREATE TABLE 4images_lightboxes (lightbox_id varchar(32) NOT NULL default '',user_id int(11) NOT NULL default '0',lightbox_lastaction int(11) unsigned NOT NULL default '0',lightbox_image_ids text,KEY lightbox_id (lightbox_id),KEY user_id (user_id)) TYPE=MyISAM
CREATE TABLE 4images_postcards (postcard_id varchar(32) NOT NULL default '',image_id int(10) unsigned NOT NULL default '0',postcard_date int(11) unsigned NOT NULL default '0',postcard_bg_color varchar(100) NOT NULL default '',postcard_border_color varchar(100) NOT NULL default '',postcard_font_color varchar(100) NOT NULL default '',postcard_font_face varchar(100) NOT NULL default '',postcard_sender_name varchar(255) NOT NULL default '',postcard_sender_email varchar(255) NOT NULL default '',postcard_recipient_name varchar(255) NOT NULL default '',postcard_recipient_email varchar(255) NOT NULL default '',postcard_headline varchar(255) NOT NULL default '',postcard_message text NOT NULL,PRIMARY KEY (postcard_id)) TYPE=MyISAM
CREATE TABLE 4images_sessions (session_id varchar(32) NOT NULL default '',session_user_id int(11) NOT NULL default '0',session_lastaction int(11) unsigned NOT NULL default '0',session_location varchar(255) NOT NULL default '',session_ip varchar(15) NOT NULL default '',PRIMARY KEY (session_id),KEY session_user_id (session_user_id),KEY session_id_ip_user_id (session_id,session_ip,session_user_id)) TYPE=HEAP
CREATE TABLE 4images_settings (setting_name varchar(255) NOT NULL default '',setting_value mediumtext NOT NULL,PRIMARY KEY (setting_name)) TYPE=MyISAM
INSERT INTO 4images_settings VALUES ('site_name', '4images - Image Gallery Management System')
INSERT INTO 4images_settings VALUES ('site_email', 'admin@yourdomain.com')
INSERT INTO 4images_settings VALUES ('use_smtp', '0')
INSERT INTO 4images_settings VALUES ('smtp_host', '')
INSERT INTO 4images_settings VALUES ('smtp_username', '')
INSERT INTO 4images_settings VALUES ('smtp_password', '')
INSERT INTO 4images_settings VALUES ('template_dir', 'default')
INSERT INTO 4images_settings VALUES ('language_dir', 'deutsch')
INSERT INTO 4images_settings VALUES ('date_format', 'd.m.Y')
INSERT INTO 4images_settings VALUES ('time_format', 'H:i')
INSERT INTO 4images_settings VALUES ('convert_tool', 'none')
INSERT INTO 4images_settings VALUES ('convert_tool_path', '')
INSERT INTO 4images_settings VALUES ('gz_compress', '0')
INSERT INTO 4images_settings VALUES ('gz_compress_level', '9')
INSERT INTO 4images_settings VALUES ('cat_cells', '2')
INSERT INTO 4images_settings VALUES ('cat_table_width', '100%')
INSERT INTO 4images_settings VALUES ('cat_table_cellspacing', '1')
INSERT INTO 4images_settings VALUES ('cat_table_cellpadding', '3')
INSERT INTO 4images_settings VALUES ('num_subcats', '3')
INSERT INTO 4images_settings VALUES ('image_order', 'image_name')
INSERT INTO 4images_settings VALUES ('image_sort', 'ASC')
INSERT INTO 4images_settings VALUES ('new_cutoff', '10')
INSERT INTO 4images_settings VALUES ('image_border', '1')
INSERT INTO 4images_settings VALUES ('image_cells', '3')
INSERT INTO 4images_settings VALUES ('default_image_rows', '3')
INSERT INTO 4images_settings VALUES ('custom_row_steps', '10')
INSERT INTO 4images_settings VALUES ('image_table_width', '100%')
INSERT INTO 4images_settings VALUES ('image_table_cellspacing', '1')
INSERT INTO 4images_settings VALUES ('image_table_cellpadding', '3')
INSERT INTO 4images_settings VALUES ('upload_mode', '2')
INSERT INTO 4images_settings VALUES ('allowed_mediatypes', 'jpg,gif,png,aif,au,avi,mid,mov,mp3,mpg,swf,wav,ra,rm,zip,pdf')
INSERT INTO 4images_settings VALUES ('max_thumb_width', '300')
INSERT INTO 4images_settings VALUES ('max_thumb_height', '300')
INSERT INTO 4images_settings VALUES ('max_thumb_size', '100')
INSERT INTO 4images_settings VALUES ('max_image_width', '1024')
INSERT INTO 4images_settings VALUES ('max_image_height', '1024')
INSERT INTO 4images_settings VALUES ('max_media_size', '2000')
INSERT INTO 4images_settings VALUES ('upload_notify', '0')
INSERT INTO 4images_settings VALUES ('upload_emails', '')
INSERT INTO 4images_settings VALUES ('auto_thumbnail', '0')
INSERT INTO 4images_settings VALUES ('auto_thumbnail_dimension', '100')
INSERT INTO 4images_settings VALUES ('auto_thumbnail_resize_type', '1')
INSERT INTO 4images_settings VALUES ('auto_thumbnail_quality', '75')
INSERT INTO 4images_settings VALUES ('badword_list', 'tra-la-la {tra-la-la}')
INSERT INTO 4images_settings VALUES ('badword_replace_char', '*')
INSERT INTO 4images_settings VALUES ('wordwrap_comments', '50')
INSERT INTO 4images_settings VALUES ('html_comments', '0')
INSERT INTO 4images_settings VALUES ('bb_comments', '1')
INSERT INTO 4images_settings VALUES ('bb_img_comments', '0')
INSERT INTO 4images_settings VALUES ('category_separator', ' / ')
INSERT INTO 4images_settings VALUES ('paging_range', '5')
INSERT INTO 4images_settings VALUES ('user_edit_image', '1')
INSERT INTO 4images_settings VALUES ('user_delete_image', '1')
INSERT INTO 4images_settings VALUES ('user_edit_comments', '1')
INSERT INTO 4images_settings VALUES ('user_delete_comments', '1')
INSERT INTO 4images_settings VALUES ('account_activation', '1')
INSERT INTO 4images_settings VALUES ('activation_time', '14')
INSERT INTO 4images_settings VALUES ('session_timeout', '15')
INSERT INTO 4images_settings VALUES ('display_whosonline', '1')
INSERT INTO 4images_settings VALUES ('highlight_admin', '1')
CREATE TABLE 4images_users (user_id int(11) NOT NULL auto_increment,user_level int(11) NOT NULL default '1',user_name varchar(255) NOT NULL default '',user_password varchar(255) NOT NULL default '',user_email varchar(255) NOT NULL default '',user_showemail tinyint(1) NOT NULL default '0',user_allowemails tinyint(1) NOT NULL default '1',user_invisible tinyint(1) NOT NULL default '0',user_joindate int(11) unsigned NOT NULL default '0',user_activationkey varchar(32) NOT NULL default '',user_lastaction int(11) unsigned NOT NULL default '0',user_location varchar(255) NOT NULL default '',user_lastvisit int(11) unsigned NOT NULL default '0',user_comments int(10) unsigned NOT NULL default '0',user_homepage varchar(255) NOT NULL default '',user_icq varchar(20) NOT NULL default '',PRIMARY KEY (user_id),KEY user_lastaction (user_lastaction),KEY user_name (user_name)) TYPE=MyISAM
INSERT INTO 4images_users VALUES (-1, -1, 'Guest', '0493984f537120be0b8d96bc9b69cdd2', '', 0, 0, 0, 0, '', 0, '', 0, 0, '', '')
INSERT INTO 4images_users VALUES (1, 9, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin@yourdomain.com', 1, 1, 0, 1016023608, '1e3457c0b2052a9633b886fd75ef91e0', 1016023608, '', 0, 0, '', '')
CREATE TABLE 4images_wordlist (word_text varchar(50) NOT NULL default '',word_id int(10) unsigned NOT NULL auto_increment,PRIMARY KEY (word_id),UNIQUE KEY word_text (word_text)) TYPE=MyISAM
CREATE TABLE 4images_wordmatch (image_id int(10) unsigned NOT NULL default '0',word_id int(10) unsigned NOT NULL default '0',name_match tinyint(1) NOT NULL default '0',desc_match tinyint(1) NOT NULL default '0',keys_match tinyint(1) NOT NULL default '0',UNIQUE KEY image_word_id (image_id,word_id)) TYPE=MyISAM

TheOracle

  • Guest
Re: Que faut il mettre
« Reply #10 on: July 17, 2005, 09:37:02 PM »
En supposant que c'est votre première installation de 4images ; sous votre fichier /data/database/mysql_default.sql, vous devriez trouver "14 résultats" de la ligne suivante :

Quote

#DROP TABLE


À chacun de ces lignes,

remplacez par :

Code: [Select]

DROP TABLE


Ensuite, re-démarrer l'installation de nouveau et, s.v.p, nous envoyez les résultats. ;)

Offline Lintu

  • Pre-Newbie
  • Posts: 6
    • View Profile
Re: Que faut il mettre
« Reply #11 on: July 18, 2005, 03:24:07 PM »
Alors j'ai enlever les # et je refais l'installation
Ca a bien marcher et sul la page il y a marquer
Installation réussie!

Votre Login en mode Admin a été créé. A ce niveau d'installation, la base de données est complète. S'il vous plaît soyez sûr de vérifier la Configuration Générale en détail, faire les changements dans votre tableau de bord..
» 4images Panneau de Contrôle

J'ai cliquez sur 4images panneau de contrôle et la ca ma marquer


Warning: session_start(): open(/var/www/free.fr/6/4/whatsername/sessions/sess_3974b277a05371ed57dd5528ce1e15b5, O_RDWR) failed: No such file or directory (2) in /var/www/free.fr/6/4/whatsername/4images/includes/sessions.php on line 84

Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /var/www/free.fr/6/4/whatsername/4images/includes/sessions.php:84) in /var/www/free.fr/6/4/whatsername/4images/includes/sessions.php on line 84

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /var/www/free.fr/6/4/whatsername/4images/includes/sessions.php:84) in /var/www/free.fr/6/4/whatsername/4images/includes/sessions.php on line 84

Warning: Cannot modify header information - headers already sent by (output started at /var/www/free.fr/6/4/whatsername/4images/includes/sessions.php:84) in /var/www/free.fr/6/4/whatsername/4images/includes/sessions.php on line 92

Warning: Cannot modify header information - headers already sent by (output started at /var/www/free.fr/6/4/whatsername/4images/includes/sessions.php:84) in /var/www/free.fr/6/4/whatsername/4images/includes/sessions.php on line 92

Warning: Cannot modify header information - headers already sent by (output started at /var/www/free.fr/6/4/whatsername/4images/includes/sessions.php:84) in /var/www/free.fr/6/4/whatsername/4images/admin/admin_functions.php on line 168

Warning: Cannot modify header information - headers already sent by (output started at /var/www/free.fr/6/4/whatsername/4images/includes/sessions.php:84) in /var/www/free.fr/6/4/whatsername/4images/admin/admin_functions.php on line 169

Warning: Cannot modify header information - headers already sent by (output started at /var/www/free.fr/6/4/whatsername/4images/includes/sessions.php:84) in /var/www/free.fr/6/4/whatsername/4images/admin/admin_functions.php on line 170

Warning: Cannot modify header information - headers already sent by (output started at /var/www/free.fr/6/4/whatsername/4images/includes/sessions.php:84) in /var/www/free.fr/6/4/whatsername/4images/admin/admin_functions.php on line 171

Warning: Cannot modify header information - headers already sent by (output started at /var/www/free.fr/6/4/whatsername/4images/includes/sessions.php:84) in /var/www/free.fr/6/4/whatsername/4images/admin/admin_functions.php on line 172



Si vous n'êtes pas l'administrateur du site. Vous ne devez pas être ici.

     
Nom d'utilisateur Mot de Passe
 
 

4images Administration Control Panel


Warning: Unknown(): open(/var/www/free.fr/6/4/whatsername/sessions/sess_3974b277a05371ed57dd5528ce1e15b5, O_RDWR) failed: No such file or directory (2) in Unknown on line 0

Warning: Unknown(): Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/www/free.fr/6/4/whatsername/sessions) in Unknown on line 0

Et je ne peux pas me connecter, et sur la page de démarrage de la gallerie ca me marque pareil:
http://whatsername.free.fr/4images/

TheOracle

  • Guest
Re: Que faut il mettre
« Reply #12 on: July 18, 2005, 03:27:30 PM »
Puisque vous êtes un utilisateur de chez free.fr, il y a un topique démontrant les étapes que vous devez faire pour éviter ces messages d'erreures de sessions et le voici :

http://www.4homepages.de/forum/index.php?topic=8121.0

Offline Lintu

  • Pre-Newbie
  • Posts: 6
    • View Profile
Re: Que faut il mettre
« Reply #13 on: July 19, 2005, 04:06:38 PM »
Merci beaucoup, ca marche
Merci d'avoir eu la patience de me répondre

TheOracle

  • Guest
Re: Que faut il mettre
« Reply #14 on: July 19, 2005, 04:14:14 PM »
Mais de rien. ;)