Sonny Software

I updated to 14.0.9 yesterday and the SQL Smart Folders that are date based (i.e. added or edited last two weeks) are no longer populated, even though I added various PDFs to the library and edited various publications.

I could verify tomorrow in the office if this is also the case for 14.0.8, but I was just wondering if this is a bug introduced with 14.0.9?

Nothing has changed in 14.0.9 in this regard. Please Rebuild your library and see if that helps.

Jon
Sonny Software

I rebuild, verified and all that, but no change. I can also confirm that it happens under 14.0.8 with my library.

I can get the SQL 'last 15 references added' to work and view the latest added articles, so unsure what is causing the problem

Did you edit the smart SQL group? Post the actual SQL in the group that's not working.

Jon
Sonny Software

These standard SQL do not work

dateModified > datediff( now(), '01/01/1904 00:00:00', 'second' ) - (14 * 24 * 60 * 60)
dateAdded > datediff( now(), '01/01/1904 00:00:00', 'second' ) - (14 * 24 * 60 * 60)

I edited one of these into this for myself (For added last day..) that also does not work

dateAdded > datediff( now(), '01/01/1904 00:00:00', 'second' ) - (1 * 24 * 60 * 60)

This SQL - however - does work

recID <> 0 order by dateAdded DESC limit 30

The first two work for me. Please do a Repair and then a Rebuild on your library in case there is an issue with it.

Jon
Sonny Software

I tried those, but they don't work to solve the problem..

Please try with a fresh new library.

And zip and send your library to support@sonnysoftware.com

Jon
Sonny Software

Creating a fresh library and adding several articles returned the same problem for the smart groups.

You got mail (in a few moments), thanks for helping out.

same problem with me
i die repair and rebuild library
and have sent my library to you as well some time ago
still does not work the same sql

What version of Bookends?

Jon
Sonny Software