Search Forums
Forums
Kiwitrees on Twitter
    Tags

    fixing errors, release, Default record, re-order, 3.0.0. setup, kiwitrees 2.0.2, Extra menus, HTML block, IE11, cousins, events of close relatives, responsive menus, BAPM, missing data, multiple marriages, 3.0.0, special character, button, fatal error, validation, session, internal messaging, simpl_grey, flags, batch update, Google Maps, modules, search, googlemap, mysql5.7, link, wish, save settings, Georgian, ID notes, ASSO, contact links, My Page, footer, folder, 3.0.0 widgets, statistics, places, login, image, error, help, relationships, menu, installation, delete, simpl_research, name, notes, webtrees 1.4.4.1, IE problem, favourite, person, 2.0, html

    Topic:   3.0 upgrade  

    This topic contains 12 replies, has 2 voices, and was last updated by kiwi kiwi 2 years, 5 months ago.

    Viewing 13 posts - 1 through 13 (of 13 total)
    • Author
      Posts
    • #4065
      macalter
      macalter
      Participant

      536 posts

      Just got chance to do trial install of 3.0 to directory not active. I removed everything except /data file before installing. Got below error:

      exception ‘PDOException’ with message ‘SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (my family.uu_block_setting, CONSTRAINT uu_block_setting_ibfk_1 FOREIGN KEY (block_id) REFERENCES uu_block (block_id))’ in /home/ftpdir/myfamily.com/kiwitrees/library/WT/DB.php:198 Stack trace: #0 /home/ftpdir/myfamily.com/kiwitrees/library/WT/DB.php(198): PDO->exec(‘DELETE FROM uu...') #1 /home/ftpdir/myfamily.com/kiwitrees/includes/db_schema/db_schema_27_28.php(44): WT_DB::exec('DELETE FROM##…’) #2 /home/ftpdir/myfamily.com/kiwitrees/library/WT/DB.php(258): require(‘/home/ftpdir/m…’) #3 /home/ftpdir/myfamily.com/kiwitrees/includes/session.php(260): WT_DB::updateSchema(‘/home/ftpmyra/a…’, ‘WT_SCHEMA_VERSI…’, 28) #4 /home/ftpdir/myfamily.com/kiwitrees/index.php(26): require(‘/home/ftpmyra/a…’) #5 {main}

      -----
      Kiwitrees:
      "A-D connections 3.3.0 (rev)"
      PHP 5.6.29 Fast CGI

      "The Royals 3.3.0.."
      PHP 7.0 Fast CGI
      mySQL server: 5.1.56
      MacOS: 10.11.6  (El Capitan)
      Browsers (mac): Safari  Version 10.1.1 (11603.2.5);  Firefox 53.0.2
      [updated: 22 May 2017]

      #4066
      kiwi
      kiwi
      Keymaster

      1449 posts

      Ah, interesting. That’s the first time that’s happened. Its a combination I wasn’t expecting.

      Pretty sure I know what is needed. I’ll get back to you tomorrow with a solution.

      As an aside, and more for general information than you specifically- its not actually a good idea to install kiwitrees (or webtrees for that matter) in a new location but still addressing an old database. Especially not if that database is your main one.
      During many upgrades non-reversible changes to the database are made. That is the case this time. It may be fortunate that you had that error, otherwise changes will have been made that would have rendered your main site unusable.

      Nigel

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

      #4068
      macalter
      macalter
      Participant

      536 posts

      The location contained kiwitrees 2.0.1. The database is independent of my active one. Because the upgrade was major, and I knew to error could cost me my site, am doing my trial in this non-active directory. The dB isn’t part of my active site.

      I could alternatively create new dB for this directory if you think the existing one has something in it causing problem.

      -----
      Kiwitrees:
      "A-D connections 3.3.0 (rev)"
      PHP 5.6.29 Fast CGI

      "The Royals 3.3.0.."
      PHP 7.0 Fast CGI
      mySQL server: 5.1.56
      MacOS: 10.11.6  (El Capitan)
      Browsers (mac): Safari  Version 10.1.1 (11603.2.5);  Firefox 53.0.2
      [updated: 22 May 2017]

      #4069
      kiwi
      kiwi
      Keymaster

      1449 posts

      No, don’t do that. It is definitely a bug, nothing caused by your database. It would be more helpful to leave it as it us, so we can be assured a solution does work.

      Nigel

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

      #4070
      macalter
      macalter
      Participant

      536 posts

      No problem.

      PS: your post is 8.20pm but Australia (don’t have clock for NZ) is 6.20. My server in LA is 11.20pm. Where’s the time from?

      -----
      Kiwitrees:
      "A-D connections 3.3.0 (rev)"
      PHP 5.6.29 Fast CGI

      "The Royals 3.3.0.."
      PHP 7.0 Fast CGI
      mySQL server: 5.1.56
      MacOS: 10.11.6  (El Capitan)
      Browsers (mac): Safari  Version 10.1.1 (11603.2.5);  Firefox 53.0.2
      [updated: 22 May 2017]

      #4071
      kiwi
      kiwi
      Keymaster

      1449 posts

      That’s NZ local time, and it’s after 8pm on MONDAY 🙂

      Also worth noting that Australia, like the US has multiple time zones, not just one. NZ however has just one.

      Nigel

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

      #4076
      kiwi
      kiwi
      Keymaster

      1449 posts

      The attached zip folder contains two replacement files:

      1 – db_scheme_28_28.php Place this in the folder /kiwitrees/includes/db_schema/ replacing the existing file of the same name.
      2 – setup.php Place this in the root folder (/kiwitrees/ or whatever name you use)

      Your upgrade should now run correctly.

      IMPORTANT – please ensure you read the upgrading instructions for “Upgrading to kiwitrees 3.0.0” on this site at https://kiwitrees.net/faqs/general/upgrading/ before progressing. This is a complex upgrade, much more so than a ‘normal’ upgrade.

      Once this upgrade works OK, you can also try your fresh installation as well, using these same two new files in that as well.

      Nigel

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

      Attachments:
      #4078
      macalter
      macalter
      Participant

      536 posts

      I have the page for configuring open and saw the complexity hence why I want to do the test install on non-active site.

      Placed the two files as instructed but no change.

      -----
      Kiwitrees:
      "A-D connections 3.3.0 (rev)"
      PHP 5.6.29 Fast CGI

      "The Royals 3.3.0.."
      PHP 7.0 Fast CGI
      mySQL server: 5.1.56
      MacOS: 10.11.6  (El Capitan)
      Browsers (mac): Safari  Version 10.1.1 (11603.2.5);  Firefox 53.0.2
      [updated: 22 May 2017]

      #4079
      kiwi
      kiwi
      Keymaster

      1449 posts

      Placed the two files as instructed but no change.

      Does that mean you still get the error that says:
      “Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails”

      Nigel

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

      #4080
      macalter
      macalter
      Participant

      536 posts

      exception ‘PDOException’ with message ‘SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (my family.uu_block_setting, CONSTRAINT uu_block_setting_ibfk_1 FOREIGN KEY (block_id) REFERENCES uu_block (block_id))’ in /home/ftpmac/family.myserver.com/kiwitrees/library/WT/DB.php:198 Stack trace: #0 /home/ftpmac/family.myserver.com/kiwitrees/library/WT/DB.php(198): PDO->exec(‘DELETE FROM uu...') #1 /home/ftpmac/family.myserver.com/kiwitrees/includes/db_schema/db_schema_27_28.php(44): WT_DB::exec('DELETE FROM##…’) #2 /home/ftpmac/family.myserver.com/kiwitrees/library/WT/DB.php(258): require(‘/home/ftpmyra/a…’) #3 /home/ftpmac/family.myserver.com/kiwitrees/includes/session.php(260): WT_DB::updateSchema(‘/home/ftpmyra/a…’, ‘WT_SCHEMA_VERSI…’, 28) #4 /home/ftpmac/family.myserver.com/kiwitrees/index.php(26): require(‘/home/ftpmyra/a…’) #5 {main}

      -----
      Kiwitrees:
      "A-D connections 3.3.0 (rev)"
      PHP 5.6.29 Fast CGI

      "The Royals 3.3.0.."
      PHP 7.0 Fast CGI
      mySQL server: 5.1.56
      MacOS: 10.11.6  (El Capitan)
      Browsers (mac): Safari  Version 10.1.1 (11603.2.5);  Firefox 53.0.2
      [updated: 22 May 2017]

      #4081
      kiwi
      kiwi
      Keymaster

      1449 posts

      Oh dear – entirely my fault, sorry. No surprise you got the same error. I gave you back copies of the old files instead of the new ones 🙁

      Please try these. Same file locations.

      Nigel

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

      Attachments:
      #4083
      macalter
      macalter
      Participant

      536 posts

      The error is the same (NOTE: the URL is changed to disguise, so don’t worry if I don’t match that exactly)

      exception ‘PDOException’ with message ‘SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (uufamily.uu_block_setting, CONSTRAINT uu_block_setting_ibfk_1 FOREIGN KEY (block_id) REFERENCES uu_block (block_id))’ in /home/ftpfamily/myfamily.woodengems.com/kiwitrees/library/WT/DB.php:198 Stack trace: #0 /home/ftpfamily/myfamily.woodengems.com/kiwitrees/library/WT/DB.php(198): PDO->exec(‘DELETE FROM uu...') #1 /home/ftpfamily/myfamily.woodengems.com/kiwitrees/includes/db_schema/db_schema_27_28.php(44): WT_DB::exec('DELETE FROM##…’) #2 /home/ftpfamily/myfamily.woodengems.com/kiwitrees/library/WT/DB.php(258): require(‘/home/ftpfamily/a…’) #3 /home/ftpfamily/myfamily.woodengems.com/kiwitrees/includes/session.php(260): WT_DB::updateSchema(‘/home/ftpfamily/a…’, ‘WT_SCHEMA_VERSI…’, 28) #4 /home/ftpfamily/myfamily.woodengems.com/kiwitrees/index.php(26): require(‘/home/ftpfamily/a…’) #5 {main}

      -----
      Kiwitrees:
      "A-D connections 3.3.0 (rev)"
      PHP 5.6.29 Fast CGI

      "The Royals 3.3.0.."
      PHP 7.0 Fast CGI
      mySQL server: 5.1.56
      MacOS: 10.11.6  (El Capitan)
      Browsers (mac): Safari  Version 10.1.1 (11603.2.5);  Firefox 53.0.2
      [updated: 22 May 2017]

      #4084
      kiwi
      kiwi
      Keymaster

      1449 posts

      Strange… Those file work perfectly on all my tests.

      Can you send me (offline) an export of these two tables from your database:
      1 – uu_block
      2 – uu_block_setting

      Perhaps you have something in there I’m not testing for.

      Nigel

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

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

    You must be logged in to reply to this topic.