Print

[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