- This topic has 6 replies, 3 voices, and was last updated 5 years, 10 months ago by
Derek.
-
30th January 2018 at 6:32 pm #9939
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
, CONSTRAINTkt_block_ibfk_3
FOREIGN KEY (module_name
) REFERENCESkt_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
-
30th January 2018 at 9:49 pm #9940
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)
-
31st January 2018 at 12:18 am #9941
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
-
31st January 2018 at 1:40 am #9942
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)
-
31st January 2018 at 7:33 am #9943
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 descriptionas 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 -
31st January 2018 at 3:53 pm #9944
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)
-
31st January 2018 at 8:58 pm #9945
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
- The topic ‘Error after 3.3.2 upgrade’ is closed to new replies.