Det har oppstått en feil i TNG programvaren. Hva du kan gjøre:

Hvis du nettopp har installert en oppgradering, har du kanskje hoppet over et punkt i installasjonsinstruksjonene. Vær spesielt oppmerksom på punktet som gjelder oppdatering av databasestruktur.

Hvis du nettopp har installert TNG for første gang, kan det hende du fremdeles må opprette databasetabellene. Gå tilbake til readme.html siden for å finne det punktet.

Hvis du er nettstedets eier, kan du kontakte TNG kundestøtte for videre assistanse med dette problemet. Kopier spørringen nedenfor og lim den inn i meldingen til kundestøtte.



Spørring: SELECT familyID, h.personID AS HusbandPersonID, h.lastname AS Lastname1, h.firstname AS Firstname1, h.birthdate as birthdate1, h.birthplace as birthplace1, h.deathdate as deathdate1, h.deathplace as deathplace1, w.personID AS WifePersonID, w.lastname AS Lastname2, w.firstname AS Firstname2, w.birthdate, w.birthplace, w.deathdate, w.deathplace FROM tng_families AS f LEFT JOIN tng_people AS h ON f.husband = h.personID LEFT JOIN tng_people AS w ON f.wife = w.personID WHERE ( h.birthplace LIKE "%kanaal%" OR w.birthplace LIKE "%kanaal%" ) OR ( h.birthplace LIKE "%mond, %Drenthe" OR w.birthplace LIKE "%mond, %Drenthe" ) OR ( h.deathplace LIKE "%kanaal%" OR w.deathplace LIKE "%kanaal%" ) OR ( h.deathplace LIKE "%mond, %Drenthe" OR w.deathplace LIKE "%mond, Drenthe%" ) OR ( h.altbirthplace LIKE "%kanaal%" OR w.altbirthplace LIKE "%kanaal%" ) OR ( h.altbirthplace LIKE "%mond, %Drenthe" OR w.altbirthplace LIKE "%mond, %Drenthe" ) OR ( h.burialplace LIKE "%kanaal%" OR w.burialplace LIKE "%kanaal%" ) OR ( h.burialplace LIKE "%mond, %Drenthe" OR w.burialplace LIKE "%mond, %Drenthe" ) OR ( h.birthplace LIKE "%Nieuw-Buinen%" OR w.birthplace LIKE "%Nieuw-Buinen%" ) OR ( h.deathplace LIKE "%Nieuw-Buinen%" OR w.deathplace LIKE "%Nieuw-Buinen%" ) OR ( h.birthplace LIKE "%Ter Apel%" OR w.birthplace LIKE "%Ter Apel%" ) OR ( h.deathplace LIKE "%Ter Apel%" OR w.deathplace LIKE "%Ter Apel%" ) OR ( h.birthplace LIKE "%Veendam%" OR w.birthplace LIKE "%Veendam%" ) OR ( h.deathplace LIKE "%Veendam%" OR w.deathplace LIKE "%Veendam%" ) OR ( h.birthplace LIKE "%Wildervank%" OR w.birthplace LIKE "%Wildervank%" ) OR ( h.deathplace LIKE "%Wildervank%" OR w.deathplace LIKE "%Wildervank%" ) OR ( h.birthplace LIKE "%Pekela%" OR w.birthplace LIKE "%Pekela%" ) OR ( h.deathplace LIKE "%Pekela%" OR w.deathplace LIKE "%Pekela%" ) OR ( h.birthplace LIKE "%Horsten%" OR w.birthplace LIKE "%Horsten%" ) OR ( h.deathplace LIKE "%Horsten%" OR w.deathplace LIKE "%Horsten%" ) ORDER BY h.lastname, h.firstname, h.personID, w.firstname, w.lastname, w.personID LIMIT 50

The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay