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

plg
2004-11-01 20:02:46

Jovial a écrit:

Super, comment t'as fait pour les mettre tout bien visible comme ca ?

1. copier le texte dans un fichier local
2.

Code:

$ perl -pi -e "s/,\(/,\n  \(/g" monfichier.sql

3. je copies colles sur le forum dans une balise de code pour avoir une police à chasse fixe

Jovial
2004-11-01 17:10:55

Super, comment t'as fait pour les mettre tout bien visible comme ca ?

Bon en fait j'avais pas mal de photos dans ce cas, surement du au fait que ma connexion chie un peu en ce moment...

Merci zorglub !

plg
2004-11-01 12:50:20

(j'ai un peu reformaté ta réponse, histoire de la rendre lisible :-)

On voit clairement (enfin, je vois clairement...) qu'il y a un problème avec PICT0077.JPG. Vérifies que ce fichier n'est pas corompu par exemple.

Jovial
2004-11-01 12:25:49

Code:

INSERT INTO phpwebgallery_images
  (file,storage_category_id,date_available,tn_ext,filesize,width,height,name,author,comment,date_creation)
  VALUES
  ('PICT0001.JPG',40,'2004-11-01','jpg',85,1024,768,'','','',NULL),
  ('PICT0002.JPG',40,'2004-11-01','jpg',104,1024,768,'','','',NULL),
  ('PICT0003.JPG',40,'2004-11-01','jpg',147,1024,768,'','','',NULL),
  ('PICT0004.JPG',40,'2004-11-01','jpg',139,1024,768,'','','',NULL),
  ('PICT0006.JPG',40,'2004-11-01','jpg',101,1024,768,'','','',NULL),
  ('PICT0009.JPG',40,'2004-11-01','jpg',108,1024,768,'','','',NULL),
  ('PICT0010.JPG',40,'2004-11-01','jpg',95,1024,768,'','','',NULL),
  ('PICT0011.JPG',40,'2004-11-01','jpg',97,1024,768,'','','',NULL),
  ('PICT0012.JPG',40,'2004-11-01','jpg',140,1024,768,'','','',NULL),
  ('PICT0013.JPG',40,'2004-11-01','jpg',108,1024,768,'','','',NULL),
  ('PICT0015.JPG',40,'2004-11-01','jpg',75,1024,768,'','','',NULL),
  ('PICT0016.JPG',40,'2004-11-01','jpg',126,1024,768,'','','',NULL),
  ('PICT0017.JPG',40,'2004-11-01','jpg',111,1024,768,'','','',NULL),
  ('PICT0019.JPG',40,'2004-11-01','jpg',88,1024,768,'','','',NULL),
  ('PICT0020.JPG',40,'2004-11-01','jpg',110,1024,768,'','','',NULL),
  ('PICT0021.JPG',40,'2004-11-01','jpg',79,1024,768,'','','',NULL),
  ('PICT0022.JPG',40,'2004-11-01','jpg',92,1024,768,'','','',NULL),
  ('PICT0023.JPG',40,'2004-11-01','jpg',114,768,1024,'','','',NULL),
  ('PICT0024.JPG',40,'2004-11-01','jpg',85,1024,768,'','','',NULL),
  ('PICT0026.JPG',40,'2004-11-01','jpg',83,1024,768,'','','',NULL),
  ('PICT0027.JPG',40,'2004-11-01','jpg',138,1024,768,'','','',NULL),
  ('PICT0028.JPG',40,'2004-11-01','jpg',82,1024,768,'','','',NULL),
  ('PICT0029.JPG',40,'2004-11-01','jpg',79,1024,768,'','','',NULL),
  ('PICT0030.JPG',40,'2004-11-01','jpg',74,1024,768,'','','',NULL),
  ('PICT0031.JPG',40,'2004-11-01','jpg',103,1024,768,'','','',NULL),
  ('PICT0032.JPG',40,'2004-11-01','jpg',90,1024,768,'','','',NULL),
  ('PICT0035.JPG',40,'2004-11-01','jpg',91,1024,768,'','','',NULL),
  ('PICT0037.JPG',40,'2004-11-01','jpg',114,1024,768,'','','',NULL),
  ('PICT0038.JPG',40,'2004-11-01','jpg',131,1024,768,'','','',NULL),
  ('PICT0039.JPG',40,'2004-11-01','jpg',138,1024,768,'','','',NULL),
  ('PICT0040.JPG',40,'2004-11-01','jpg',100,1024,768,'','','',NULL),
  ('PICT0041.JPG',40,'2004-11-01','jpg',86,1024,768,'','','',NULL),
  ('PICT0042.JPG',40,'2004-11-01','jpg',104,1024,768,'','','',NULL),
  ('PICT0043.JPG',40,'2004-11-01','jpg',113,1024,768,'','','',NULL),
  ('PICT0044.JPG',40,'2004-11-01','jpg',82,1024,768,'','','',NULL),
  ('PICT0045.JPG',40,'2004-11-01','jpg',96,1024,768,'','','',NULL),
  ('PICT0046.JPG',40,'2004-11-01','jpg',87,1024,768,'','','',NULL),
  ('PICT0048.JPG',40,'2004-11-01','jpg',120,1024,768,'','','',NULL),
  ('PICT0049.JPG',40,'2004-11-01','jpg',149,768,1024,'','','',NULL),
  ('PICT0050.JPG',40,'2004-11-01','jpg',145,1024,768,'','','',NULL),
  ('PICT0051.JPG',40,'2004-11-01','jpg',148,1024,768,'','','',NULL),
  ('PICT0052.JPG',40,'2004-11-01','jpg',114,768,1024,'','','',NULL),
  ('PICT0053.JPG',40,'2004-11-01','jpg',132,768,1024,'','','',NULL),
  ('PICT0054.JPG',40,'2004-11-01','jpg',144,768,1024,'','','',NULL),
  ('PICT0055.JPG',40,'2004-11-01','jpg',139,768,1024,'','','',NULL),
  ('PICT0056.JPG',40,'2004-11-01','jpg',116,1024,768,'','','',NULL),
  ('PICT0057.JPG',40,'2004-11-01','jpg',106,1024,768,'','','',NULL),
  ('PICT0058.JPG',40,'2004-11-01','jpg',129,768,1024,'','','',NULL),
  ('PICT0059.JPG',40,'2004-11-01','jpg',129,768,1024,'','','',NULL),
  ('PICT0060.JPG',40,'2004-11-01','jpg',110,768,1024,'','','',NULL),
  ('PICT0061.JPG',40,'2004-11-01','jpg',128,768,1024,'','','',NULL),
  ('PICT0062.JPG',40,'2004-11-01','jpg',136,768,1024,'','','',NULL),
  ('PICT0063.JPG',40,'2004-11-01','jpg',124,1024,768,'','','',NULL),
  ('PICT0064.JPG',40,'2004-11-01','jpg',122,768,1024,'','','',NULL),
  ('PICT0065.JPG',40,'2004-11-01','jpg',147,1024,768,'','','',NULL),
  ('PICT0066.JPG',40,'2004-11-01','jpg',38,1024,768,'','','',NULL),
  ('PICT0067.JPG',40,'2004-11-01','jpg',103,1024,768,'','','',NULL),
  ('PICT0068.JPG',40,'2004-11-01','jpg',109,1024,768,'','','',NULL),
  ('PICT0069.JPG',40,'2004-11-01','jpg',127,768,1024,'','','',NULL),
  ('PICT0070.JPG',40,'2004-11-01','jpg',145,768,1024,'','','',NULL),
  ('PICT0072.JPG',40,'2004-11-01','jpg',132,768,1024,'','','',NULL),
  ('PICT0073.JPG',40,'2004-11-01','jpg',136,768,1024,'','','',NULL),
  ('PICT0074.JPG',40,'2004-11-01','jpg',127,768,1024,'','','',NULL),
  ('PICT0075.JPG',40,'2004-11-01','jpg',107,768,1024,'','','',NULL),
  ('PICT0076.JPG',40,'2004-11-01','jpg',101,768,1024,'','','',NULL),
  ('PICT0077.JPG',40,'2004-11-01','jpg',4,,,'','','',NULL),
  ('PICT0078.JPG',40,'2004-11-01','jpg',89,1024,768,'','','',NULL),
  ('PICT0079.JPG',40,'2004-11-01','jpg',99,1024,768,'','','',NULL),
  ('PICT0080.JPG',40,'2004-11-01','jpg',128,768,1024,'','','',NULL),
  ('PICT0081.JPG',40,'2004-11-01','jpg',95,1024,768,'','','',NULL),
  ('PICT0083.JPG',40,'2004-11-01','jpg',89,1024,768,'','','',NULL),
  ('PICT0084.JPG',40,'2004-11-01','jpg',90,1024,768,'','','',NULL),
  ('PICT0086.JPG',40,'2004-11-01','jpg',120,768,1024,'','','',NULL),
  ('PICT0087.JPG',40,'2004-11-01','jpg',116,768,1024,'','','',NULL),
  ('PICT0088.JPG',40,'2004-11-01','jpg',80,768,1024,'','','',NULL),
  ('PICT0089.JPG',40,'2004-11-01','jpg',94,768,1024,'','','',NULL),
  ('PICT0090.JPG',40,'2004-11-01','jpg',107,1024,768,'','','',NULL),
  ('PICT0091.JPG',40,'2004-11-01','jpg',151,768,1024,'','','',NULL),
  ('PICT0092.JPG',40,'2004-11-01','jpg',116,1024,768,'','','',NULL),
  ('PICT0093.JPG',40,'2004-11-01','jpg',127,768,1024,'','','',NULL),
  ('PICT0094.JPG',40,'2004-11-01','jpg',90,768,1024,'','','',NULL),
  ('PICT0095.JPG',40,'2004-11-01','jpg',77,1024,768,'','','',NULL),
  ('PICT0096.JPG',40,'2004-11-01','jpg',117,1024,768,'','','',NULL),
  ('PICT0097.JPG',40,'2004-11-01','jpg',113,1024,768,'','','',NULL),
  ('PICT0098.JPG',40,'2004-11-01','jpg',104,1024,768,'','','',NULL),
  ('PICT0099.JPG',40,'2004-11-01','jpg',94,768,1024,'','','',NULL),
  ('PICT0101.JPG',40,'2004-11-01','jpg',137,768,1024,'','','',NULL),
  ('PICT0102.JPG',40,'2004-11-01','jpg',123,1024,768,'','','',NULL),
  ('PICT0103.JPG',40,'2004-11-01','jpg',112,768,1024,'','','',NULL),
  ('PICT0104.JPG',40,'2004-11-01','jpg',129,1024,768,'','','',NULL),
  ('PICT0105.JPG',40,'2004-11-01','jpg',92,768,1024,'','','',NULL),
  ('PICT0106.JPG',40,'2004-11-01','jpg',130,768,1024,'','','',NULL),
  ('PICT0107.JPG',40,'2004-11-01','jpg',87,768,1024,'','','',NULL),
  ('PICT0108.JPG',40,'2004-11-01','jpg',115,768,1024,'','','',NULL),
  ('PICT0109.JPG',40,'2004-11-01','jpg',119,1024,768,'','','',NULL),
  ('PICT0110.JPG',40,'2004-11-01','jpg',122,1024,768,'','','',NULL),
  ('PICT0111.JPG',40,'2004-11-01','jpg',105,1024,768,'','','',NULL),
  ('PICT0112.JPG',40,'2004-11-01','jpg',99,1024,768,'','','',NULL),
  ('PICT0113.JPG',40,'2004-11-01','jpg',97,1024,768,'','','',NULL),
  ('PICT0114.JPG',40,'2004-11-01','jpg',122,1024,768,'','','',NULL),
  ('PICT0115.JPG',40,'2004-11-01','jpg',112,1024,768,'','','',NULL),
  ('PICT0116.JPG',40,'2004-11-01','jpg',110,1024,768,'','','',NULL),
  ('PICT0117.JPG',40,'2004-11-01','jpg',114,1024,768,'','','',NULL),
  ('PICT0118.JPG',40,'2004-11-01','jpg',86,1024,768,'','','',NULL),
  ('PICT0119.JPG',40,'2004-11-01','jpg',113,1024,768,'','','',NULL),
  ('PICT0120.JPG',40,'2004-11-01','jpg',76,768,1024,'','','',NULL),
  ('PICT0121.JPG',40,'2004-11-01','jpg',126,768,1024,'','','',NULL),
  ('PICT0122.JPG',40,'2004-11-01','jpg',167,768,1024,'','','',NULL),
  ('PICT0123.JPG',40,'2004-11-01','jpg',151,768,1024,'','','',NULL),
  ('PICT0124.JPG',40,'2004-11-01','jpg',134,768,1024,'','','',NULL),
  ('PICT0125.JPG',40,'2004-11-01','jpg',105,1024,768,'','','',NULL),
  ('PICT0126.JPG',40,'2004-11-01','jpg',101,768,1024,'','','',NULL),
  ('PICT0127.JPG',40,'2004-11-01','jpg',111,768,1024,'','','',NULL),
  ('PICT0128.JPG',40,'2004-11-01','jpg',123,768,1024,'','','',NULL),
  ('PICT0129.JPG',40,'2004-11-01','jpg',159,768,1024,'','','',NULL),
  ('PICT0130.JPG',40,'2004-11-01','jpg',73,1024,768,'','','',NULL),
  ('PICT0131.JPG',40,'2004-11-01','jpg',96,768,1024,'','','',NULL),
  ('PICT0132.JPG',40,'2004-11-01','jpg',140,768,1024,'','','',NULL),
  ('PICT0133.JPG',40,'2004-11-01','jpg',63,768,1024,'','','',NULL),
  ('PICT0134.JPG',40,'2004-11-01','jpg',105,1024,768,'','','',NULL),
  ('PICT0135.JPG',40,'2004-11-01','jpg',128,768,1024,'','','',NULL),
  ('PICT0136.JPG',40,'2004-11-01','jpg',118,768,1024,'','','',NULL),
  ('PICT0142.JPG',40,'2004-11-01','jpg',104,1024,768,'','','',NULL),
  ('PICT0144.JPG',40,'2004-11-01','jpg',123,1024,768,'','','',NULL),
  ('PICT0147.JPG',40,'2004-11-01','jpg',57,1024,768,'','','',NULL);
plg
2004-11-01 10:43:21

dans admin/update.php (1.3.2), après

Code:

336     $query.= implode( ',', $inserts );
337     $query.= ';'

insères

Code:

echo $query;

et montres-nous ce que ça affiche lorsque tu fais une mise à jour de la base d'images

Jovial
2004-11-01 10:18:11

Non malheureusement ce n'est pas ça.
Les fichiers sont correctement uploadés sur le site ...

plg
2004-10-31 16:58:20

vérifies que tu n'as pas de fichiers "mal uploadés" sur ton site : avec un poids à 0 par exemple. La requête générée pour insérer l'image dans phpwebgallery_images serait alors fausse et on se retrouve dans le cas que tu cites.

Jovial
2004-10-31 12:08:11

Bonjour,
J'utilise phpwebgallery depuis plusieurs mois et jusqu'à présent je n'avais pas eu à faire à un soucis comme celui-ci.

Voilà j'ai uploader sur mon site un nouveau répertoire contenant des photos avec les miniatures comme d'habitude.
J'ai fait MAJ BASE IMAGE et mettre tout à jour et là la nouvelle catégorie à été trouvé et ça m'indique bien que toutes les photos ont été ajoutées.
Donc ensuite je vais dans catégorie et je vais renommer ma catégorie et là je vois qu'il y a 0 image dans le catégorie. Je fais mettre à jour sur cette catégorie, ça m'indique que l'ensemble des photos est ajouté et en revenant dans la gestion des catégorie, rebelote, 0 image.
Evidemment sur le site la catégorie est vide.

J'ai jeté un coup d'oeil dans la base et effectivement il n'y aucune photo dans la table "phpwebgallery_image_category" lié à la nouvelle catégorie récalcitrante.

Pour info, j'ai ajouté une autre catégorie et ça n'a pas marché non plus. J'ai l'impression que c'est quand j'ai plus d'un certain nombre de photos dans une catégorie.

J'ai aussi essayé de déplacer mon répertoire qui marche pas, de faire un MAJ de la base, de le remettre et de refaire une MAJ et ça n'a pas marché non plus.

Donc voilà
J'utilise la version 1.3.2

Si quelqu'un peut m'aider...

Merci d'avance

Pied de page des forums

Propulsé par FluxBB

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