z0rglub a écrit:
Try this query :
Code:
select date_creation,path from phpwebgallery_images where year(date_creation) = 0;
Ok, He found 7record :-)
I modify the date on this :-)
Try this query :
select date_creation,path from phpwebgallery_images where year(date_creation) = 0;
This problem is still in final 1.4.0
z0rglub a écrit:
Give us the result of this query :
Code:
SELECT file,tn_ext,date_creation,path FROM phpwebgallery_images INNER JOIN phpwebgallery_image_category ON id = image_id WHERE date_creation IS NOT NULL AND date_creation BETWEEN '0-1-1' AND '0-12-31' ;
Votre requête SQL a été exécutée avec succès (traitement: 0.0010 sec.)
requête SQL:
SELECT FILE , tn_ext, date_creation, path
FROM phpwebgallery_images
INNER JOIN phpwebgallery_image_category ON id = image_id
WHERE date_creation IS NOT NULL
AND date_creation
BETWEEN '0-1-1'
AND '0-12-31'
LIMIT 0 , 30
And there is nothing more (no rows selected)
If i select WHERE date_creation IS NOT NULL
AND date_creation
> '0-1-1'
I have all the record
Give us the result of this query :
SELECT file,tn_ext,date_creation,path FROM phpwebgallery_images INNER JOIN phpwebgallery_image_category ON id = image_id WHERE date_creation IS NOT NULL AND date_creation BETWEEN '0-1-1' AND '0-12-31' ;
z0rglub a écrit:
At the root of calendar special category, thumbnails correspond to distinct years found in date_creation (by default) field of images table. If PhpWebGallery proposes year 0, it means that there are elements in your gallery with date creation in year 0.
You say "I think it corresponds", can you be more precise ? can you be sure ? which thumbnails are shown ?
Wich date have I to look in the base ?
Example:
http://www.la25eme.be/WebGallery/catego … t=calendar
At the root of calendar special category, thumbnails correspond to distinct years found in date_creation (by default) field of images table. If PhpWebGallery proposes year 0, it means that there are elements in your gallery with date creation in year 0.
You say "I think it corresponds", can you be more precise ? can you be sure ? which thumbnails are shown ?
Hello,
In calendar, I have 7 category from year '0'.
I think it correspond a the 7 main category of the gallery where there are no picture, but only sub-category(with picture)