Hi,
Inspecting queries I found
SELECT DISTINCT(MONTH(date_creation)) as period,
COUNT(DISTINCT id) as nb_images FROM images
INNER JOIN image_category ON id = image_id
WHERE 1 = 1 AND date_creation BETWEEN '1975-01-01' AND '1975-12-31 23:59:59'
GROUP BY period;
(this query time : 0.001 s)
(total SQL time : 0.003 s)
(total time : 0.019 s)
(num rows : 0 )
but as I have images like date_creation=1975-00-00 00:00:00
I want to suggest change the query to something like
.....
WHERE date_creation LIKE '1975%'
.....
that returns my missing image when using phpmyadmin.
If someone point me where is it in the source code I can do some tests and propose a patch for this.
Masaki
Piwigo version: 2.7.3
PHP: 5.5.9-1ubuntu4.5
MySQL: 5.5.40-0ubuntu0.14.04.1
Offline
msakik wrote:
but as I have images like date_creation=1975-00-00 00:00:00
I want to suggest change the query to something like
Of course it can be done but your date is incorrect
Offline