Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Erreur lors de l'exécution de la requête  (Read 17340 times)

0 Members and 1 Guest are viewing this topic.

Charly03

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Erreur lors de l'exécution de la requête
« on: June 05, 2013, 10:24:09 pm »

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.
Logged

Charly03

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: Erreur lors de l'exécution de la requête
« Reply #1 on: June 05, 2013, 10:26:32 pm »

Voici le message d'erreur.

Quote
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: ;
Logged

François Keller

  • Moderator
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 9094
  • aka Frantz
    • Ma galerie
Re: Erreur lors de l'exécution de la requête
« Reply #2 on: June 06, 2013, 10:51:56 am »

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 ?
Logged
Avez vous lu la DOC ? la FAQ ? et cherché sur le forum avant de poster ?
Did you read the DOC ? the FAQ ? and search the board before posting ?
Mon Blog

Charly03

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: Erreur lors de l'exécution de la requête
« Reply #3 on: June 06, 2013, 12:07:54 pm »

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"
Logged

François Keller

  • Moderator
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 9094
  • aka Frantz
    • Ma galerie
Re: Erreur lors de l'exécution de la requête
« Reply #4 on: June 06, 2013, 05:41:32 pm »

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)
Logged
Avez vous lu la DOC ? la FAQ ? et cherché sur le forum avant de poster ?
Did you read the DOC ? the FAQ ? and search the board before posting ?
Mon Blog

Charly03

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: Erreur lors de l'exécution de la requête
« Reply #5 on: June 06, 2013, 06:19:33 pm »

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

François Keller

  • Moderator
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 9094
  • aka Frantz
    • Ma galerie
Re: Erreur lors de l'exécution de la requête
« Reply #6 on: June 09, 2013, 11:38:22 am »

Il faut recréer la table manquante depuis phpmyadmin en utilisant le code ci dessous
Code: [Select]
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)
Logged
Avez vous lu la DOC ? la FAQ ? et cherché sur le forum avant de poster ?
Did you read the DOC ? the FAQ ? and search the board before posting ?
Mon Blog
Pages: [1]   Go Up
 

Page created in 0.022 seconds with 20 queries.