JEM Genealogy Ornes Moore Motley Echols Edwards Fackler Parsons Reynolds Smith Brown Bruce Munger Beer Kern Viele Nims Baker Bondurant Von Krogh Magnus Munthe and others
Burgess --"Mayor of Truro" (English member of Parliament)
1 (0%)
1 (100%)
0
0
1575
1575
An error has occurred in the TNG software. What to do:
If you just installed an upgrade, you might have skipped part of the installation instructions. Go back to the upgrade readme page reread the instructions. Pay special attention to the database structure step.
If you just installed TNG for the first time, you might still need to create the database tables. Return to the readme.html page to find that step.
If you are the site owner, you may contact TNG support for further assistance with this problem. Please copy the query below and paste it into your message.
Query: SELECT lastname, YEAR( deathdatetr ) - YEAR( birthdatetr )
AS yearsold, DAYOFYEAR( deathdatetr ) - DAYOFYEAR( birthdatetr ) AS daysold,
IF(DAYOFYEAR(deathdatetr) and DAYOFYEAR(birthdatetr),TO_DAYS(deathdatetr) - TO_DAYS(birthdatetr),(YEAR(deathdatetr) - YEAR(birthdatetr)) * 365) as totaldays
FROM tng_people
WHERE lastname = "Burgess --"Mayor of Truro" (English member of Parliament)"
AND birthdatetr != '0000-00-00' AND deathdatetr != '0000-00-00'
AND birthdate not like 'AFT%' AND deathdate not like 'AFT%'
AND birthdate not like 'BEF%' AND deathdate not like 'BEF%'
AND birthdate not like 'ABT%' AND deathdate not like 'ABT%'
AND birthdate not like 'BET%' AND deathdate not like 'BET%'
AND birthdate not like 'CAL%' AND deathdate not like 'CAL%'
ORDER BY totaldays DESC
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Mayor of Truro" (English member of Parliament)"
AND birthdatetr != '0000-00-00' at line 5
Expand Filter
Collapse Filter