Web based family history software

If you need to upgrade your PGV installation, then hopefully you will also consider that you can conveniently move to webtrees with our PGV-to-webtrees wizard. It will move ALL your users, news, favorites and family trees to webtrees in a matter of minutes.

Question ERROR 8 problem

  • geroronimo
  • Topic Author
  • Visitor
  • Visitor
10 years 11 months ago #1 by geroronimo
ERROR 8 problem was created by geroronimo
Hi,

I'm trying to migrate my PhpGedView (4.2.4) installation to webtrees (1.4.1), but it stops with the following error:

/hsphere/local/home/geroroni/geroronimo.net/gen/index/config.php => wt_site_setting ...
pgv_site_setting => wt_site_setting ...
pgv_gedcom => wt_gedcom ...
pgv_gedcom_setting => wt_gedcom_setting ...
pgv_user => wt_user ...
pgv_user_setting => wt_user_setting ...
pgv_user_gedcom_setting => wt_user_gedcom_setting ...
Reading configuration file ../gen/./index/audun.ged_conf.php
Reading privacy file ../gen/./index/audun.ged_priv.php

ERROR 8: Undefined variable: NO_UPDATE_CHAN
0 Error occurred on line 716 of file admin_pgv_to_wt.php

Any ideas what is wrong?
I guess a variable NO_UPDATE_CHAN (presumably in audun.ged_priv.php) should be defined, but where and how?
Any help is much appreciated!

Audun

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

More
10 years 11 months ago #2 by kiwi
Replied by kiwi on topic ERROR 8 problem
There is an option somewhere in PGV's configuration (probably the privacy section" with a title something lik "Do not update the ‘last change’ record". Set and save that, then try the wizard again. I'm afraid I can't tell you exactly where in PGV, or the correct name as it's many years since I used PGV.

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

  • geroronimo
  • Topic Author
  • Visitor
  • Visitor
10 years 11 months ago #3 by geroronimo
Replied by geroronimo on topic ERROR 8 problem
Found it under Gedcom configuration -> Edit options -> Do not update the CHAN (Last Change) record
Set and save, and I got further in the wizard (now it hangs at "Genealogy records ...", and I guess I got som cleaning up to do in my Gedcom file - but it's progress!).
Thanks a lot!


Audun

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

More
10 years 11 months ago #4 by kiwi
Replied by kiwi on topic ERROR 8 problem
It might not be hanging. It can take a little while if you have a large database.

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

  • geroronimo
  • Topic Author
  • Visitor
  • Visitor
10 years 11 months ago #5 by geroronimo
Replied by geroronimo on topic ERROR 8 problem
Ah, I'll let it run for the night then, though I suspect my relatively small database (about 1000 records) really needs some cleaning up. When using the automatic gedcom-check in PhpGedView I get a very long list of multimedia object related errors (a few houndred of these: "‎00011081 OBJE @M20@‎ missing ‎0 @M20@ OBJE ‎; see ‎INDI @I2226@‎").


Audun

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

More
10 years 11 months ago #6 by kiwi
Replied by kiwi on topic ERROR 8 problem
:-))

No, I didn't mean that long. Minutes yes, hours, no, not even for a 100,000 person tree!

I doubt its related to those GEDCOM errors either, as they would be transferred as they are, leaving you the opportunity to tidy them up in webtrees.

It sounds to me more like one of your DBs is corrupt. Is PGV working OK?

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

  • geroronimo
  • Topic Author
  • Visitor
  • Visitor
10 years 11 months ago #7 by geroronimo
Replied by geroronimo on topic ERROR 8 problem
PGV is working OK as far as I can see. Any way of checking DB health?

-Audun

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

More
10 years 11 months ago #8 by kiwi
Replied by kiwi on topic ERROR 8 problem
If you have PhpMyAdmin or a similar database tool you can check the DB for errors.

Otherwise, try fixing those errors in PGV and run the wizard again. At least that will eliminate one possible issue.

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

  • geroronimo
  • Topic Author
  • Visitor
  • Visitor
10 years 11 months ago #9 by geroronimo
Replied by geroronimo on topic ERROR 8 problem
I will try that. Thanks for the advice!

Audun

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

More
10 years 10 months ago #10 by HenkK
Replied by HenkK on topic ERROR 8 problem
I also have the problem that the wizard hangs at. "Genealogy records ..."
When I click a link like MyPage, I have to log in again.

How can I enable error messages? I have no idea where to look for the error.

Phpgedview is. 4.2.4 stable
webtrees is 1.4.1
Running under Ubuntu 13.04
Php is 5.4.9-4ubuntu2
Apache 2.2.22 ubuntu

webtrees is 2.1.18
Raspberry Pi with latest OS (Bullseye)
Php is 8.1.25
Apache/2.4.56 (Raspbian)

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

More
10 years 10 months ago - 10 years 10 months ago #11 by fisharebest
Replied by fisharebest on topic ERROR 8 problem

I also have the problem that the wizard hangs at. "Genealogy records ..."


At this stage, webtrees is simply copying data from 5 PGV tables into one webtrees table.

There is little to go wrong......

You could try adding some "echo 'xxx';" statements between the SQL statements to see which one fails. (Line ~1000 of admin_pgv_to_wt.php).

How can I enable error messages?


You enable PHP error messages in your PHP configuration file (e.g. php.ini). You need to look for the "display_errors" setting, and the "error_reporting" settings.

webtrees also logs many errors. Administration -> Logs

When I click a link like MyPage, I have to log in again.


This is normal. The import wizard replaces the current list of user accounts with the user accounts from PGV. The account you used to start the wizard was deleted - hence you must now log in with one of the accounts from PGV.

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net
Last edit: 10 years 10 months ago by fisharebest.

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

More
10 years 10 months ago #12 by HenkK
Replied by HenkK on topic ERROR 8 problem
Thanks for the suggestion, now I do get an error message.

I also compared the tables for PGV and WT and noticed that no fields were copied from PGV to WT

I get the following error message:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`webtrees`.`wt_gedcom_chunk`, CONSTRAINT `wt_gedcom_chunk_ibfk_1` FOREIGN KEY (`gedcom_id`)

Can itbe that I have PGV and webtrees in different folders (different virtual apache servers)? ../genealogie and ../genealogie2
The wizard however does find my PGV installation :

This thread is not an "ERROR 8 problem" Let me know if I should start a new topic

webtrees is 2.1.18
Raspberry Pi with latest OS (Bullseye)
Php is 8.1.25
Apache/2.4.56 (Raspbian)

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

More
10 years 10 months ago #13 by fisharebest
Replied by fisharebest on topic ERROR 8 problem
OK - this error message indicates that your PGV database contains data for an old GEDCOM that no longer exists.

[ Perhaps you once deleted a GEDCOM, but the operation did not complete properly? ]

In particular, one of these tables/columns

pgv_media.m_gedfile
pgv_sources.s_file
pgv_families.f_file
pgv_individuals.i_file
pgv_other.o_file

contains an entry that cannot be found in PGV's list of GEDCOMs.

Are you able to find/delete the erroneous rows?

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

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

More
10 years 10 months ago #14 by fisharebest
Replied by fisharebest on topic ERROR 8 problem
FYI, I've raised a bug report:

bugs.launchpad.net/webtrees/+bug/1181682

I'll try to get this fixed for the next release.

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

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

Powered by Kunena Forum
}