Annonce

  •  » Utilisation
  •  » affichage erreur envoi notification

#1 2007-08-29 12:16:26

patnoe
Membre
Alsace
2007-08-22
34

affichage erreur envoi notification

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

#2 2007-08-29 12:48:47

rub
Former Piwigo Team
Lille
2005-08-26
5239

Re: affichage erreur envoi notification

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

#3 2008-01-29 17:40:04

mathiasm
Former Piwigo Team
2006-02-06
2692

Re: affichage erreur envoi notification

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) ?

Hors ligne

#4 2008-01-29 19:13:52

rub
Former Piwigo Team
Lille
2005-08-26
5239

Re: affichage erreur envoi notification

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

#5 2008-01-29 21:20:18

mathiasm
Former Piwigo Team
2006-02-06
2692

Re: affichage erreur envoi notification

j'ai mis à jour le bug

Hors ligne

  •  » Utilisation
  •  » affichage erreur envoi notification

Pied de page des forums

Propulsé par FluxBB

github twitter newsletter Faire un don Piwigo.org © 2002-2024 · Contact