Viewing 10 posts - 11 through 20 (of 21 total)
Author
Posts
  • #13611

    You should have received an email with details. I’ve never done this before but tech support walked me thru. See if link works. I will private email you username and password.

    BTW: There is probably 2 families in the database. A-D INDI starts with “A”.

    -----
    [updated: 30 Nov 2021]
    MacOS: 10.15.7  (Catalina)
    Safari   14.1.2;  Firefox 94.0.2
    PHP 7.4.5 FastCGI; mySQL 5.x

    Alter-Drukarsh connections... 3.3.9 <private>
    The Royals 3.3.9
    The Gerrer Rebbes 3.3.9
    The Kennedys 3.3.9

  • #13612

    You should have received an email with details. I’ve never done this before but tech support walked me thru. See if link works. I will private email you username and password.

    You were too late I’m afraid. I’ve already sorted that out! You can now access the admin trees page again. Leave my Dreamhost access as it is for a day or two, just in case, then you can have them remove it – unless you want to get them to also give me access to the MySQL8 test site?? It woulld certainly help.

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

    The mySQL test site you have access to is full access. More than this. As mentioned, only email is active. Upgrade is “tonight/tomorrow” Nov 16.

    I’ll log out and log in to see if all is well. reply separately with results

    -----
    [updated: 30 Nov 2021]
    MacOS: 10.15.7  (Catalina)
    Safari   14.1.2;  Firefox 94.0.2
    PHP 7.4.5 FastCGI; mySQL 5.x

    Alter-Drukarsh connections... 3.3.9 <private>
    The Royals 3.3.9
    The Gerrer Rebbes 3.3.9
    The Kennedys 3.3.9

  • #13614

    THANK YOU.

    I’ll export a backup. Now, if I want to do the corrections (thousands) offline, what’s the max I can upload? Thought 10mb? Mine is larger, can I zip? Is that size lmited too?

    That was my intention but clicked the upload before the download (backup). I do keep you busy 🙂

    -----
    [updated: 30 Nov 2021]
    MacOS: 10.15.7  (Catalina)
    Safari   14.1.2;  Firefox 94.0.2
    PHP 7.4.5 FastCGI; mySQL 5.x

    Alter-Drukarsh connections... 3.3.9 <private>
    The Royals 3.3.9
    The Gerrer Rebbes 3.3.9
    The Kennedys 3.3.9

  • #13615

    What I fixed was a fault during the import process. The only way to fix it was to delete the temporary upload table in the database. I didn’t try to investigate the precise reason it failed though. It will be a malformed entry in th GEDCOM file though; there’s not much else it could possibly be.

    So I suggest that before you try importing again, zip the GEDCOM file and mail it to me. I can then run some tests and see if the previous fault still exists.

    As for the import itself, your “upload_max_filesize” (you can read this in kiwitrees Administration > Server information ) is a massive 512M. That is, unless Dreamhost have another limit we can’t see, which is not unusual. I have no way to know what that might be.

    All these can be avoided by uploading the file with FTP, rather than through the upload / import options. Then just use Import (instead of Upload), and read the file from the server.

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

    I normally put the file on the server then have it import into kiwitrees. Saves digging through directories.

    I have trial version of GEDitCom II which has a GEDCOM checker. That’s why I didn’t want to do the import, the file had 4 errors I couuldn’t fix and was going look at the GEDCOM for those. Wanted a current file downloaded to computer first (usually do only to server).

    The program efaults to inserting code to identify each record and place (don’t have the tags in front of me). I didn’t know to turn off and it added thousands of lines. Got that fixed so will see if I pass once I fix the PLAC entries inside kiwitrees.

    -----
    [updated: 30 Nov 2021]
    MacOS: 10.15.7  (Catalina)
    Safari   14.1.2;  Firefox 94.0.2
    PHP 7.4.5 FastCGI; mySQL 5.x

    Alter-Drukarsh connections... 3.3.9 <private>
    The Royals 3.3.9
    The Gerrer Rebbes 3.3.9
    The Kennedys 3.3.9

  • #13624

    Similar to previous problem — I added the Kennedys GEDCOM to my A-D site instead of Royals. When I tried to delete, it choked. See it’s still stuck. Not sure I the questionable code caused it (one I found online).

    -----
    [updated: 30 Nov 2021]
    MacOS: 10.15.7  (Catalina)
    Safari   14.1.2;  Firefox 94.0.2
    PHP 7.4.5 FastCGI; mySQL 5.x

    Alter-Drukarsh connections... 3.3.9 <private>
    The Royals 3.3.9
    The Gerrer Rebbes 3.3.9
    The Kennedys 3.3.9

  • #13626

    Similar to previous problem — I added the Kennedys GEDCOM to my A-D site instead of Royals. When I tried to delete, it choked. See it’s still stuck. Not sure I the questionable code caused it (one I found online).

    Yes, that ‘dodgy’ GEDCOM file is the problem. You shouldn’t try to import it unless you can clean it up first.

    To fix the blockage now you need to access the database and delete or empty the table ” _gedcom_chunk”.

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

    Thanks, will do. I in fact have done cleanup. Did you want it for the test sites? Or if you have something, feel free to use.

    -----
    [updated: 30 Nov 2021]
    MacOS: 10.15.7  (Catalina)
    Safari   14.1.2;  Firefox 94.0.2
    PHP 7.4.5 FastCGI; mySQL 5.x

    Alter-Drukarsh connections... 3.3.9 <private>
    The Royals 3.3.9
    The Gerrer Rebbes 3.3.9
    The Kennedys 3.3.9

  • #13628

    1 gedcom_chunk_idPrimary int(11) No None AUTO_INCREMENT Change Change Drop Drop
    2 gedcom_idIndex int(11) No None Change Change Drop Drop
    3 chunk_data mediumblob No None Change Change Drop Drop
    More More
    4 importedIndex tinyint(1) No 0 Change Change Drop Drop

    Action Keyname Type Unique Packed Column Cardinality Collation Null Comment
    Edit Edit Drop Drop PRIMARY BTREE Yes No gedcom_chunk_id 0 A No
    Edit Edit Drop Drop kt_gedcom_chunk_ix1 BTREE No No gedcom_id 0 A No
    imported

    These are what show when I click on kt_gedcom_chunk in PHPAdmin on my host. Which ones do I drop/drop table?

    -----
    [updated: 30 Nov 2021]
    MacOS: 10.15.7  (Catalina)
    Safari   14.1.2;  Firefox 94.0.2
    PHP 7.4.5 FastCGI; mySQL 5.x

    Alter-Drukarsh connections... 3.3.9 <private>
    The Royals 3.3.9
    The Gerrer Rebbes 3.3.9
    The Kennedys 3.3.9

Viewing 10 posts - 11 through 20 (of 21 total)
  • You must be logged in to reply to this topic.