Posts

DataTables warning: table id=change_list – Ajax error. For more information about this error, please see http://datatables.net/tn/7

 

Thought I’d submit both types o errors as they’re both in Admin.

Not sure if first is related to my attempt to run Facts and Events > Custom Fact > Type: Common ancestor (or any other type of custom fact) and no results.

Second (above) is doing housekepping  of logs for previous year(s). Accepted would not delete to 31 Dec 2021

----- [updated: 31Aug2023]

 Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 -  PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis  3.3.12 -  PHP Version 8.1.17 - mySQL 8.1

A couple of questions before I look at this…

1. Did your selection (filtering) include anything apart from the date and “accepted” fields? Just so I can replicate the issue.
2. Which of your sites is this on?
3. Are you aware that on the INDI pages there is a “Changes” tab (if you have it enabled) that displays the recorded changes for that individual. If you tidy up this data table you will lose the data the tab uses. Just a thought. Your choice between any value the tab might have and the benefits of down-sizing the data storage.

Nigel
My personal kiwitrees site is www.our-families.info

1. DATE only
2. A-D site; your account active
3. Changes tab — never used it,

----- [updated: 31Aug2023]

 Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 -  PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis  3.3.12 -  PHP Version 8.1.17 - mySQL 8.1

DataTables warning: table id=change_list – Ajax error. For more information about this error, please see http://datatables.net/tn/7

 

The error you saw generally points to a corrupt record in your data.

I tried deleting some of the earliest few days of records you have, and they all deleted OK.

I’d prefer not to be the one deleting your data though 🙂

I recommend you delete in blocks until you find and narrow down the item in question. If you can identify a single record, or at least a small block of them you can show me the page (before you click “delete”, so I can tell if there are any obvious and fixable issues. Otherwise, delete them manually from the database (“xx_changes” table)

Nigel
My personal kiwitrees site is www.our-families.info

I did backup and ran offline GEDitCOM. Will review errors.

----- [updated: 31Aug2023]

 Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 -  PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis  3.3.12 -  PHP Version 8.1.17 - mySQL 8.1

That wont help. I was only referring to errors in the changes log table in the database. Not errors in the actual current GEDCOM data.

Nigel
My personal kiwitrees site is www.our-families.info

Can’t display anything in Changes Log > Accepted. Only shows the error.

----- [updated: 31Aug2023]

 Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 -  PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis  3.3.12 -  PHP Version 8.1.17 - mySQL 8.1

Odd. It worked fine for me. I set dates by leaving “from” at its default and setting “to” date as just a couple of days later.

You haven’t tried with the month/day figures transposed in error?

Nigel
My personal kiwitrees site is www.our-families.info

wiLl try again shortly.

Found some bad GEDCOM I’m fixing. Interesting offline program FTanalyzer.app. It choked trying to display the code (too long) but did provide the errors. Want to inish and run backup again.

----- [updated: 31Aug2023]

 Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 -  PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis  3.3.12 -  PHP Version 8.1.17 - mySQL 8.1

I’m back — found quite a few dirty GEDCOM bits. All clean.

2019-10-04 TO 2020-10-04 ERROR
DataTables warning: table id=change_list – Ajax error. For more information about this error, please see http://datatables.net/tn/7

Running in increments but have mouse issues so taking bit longer

----- [updated: 31Aug2023]

 Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 -  PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis  3.3.12 -  PHP Version 8.1.17 - mySQL 8.1