Erreur lors de l'exécution de la requête

[Charly03]

Bonsoir,

Je viens vers vous car j'ai besoin d'aide pour retrouver ma galerie.

Mon site a été suspendu hier par Free à cause des spams. J'ai désormais un message d'erreur qui s'affiche "Erreur lors de l'exécution de la requête". J'ai parcouru le forum et ai trouvé des sujets qui traitaient du même souci, mais après avoir suivi la procédure conseillée, le problème persiste. Je ne sais plus quoi faire. Je ne m'y connais pas beaucoup. J'espère que quelqu'un pourra m'aider.

Voici le lien de ma galerie : http://jolieaddiction.free.fr/photos/index.php

Merci d'avance.

[Charly03]

Voici le message d'erreur.

USER:
------------------
Array
(
    [ID] => 9566a3036b48295ed9df893495caea8b
    [am] => 1
    [lang] => french
    [liv] => Array
        (
        )

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => ****
    [groups] => Array
        (
           

• => 1
          )
  
      [disk_max] => 0
      [disk_min] => 0
      [can_rate_pictures] => 1
      [can_send_ecards] => 1
      [ufc_max] => 3
      [ufc_min] => 3
      [custom_user_upload] => 0
      [num_file_upload] => 5
      [num_URI_upload] => 3
      [can_post_comments] => 1
      [can_upload_pictures] => 1
      [can_create_albums] => 1
      [has_admin_access] => 1
      [pub_upl_need_approval] => 0
      [priv_upl_need_approval] => 0
      [group_name] => Administrators
      [upload_form_config] => 3
      [group_quota] => 0
      [can_see_all_albums] => 1
      [group_id] => 1
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content, player FROM galerie_filetypes; (0s)
      [1] => select * from galerie_plugins order by priority asc; (0s)
      [2] => delete from `jolieaddiction`.galerie_sessions where time<1370459861 and remember=0; (0.001s)
      [3] => delete from `jolieaddiction`.galerie_sessions where time<1369253861; (0.001s)
      [4] => select user_id from `jolieaddiction`.galerie_sessions where session_id = '218e88c648b17e982c1fb540852a9fd8' (0s)
      [5] => select user_id as id, user_password as password from `jolieaddiction`.galerie_users where user_id=1 (0s)
      [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.avatar_url AS avatar_url, u.enable_admin_email AS notify, u.auto_subscribe_post AS auto_subscribe_post, u.auto_subscribe_comment AS auto_subscribe_comment, u.user_group+100 AS group_id FROM `jolieaddiction`.galerie_users AS u INNER JOIN `jolieaddiction`.galerie_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
      [7] => SELECT user_group_list FROM `jolieaddiction`.galerie_users AS u WHERE user_id='1' and user_group_list <> ''; (0s)
      [8] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM galerie_usergroups WHERE group_id in (1) (0s)
      [9] => SELECT group_name FROM  galerie_usergroups WHERE group_id= 1 (0s)
      [10] => update `jolieaddiction`.galerie_sessions set time='1370463461' where session_id = '218e88c648b17e982c1fb540852a9fd8' (0s)
      [11] => SELECT user_favpics FROM galerie_favpics WHERE user_id = 1 (0.001s)
      [12] => SELECT count(*) FROM  galerie_pms WHERE owner=1 (0.001s)
      [13] => SELECT count(*) FROM  galerie_pms WHERE owner=1 AND showed='0' (0s)
      [14] => SELECT count(*) FROM  galerie_buddy WHERE user_id=1 (0s)
      [15] => SELECT count(*) FROM  galerie_buddy_req WHERE buddy_to=1 (0s)
      [16] => DELETE FROM galerie_banned WHERE expiry < '2013-06-05 22:17:41' (0s)
      [17] => SELECT * FROM galerie_banned WHERE (ip_addr='89.28.145.53' OR ip_addr='89.28.145.53' OR user_id=1) AND brute_force=0 (0.001s)
      [18] => SELECT cid, name, description, thumb FROM galerie_categories WHERE parent = ''  ORDER BY pos (0.003s)
      [19] => SELECT aid FROM galerie_albums WHERE category = 2 (0.001s)
      [20] => SELECT count(*) FROM galerie_pictures as p, galerie_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 2 (0s)
      [21] => SELECT aid FROM galerie_albums WHERE category = 3 (0s)
      [22] => SELECT count(*) FROM galerie_pictures as p, galerie_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 3 (0s)
      [23] => SELECT aid FROM galerie_albums WHERE category = 4 (0s)
      [24] => SELECT count(*) FROM galerie_pictures as p, galerie_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 4 (0s)
      [25] => SELECT aid FROM galerie_albums WHERE category = 5 (0s)
      [26] => SELECT count(*) FROM galerie_pictures as p, galerie_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 5 (0s)
      [27] => SELECT aid FROM galerie_albums WHERE category = 6 (0s)
      [28] => SELECT count(*) FROM galerie_pictures as p, galerie_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 6 (0s)
      [29] => SELECT aid FROM galerie_albums WHERE category = 7 (0s)
      [30] => SELECT count(*) FROM galerie_pictures as p, galerie_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 7 (0s)
      [31] => SELECT aid FROM galerie_albums WHERE category = 8 (0s)
      [32] => SELECT count(*) FROM galerie_pictures as p, galerie_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 8 (0s)
      [33] => SELECT aid FROM galerie_albums WHERE category = 147 (0s)
      [34] => SELECT count(*) FROM galerie_pictures as p, galerie_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 147 (0s)
      [35] => SELECT aid FROM galerie_albums WHERE category = 151 (0.001s)
      [36] => SELECT count(*) FROM galerie_pictures as p, galerie_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 151 (0s)
      [37] => SELECT aid FROM galerie_albums WHERE category = 9 (0s)
      [38] => SELECT count(*) FROM galerie_pictures as p, galerie_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 9 (0.004s)
      [39] => SELECT aid FROM galerie_albums as a WHERE category>=10000 (0s)
      [40] => SELECT count(*) FROM galerie_pictures as p, galerie_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0.004s)
      [41] => SELECT aid FROM galerie_albums as a WHERE category = '0' (0s)
      [42] => SELECT count(*) FROM galerie_albums as a WHERE 1 (0s)
      [43] => SELECT count(*) FROM galerie_categories WHERE 1 (0s)
      [44] => SELECT count(*) FROM galerie_pictures as p LEFT JOIN galerie_albums as a ON a.aid=p.aid WHERE 1 AND approved='YES' (0.014s)
      [45] => SELECT sum(hits) FROM galerie_pictures as p LEFT JOIN galerie_albums as a ON p.aid=a.aid WHERE 1 (0.052s)
      [46] => SELECT count(*) FROM galerie_comments as c LEFT JOIN galerie_pictures as p ON c.pid=p.pid LEFT JOIN galerie_albums as a ON a.aid=p.aid WHERE 1 (0s)
      [47] => SELECT COUNT(*) FROM galerie_pictures WHERE approved = 'NO' (0.008s)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 4.4.3-dev - OK
  ------------------
  mySQL version: 5.0.83
  ------------------
  Coppermine version: 1.4.27(stable)
  ==========================
  Module: GD
  ------------------
  GD Version: bundled (2.0.28 compatible)
  FreeType Support: 1
  FreeType Linkage: with freetype
  T1Lib Support: 1
  GIF Read Support: 1
  GIF Create Support: 1
  JPG Support: 1
  PNG Support: 1
  WBMP Support: 1
  XBM Support: 1
  JIS-mapped Japanese Font Support:
  
  ==========================
  Module: mysql
  ------------------
  MySQL Supportenabled
  Client API version 5.0.77
  MYSQL_MODULE_TYPE external
  MYSQL_SOCKET /tmp/mysql.sock
  MYSQL_INCLUDE -I/usr/mysql-client/include/mysql
  MYSQL_LIBS -L/usr/mysql-client/lib/mysql -lmysqlclient 
  ==========================
  Module: zlib
  ------------------
  ZLib Support enabled
  Compiled Version 1.2.3.3
  Linked Version 1.2.3.3
  ==========================
  Server restrictions (safe mode)?
  ------------------
  Directive | Local Value | Master Value
  safe_mode | On | On
  safe_mode_exec_dir | no value | no value
  safe_mode_gid | Off | Off
  safe_mode_include_dir | no value | no value
  safe_mode_exec_dir | no value | no value
  sql.safe_mode | On | On
  disable_functions | no value | no value
  file_uploads | On | On
  include_path | /mnt/112/sdb/e/d/jolieaddiction/include:.:/usr/php4/lib/php | .:/usr/php4/lib/php/
  open_basedir | /mnt/112/sdb/e/d/jolieaddiction | no value
  ==========================
  email
  ------------------
  Directive | Local Value | Master Value
  sendmail_from | no value | no value
  sendmail_path | /usr/sbin/sendmail -t -i  | /usr/sbin/sendmail -t -i 
  SMTP | localhost | localhost
  smtp_port | 25 | 25
  ==========================
  Size and Time
  ------------------
  Directive | Local Value | Master Value
  max_execution_time | 30 | 30
  max_input_time | 60 | 60
  upload_max_filesize | 2M | 2M
  post_max_size | 2M | 2M
  ==========================
  Page generated in 0.561 seconds - 48 queries in 0.092 seconds - Album set : ; Meta set: ;

[François Keller]

Bonjour,

ce n'est pas le message d'erreur, mais la sortie de deboggage. Le message d'erreur apparait quand? erreur d'execution de la requête) ? quel est son contenu exact ?

[Charly03]

Désolée. Voici le message d'erreur :

"While executing query "SELECT count(*) FROM galerie_comments as c LEFT JOIN galerie_pictures as p ON c.pid=p.pid LEFT JOIN galerie_albums as a ON a.aid=p.aid WHERE 1" on 0

mySQL error: Table 'jolieaddiction.galerie_comments' doesn't exist"

[François Keller]

Ce qui veut dire que la table comment a été effacée par free à cause des Spams. Il faut donc la recrée depuis phpmyadmin en utilisant la structure de la table telle qu'elle existe normalement (voir http://documentation.coppermine-gallery.net/en/dev_database.htm#db_comments)

[Charly03]

Je ne comprends pas ce qu'il faut changer depuis phpmyadmin =S

[François Keller]

Il faut recréer la table manquante depuis phpmyadmin en utilisant le code ci dessous

Code Select Expand


CREATE TABLE CPG_comments (
  pid mediumint(10) NOT NULL default '0',
  msg_id mediumint(10) NOT NULL auto_increment,
  msg_author varchar(25) NOT NULL default '',
  msg_body text NOT NULL,
  msg_date datetime NOT NULL default '0000-00-00 00:00:00',
  msg_raw_ip tinytext,
  msg_hdr_ip tinytext,
  author_md5_id varchar(32) NOT NULL default '',
  author_id int(11) NOT NULL default '0',
  approval enum('YES','NO') NOT NULL default 'YES',
  spam enum('YES','NO') NOT NULL default 'NO',
  PRIMARY KEY  (msg_id),
  KEY com_pic_id (pid),
  KEY author_id (author_id)
) COMMENT='Used to store comments made on pics';

Attention il faut remplacer CPG dans la première ligne par le préfixe de table utilisé dans ta base de donnée (à priori c'est jolieaddiction.galerie)