[tngusers2] Problem with getperson.php - version 7.03

[Henny Savenije]

Sorry forgot to say, repair fixes the corrupt records in a table, of 
course that can be done on a limited scale and sometimes a record is 
beyond reparation.

Basically a corrupt database points to the wrong values. That's why 
you get those errormessages

At 07:46 PM 1/19/2009, you wrote:
>It's a bit more complicated. If you "repair" a table, it will be 
>optimized as well, but not the other way around.
>
>Optimisation takes out empty records and makes the database faster 
>(especially if you have a lot of empty records) Not optimized 
>databases tend to take a lot of processor time. If your provider is 
>smart he has a program which optimizes all databases server wide.
>
>
>At 06:20 PM 1/19/2009, you wrote:
>>Content-Language: en-US
>>Content-Type: multipart/alternative;
>>boundary="_000_4F54435C225E364D95A719044435714E05BD5CCEwinxbeuk01excha_"
>>
>>
>>With regard to Larry's problem, would "Optimise Database" from the 
>>admin menu have done the same thing or is that a completely different function?
>>
>>Regards
>>Roger
>><http://www.mitchellfamilyonline.co.uk>www.mitchellfamilyonline.co.uk
>>
>>
>>
>>
>>From: tngusers2-bounces at lythgoes.net 
>>[mailto:tngusers2-bounces at lythgoes.net] On Behalf Of Larry Majercin
>>Sent: 19 January 2009 08:28
>>To: TNG Users List
>>Subject: Re: [tngusers2] Problem with getperson.php - version 7.03
>>
>>Problem solved.
>>I went to my phpMyAdmin and clicked repair table.  Worked like a charm.
>>
>>FYI... For periodic database maintenance the following link has a 
>>great tip on database maintenance:
>><http://paulstamatiou.com/2006/05/31/how-to-quickie-repair-mysql-tables-in-phpmyadmin>http://paulstamatiou.com/2006/05/31/how-to-quickie-repair-mysql-tables-in-phpmyadmin
>>
>>It recommends "repairing" tables that have an "Overhead value to 
>>optimize the database.
>>
>>Thanks to Henny and Roger for jumping in.
>>
>>Regards,
>>Larry Majercin
>>----------
>>On Sun, Jan 18, 2009 at 11:12 PM, Larry Majercin 
>><<mailto:lmajercin at gmail.com>lmajercin at gmail.com> wrote:
>>New information on my website..
>>
>>I then went to my phpMyAdmin program and when I attempted to browse 
>>the tng_xnotes data file, I received this error message:
>>MySQL said: 
>><http://dev.mysql.com/doc/mysql/en/Error-returns.html>Error! 
>>Filename not specified.
>>
>>#1194 - Table 'tng_xnotes' is marked as crashed and should be repaired
>>
>>
>>
>>
>>No virus found in this incoming message.
>>Checked by AVG - www.avg.com
>>Version: 8.0.233 / Virus Database: 270.10.9/1900 - Release Date: 
>>01/18/09 12:11:00
>>_______________________________________________
>>tngusers2 mailing list
>>tngusers2 at lythgoes.net
>>http://lythgoes.net/mailman/listinfo/tngusers2_lythgoes.net
>
>                  _   _
>                 (o) (o)
>      oOOO----(_)----OOOo---
>Henny (Lee Hae Kang)
>-----------------------------
>http://www.henny-savenije.pe.kr Portal to all my sites
>http://www.hendrick-hamel.henny-savenije.pe.kr (in English) Feel 
>free to discover Korea with Hendrick Hamel (1653-1666)
>http://www.hendrick-hamel.henny-savenije.pe.kr/indexk2.htm In Korean
>http://www.hendrick-hamel.henny-savenije.pe.kr/Dutch In Dutch
>http://www.vos.henny-savenije.pe.kr Frits Vos Article about Witsen 
>and Eibokken and his first Korean-Dutch dictionary
>http://www.cartography.henny-savenije.pe.kr (in English) Korea 
>through Western Cartographic eyes
>http://www.hwasong.henny-savenije.pe.kr Hwasong the fortress in Suwon
>http://www.oldKorea.henny-savenije.pe.kr Old Korea in pictures
>http://www.british.henny-savenije.pe.kr A British encounter in Pusan (1797)
>http://www.genealogy.henny-savenije.pe.kr/ Genealogy
>http://www.henny-savenije.pe.kr/phorum Bulletin board for Korean studies
>
>
>
>
>_______________________________________________
>tngusers2 mailing list
>tngusers2 at lythgoes.net
>http://lythgoes.net/mailman/listinfo/tngusers2_lythgoes.net

                  _   _
                 (o) (o)
      oOOO----(_)----OOOo---
Henny (Lee Hae Kang)
-----------------------------
http://www.henny-savenije.pe.kr Portal to all my sites
http://www.hendrick-hamel.henny-savenije.pe.kr (in English) Feel free 
to discover Korea with Hendrick Hamel (1653-1666)
http://www.hendrick-hamel.henny-savenije.pe.kr/indexk2.htm In Korean
http://www.hendrick-hamel.henny-savenije.pe.kr/Dutch In Dutch
http://www.vos.henny-savenije.pe.kr Frits Vos Article about Witsen 
and Eibokken and his first Korean-Dutch dictionary
http://www.cartography.henny-savenije.pe.kr (in English) Korea 
through Western Cartographic eyes
http://www.hwasong.henny-savenije.pe.kr Hwasong the fortress in Suwon
http://www.oldKorea.henny-savenije.pe.kr Old Korea in pictures
http://www.british.henny-savenije.pe.kr A British encounter in Pusan (1797)
http://www.genealogy.henny-savenije.pe.kr/ Genealogy
http://www.henny-savenije.pe.kr/phorum Bulletin board for Korean studies