I'm having all sorts of problems getting phpGedView to work properly. I'm running PHP 4.3.3 and mySQL 4.0.17. I'm not able to use mySQL mode for some reason (it won't work even though I've set everything up so I end up using the index directory.
I'm wondering if i'm just running too new a version of PHP and mySQL for this.
Using index mode, I get the following error when clicking on family:
Family List
ALL
Notice: Undefined variable: alpha in /var/www/html/familytree/famlist.php on line 52
Notice: Undefined index: in /var/www/html/familytree/functions_index.php on line 867
Notice: Undefined index: in /var/www/html/familytree/functions_index.php on line 870
Surnames
Skip Surname Lists
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2004-01-16
Hey Mark,
By the looks of it you don't have any families/couples in your Gedcom file that is causing this utterly ungraceful error.
The script looks for families and can't find one. This leaves the alpha variable empty and hence the errors.
If you replace line 51-53 with this code:
-----code begins
if (isset($alpha)){
print "<a href=\"famlist.php?show_all=yes&surname_sublist=$surname_sublist\">".$pgv_lang["all"]."</a>\n";
$tfamlist = get_alpha_fams($alpha);
uasort($tfamlist, "itemsort");
}
-----code ends
It should all be solved. It will be added to the next release. Thanks for your posting.
Regards,
Roland
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Still getting these errors but I tend to be able to work around them. Can't create a new file any other way than to actually create a new person.
But it's working great otherwise, I'm assuming that the tool is made more for maintaining existing data and displaying it more than creating from scratch.
Thanks for the help!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Yes, you are right, it wasn't until recently the possibility to create gedcoms was added to phpGedView.
Since you are using phpGedView in this new way, I think it must be very valuable to John and his coworkers to learn about all problems and errors and notices you encounter, because most of us probably use phpGedView for displaying existing data only.
Best regards,
Arne
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Yeah, I am finding out that the more I use the program, the less errors I'm getting. Got rid of a great deal of errors when I finally entered my wife's parents in it (their names start with A).
Has this been tested at all with mySQL 4.0? I've upgraded my server to that (needed the increase in speed). When I tried to use mySQL as the database I was getting errors about not being able to find the database (but the database is there with the name and password given.)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2004-01-17
Hello Mark,
As Arne said, these error messages are very valuable as basically everybody uses it for viewing existing gedcoms. The second error you posted about he undefined A and index should not happen either. I will try to recreate this error also.
I use MySQL 4.0.17 myself and have no problems at all. Did it not find the database or the MySQL at all? If you can give me the error message that would be great.
Regards,
Roland
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I get the error "Your current database configuration is bad. Please check your database connection parameters and configure again."
But when I go into phpMyAdmin using my username and password, it shows the appropriate database and that user has the ability to create tables in that database.
I had it show a couple of if statements to determine the values of $DBSEL and $DBCONN and they both show false.
Currently you can see what's going on at http://www.thompsonkids.com/test/editconfig.php (it's using the username and password as both being "thompson", just as a test to make it easy and the database name is thompsonpgv. If you have any code that you want me to add for testing, let me know.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You know at my Webhotel I named my database phpgvdb I went round and round with my config the first night. My WebHotel changed the name to be my <account id>_phpgvdb Note during the install I only tried phpgvdb.
I recomend that you dbl check both the user name and database name to verify that isn't the problem. I helped 2 others with the same issue.
Hope this helps.
John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I logged to watch if i could see something; the valu stored in $DBHOST (MySQL Database Host) is "localhost" and that's wrong: you have to put the name of the sql server where your database is hosted. It can't be "localhsot" from the internet.
Hope that helps
Andr
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
In at least 90% of all cases the $DBHOST has to be localhost.
Your argument about the internet doesn't apply here, because the application doesn't access the MySQL server from the internet. In far the most cases the application access the MySQL locally.
Best regards,
Arne
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Like John trainer suggest, you may have some trouble with your databasename or the accessrights to your MySQL.
Providing you have access to your MySQL via phpMyAdmin, I wonder if you could send the URL, userid and password to the phpMyAdmin to Roland, and talk him into checking up on it.
Don't give away userid, password and URL in this forum - send it via e-mail directly to Roland.
Best regards,
Arne
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Ok, went the really simple route and just ran the code:
<?php
$db = mysql_connect("localhost", "thompson", "thompson")
or die("Could not connect: " . mysql_error());
echo "YES, IT CONNECTED!!!";
mysql_close($db);
?>
so that I could get the actual error message and it came up as a unix permissions error, not as a mysql error message error. Found out that Ensim Pro is a lot more strict than Ensim 3.1 with regard to permissions needed to even connect to mySQL (before it would just let you have a username and password, not it requires that you have mySQL on for a site.)
From working with it, it seems that everything's working. Thanks everyone for helping out!
Decided I'm going to use phpGedView for displaying, but entering data seems a bit easier locally with that PAF program that someone spoke so highly of but phpGedView seems to be a lot better for displaying the data and having other family members help me out :)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
PhpGedView is designed to be primarily a data viewer, thought the editing capabilities are improving. But I don't have plans to add all of the editing capabilities of a standard genealogy program. It is designed to share genealogy on the Internet, and promote research and collaboration among relatives. To do this some editing capabilities are required.
There is another option for entering data directly into PhpGedView. You could also try using the java based GDBI client available from the GDBI project page on SourceForge here: http://sourceforge.net/projects/gdbi/
--John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm having all sorts of problems getting phpGedView to work properly. I'm running PHP 4.3.3 and mySQL 4.0.17. I'm not able to use mySQL mode for some reason (it won't work even though I've set everything up so I end up using the index directory.
I'm wondering if i'm just running too new a version of PHP and mySQL for this.
Using index mode, I get the following error when clicking on family:
Family List
ALL
Notice: Undefined variable: alpha in /var/www/html/familytree/famlist.php on line 52
Notice: Undefined index: in /var/www/html/familytree/functions_index.php on line 867
Notice: Undefined index: in /var/www/html/familytree/functions_index.php on line 870
Surnames
Skip Surname Lists
I'm sorry, I forgot, here is the URL for the page:
http://www.thompsonkids.com/familytree/
Hey Mark,
By the looks of it you don't have any families/couples in your Gedcom file that is causing this utterly ungraceful error.
The script looks for families and can't find one. This leaves the alpha variable empty and hence the errors.
If you replace line 51-53 with this code:
-----code begins
if (isset($alpha)){
print "<a href=\"famlist.php?show_all=yes&surname_sublist=$surname_sublist\">".$pgv_lang["all"]."</a>\n";
$tfamlist = get_alpha_fams($alpha);
uasort($tfamlist, "itemsort");
}
-----code ends
It should all be solved. It will be added to the next release. Thanks for your posting.
Regards,
Roland
Solved that one.
Is this the appropriate way for me to get started, by entering data into this program?
Just found, when I click on Skip Surname Lists and it comes up with a couple more errors:
Family List
ALL
Notice: Undefined index: A in /var/www/html/familytree/functions_index.php on line 867
Notice: Undefined index: in /var/www/html/familytree/functions_index.php on line 870
--Marriage:
Show Surname Lists
Further note:
Still getting these errors but I tend to be able to work around them. Can't create a new file any other way than to actually create a new person.
But it's working great otherwise, I'm assuming that the tool is made more for maintaining existing data and displaying it more than creating from scratch.
Thanks for the help!
Hi Mark
Yes, you are right, it wasn't until recently the possibility to create gedcoms was added to phpGedView.
Since you are using phpGedView in this new way, I think it must be very valuable to John and his coworkers to learn about all problems and errors and notices you encounter, because most of us probably use phpGedView for displaying existing data only.
Best regards,
Arne
Yeah, I am finding out that the more I use the program, the less errors I'm getting. Got rid of a great deal of errors when I finally entered my wife's parents in it (their names start with A).
Has this been tested at all with mySQL 4.0? I've upgraded my server to that (needed the increase in speed). When I tried to use mySQL as the database I was getting errors about not being able to find the database (but the database is there with the name and password given.)
Hello Mark,
As Arne said, these error messages are very valuable as basically everybody uses it for viewing existing gedcoms. The second error you posted about he undefined A and index should not happen either. I will try to recreate this error also.
I use MySQL 4.0.17 myself and have no problems at all. Did it not find the database or the MySQL at all? If you can give me the error message that would be great.
Regards,
Roland
I get the error "Your current database configuration is bad. Please check your database connection parameters and configure again."
But when I go into phpMyAdmin using my username and password, it shows the appropriate database and that user has the ability to create tables in that database.
I had it show a couple of if statements to determine the values of $DBSEL and $DBCONN and they both show false.
Currently you can see what's going on at http://www.thompsonkids.com/test/editconfig.php (it's using the username and password as both being "thompson", just as a test to make it easy and the database name is thompsonpgv. If you have any code that you want me to add for testing, let me know.
You know at my Webhotel I named my database phpgvdb I went round and round with my config the first night. My WebHotel changed the name to be my <account id>_phpgvdb Note during the install I only tried phpgvdb.
I recomend that you dbl check both the user name and database name to verify that isn't the problem. I helped 2 others with the same issue.
Hope this helps.
John
I logged to watch if i could see something; the valu stored in $DBHOST (MySQL Database Host) is "localhost" and that's wrong: you have to put the name of the sql server where your database is hosted. It can't be "localhsot" from the internet.
Hope that helps
Andr
Hi Andr
In at least 90% of all cases the $DBHOST has to be localhost.
Your argument about the internet doesn't apply here, because the application doesn't access the MySQL server from the internet. In far the most cases the application access the MySQL locally.
Best regards,
Arne
Hi again Mark,
Like John trainer suggest, you may have some trouble with your databasename or the accessrights to your MySQL.
Providing you have access to your MySQL via phpMyAdmin, I wonder if you could send the URL, userid and password to the phpMyAdmin to Roland, and talk him into checking up on it.
Don't give away userid, password and URL in this forum - send it via e-mail directly to Roland.
Best regards,
Arne
Two more questions:
Can you access your MySQL from other applications?
Are you username in MySQL created as thompson@localhost or thompson@% ?
Best regards,
Arne
Ok, went the really simple route and just ran the code:
<?php
$db = mysql_connect("localhost", "thompson", "thompson")
or die("Could not connect: " . mysql_error());
echo "YES, IT CONNECTED!!!";
mysql_close($db);
?>
so that I could get the actual error message and it came up as a unix permissions error, not as a mysql error message error. Found out that Ensim Pro is a lot more strict than Ensim 3.1 with regard to permissions needed to even connect to mySQL (before it would just let you have a username and password, not it requires that you have mySQL on for a site.)
From working with it, it seems that everything's working. Thanks everyone for helping out!
Decided I'm going to use phpGedView for displaying, but entering data seems a bit easier locally with that PAF program that someone spoke so highly of but phpGedView seems to be a lot better for displaying the data and having other family members help me out :)
PhpGedView is designed to be primarily a data viewer, thought the editing capabilities are improving. But I don't have plans to add all of the editing capabilities of a standard genealogy program. It is designed to share genealogy on the Internet, and promote research and collaboration among relatives. To do this some editing capabilities are required.
There is another option for entering data directly into PhpGedView. You could also try using the java based GDBI client available from the GDBI project page on SourceForge here:
http://sourceforge.net/projects/gdbi/
--John