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

    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}

    -----
    [updated: 11 Jun 2021]
    MacOS: 10.15.7  (Catalina)
    Safari   14.0.3;  Firefox 89.0
    PHP 7.4 FastCGI

    Alter-Drukarsh connections... 3.3.8 <private>
    The Royals 3.3.8<royals.rbcsolutions.ca
    >
    The Gerrer Rebbes 3.3.8 <royals.rbcsolutions.ca/index.php?ged=rebbes>

  • #4066

    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

    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.

    -----
    [updated: 11 Jun 2021]
    MacOS: 10.15.7  (Catalina)
    Safari   14.0.3;  Firefox 89.0
    PHP 7.4 FastCGI

    Alter-Drukarsh connections... 3.3.8 <private>
    The Royals 3.3.8<royals.rbcsolutions.ca
    >
    The Gerrer Rebbes 3.3.8 <royals.rbcsolutions.ca/index.php?ged=rebbes>

  • #4069

    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

    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?

    -----
    [updated: 11 Jun 2021]
    MacOS: 10.15.7  (Catalina)
    Safari   14.0.3;  Firefox 89.0
    PHP 7.4 FastCGI

    Alter-Drukarsh connections... 3.3.8 <private>
    The Royals 3.3.8<royals.rbcsolutions.ca
    >
    The Gerrer Rebbes 3.3.8 <royals.rbcsolutions.ca/index.php?ged=rebbes>

  • #4071

    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

    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
  • #4078

    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.

    -----
    [updated: 11 Jun 2021]
    MacOS: 10.15.7  (Catalina)
    Safari   14.0.3;  Firefox 89.0
    PHP 7.4 FastCGI

    Alter-Drukarsh connections... 3.3.8 <private>
    The Royals 3.3.8<royals.rbcsolutions.ca
    >
    The Gerrer Rebbes 3.3.8 <royals.rbcsolutions.ca/index.php?ged=rebbes>

  • #4079

    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

    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}

    -----
    [updated: 11 Jun 2021]
    MacOS: 10.15.7  (Catalina)
    Safari   14.0.3;  Firefox 89.0
    PHP 7.4 FastCGI

    Alter-Drukarsh connections... 3.3.8 <private>
    The Royals 3.3.8<royals.rbcsolutions.ca
    >
    The Gerrer Rebbes 3.3.8 <royals.rbcsolutions.ca/index.php?ged=rebbes>

Viewing 10 posts - 1 through 10 (of 13 total)
  • The topic ‘3.0 upgrade’ is closed to new replies.