MantisBT - Piwigo
View Issue Details
0002378Piwigosynchronizationpublic2011.07.17 19:522011.08.30 11:26
plg 
plg 
normalminoralways
closedfixed 
2.2.4 
2.2.52.2.5 
any
Apache 1.3.x
0002378: MySQL warning on simulation with new albums found
When you run the synchronization with simulation mode and with new albums, you get an ugly SQL error :


Warning: [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 ')
    AND status = 'private'' at line 4

SELECT
    id
  FROM piwigo_categories
  WHERE id IN ()
    AND status = 'private'
; in /home/pierrick/public_html/piwigo/tmp/224/include/dblayer/functions_mysql.inc.php on line 654
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/pierrick/public_html/piwigo/tmp/224/include/dblayer/functions_mysql.inc.php on line 200
No tags attached.
related to 0002245closed plg automatically give permissions to the creator of a new private album 
Issue History
2011.07.17 19:52plgNew Issue
2011.07.17 19:52plgStatusnew => assigned
2011.07.17 19:52plgAssigned To => plg
2011.07.17 19:52plgbrowser => any
2011.07.17 19:52plgWeb server => Apache 1.3.x
2011.07.19 16:56rvelicesRelationship addedrelated to 0002245
2011.08.30 11:25svnCheckin
2011.08.30 11:25svnNote Added: 0005444
2011.08.30 11:25svnCheckin
2011.08.30 11:25svnNote Added: 0005445
2011.08.30 11:26plgStatusassigned => closed
2011.08.30 11:26plgResolutionopen => fixed
2011.08.30 11:26plgFixed in Version => 2.2.5

Notes
(0005444)
svn   
2011.08.30 11:25   
[Subversion] r12011 by plg on branch 2.2

-----[Subversion commit log]----------------------------------------------------
bug 2378 fixed: remove MySQL warning when synchronizing with simulation
activated. The warning occurs when there are new dircetories found.
(0005445)
svn   
2011.08.30 11:25   
[Subversion] r12012 by plg on trunk

-----[Subversion commit log]----------------------------------------------------
merge r12011 from branch 2.2 to trunk

bug 2378 fixed: remove MySQL warning when synchronizing with simulation
activated. The warning occurs when there are new dircetories found.