Hello/Hi/Greetings,
Piwigo version 2.7 stopped working due to an error with apparently PHP compatibility
(according to messages in the Forum)
Therefore decided to upgrade and manually installed Piwigo 2.9
The installation came back successful, but with many warnings, for example:
Warning: [mysql error 1050] Table 'piwigo_caddie' already exists
CREATE TABLE `piwigo_caddie` ( `user_id` mediumint(8) unsigned NOT NULL default '0', `element_id` mediumint(8) NOT NULL default '0', PRIMARY KEY (`user_id`,`element_id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET utf8; in /data/9/3/115/44/3115207/user/3474201/htdocs/albums/piwigo/include/dblayer/functions_mysqli.inc.php on line 845
Warning: [mysql error 1062] Duplicate entry 'picture_slideshow_icon' for key 'PRIMARY'
INSERT INTO piwigo_config (param,value,comment) VALUES ('picture_slideshow_icon','true','Display slideshow icon on picture page'); in /data/9/3/115/44/3115207/user/3474201/htdocs/albums/piwigo/include/dblayer/functions_mysqli.inc.php on line 845
When I go to the Gallery, I see all my Albums and it displays the number of photos in it,
but I cannot see the photos.
Looking at the MySQL database with phpMyAdmin, I can see all the photos under the
piwigo_images entry. So the pictures are still there. How do I connect to them ?
Or how do I fix the piwigo installation or the database ?
Thanks
Piwigo 2.9.4
Operating system: Linux
PHP: 7.0.2-pl0-gentoo (Show info) [2020-08-18 03:08:01]
MySQL: 5.6.48-88.0-56-log [2020-08-18 03:08:01]
Graphics Library: ImageMagick 6.9.0-3
Offline
The image files are not stored in the database but on disk, for the physical albums ftp-sync method under piwigo/galleries/ and for the virtual albums method under piwigo/upload/
Maybe you wiped those directories before you installed the newer version? Then restore from your backup.
Offline
Ok, got it.
Thanks so much.
I had renamed the old install and had looked in /galleries, but the images are in /upload.
Thanks :-)
Offline
Just for completeness -- images uploaded through the web facilities are in upload; you can also directly place photos under galleries (and then force a synchronization to find them). Both are useful, and you can do both to the same site.
Offline