News:

CPG Release 1.6.29
During HTML5 upload, keep pseudo blank code 200 messages from triggering error condition
added Russian language
correct failure to use theme menu icons in album manager
minor vulnerabilities mitigation

Main Menu

Encore "Il y eu une erreur lors de l'exécution de la requête "

Started by sebmlmp, September 18, 2008, 10:24:17 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

sebmlmp

Hello à tous et merci d'avance pour votre aide...
Ben pour ma part, c'est apparu il y a quelques temps : impossible d'ouvrir le bouton Utilisateurs dans l'admin.
Message d'erreur à chaque fois malgré les mises à jour etc...
Voici le code debug relatif à ça :

QuoteWhile executing query "SELECT user_id as user_id, user_name as user_name, user_email as user_email, UNIX_TIMESTAMP(user_regdate) as user_regdate, UNIX_TIMESTAMP(user_lastvisit) as user_lastvisit, user_active as user_active, COUNT(pid) as pic_count, ROUND(SUM(total_filesize)/1024) as disk_usage, group_name, group_quota FROM `bataclanclubcom`.cpg1410_users AS u INNER JOIN cpg1410_usergroups AS g ON u.user_group = g.group_id LEFT JOIN cpg1410_pictures AS p ON p.owner_id = u.user_id GROUP BY user_id ORDER BY user_regdate DESC LIMIT 0, 25;" on Resource id #7

mySQL error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Quelqu'un a t il une idée??

Merci d'avance,

Pascal YAP

Avez-vous essayez UPDATE.PHP depuis votre Compte Admin,
et/ou "Réparez les Tables" depuis votre PhpMyAdmin ?