Importing Gedcom

[Willem van Osnabrugge]

My TNG software has worked properly for many years and shows well.

However, since mid January (2024) I am not able to import gedcoms anymore. Even when I first upload them to the gecom folder and then import. The screen just says Opening xxxx.ged.
The file size is only 6MB.

My TNG version is 11.11.2
From the Diagnostic page: 
Diagnostics: all boxes are Green ticked.
PHP 7.4.33
File upload: Permitted
My SQL version: My SQL mysind 7.4.33 (client)
MySQL 5.5.5-10.6.16-MariaDB-cll-lve (server)
Webserver: Apache
File/Folder Permission: Key folders are all read/write
 Configuration files are all read/write

On importing in the Old Style it gave the following error message:
1-23-24.ged opened...
An error has occurred in the TNG software. This could be due to a setup issue, an incomplete upgrade or a program bug. If you are the site owner, you may contact TNG support for help with this problem. Please copy the query below and paste it into your message.

Query: INSERT INTO tng_saveimport (filename, icount, ioffset, fcount, foffset, scount, soffset, mcount, pcount, ncount, noffset, roffset, offset, delvar, ucaselast, norecalc, neweronly, media, gedcom, branch) VALUES("/home/p9rwpklyxiqt/public_html/vanosnabrugge.org/genealogy/gedcom-folder/1-23-24.ged", 0, "0", 0, "0", 0, "0", 0, 0, 0, "0", "0", 0, "match", 0, 1, 1, 1, "tree1", "")

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'offset, delvar, ucaselast, norecalc, neweronly, media, gedcom, branch) VALUE...' at line 1

Can anybody please help me to solve this?

 

 

 

[ADC]

I don't know if this is going to help, but you state your TNG version is 11.11.2. I think this is maybe a typo and you mean 11.1.2.

The maximum PHP version for 11.1.2 is PHP 7.2, but you state you are using PHP 7.4.33

I wonder if your PHP version updated itself recently and now you have a mismatch? You can find the permitted versions here: https://tng.lythgoes.net/wiki/index.php/TNG_versions

It might be an idea to contact TNG support as advised in the error message. I don't believe Darrin reads these forums.

[willemvano]

Thank you. That is vavuable information. Yes, that was a typo. Iy is indeed 11.1.2.