Gedcom Import Failure

[mkel2010]

I am trying to import a Gedcom and can't get the import past the first 5 records in the file (there are over 10k). By switching to the Old Style Import, I found the following error:  Kelly-c.ged opened...
Cannot execute query: SELECT medialinkID, mediaID, tng_medialinks.eventID, persfamID, eventtypeID, eventdate, eventplace, info FROM (tng_medialinks,tng_events) WHERE tng_medialinks.gedcom = "tree1" AND tng_medialinks.eventID != "" AND tng_medialinks.eventID = tng_events.eventID

When I don't use the old style import, I get an import of the first 5 records and then nothing. With the above message, there was no import at all.

Can someone assist in either a way to correct whatever the issue is or give me some troubleshooting steps?

[mkel2010]

Initially, I'm trying to set up TNG to run on a Wampserver so that I can experiment with things before uploading to my hosting company. That said, the Gedcom is residing in the gedcom folder within the files for TNG on the Wampserver.

[mkel2010]

I was able to resolve my Gedcom import issues. Briefly, I discovered that the MySQL database would not accept dates that were constructed like "1891-00-00." There are two SQL modes that need to be removed to prevent this from happening. In my case, running on a Wamp Server, I had to Edit the following lines in the MySQL my.ini file:

Original configuration:

# Set the SQL mode to strict
#sql-mode=""
sql-mode="STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER"

New Configuration:

# Set the SQL mode to strict
#sql-mode=""

sql-mode="STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER"

 

I removed NO_ZERO_DATE and NO_ZERO_IN_DATE from the configuration line, saved the file and then restarted the Wamp Server. I then re-ran the import and in completed without error.

In working with Darrin Lythgoe to resolve my issue, I learned that the date data (1891-00-00) is not something that is in a Gedcom, but is data created by TNG during the import process to make an "internal" format of data with only a year in order to add a non-existent month and day.