Announcement

#1 2020-08-18 09:18:48

dirklanger
Member
2020-08-18
5

Reinstalling Piwigo caused loss of database access

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

 

#2 2020-08-18 12:15:37

erAck
Only trying to help
2015-09-06
2035

Re: Reinstalling Piwigo caused loss of database access

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.


Running Piwigo at https://erack.net/gallery/

Offline

 

#3 2020-08-18 23:01:09

dirklanger
Member
2020-08-18
5

Re: Reinstalling Piwigo caused loss of database access

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

 

#4 2020-09-13 21:00:33

dd-b
Member
Minneapolis, MN USA
2018-04-16
70

Re: Reinstalling Piwigo caused loss of database access

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

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact