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

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

Try this query :

select date_creation,path from phpwebgallery_images where year(date_creation) = 0;