Table crashed

[bigalp]

Hi All

looking at individuals seems to throw an error as below which looks like a table crash

Any ideas on how to fix it please? I am not aware of anything that I have changed to cause this

Thanks

Alan Pearce

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: SELECT display, tng_xnotes.note as note, tng_notelinks.eventID as eventID, tng_notelinks.xnoteID as xnoteID, tng_notelinks.ID as ID, noteID FROM tng_notelinks LEFT JOIN tng_xnotes on tng_notelinks.xnoteID = tng_xnotes.ID AND tng_notelinks.gedcom = tng_xnotes.gedcom LEFT JOIN tng_events ON tng_notelinks.eventID = tng_events.eventID LEFT JOIN tng_eventtypes on tng_eventtypes.eventtypeID = tng_events.eventtypeID WHERE tng_notelinks.persfamID="I0013" AND tng_notelinks.gedcom="Pearce" ORDER BY eventdatetr, tng_eventtypes.ordernum, tag, tng_notelinks.ordernum, ID

Table './pearcea_tng/tng_xnotes' is marked as crashed and should be repaired

 

[theKiwi]

Go to your site's cPanel, and in the phpMyAdmin screen you can select your database and then the "crashed" table (you could select all the tables) and Repair that table - see this screen shot

Roger

[bigalp]

Excellent!  Now fixed

Thanks very much Roger

Alan Pearce