OK, so far I've kept my system pretty simple. There's one user (me) and I'm the admin. No one has asked for an account and they had no need to as I was not supporting direct editing of the GEDCOM.
Now we have the MyGedView page and the ability to customize things per user as well as the ability to send messages.
I've got things configured so I run the Apache web server with PHP and also run MySQL locally. I can install an phpGedView update by removing the old phpGedView directory and installing the new stuff, "uploading" the GEDCOM and re-importing it. Once I think things are working, I can publish the whole thing to my external site.
With the new features, if I'm not carefull, I'll wipe out the user and message info. So what needs to be saved? (I'm looking at the README and there is a section on upgrading that looks like it needs some updating.)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Since you are using MySQL, as long as you don't drop the tables, the users, favorites, and messages will all remain intact between upgrades.
Here are some alternate steps to upgrading:
1. download the latest release
2. upload all the .php files except the config.php and authenticate.php if you are using index mode
3. compare the new config.php file with your old config.php file and add any new variables that were introduced in this new version (there usually aren't any)
4. upload the new themes and review the Style Guide documentation for changes that you need to make to your custom themes.
5. Login as the admin user and go to Admin->Manage Gedcoms->edit configuration and save the configuration to apply any new configuration variables.
6. Reimport your gedcoms (this step may not be necessary)
You do not need to to anything to your ./index/ directory or your database. Database changes will be applied automatically when you reimport your gedcom or login.
--John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Maybe I'm missing something. When I re-import a GEDCOM (which I will want to do from time to time), it tells me it has to DROP the tables. Are you saying that there is user and message information in the database that is not DROP'ed?
I looked in the database for message and user data. I couldn't find it. I have four tables: pgv_families, pgv_individuals, pgv_other, and pgv_sources. Only pgv_other seemed like a reasonable place to find the user/message info, and it's not there.
On the other hand, my /index/ directory has favorites.dat and messages.dat. So even though I'm using MySQL, user/message info doesn't seem to be stored in MySQL. Did I screw something up?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
When you reimport the gedcom you are only asked if you really want to erase your old data, which doesn't drop the tables, it only erases the data in the database for that particular gedcom and it only erases the data in the pgv_individuals, pgv_users, pgv_sources, and pgv_other tables.
There should be three other tables created, pgv_users, pgv_messages, and pgv_favorites. If you have a messages.dat in the ./index folder, then you are using the authentication_index.php module instead of the authentication_mysql.php module. This should automatically change when you change the database mode from index to mysql. Go to Admin->Configuration and check what file is listed in the "Authentication Module" parameter. It should be authentication_mysql.php
--John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
OK, when I upgraded to 2.60, I mistakenly started with the Index configuration. I changed this to MySQL, but the authentication module didn't get updated. I manually changed this, and I now see the new tables.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
OK, so far I've kept my system pretty simple. There's one user (me) and I'm the admin. No one has asked for an account and they had no need to as I was not supporting direct editing of the GEDCOM.
Now we have the MyGedView page and the ability to customize things per user as well as the ability to send messages.
I've got things configured so I run the Apache web server with PHP and also run MySQL locally. I can install an phpGedView update by removing the old phpGedView directory and installing the new stuff, "uploading" the GEDCOM and re-importing it. Once I think things are working, I can publish the whole thing to my external site.
With the new features, if I'm not carefull, I'll wipe out the user and message info. So what needs to be saved? (I'm looking at the README and there is a section on upgrading that looks like it needs some updating.)
Since you are using MySQL, as long as you don't drop the tables, the users, favorites, and messages will all remain intact between upgrades.
Here are some alternate steps to upgrading:
1. download the latest release
2. upload all the .php files except the config.php and authenticate.php if you are using index mode
3. compare the new config.php file with your old config.php file and add any new variables that were introduced in this new version (there usually aren't any)
4. upload the new themes and review the Style Guide documentation for changes that you need to make to your custom themes.
5. Login as the admin user and go to Admin->Manage Gedcoms->edit configuration and save the configuration to apply any new configuration variables.
6. Reimport your gedcoms (this step may not be necessary)
You do not need to to anything to your ./index/ directory or your database. Database changes will be applied automatically when you reimport your gedcom or login.
--John
Maybe I'm missing something. When I re-import a GEDCOM (which I will want to do from time to time), it tells me it has to DROP the tables. Are you saying that there is user and message information in the database that is not DROP'ed?
I looked in the database for message and user data. I couldn't find it. I have four tables: pgv_families, pgv_individuals, pgv_other, and pgv_sources. Only pgv_other seemed like a reasonable place to find the user/message info, and it's not there.
On the other hand, my /index/ directory has favorites.dat and messages.dat. So even though I'm using MySQL, user/message info doesn't seem to be stored in MySQL. Did I screw something up?
When you reimport the gedcom you are only asked if you really want to erase your old data, which doesn't drop the tables, it only erases the data in the database for that particular gedcom and it only erases the data in the pgv_individuals, pgv_users, pgv_sources, and pgv_other tables.
There should be three other tables created, pgv_users, pgv_messages, and pgv_favorites. If you have a messages.dat in the ./index folder, then you are using the authentication_index.php module instead of the authentication_mysql.php module. This should automatically change when you change the database mode from index to mysql. Go to Admin->Configuration and check what file is listed in the "Authentication Module" parameter. It should be authentication_mysql.php
--John
OK, when I upgraded to 2.60, I mistakenly started with the Index configuration. I changed this to MySQL, but the authentication module didn't get updated. I manually changed this, and I now see the new tables.