Erreur critique : "There was an error while processing a database query"

[Eliza01]

Salut 
J'ai un gros probleme avec ma galerie, http://maggieparadise.free.fr/galerie/
Erreur critique : "There was an error while processing a database query"
Il me met cette erreur en plein sur ma page d'accueil, donc je n'arrive plus a acceder a aucunes fonctions  :-\
Je suis assez flippée j'ai presque 4000 photos dessus et ca me tente pas de recommencer a zero 
Je suis vraiment novice la dedans alors j'esperais que quelqu'un pourrait me donner la solution ...
J'espere que quelqu'un pourra m'aider

[Pascal YAP]

Bonjour

J'ai un gros probleme avec ma galerie

Et moi j'ai un gros Cheval de Troie depuis que je me suis connecté chez vous, puis après avoir cliqué sur Theme credit 
Il y a quelque chose de pas très clean sur ce site, et ça fait plus de trois heures que je tente de retrouver l'intégrité de ma machine (qui n'était pas en réseau)
Donc je n'ai pas de réponse à vous fournir.
Ce post est destiné à faire savoir à nos utilisateurs qu'il ne faut pas cliquer sur vos liens.........

PYAP

[François Keller]

Et moi j'ai un gros Cheval de Troie

Pareil, sauf que je ne me suis pas connecté sur ce site  mais peut être sur celui d'autres utilisateurs de coppermine qui ne sont pas très attentifs à la sécurité de leur fichiers

[Titooy]

Sorry les gars mais j'ai beau chercher, je ne vois pas quel pourrait être le lien entre votre cheval de Troie et ce site... à mon avis, c'est un pur hasard...

Pour en revenir à la question, que s'est-il passé entre le moment où ça a arrêté de fonctionner ?

Une solution pourrait peut-être être de faire la mise à jour vers la version 1.3.5 (en appliquant en plus cette modification) ou mieux vers la version 1.4.4

[Eliza01]

Désolée je vois pas se qui a pu coincer chez vous, j'avais jamais eu de problemes avec personnes avant ... 
Titooy, en faite j'ai uplaoder une photos et puis paf plus rien  :-\
Je vais faire se que tu m'a dit en esperant que ca marche, sinon j'ai activé le mode debug et j'irai voir dans le forum 133
Merci 

[Titooy]

Comme le dit le message d'erreur

mySQL error: Table './maggieparadise/cpg133_pictures' is marked as crashed and should be repaired

tu dois réparer la table cpg133_pictures. Pour cela, va sur http://phpmyadmin.free.fr/ et connecte toi avec maggieparadise et ton mot de passe, clique sur maggieparadise puis sélectionne la table en question et choisis Réparer la table dans le menu déroulant qui se trouve en dessous de la liste des tables.

(exemple illustré : http://linuxeduquebec.org/article.php3?id_article=272)

[Eliza01]

  Ca marche !!
Je vois mes albums et j'arrive a mes fonctions
Mais j'ai encore un probleme : il me marque ca :

USER:
------------------
Array
(***
    [ID] => 3cf97cd8f5a03506369dbcd07a2a93f3
    [am] => 1
    [liv] => Array
        (
           

• => 5805
              [1] => 5500
              [2] => 5797
              [3] => 5806
              [4] => 4462
          )
  
      [lap] => 2
      [search] => ###naveen
      [uid] => 1
      [name] => Sacha
      [lang] => french
      [sort] => na
  )
  
  ==========================
  USER DATA:
  ------------------
  Array
  (
      [user_id] => 1
      [user_group] => 1
      [user_active] => YES
      [user_name] => cindy
      [user_password] => ********
      [user_lastvisit] => 2006-03-30 14:42:53
      [user_regdate] => 2005-07-27 22:21:11
      [user_group_list] =>
      [user_email] =>
      [user_website] => http://www.maggie-grace.be.cx
      [user_location] => Belgique
      [user_interests] =>
      [user_occupation] =>
      [user_actkey] =>
      [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] => 10
      [num_URI_upload] => 5
      [can_post_comments] => 1
      [can_upload_pictures] => 1
      [can_create_albums] => 0
      [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
      [groups] => Array
          (
              [1] => 1
          )
  
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content FROM cpg133_filetypes;
      [1] => SELECT * FROM cpg133_users WHERE user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = '1dc8edebd0c8c1c14a00cdd7824c8031'
      [2] => 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 cpg133_usergroups WHERE group_id in (1)
      [3] => SELECT group_name FROM  cpg133_usergroups WHERE group_id= 1
      [4] => DELETE FROM cpg133_banned WHERE expiry < '2006-03-31 11:54:11'
      [5] => SELECT * FROM cpg133_banned WHERE ip_addr='80.201.184.207' OR ip_addr='80.201.184.207' OR user_id=1
      [6] => SELECT cid, name, description, thumb FROM cpg133_categories WHERE parent = ''  ORDER BY pos
      [7] => SELECT aid FROM cpg133_albums WHERE category = 2
      [8] => SELECT count(*) FROM cpg133_pictures as p, cpg133_albums as a WHERE p.aid = a.aid AND category = 2
      [9] => SELECT count(*) FROM cpg133_albums as a WHERE category = '2'
      [10] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg133_albums as a LEFT JOIN cpg133_pictures as p ON a.thumb=p.pid WHERE category=2 ORDER BY a.pos LIMIT 0,16
      [11] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg133_pictures WHERE aid IN (249, 248, 232, 228, 187, 177, 175, 164, 163, 153, 151, 150, 144, 143, 133, 128) AND approved = 'YES' GROUP BY aid
      [12] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='5808'
      [13] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='3575'
      [14] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='4357'
      [15] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='2889'
      [16] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='3741'
      [17] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='3468'
      [18] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='2448'
      [19] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='4449'
      [20] => SELECT cid, name, description, thumb FROM cpg133_categories WHERE parent = '2'  ORDER BY pos
      [21] => SELECT aid FROM cpg133_albums WHERE category = 3
      [22] => SELECT count(*) FROM cpg133_pictures as p, cpg133_albums as a WHERE p.aid = a.aid AND category = 3
      [23] => SELECT count(*) FROM cpg133_albums as a WHERE category = '3'
      [24] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg133_albums as a LEFT JOIN cpg133_pictures as p ON a.thumb=p.pid WHERE category=3 ORDER BY a.pos LIMIT 0,16
      [25] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg133_pictures WHERE aid IN (245, 207, 196, 193, 189, 219, 170, 139, 208, 91, 243, 85, 236, 18, 25, 66) AND approved = 'YES' GROUP BY aid
      [26] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='4390'
      [27] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='4632'
      [28] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='4251'
      [29] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='1898'
      [30] => SELECT cid, name, description, thumb FROM cpg133_categories WHERE parent = '3'  ORDER BY pos
      [31] => SELECT aid FROM cpg133_albums WHERE category = 17
      [32] => SELECT count(*) FROM cpg133_pictures as p, cpg133_albums as a WHERE p.aid = a.aid AND category = 17
      [33] => SELECT count(*) FROM cpg133_albums as a WHERE category = '17'
      [34] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg133_albums as a LEFT JOIN cpg133_pictures as p ON a.thumb=p.pid WHERE category=17 ORDER BY a.pos LIMIT 0,7
      [35] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg133_pictures WHERE aid IN (183, 168, 218, 238, 237, 68, 31) AND approved = 'YES' GROUP BY aid
      [36] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='3735'
      [37] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='4354'
      [38] => SELECT cid, name, description, thumb FROM cpg133_categories WHERE parent = '17'  ORDER BY pos
      [39] => SELECT aid FROM cpg133_albums WHERE category = 14
      [40] => SELECT count(*) FROM cpg133_pictures as p, cpg133_albums as a WHERE p.aid = a.aid AND category = 14
      [41] => SELECT count(*) FROM cpg133_albums as a WHERE category = '14'
      [42] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg133_albums as a LEFT JOIN cpg133_pictures as p ON a.thumb=p.pid WHERE category=14 ORDER BY a.pos LIMIT 0,16
      [43] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg133_pictures WHERE aid IN (247, 244, 226, 225, 223, 224, 215, 216, 214, 217, 213, 192, 134, 235, 234, 127) AND approved = 'YES' GROUP BY aid
      [44] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='5023'
      [45] => SELECT cid, name, description, thumb FROM cpg133_categories WHERE parent = '14'  ORDER BY pos
      [46] => SELECT aid FROM cpg133_albums WHERE category = 5
      [47] => SELECT count(*) FROM cpg133_pictures as p, cpg133_albums as a WHERE p.aid = a.aid AND category = 5
      [48] => SELECT count(*) FROM cpg133_albums as a WHERE category = '5'
      [49] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg133_albums as a LEFT JOIN cpg133_pictures as p ON a.thumb=p.pid WHERE category=5 ORDER BY a.pos LIMIT 0,9
      [50] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg133_pictures WHERE aid IN (230, 161, 155, 131, 122, 93, 49, 54, 79) AND approved = 'YES' GROUP BY aid
      [51] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='5095'
      [52] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='367'
      [53] => SELECT cid, name, description, thumb FROM cpg133_categories WHERE parent = '5'  ORDER BY pos
      [54] => SELECT aid FROM cpg133_albums WHERE category = 13
      [55] => SELECT count(*) FROM cpg133_pictures as p, cpg133_albums as a WHERE p.aid = a.aid AND category = 13
      [56] => SELECT count(*) FROM cpg133_albums as a WHERE category = '13'
      [57] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg133_albums as a LEFT JOIN cpg133_pictures as p ON a.thumb=p.pid WHERE category=13 ORDER BY a.pos LIMIT 0,16
      [58] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg133_pictures WHERE aid IN (211, 190, 185, 152, 132, 130, 129, 110, 88, 56, 108, 84, 57, 76, 77, 78) AND approved = 'YES' GROUP BY aid
      [59] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='371'
      [60] => SELECT cid, name, description, thumb FROM cpg133_categories WHERE parent = '13'  ORDER BY pos
      [61] => SELECT aid FROM cpg133_albums WHERE category = 15
      [62] => SELECT count(*) FROM cpg133_pictures as p, cpg133_albums as a WHERE p.aid = a.aid AND category = 15
      [63] => SELECT count(*) FROM cpg133_albums as a WHERE category = '15'
      [64] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg133_albums as a LEFT JOIN cpg133_pictures as p ON a.thumb=p.pid WHERE category=15 ORDER BY a.pos LIMIT 0,5
      [65] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg133_pictures WHERE aid IN (174, 191, 169, 171, 165) AND approved = 'YES' GROUP BY aid
      [66] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='4158'
      [67] => SELECT cid, name, description, thumb FROM cpg133_categories WHERE parent = '15'  ORDER BY pos
      [68] => SELECT aid FROM cpg133_albums WHERE category = 10
      [69] => SELECT count(*) FROM cpg133_pictures as p, cpg133_albums as a WHERE p.aid = a.aid AND category = 10
      [70] => SELECT count(*) FROM cpg133_albums as a WHERE category = '10'
      [71] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg133_albums as a LEFT JOIN cpg133_pictures as p ON a.thumb=p.pid WHERE category=10 ORDER BY a.pos LIMIT 0,16
      [72] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg133_pictures WHERE aid IN (246, 240, 233, 231, 229, 227, 222, 220, 212, 209, 242, 221, 202, 197, 194, 195) AND approved = 'YES' GROUP BY aid
      [73] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='4861'
      [74] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='4860'
      [75] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='4635'
      [76] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='5578'
      [77] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='3944'
      [78] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='4391'
      [79] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='4373'
      [80] => SELECT cid, name, description, thumb FROM cpg133_categories WHERE parent = '10'  ORDER BY pos
      [81] => SELECT aid FROM cpg133_albums WHERE category = 6
      [82] => SELECT count(*) FROM cpg133_pictures as p, cpg133_albums as a WHERE p.aid = a.aid AND category = 6
      [83] => SELECT count(*) FROM cpg133_albums as a WHERE category = '6'
      [84] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg133_albums as a LEFT JOIN cpg133_pictures as p ON a.thumb=p.pid WHERE category=6 ORDER BY a.pos LIMIT 0,4
      [85] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg133_pictures WHERE aid IN (241, 13, 14, 51) AND approved = 'YES' GROUP BY aid
      [86] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='5067'
      [87] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='5572'
      [88] => SELECT cid, name, description, thumb FROM cpg133_categories WHERE parent = '6'  ORDER BY pos
      [89] => SELECT aid FROM cpg133_albums as a WHERE category>=10000
      [90] => SELECT count(*) FROM cpg133_pictures as p, cpg133_albums as a WHERE p.aid = a.aid AND category >= 10000
      [91] => SELECT cid, name, description, thumb FROM cpg133_categories WHERE parent = '1'  ORDER BY pos
      [92] => SELECT aid FROM cpg133_albums as a WHERE category = '0'
      [93] => SELECT count(*) FROM cpg133_albums as a WHERE 1
      [94] => SELECT count(*) FROM cpg133_pictures as p LEFT JOIN cpg133_albums as a ON a.aid=p.aid WHERE 1
      [95] => SELECT count(*) FROM cpg133_comments as c LEFT JOIN cpg133_pictures as p ON c.pid=p.pid LEFT JOIN cpg133_albums as a ON a.aid=p.aid WHERE 1
      [96] => SELECT count(*) FROM cpg133_categories WHERE 1
      [97] => SELECT sum(hits) FROM cpg133_pictures as p LEFT JOIN cpg133_albums as a ON p.aid=a.aid WHERE 1
      [98] => SELECT count(*) FROM cpg133_albums as a WHERE category = '0'
      [99] => SELECT COUNT(*) from cpg133_pictures WHERE approved = 'YES'
      [100] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid,title, caption, owner_id, owner_name, aid FROM cpg133_pictures WHERE approved = 'YES'  ORDER BY pid DESC  LIMIT 0 ,10
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 4.3.10 - OK
  ------------------
  mySQL version: 5.0.19
  ------------------
  Coppermine version: 1.3.3
  ==========================
  Module: gd
  ------------------
  GD Support enabled
  GD Version 2.0 or higher
  FreeType Support enabled
  FreeType Linkage with freetype
  T1Lib Support enabled
  GIF Read Support enabled
  GIF Create Support enabled
  JPG Support enabled
  PNG Support enabled
  WBMP Support enabled
  ==========================
  Module: mysql
  ------------------
  Active Links 1
  Client API version 5.0.19
  MYSQL_MODULE_TYPE external
  MYSQL_SOCKET /tmp/mysql.sock
  MYSQL_INCLUDE -I/usr/mysql/include/mysql
  MYSQL_LIBS -L/usr/mysql/lib/mysql -lmysqlclient 
  ==========================
  Module: zlib
  ------------------
  ZLib Support enabled
  Compiled Version 1.2.3
  Linked Version 1.2.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 | /var/www/free.fr/8/e/maggieparadise/include:. | .
  open_basedir | no value | 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.437 seconds - 101 queries in 0.132 seconds - Album set :

[Titooy]

C'est tout-à-fait normal. Tu peux maintenant désactiver le mode de débogage

[Eliza01]

Ouf je me sens plus legere de suite lol
Un enorme merci a toi Titooy
Et encore désolée pour les problemes de bug que ca a provoqué chez vous, je comprend pas se qui s'est passé  :-\

[François Keller]

Et encore désolée pour les problemes de bug que ca a provoqué chez vous, je comprend pas se qui s'est passé

Pas de problème, Titooy a bien précisisé qu'a priori ça ne venait pas de toi