- This topic has 12 replies, 2 voices, and was last updated 8 years, 9 months ago by
.
-
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, CONSTRAINTuu_block_setting_ibfk_1FOREIGN KEY (block_id) REFERENCESuu_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 FROMuu...') #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: 31Aug2023]
Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 - PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis 3.3.12 - PHP Version 8.1.17 - mySQL 8.1 -
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 -
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: 31Aug2023]
Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 - PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis 3.3.12 - PHP Version 8.1.17 - mySQL 8.1 -
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 -
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: 31Aug2023]
Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 - PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis 3.3.12 - PHP Version 8.1.17 - mySQL 8.1 -
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 -
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 http://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 -
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: 31Aug2023]
Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 - PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis 3.3.12 - PHP Version 8.1.17 - mySQL 8.1 -
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 -
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, CONSTRAINTuu_block_setting_ibfk_1FOREIGN KEY (block_id) REFERENCESuu_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 FROMuu...') #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: 31Aug2023]
Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 - PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis 3.3.12 - PHP Version 8.1.17 - mySQL 8.1
- The topic ‘3.0 upgrade’ is closed to new replies.