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
Hors ligne
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
Hors ligne
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.
Hors ligne