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 ;D
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
Bonjour
QuoteJ'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
QuoteEt 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
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 (http://forum.coppermine-gallery.net/index.php?topic=28207.0)) ou mieux vers la version 1.4.4
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 ;)
Comme le dit le message d'erreur
QuotemySQL 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)
:o 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 :
C'est tout-à-fait normal. Tu peux maintenant désactiver le mode de débogage
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é :-\
QuoteEt 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 ;)