adam/Piwigo
1
0 Fork 0
mirror of https://github.com/Piwigo/Piwigo.git synced 2026-10-30 21:52:00 +01:00
Code Issues 657 Packages Projects Releases Wiki Activity

[notification] affichage erreur envoi notification #50

New Issue
Closed
opened 2026-10-04 23:41:30 +02:00 by adam · 2 comments
adam commented 2026-10-04 23:41:30 +02:00
Owner
Copy link
Copy source

Reported by patnoe on 29 Aug 2007 10:05

Version: 1.7.0

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

Additional information: http://forum.phpwebgallery.net/viewtopic.php?pid=69247#p69247

Piwigo Bugtracker #739

**Reported by patnoe on 29 Aug 2007 10:05** **Version:** 1.7.0 A l&#039;envoi de la Notification par mail j&#039;ai les messages suivant qui s&#039;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 &gt; &#039;&#039; AND date_available &lt;= &#039;2007-08-29 08:47:11&#039; 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 &#039;))&#039; 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 &gt; &#039;&#039; AND date_available &lt;= &#039;2007-08-29 08:47:11&#039; 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 &#039;))&#039; 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 &gt; &#039;&#039; AND date_available &lt;= &#039;2007-08-29 08:47:11&#039; 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 &#039;))&#039; 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 &gt; &#039;&#039; AND date_available &lt;= &#039;2007-08-29 08:47:11&#039; 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 &#039;))&#039; 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 **Additional information:** http://forum.phpwebgallery.net/viewtopic.php?pid=69247#p69247 [Piwigo Bugtracker #739](http://piwigo.org/bugs/view.php?id=739) <!-- github-sync-id:97225374 -->
adam closed this issue 2026-10-04 23:41:30 +02:00
adam commented 2026-10-04 23:41:31 +02:00
Author
Owner
Copy link
Copy source

Comment posted by rub on 29 Aug 2007 10:48

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.

**Comment posted by rub on 29 Aug 2007 10:48** Il ne s&#039;agit pas d&#039;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. <!-- github-comment-id:124890093 -->
adam commented 2026-10-04 23:41:32 +02:00
Author
Owner
Copy link
Copy source

Comment posted by mathiasm on 29 Jan 2008 20:19

s'il y a trop déléments, le IN fait planter MySQL.

Méthode de contournement à étudier.

**Comment posted by mathiasm on 29 Jan 2008 20:19** s&#039;il y a trop déléments, le IN fait planter MySQL. Méthode de contournement à étudier. <!-- github-comment-id:124890099 -->
Sign in to join this conversation.
No Branch/Tag Specified
Labels
No items
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
adam (Adam Wojcieszonek)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: adam/Piwigo#50