Pages: 1
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 ?
Hors ligne
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
Hors ligne
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' ;
Hors ligne
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
Hors ligne
Try this query :
select date_creation,path from phpwebgallery_images where year(date_creation) = 0;
Hors ligne
Pages: 1