🌍
Français
j'ai mis à jour le bug
mathiasm a écrit:
Et donc ?
ça rentre dans l'ordre tout seul au bout de plusieurs rechargements de page ?
Sinon, un efonction avancé de pré-génération du cache peut-elle être utile (même en plugin) ?
Et donc, il faut revoir les requêtes qui dépasse la taille max.
Et donc ?
ça rentre dans l'ordre tout seul au bout de plusieurs rechargements de page ?
Sinon, un efonction avancé de pré-génération du cache peut-elle être utile (même en plugin) ?
Il ne s'agit pas d'un pb NBM pure mais ca se produit lors de la construction du cache.
Pour rappel, la galerie de patnoe contient énormément de données.
cf http://bugs.phpwebgallery.net/view.php?id=739
A l'envoi de la Notification par mail j'ai les messages suivant qui s'affichent
SELECT count(distinct image_id) as CountId
FROM phpwebgallery_images INNER JOIN phpwebgallery_image_category AS ic ON image_id = id
WHERE date_available > ''
AND date_available <= '2007-08-29 08:47:11'
AND (ic.category_id NOT IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,
etc.....))
;
[mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 6
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\www\phpwebgallery\include\functions_notification.inc.php on line 152
SELECT count(distinct category_id) as CountId
FROM phpwebgallery_images INNER JOIN phpwebgallery_image_category AS ic ON image_id = id
WHERE date_available > ''
AND date_available <= '2007-08-29 08:47:11'
AND (ic.category_id NOT IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,
etc.........))
;
[mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 8
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\www\phpwebgallery\include\functions_notification.inc.php on line 152
SELECT count(distinct image_id) as CountId
FROM phpwebgallery_images INNER JOIN phpwebgallery_image_category AS ic ON image_id = id
WHERE date_available > ''
AND date_available <= '2007-08-29 08:47:11'
AND (ic.category_id NOT IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,
etc........))
;
[mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 6
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\www\phpwebgallery\include\functions_notification.inc.php on line 152
SELECT count(distinct category_id) as CountId
FROM phpwebgallery_images INNER JOIN phpwebgallery_image_category AS ic ON image_id = id
WHERE date_available > ''
AND date_available <= '2007-08-29 08:47:11'
AND (ic.category_id NOT IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83etc...........))
;
[mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 6
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\www\phpwebgallery\include\functions_notification.inc.php on line 152