Posts

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: 31Aug2023]

 Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 -  PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis  3.3.12 -  PHP Version 8.1.17 - mySQL 8.1

macalter wrote:

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

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: 31Aug2023]

 Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 -  PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis  3.3.12 -  PHP Version 8.1.17 - mySQL 8.1

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: 31Aug2023]

 Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 -  PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis  3.3.12 -  PHP Version 8.1.17 - mySQL 8.1

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

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: 31Aug2023]

 Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 -  PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis  3.3.12 -  PHP Version 8.1.17 - mySQL 8.1

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: 31Aug2023]

 Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 -  PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis  3.3.12 -  PHP Version 8.1.17 - mySQL 8.1

macalter wrote:

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

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: 31Aug2023]

 Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 -  PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis  3.3.12 -  PHP Version 8.1.17 - mySQL 8.1

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: 31Aug2023]

 Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 -  PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis  3.3.12 -  PHP Version 8.1.17 - mySQL 8.1