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
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
should be fixed with SmartAlbums 2.1.1
Offline
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
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