Search
Forums
Topic Information
ForumSupport for kiwitrees
AuthorDerek
Last activity1 year, 3 months ago
StatusOpen
Replies6
Voices3
ParticipantsDerek, jacoline, kiwi
Actions
Tags

7.0, custom text, folder, updates, kiwitrees 2.0.2, progress, github, contacts, UID, block, advanced, google, configure, feedback, 3.0.0, tags, research, mystyle, SUBM, access level, type, gettext, REFN, road map, getClientIp, kiwitrees theme, logs, 3.1, survey, Default record, 3.3.1, 3.2.3, nickname, bug, custom modules, HTML variables, pop-ups, mobile, research tasks, FAQ, duplicates, administration pages, lists individuals families, CHR, data errors, add_asso_facts, beta, 3.2.0, CREM, emigration, new feature, slideshow, surname, 500, save settings, prison, GEDCOM errors, performance, blocks, notes

Kiwitrees on Twitter

    Topic:   Error after 3.3.2 upgrade  

    This topic contains 6 replies, has 3 voices, and was last updated by Avatar Derek 1 year, 3 months ago.

    Viewing 7 posts - 1 through 7 (of 7 total)
    • Author
      Posts
    • #9939
      Avatar
      Derek
      Participant

      9 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

      #9940
      Avatar
      jacoline
      Participant

      471 posts

      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:
      www.jaconelli.dk/webtrees, www.jaconelli.dk/history, www.familien-johnsen.dk(submenu) and danish support at www.host-siden.dk/sandbox and facebook

      #9941
      Avatar
      Derek
      Participant

      9 posts

      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

      #9942
      Avatar
      jacoline
      Participant

      471 posts

      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:
      www.jaconelli.dk/webtrees, www.jaconelli.dk/history, www.familien-johnsen.dk(submenu) and danish support at www.host-siden.dk/sandbox and facebook

      #9943
      kiwi
      kiwi
      Keymaster

      1716 posts

      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
      #9944
      Avatar
      jacoline
      Participant

      471 posts

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

      Regards,
      Jamie Jaconelli

      admin and owner of:
      www.jaconelli.dk/webtrees, www.jaconelli.dk/history, www.familien-johnsen.dk(submenu) and danish support at www.host-siden.dk/sandbox and facebook

      #9945
      Avatar
      Derek
      Participant

      9 posts

      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

    Viewing 7 posts - 1 through 7 (of 7 total)

    You must be logged in to reply to this topic.