Another GEDCOM Upload Issue

[Nick W]

I currently have a problem uploading GEDCOM files to our site and this may be in some way related to some of the issues faced by others on this forum.

The last GEDCOM I uploaded to our public tree was on 23 Feb. I received the following from our host last week:

We will be upgrading the MySQL version on the shared server euk5.eukhosting.net from MariaDB 10.3 to MariaDB 10.6. This upgrade is scheduled on 23rd, March at 6:00 AM (off business hours).

MariaDB 10.6 Features:
1. Numerous performance improvements for high-concurrency load and performance data structures.
2. Scalability and performance improvements to global data structures.
3. The Information Schema uses much less memory when you select from INFORMATION_SCHEMA.TABLES or any other table with many VARCHAR or TEXT columns.
4. Added various new system variables and SQL syntaxes.
5. Bundled sys_schema, a collection of views, functions, and procedures to help administrators get insight into database usage.

All the user and admin functions appear to be working apart from the GEDCOM upload which I only discovered this morning after upgrading our members area tree to v14. That upgrade appears to have gone well with everything working apart from one mod and the GEDCOM upload, which therefore must be connected with the host’s MySQL upgrade.

I’ve tried (a) uploading to an existing tree and (b) into an empty test tree and neither work. The GEDCOM files do appear in my GEDCOM folder in the c panel and I’ve tried uploading them from there as well, but no success.

There appears to be a mismatch between the versions of php in the control panel.

I would appreciate any help from anyone who might be able to help.

[Ken Roy]

TNG v14 requires at a minimum PHP 7.   You need to change your PHP version from PHP 5.6 to a current PHP version.

13 minutes ago, Nick W said:

All the user and admin functions appear to be working apart from the GEDCOM upload which I only discovered this morning after upgrading our members area tree to v14

You may need to close your browser completely and clear cache to make sure you have the latest TNG js and css files.  The Diagnostic screen should be returning

Edited March 25, 2023 by Ken Roy
fix image

[Nick W]

Thanks Ken,

And so it is on the members tree. I'll upgrade the public tree from 11.1.2 to v14 first before attempting the php change as it seems there is a lot of disparity between the php versions allowed.

Cheers,

Nick

[Nick W]

Public tree now upgraded to v14 and php version changed to 7.4. All seems to be working well now apart from the gedcom upload, which still doesn't work. I don't think this has anything to do with the TNG upgrade since I couldn't upload gedcoms to the public tree prior to upgrade. 

[Ken Roy]

@Nick W

Nick,

Do you have cPanel access as to how PHP is run on your site?  I ask because Import does not work on my site if the PHP Handler is FPM with OPcache.  The PHP caching works for everything but GEDCOM Import that i can tell, so I have to change the PHP Handler to CGI when I want to do an import

Your hosting service might not provide the capability to select the PHP Handler.  Just offering what does not work on my host.

[Nick W]

Hi Ken,

I can only find the attached screenshots from the c-panel and I'm not sure if these are relevant. There doesn't look to be much I can change. Having said that, there isn't any visibility of OPcache anywhere and I don't know what these things were before they did the SQL upgrade.