Posts

Hi everyone, I’ve just got around to updating from 3.3.1 to 3.3.2 and an error has appeared after uploading the files and then click ‘dashboard > home’.

The error I’m seeing is as follows. Has anyone encountered something similar?

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (djw_kiwitree.kt_block, CONSTRAINT kt_block_ibfk_3 FOREIGN KEY (module_name) REFERENCES kt_module (module_name)) in /home/djw/kt.derekjwhitten.id.au/library/KT/DB.php:193 Stack trace: #0 /home/djw/kt.derekjwhitten.id.au/library/KT/DB.php(193): PDO->exec(‘INSERT IGNORE I…’) #1 /home/djw/kt.derekjwhitten.id.au/includes/db_schema/db_schema_16_17.php(34): KT_DB::exec(‘INSERT IGNORE I…’) #2 /home/djw/kt.derekjwhitten.id.au/library/KT/DB.php(253): require(‘/home/djw/kt.de…’) #3 /home/djw/kt.derekjwhitten.id.au/includes/session.php(276): KT_DB::updateSchema(‘/home/djw/kt.de…’, ‘KT_SCHEMA_VERSI…’, 34) #4 /home/djw/kt.derekjwhitten.id.au/admin.php(26): require(‘/home/djw/kt.de…’) #5 {main}

My personal kiwitrees installation - http://familytree.derekjwhitten.id.au

Just comment out the line 34 in includes/db_schema/db_schema_16_17.php file

I did that and it worked

Regards, Jamie Jaconelli

admin and owner of a user customized version of kiwitrees (contain 3 family trees)

Thanks Jacoline. I have done this and the site is working again. It looks like this line of code is setting some defaults so given it is an established site this shouldn’t be an issue.

Nigel, do you see any issues with us commenting out this line? Is there anything we should be aware of here?

[EDIT]
I spoke to soon…With the upgrade now complete, when I view an individual’s page as a guest it loads fine, but as a logged in user it loads the page title, header and footer but the middle of the page is empty.

Looking at the console in Chrome, I’m seeing the following error as a logged in user. Should WT_GEDCOM be KT_GEDCOM?

I’ve uploaded kiwitrees.js to my server again and the error persists.

Uncaught ReferenceError: WT_GEDCOM is not defined
    at HTMLInputElement.<anonymous> (kiwitrees.js:1477)
    at Function.each (jquery.min.js:2)
    at n.fn.init.each (jquery.min.js:2)
    at autocomplete (kiwitrees.js:1468)
    at individual.php?pid=I458&ged=OurTree:942

My personal kiwitrees installation - http://familytree.derekjwhitten.id.au

I do not think your next problem has something to do with the other issue. Since I can not see any issue as guest you might need help from Nigel 🙂

Regards, Jamie Jaconelli

admin and owner of a user customized version of kiwitrees (contain 3 family trees)

Derek wrote:

Nigel, do you see any issues with us commenting out this line? Is there anything we should be aware of here?

No problem with commenting that out on an established site. It’s mainly for people upgrading directly from a very old version to the latest in one go. I’m not sure of the exact mix of circumstances that triggers the error you (and Jamie) got, but you are the only ones, so clearly quite a limited and one-off issue.

Jamie is right about your other error. Not related to the first.
You are also right. WT_ anything should be changed to KT_. That implies you have a custom page of some sort that you haven’t fixed as per upgrade instructions. Given your description

as a logged in user, it loads the page title, header and footer but the middle of the page is empty.

it might be a custom tab perhaps, or a sidebar element, or a research plugin not part of the standard set? If you can’t find it, send me login details and I’ll take a look.

It’s not an issue in kiwitrees.js. That error message is the result of the error, not the cause, unfortunately.

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

You have a custom theme. Perhabs a mytheme, myfooter, myheader? Where you have wt_ instead of kt_ ?

Regards, Jamie Jaconelli

admin and owner of a user customized version of kiwitrees (contain 3 family trees)

After downloading all the source files, searching for WT_ and finding no results it occurred to me this might be a browser issue.

Looking at the error it was coming from kiwitrees.js, and I think my browser had cached that file. Forcing a full refresh (SHIFT+F5) it has pulled through the latest JS file and the page is loading again.

Thank you both for your comments here.

My personal kiwitrees installation - http://familytree.derekjwhitten.id.au