Question PGV transfer wizard
- thornton
- Topic Author
- Offline
- New Member
When I go to the Data and GEDCOM administration window, I no longer see an option to transfer from PGV. Is this a one time option?
thornton
webtrees 2.1.16
PHP 5.4.24, Apache 2.2.26 MySQL 5.5.36
Website - www.frf.com/wt_2.1.16
Please Log in or Create an account to join the conversation.
- rick
- Visitor
Yes, once the database has been filled and you copied the config.ini.php to the data folder, the import option is not available anymore. To have a new session, you could delete the database table and remove the config.ini.php file. Go to the website of webtrees and you can reinstall the software again, including the import of PGV.
The path should be something like :
/var/www/web1/web where in the last web folder, the main files are located of PGV.
Rick.
Please Log in or Create an account to join the conversation.
- ToyGuy
- Offline
- Moderator
- Live like it's Christmas every day - Santa Stephen
The short answer is NO - the two user tables are not really compatible as they have been split, but yours is the first we've heard of any user transfer table issues. I would suggest you simply trash the webtrees installation and start over. It goes pretty fast - even my 5 GEDCOM 85,000 INDI files transfers in less than 5 minutes.
I've done the setup remotely and locally, perhaps a dozen or so times, and never had this issue, although I did have one problem with one user being wiped. I simply used the new user feature and reentered this person. I have yet to do a new wizard transfer since there have been several improvements, but intend to do so later today to spot any remaining issues.
Santa Stephen the Fabled Santa
Latest webtrees at MyArnolds.com
Hosted by webtreesonline.com , a division of GeneHosts LLC
MacOS 10.6.8, Apache 2.2+, PHP 5.4.16, MySQL 5.5.28
Please Log in or Create an account to join the conversation.
- kiwi
- Offline
- Platinum Member
As Rick said, it is a once-only feature, though not related to the config.ini.php file. Once you have populated the tables with data from a GEDCOM import it would be wrong to over-write it with PGV data.
Unfortunately the users table is not a straightforward one to transfer as there are differences between PGV and WT. I would recommend you delete your imported GEDCOM file, and (using PhpMyAdmin or whatever 'back-end' tool your web host provides) empty all the WT tables. This will make the transfer wizard once again available.
Then using Rick's suggestion try again with a different address for your PGV path, as I'm sure thats all the problem was.
A couple of other comments:
That is probably not correct. What about all your GEDCOM config and privacy settings? The webtrees defaults are quite different from PGV's and stored in the DB not a file, so you will have a lot of re-configuring to do.The only reason I want to transfer my PGV installation is to get the User table.
Thats fine, but note that webtrees does NOT automatically synchronise changes made during use into your GEDCOM file. You will need to "export" your data to create a new GEDCOM file before using it off-line.I upload my GEDCOM regularly
Nigel
www.our-families.info
Please Log in or Create an account to join the conversation.
- thornton
- Topic Author
- Offline
- New Member
Thank you for the response. I'll probably do as you suggest and restart. If I understand correctly, I should delete and recreate the database, delete the config.ini.php file and then restart. I obviously didn't have the correct address for my PGV database. So I'll try Rick's suggest path.
I looked at the user tables for both installations and realized that there was too many differences to be able to export/import.
Thanks again for the help.
Thornton
webtrees 2.1.16
PHP 5.4.24, Apache 2.2.26 MySQL 5.5.36
Website - www.frf.com/wt_2.1.16
Please Log in or Create an account to join the conversation.
- ToyGuy
- Offline
- Moderator
- Live like it's Christmas every day - Santa Stephen
And on my MACs,
/Library/WebServer/Documents/genealogy/PGV-423
Please note above in your first posting that you misspelled Library. This feature would be easier if there was a browse function - something we're looking into - as the path has to be exact and can be quite complicated.
-Stephen
Santa Stephen the Fabled Santa
Latest webtrees at MyArnolds.com
Hosted by webtreesonline.com , a division of GeneHosts LLC
MacOS 10.6.8, Apache 2.2+, PHP 5.4.16, MySQL 5.5.28
Please Log in or Create an account to join the conversation.
- thornton
- Topic Author
- Offline
- New Member
The PhpGedView database configuration settings are bad: exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'frfcom_ftree.pgv_user_setting' doesn't exist' in /home3/frfcom/public_html/webtrees/includes/classes/class_wt_db.php:352 Stack trace: #0 /home3/frfcom/public_html/webtrees/includes/classes/class_wt_db.php(352): PDOStatement->execute(Array) #1 [internal function]: WT_DBStatement->__call(Array, Array) #2 /home3/frfcom/public_html/webtrees/pgv_to_wt.php(99): WT_DBStatement->execute('execute', Array) #3 {main}
Any suggestions?
Thornton
webtrees 2.1.16
PHP 5.4.24, Apache 2.2.26 MySQL 5.5.36
Website - www.frf.com/wt_2.1.16
Please Log in or Create an account to join the conversation.
- kiwi
- Offline
- Platinum Member
webtrees.net/forums/2-open-discussion/23...rees-transfer-wizard
Its a problem we've seen before, but thought was fixed. Most likely cause is a mis-match between users in your pgv_users table and the pgv_user_setting.
Can you confirm what build of webtrees you are using?
Nigel
www.our-families.info
Please Log in or Create an account to join the conversation.
- ToyGuy
- Offline
- Moderator
- Live like it's Christmas every day - Santa Stephen
I may suggest it is most likely either a PGV version or webtrees level issue.
Santa Stephen the Fabled Santa
Latest webtrees at MyArnolds.com
Hosted by webtreesonline.com , a division of GeneHosts LLC
MacOS 10.6.8, Apache 2.2+, PHP 5.4.16, MySQL 5.5.28
Please Log in or Create an account to join the conversation.
- thornton
- Topic Author
- Offline
- New Member
Thanks!
Thornton
webtrees 2.1.16
PHP 5.4.24, Apache 2.2.26 MySQL 5.5.36
Website - www.frf.com/wt_2.1.16
Please Log in or Create an account to join the conversation.
- fisharebest
- Offline
- Administrator
Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net
Please Log in or Create an account to join the conversation.
- thornton
- Topic Author
- Offline
- New Member
Thornton
webtrees 2.1.16
PHP 5.4.24, Apache 2.2.26 MySQL 5.5.36
Website - www.frf.com/wt_2.1.16
Please Log in or Create an account to join the conversation.
- ToyGuy
- Offline
- Moderator
- Live like it's Christmas every day - Santa Stephen
Using phpMyAdmin (or your preferred DB manager), you should review your PGV installation. There should be 39 tables, including:
pgv_users
pgv_user_comments
pgv_user_gedcom_setting
pgv_user_setting
If any of these are missing, then you failed to properly set up PGV sometime during its operation, either not doing an update of the DB when required to create tables, or failing to import (most likely the first).
Greg will advise, but it may be necessary to run some kind of updater to the tables prior to using your PGV-2-WT wizard as the table is required to properly move data across and should be part of your current PGV installation.
Santa Stephen the Fabled Santa
Latest webtrees at MyArnolds.com
Hosted by webtreesonline.com , a division of GeneHosts LLC
MacOS 10.6.8, Apache 2.2+, PHP 5.4.16, MySQL 5.5.28
Please Log in or Create an account to join the conversation.
- thornton
- Topic Author
- Offline
- New Member
Thornton
webtrees 2.1.16
PHP 5.4.24, Apache 2.2.26 MySQL 5.5.36
Website - www.frf.com/wt_2.1.16
Please Log in or Create an account to join the conversation.
- kiwi
- Offline
- Platinum Member
Don't panic - I'm pretty sure you have helped identify an issue we need to address.
I just did a completely clean install of a freshly downloaded PGV 4.2.3 (basic).
It only creates 20 tables, and the only user table is pgv_users.
The fact you have 30 tables suggest you have some of the modules installed, such is Research Assistant, and GoogleMaps.
I think some of the additional tables Stephen is referring to relate to ones either left over from earlier versions of PGV (but no longer used) or created as part of the PGV upgrade process, rather than clean install.
Clearly we need to investigate further.
Did you upgrade your PGV installation from something before 4.2.3? I think that will be where pgv_user_comments comes from.
Nigel
www.our-families.info
Please Log in or Create an account to join the conversation.
- thornton
- Topic Author
- Offline
- New Member
No panic. I'm just an old man playing with his genealogy. I've used PGV since version 3 something. Yes, I upgraded from earler versions as I went along. At one point, don't remember when, I did a completely new install. The last couple of times, including to 4.2.3, have been upgrades.
Thanks for the help.
Thornton
webtrees 2.1.16
PHP 5.4.24, Apache 2.2.26 MySQL 5.5.36
Website - www.frf.com/wt_2.1.16
Please Log in or Create an account to join the conversation.
- kiwi
- Offline
- Platinum Member
Could you check something for me. In your file phpgedview/includes/session.php, near the top you should have a line like this:
define('PGV_SCHEMA_VERSION', 10);
Is it there, and is it identical, or does it have a different number to 10?
Nigel
www.our-families.info
Please Log in or Create an account to join the conversation.
- thornton
- Topic Author
- Offline
- New Member
It's as you show it. Version 10.
webtrees 2.1.16
PHP 5.4.24, Apache 2.2.26 MySQL 5.5.36
Website - www.frf.com/wt_2.1.16
Please Log in or Create an account to join the conversation.
- kiwi
- Offline
- Platinum Member
What "should" be happening is that for PGV versions with a PGV_SCHEMA_VERSION less then 12 (which exists only for svn versions later than the standard release) it has to work without the pgv_user/pgv_user_setting/pgv_user_gedcom_setting.
What I'm struggling to understand is why, in your case, that isn't happening.
Nigel
www.our-families.info
Please Log in or Create an account to join the conversation.
- kiwi
- Offline
- Platinum Member
Can you send me a contact address so I can give you a revised file to test?
The revised file is now in svn here, but may be a day or so before its released as a "nightly build".
Nigel
www.our-families.info
Please Log in or Create an account to join the conversation.