Annonce

Écrire une réponse

Veuillez écrire votre message et l'envoyer

Cliquez dans la zone sombre de l'image pour envoyer votre message.

Retour

Résumé de la discussion (messages les plus récents en premier)

Michrone
2005-03-13 12:35:38

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 :-)

plg
2005-03-13 12:26:30

Try this query :

Code:

select date_creation,path from phpwebgallery_images where year(date_creation) = 0;
Michrone
2005-03-13 11:53:34

This problem is still in final 1.4.0

Michrone
2005-03-07 17:53:50

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

plg
2005-03-07 09:13:57

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'
;
Michrone
2005-03-06 23:58:11

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

plg
2005-03-06 19:35:47

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 ?

Michrone
2005-02-26 19:05:11

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)

Pied de page des forums

Propulsé par FluxBB

github twitter newsletter Faire un don Piwigo.org © 2002-2024 · Contact