database refresh bug

I'm using Zenphoto version [10988] since about 7 years
Today I attempted to "refresh the database" because all of my images type MP4 add disapeared when viewing the pages of my web site
Then I went directly in the "media_images" table with phpmyadmin and discovered that indeed all of the records whose filename finished by .MP4 have disapeared and only the .jpg or .png are still there
Then I went directly with Fillezilla in the albums' directories on my server and surprizingly all the MP4 files are still there
Also, if I try to upload a new MP4, i.e. with the administration tool, it seems to do the job, but on closure a flash msg appears 1/2 sec to announce the upload did not work. Indeed no new video appears in the album. Doing the same with a jpg file works perfectly
Where is the bug?
Do I need to upgrade ? Is there any risk in such case to loose other images?
Or is there any way to rebuild correctly the table 'images' in the database ?


  • acrylian Administrator
    Do I need to upgrade ?
    It is your decision not to upgrade with all consequences. We only support the current version ( is nearly five years old!). So even if there was a bug you will not get a fix without upgrading.

    It is recommended to frequently upgrade as with any other system because if you update now you most likely will have to do some work especially if you are using third party plugins or themes or your own custom created ones. Not to speak of all the security fixes you missed the last five years. Furthermore your install will most likely break once your server will be upgraded to PHP7.

    But to your actual problem: Zenphoto does support mp4 and other non image types only via plugins. For mp4 you would need the class-video plugin and some mediaplayer plugin to use them. Zenphoto is file system based so it reads everything that is the /albums folder. So what you need to do is:
    • Check if they are really present in your albums within the `/albums` folder
    • Check if the plugins mentioned are for unknown reasons are disabled and re-enable them. Afterwards they should re-appear again. Naturally they are then considered "new" so you will have to re-order and re-enter titles and descriptions if you had them before (This is also why it is a good idea to have backups of the database).
    • If that all doesn't help review your server error logs.
    • Consider to upgrade.
Sign In or Register to comment.