Search Forums
Forums
Kiwitrees on Twitter
    Tags

    white screen, GEDCOM, family fact, slideshow, 3.0.0. setup, Add a wife, xmas, login upgrade, block, googlemap, illegitimate, 1939 Register, language, cookie, Georgian, login failure, Favourites, upgrade, timeout, cousins, set link, custom, children, new feature, places, album, source, webtrees 1.4.4.1, CREM, latest version, 3.0.0 widgets, edit menu, json, 3.2.1, tree, progress, mystyle, xenea, events of close relatives, library, random_media, session, pop-ups, feedback, help, I18N, message contactform, surname, multiple marriages, Support/Bug Reporting, github, 500, prison, merge, bug reporting, kiwitrees, widget, name, gender change, missing data

    Topic:   Error after 3.3.2 upgrade  

    This topic contains 6 replies, has 3 voices, and was last updated by  Derek 2 months, 3 weeks ago.

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

      Derek
      Participant

      7 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

      jacoline
      Participant

      456 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

      Derek
      Participant

      7 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

      jacoline
      Participant

      456 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

      1643 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

      jacoline
      Participant

      456 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

      Derek
      Participant

      7 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.