Announcement

#1 2013-03-17 18:14:03

Seppel
Member
2013-03-17
3

Error while synchronizing new files and folders

Hi,

when I try to synchronize new files and folders I get the following error:
----
Warning: [mysql error 1364] Field 'smart_update' doesn't have a default value

INSERT  INTO piwigo_categories
  (id,dir,name,site_id,id_uppercat,uppercats,commentable,visible,status,rank,global_rank)
  VALUES('325','xxxxxpath_to_new_folderxxxx','xxxxname_of_new_albumxxxx','1','321','321,325','true','true','public','4','14.4') in D:\Web\piwigo\include\dblayer\functions_mysql.inc.php on line 795

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 D:\Web\piwigo\include\dblayer\functions_mysql.inc.php on line 795

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in D:\Web\piwigo\include\dblayer\functions_mysql.inc.php on line 225
----
If I select "Simulation only" everything is fine. The pictures from that folder have been added to the database (I can select them in the batch processor) but the new album won't be created :(

Any help available? Where can I check - what can I do?
Exactly the same workflow worked before 2.5 like a charm...

Thanx in advance :)

Offline

 

#2 2013-03-17 19:42:25

mistic100
Former Piwigo Team
Lyon (FR)
2008-09-27
3277

Re: Error while synchronizing new files and folders

It's a bug with Smart Albums

if you don't have Smart Albums, uninstall the plugin (not just unactivate)
otherwise please wait 'till I fix it

Offline

 

#3 2013-03-17 22:24:38

mistic100
Former Piwigo Team
Lyon (FR)
2008-09-27
3277

Re: Error while synchronizing new files and folders

should be fixed with SmartAlbums 2.1.1

Offline

 

#4 2013-03-17 23:45:14

Seppel
Member
2013-03-17
3

Re: Error while synchronizing new files and folders

mistic100 wrote:

It's a bug with Smart Albums

if you don't have Smart Albums, uninstall the plugin (not just unactivate)
otherwise please wait 'till I fix it

that's it :) After deinstallation of SmartAlbums the synchronization finishs without problems again!

Thank you very much!

Offline

 

#5 2013-03-17 23:47:34

Seppel
Member
2013-03-17
3

Re: Error while synchronizing new files and folders

mistic100 wrote:

should be fixed with SmartAlbums 2.1.1

I'll test it (within the next few days) and report the result.

Thanks again :)

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact