Gallery3 migration to new server not adding photos

[David Jackie Armstrong]

I have recently migrated a large Gallery3 installation to a new server following the guidance at: 

http://codex.galleryproject.org/Gallery3:User_guide:Gallery3:Installing_and_upgrading#Moving_your_installation_to_a_different_server 

and all appeared to go fine. However, when I added a new album it appears on the site as the new album is correctly added to the items table in the database but no folders for the album were created in var and there were no error messages. Also, when I try to add photos to the album, again all seemed to be working but no photos were added and there were no error messages (this was also the case if I manually created the album folder via cpanel).

When I created a new blank Gallery3 installation on the new server it works fine, so does not appear related to any server settings. Any help appreciated as I would like to avoid migrating the files and database entries manually via the cpanel file manager and phpmyadmin as the gallery is heavily customised to look similar to the older gallery2 installation. 

Gallery2 installation: www.thejigasaurus.com

Gallery3 installation on the old server: www.dajavous.com/gallery315/index.php/

Gallery3 installation on the new server: www.oldtoysandgames.com/gallery315/

Thanks,

David Armstrong.

[J.R.]

David,

First we need to know what version of Gallery 3 you are using. The old version of Gallery 3 is version 3.0.9 and it is not compatible with servers running any version of PHP higher than 5.6 (most servers have moved on to PHP 7+... many are now moving to PHP 8+). The most recent version (which works fine with everything expect the very latest version of PHP 8) is  version 3.1.5 and available at :

https://galleryrevival.com/download.php

-- J.R.

--
WHEN USING AN EMAIL PROGRAM to reply to this message, click REPLY TO LIST or REPLY TO ALL so your reply goes out to everyone in the group. If you click REPLY or REPLY TO SENDER Google will *only* send your reply to the original author (not recommended).
 
To post a NEW MESSAGE to the group, send an new email to:
gallery...@googlegroups.com
 
To view or sign in to this group on the web, use this URL:
https://groups.google.com/forum/#!forum/gallery-3-users
---
You received this message because you are subscribed to the Google Groups "Gallery 3 Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gallery-3-use...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/d2d23aa0-4e66-498d-bc92-d6ea39aec205n%40googlegroups.com.

[David Jackie Armstrong]

I am using version 3.1.5 on PHP version 7.4 (in select PHP version in cpanel), with an Apache server. Details reported for server information on cpanel are:

Apache Version
2.4.54
PHP Version
7.3.33
MySQL Version
10.3.35-MariaDB-cll-lve
Architecture
x86_64
Operating System
linux
Perl Version
5.16.3

Thanks for the quick response.

David.

[David Jackie Armstrong]

I managed to diagnose the cause of the error and fix it. I had created two new text fields in the items table:

- g2_summary to display what was description text on the album thumbnails, as in Gallery2, and to split it off from the Gallery2 description text at the request of the client. (The g2_summary field was added to the search index also).

- tag_album was set to album when adding albums, and allowed filtering of custom tag albums (the root tag album, and a custom recent albums tag album) from the albumtree by making changes to the albumtree code, again at the request of the client

The cause of the error of no photos being added (on this new server) was diagnosed by reviewing the log files in the var folder - errors were reported in log files when adding photos as the g2_summary and tag_album fields did not have default values defined in the items table. Setting the default values of both of these fields to NULL removed the error and the customised Gallery3 installation on the new server now seems to be working fine.

My remaining issue is in understanding why this error did not occur on the original server, when these two new fields also did not have default values in the SQL table.

Regards,

David Armstrong.

[J.R.]

David,

Glad you were able to discover what the problem was. Hopefully others can answer your final question, but I have no idea other than the old server was running a version of PHP 5 or earlier and that apparently you were migrating an old Galley 2 installation into the new Gallery v. 3.1.5 (which sometimes causes some odd things to happen).

-- J.R.

To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/1ec06da3-4a6a-4cc7-9df6-0d4c7355865dn%40googlegroups.com.

[David Jackie Armstrong]

Looking more closely at the settings of the two servers, the new server has sql mode set to strict, compared to a blank field value on the original server (in the information_schema sql database). I am pretty sure this caused the error to be reported rather than automatically adjusted when adding a new photo. See:

https://www.euperia.com/wrote/mysql-fix-field-doesnt-default-value/

Regards,

David.