Before asking for help please read "How to request help" by clicking on that tab above here.
  • Page:
  • 1

TOPIC:

database crash 2 weeks 1 day ago #1

  • Peaches
  • Peaches's Avatar Topic Author
  • Offline
  • New
  • New
  • Posts: 10
I was working in my database and cleaning up duplicates. After removing them, I noticed the database no longer worked properly. Now when I log in, the database crashes. Has anyone else had this issue?

Please Log in or Create an account to join the conversation.

database crash 2 weeks 1 day ago #2

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 13196
> the database no longer worked properly.
> Now when I log in, the database crashes.

You will need to be a bit more specific.
Do you get an error message?
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

database crash 1 week 11 hours ago #3

  • Peaches
  • Peaches's Avatar Topic Author
  • Offline
  • New
  • New
  • Posts: 10
I just did a search for the duplicate person I wanted to delete. I'm attaching a screenshot, of how my database normally looks and how it looks after the duplicate removal.
Attachments:

Please Log in or Create an account to join the conversation.

database crash 1 week 6 hours ago #4

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 13196
What version of PHP is installed on your server?

Are there any error messages in the webtrees error log (Control panel, website logs)?
Are there any error messages in the webserver (e.g. apache) error logs?
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

database crash 1 week 6 hours ago #5

  • bertkoor
  • bertkoor's Avatar
  • Offline
  • Gold
  • Gold
  • Greetings from Utrecht, Holland
  • Posts: 1934
Just some weeks ago I saw a similar screenprint. If i recall correctly that was a webtrees 1.7 installation on a PHP 7.4 server. That combination won't work.

Going to your main page research.ourfamilies.info/index.php I get an error. Try to sort that out first!
See webtrees.net/faq/500/ for hints...

[edit] Greg beat me to it, sounds like the same hunch.
stamboom.BertKoor.nl runs on webtrees v1.7.13

Please Log in or Create an account to join the conversation.

Last edit: by bertkoor.

database crash 6 days 19 hours ago #6

  • Peaches
  • Peaches's Avatar Topic Author
  • Offline
  • New
  • New
  • Posts: 10
This is the web log from this week.

2020-06-30 02:25:21 error /homepages/24/d224131556/htdocs/OurFamily/db-store/webtrees/app/Individual.php:1157 Trying to access array offset on value of type null
#0 /app/Individual.php:1157 ErrorException("Trying to access array offset on value of type null")
#1 /app/GedcomRecord.php:633 addName('INDI', '@P.N. /@N.N./', [NULL])
#2 /app/GedcomRecord.php:764 getAllNames()
#3 /app/Module/FamilyNavigatorModule.php:195 getFullName()
#4 /app/Module/FamilyNavigatorModule.php:264 getHTML([Individual I2058@1])
#5 /app/Module/FamilyNavigatorModule.php:161 getFamily([Individual I1296@1])
#6 /app/Module/FamilyNavigatorModule.php:92 drawFamily([Family F381@1], 'Family with parents')
#7 /app/Controller/IndividualController.php:387 getSidebarContent()
#8 /individual.php:48 getSideBarContent()
24.192.96.98 Peaches OurFamily.GED
2020-06-30 02:23:07 error /homepages/24/d224131556/htdocs/OurFamily/db-store/webtrees/app/Individual.php:1157 Trying to access array offset on value of type null
#0 /app/Individual.php:1157 ErrorException("Trying to access array offset on value of type null")
#1 /app/GedcomRecord.php:633 addName('INDI', '@P.N. /@N.N./', [NULL])
#2 /app/GedcomRecord.php:764 getAllNames()
#3 /app/Module/FamilyNavigatorModule.php:195 getFullName()
#4 /app/Module/FamilyNavigatorModule.php:264 getHTML([Individual I2058@1])
#5 /app/Module/FamilyNavigatorModule.php:161 getFamily([Individual I1296@1])
#6 /app/Module/FamilyNavigatorModule.php:92 drawFamily([Family F381@1], 'Family with parents')
#7 /app/Controller/IndividualController.php:387 getSidebarContent()
#8 /individual.php:48 getSideBarContent()
24.192.96.98 Peaches OurFamily.GED
2020-06-30 02:23:02 search Type: General
Query: hollis watson 24.192.96.98 Peaches OurFamily.GED
2020-06-30 02:22:20 auth Login: Peaches/Web Master 24.192.96.98 Peaches <none>
2020-06-30 02:15:34 auth Logout: Peaches/Web Master 24.192.96.98 Peaches OurFamily.GED
2020-06-30 02:09:39 config Site preference "LATEST_WT_VERSION_TIMESTAMP" set to "1593482978" 24.192.96.98 Peaches <none>

2020-06-29 03:18:38 error /homepages/24/d224131556/htdocs/OurFamily/db-store/webtrees/app/Individual.php:1157 Trying to access array offset on value of type null
#0 /app/Individual.php:1157 ErrorException("Trying to access array offset on value of type null")
#1 /app/GedcomRecord.php:633 addName('INDI', '@P.N. /@N.N./', [NULL])
#2 /app/GedcomRecord.php:764 getAllNames()
#3 /app/Module/FamilyNavigatorModule.php:195 getFullName()
#4 /app/Module/FamilyNavigatorModule.php:264 getHTML([Individual I2058@1])
#5 /app/Module/FamilyNavigatorModule.php:161 getFamily([Individual I1296@1])
#6 /app/Module/FamilyNavigatorModule.php:92 drawFamily([Family F381@1], 'Family with parents')
#7 /app/Controller/IndividualController.php:387 getSidebarContent()
#8 /individual.php:48 getSideBarContent()
24.192.96.98 Peaches OurFamily.GED
2020-06-29 03:18:34 search Type: General
Query: delaware watson 24.192.96.98 Peaches OurFamily.GED
2020-06-29 03:18:33 error /homepages/24/d224131556/htdocs/OurFamily/db-store/webtrees/app/Individual.php:1157 Trying to access array offset on value of type null
#0 /app/Individual.php:1157 ErrorException("Trying to access array offset on value of type null")
#1 /app/GedcomRecord.php:633 addName('INDI', '@P.N. /@N.N./', [NULL])
#2 /app/GedcomRecord.php:764 getAllNames()
#3 /app/Module/FamilyNavigatorModule.php:195 getFullName()
#4 /app/Module/FamilyNavigatorModule.php:264 getHTML([Individual I2058@1])
#5 /app/Module/FamilyNavigatorModule.php:161 getFamily([Individual I1296@1])
#6 /app/Module/FamilyNavigatorModule.php:92 drawFamily([Family F381@1], 'Family with parents')
#7 /app/Controller/IndividualController.php:387 getSidebarContent()
#8 /individual.php:48 getSideBarContent()
24.192.96.98 Peaches OurFamily.GED
2020-06-29 03:18:28 error /homepages/24/d224131556/htdocs/OurFamily/db-store/webtrees/app/Individual.php:1157 Trying to access array offset on value of type null
#0 /app/Individual.php:1157 ErrorException("Trying to access array offset on value of type null")
#1 /app/GedcomRecord.php:633 addName('INDI', '@P.N. /@N.N./', [NULL])
#2 /app/GedcomRecord.php:764 getAllNames()
#3 /app/Theme/AbstractTheme.php:792 getFullName()
#4 /app/Functions/FunctionsPrint.php:64 individualBox([Individual I2058@1])
#5 /app/Functions/FunctionsCharts.php:343 printPedigreePerson([Individual I2058@1], 1)
#6 /family.php:77 printFamilyChildren([Family F609@1])
24.192.96.98 Peaches OurFamily.GED
2020-06-29 03:18:27 error /homepages/24/d224131556/htdocs/OurFamily/db-store/webtrees/app/Individual.php:1157 Trying to access array offset on value of type null
#0 /app/Individual.php:1157 ErrorException("Trying to access array offset on value of type null")
#1 /app/GedcomRecord.php:633 addName('INDI', '@P.N. /@N.N./', [NULL])
#2 /app/GedcomRecord.php:764 getAllNames()
#3 /app/Module/FamilyNavigatorModule.php:195 getFullName()
#4 /app/Module/FamilyNavigatorModule.php:264 getHTML([Individual I2058@1])
#5 /app/Module/FamilyNavigatorModule.php:161 getFamily([Individual I1296@1])
#6 /app/Module/FamilyNavigatorModule.php:100 drawFamily([Family F381@1], 'Family with <span class="NAME"…')
#7 /app/Controller/IndividualController.php:387 getSidebarContent()
#8 /individual.php:48 getSideBarContent()
24.192.96.98 Peaches OurFamily.GED
2020-06-29 03:18:22 error /homepages/24/d224131556/htdocs/OurFamily/db-store/webtrees/app/Individual.php:1157 Trying to access array offset on value of type null
#0 /app/Individual.php:1157 ErrorException("Trying to access array offset on value of type null")
#1 /app/GedcomRecord.php:633 addName('INDI', '@P.N. /@N.N./', [NULL])
#2 /app/GedcomRecord.php:764 getAllNames()
#3 /app/Module/FamilyNavigatorModule.php:195 getFullName()
#4 /app/Module/FamilyNavigatorModule.php:264 getHTML([Individual I2058@1])
#5 /app/Module/FamilyNavigatorModule.php:161 getFamily([Individual I1296@1])
#6 /app/Module/FamilyNavigatorModule.php:92 drawFamily([Family F381@1], 'Family with parents')
#7 /app/Controller/IndividualController.php:387 getSidebarContent()
#8 /individual.php:48 getSideBarContent()
24.192.96.98 Peaches OurFamily.GED
2020-06-29 03:18:17 error /homepages/24/d224131556/htdocs/OurFamily/db-store/webtrees/app/Individual.php:1157 Trying to access array offset on value of type null
#0 /app/Individual.php:1157 ErrorException("Trying to access array offset on value of type null")
#1 /app/GedcomRecord.php:633 addName('INDI', '@P.N. /@N.N./', [NULL])
#2 /app/GedcomRecord.php:764 getAllNames()
#3 /app/Module/FamilyNavigatorModule.php:195 getFullName()
#4 /app/Module/FamilyNavigatorModule.php:264 getHTML([Individual I2058@1])
#5 /app/Module/FamilyNavigatorModule.php:161 getFamily([Individual I1296@1])
#6 /app/Module/FamilyNavigatorModule.php:92 drawFamily([Family F381@1], 'Family with parents')
#7 /app/Controller/IndividualController.php:387 getSidebarContent()
#8 /individual.php:48 getSideBarContent()

This is from two weeks ago:

2020-06-03 18:23:19 search Type: General
Query: yvette milner 24.192.96.98 Peaches OurFamily.GED
2020-06-03 18:23:12 error /homepages/24/d224131556/htdocs/OurFamily/db-store/webtrees/app/Individual.php:1157 Trying to access array offset on value of type null
#0 /app/Individual.php:1157 ErrorException("Trying to access array offset on value of type null")
#1 /app/GedcomRecord.php:633 addName('INDI', '@P.N. /@N.N./', [NULL])
#2 /app/GedcomRecord.php:780 getAllNames()
#3 /app/Functions/FunctionsPrintLists.php:1695 getSortName()
#4 /app/Module/OnThisDayModule.php:90 eventsTable(2459004, 2459004, 'BIRT MARR', '1', 'alpha')
#5 /index.php:70 getBlock(165)
24.192.96.98 Peaches OurFamily.GED
2020-06-03 18:23:08 error /homepages/24/d224131556/htdocs/OurFamily/db-store/webtrees/app/Individual.php:1157 Trying to access array offset on value of type null
#0 /app/Individual.php:1157 ErrorException("Trying to access array offset on value of type null")
#1 /app/GedcomRecord.php:633 addName('INDI', '@P.N. /@N.N./', [NULL])
#2 /app/GedcomRecord.php:764 getAllNames()
#3 /app/Module/FamilyNavigatorModule.php:170 getFullName()
#4 /app/Module/FamilyNavigatorModule.php:92 drawFamily([Family F269@1], 'Family with parents')
#5 /app/Controller/IndividualController.php:387 getSidebarContent()
#6 /individual.php:48 getSideBarContent()
24.192.96.98 Peaches OurFamily.GED
2020-06-03 18:23:07 search Type: General
Query: yvonne baldwin 24.192.96.98 Peaches OurFamily.GED
2020-06-03 18:22:52 error /homepages/24/d224131556/htdocs/OurFamily/db-store/webtrees/app/Individual.php:1157 Trying to access array offset on value of type null
#0 /app/Individual.php:1157 ErrorException("Trying to access array offset on value of type null")
#1 /app/GedcomRecord.php:633 addName('INDI', '@P.N. /@N.N./', [NULL])
#2 /app/GedcomRecord.php:780 getAllNames()
#3 /app/Functions/FunctionsPrintLists.php:1695 getSortName()
#4 /app/Module/OnThisDayModule.php:90 eventsTable(2459004, 2459004, 'BIRT MARR', '1', 'alpha')
#5 /index.php:70 getBlock(165)
24.192.96.98 Peaches OurFamily.GED
2020-06-03 18:22:30 error /homepages/24/d224131556/htdocs/OurFamily/db-store/webtrees/app/Individual.php:1157 Trying to access array offset on value of type null
#0 /app/Individual.php:1157 ErrorException("Trying to access array offset on value of type null")
#1 /app/GedcomRecord.php:633 addName('INDI', '@P.N. /@N.N./', [NULL])
#2 /app/GedcomRecord.php:764 getAllNames()
#3 /app/Module/ReviewChangesModule.php:132 getFullName()
#4 /index.php:110 getBlock(162)
24.192.96.98 Peaches OurFamily.GED
2020-06-03 18:22:30 config Site preference "LAST_CHANGE_EMAIL" set to "1591208550" 24.192.96.98 Peaches OurFamily.GED

Please Log in or Create an account to join the conversation.

Last edit: by Peaches.

database crash 6 days 19 hours ago #7

  • Peaches
  • Peaches's Avatar Topic Author
  • Offline
  • New
  • New
  • Posts: 10
PHP 7.4.7

Please Log in or Create an account to join the conversation.

database crash 6 days 19 hours ago #8

  • Peaches
  • Peaches's Avatar Topic Author
  • Offline
  • New
  • New
  • Posts: 10
I'm not sure what the address you gave; it is unfamiliar. My webtree database is research.ourfamilylegacies.info/login.php?url=index.php%3F

Please Log in or Create an account to join the conversation.

Last edit: by Peaches. Reason: typo
Do you need a web hosting solution for your webtrees site?
If you prefer a host that specialises in webtrees, the following page lists some suppliers able to provide one for you: 

database crash 6 days 18 hours ago #9

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 13196
You are using webtrees 1.7

> PHP 7.4.7

webtrees 1.7 requires PHP 5.3 -> 7.3

You need to either select a lower version of PHP, or a later version of webtrees.

The error messages above are a consequence of using PHP 7.4 with webtrees 1.7
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

database crash 6 days 18 hours ago #10

  • Peaches
  • Peaches's Avatar Topic Author
  • Offline
  • New
  • New
  • Posts: 10
I'd rather upgrade to a newer version of webtrees but I also get an error message regarding a zip file. How can I overcome this?

•Unzip webtrees-1.7.17.zip to a temporary folder…
An error occurred when unzipping the file.
PCLZIP_ERR_BAD_FORMAT (-10) : Unable to find End of Central Dir Record signature

Please Log in or Create an account to join the conversation.

database crash 6 days 17 hours ago #11

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 13196
> PCLZIP_ERR_BAD_FORMAT (-10) : Unable to find End of Central Dir Record signature

webtrees fetches updates from another server, which changed its HTTP header configuration.

See webtrees.net/faq/upgrade-pclzip/
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

database crash 6 days 16 hours ago #12

  • Peaches
  • Peaches's Avatar Topic Author
  • Offline
  • New
  • New
  • Posts: 10
thank you

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Powered by Kunena Forum