Output display when there is no file

[Steve Lowmaster]

I uploaded and installed the latest file with no problems. I tested it with my old gedcom files and all went well. The display problem started when I updated the gedcom and there was not an I1. This is not a big problem because I'm going to change the root person but I thought you should see what was happening.

http://www.dnslaptops.com/MySQL/

Thanks

[John Finlay]

This is a problem with both the MySQL and the standard version.  Errors are displayed if the person specified as the default Root ID is not found.  I've struggled with how to fix this.  I have several options.
1. I can check if the root id is invalid and print out a more meaningful error message
2. I can check if the root id is invalid and default to the first id in the gedcom which is what the old versions used to do
3. I can check if the root id is invalid in the configuration and display an error message there.

Perhaps both 2 and 3 would be best.  That way they know their configuration is invalid but a visitor can still come to the site and see something meaningful.

--John

[Steve Lowmaster]

I think it would be best to default to a good id.

1. If possible it could search for the the next higher or lower id. This would help if someone typed in a number and missed by one digit. In my case one gedcom tree is much larger then the other, the default number in mine is higher then the largest number in my wifes. When I choose her tree I get the invalid id error and have to click on the individuals link before seeing any names.

2. The first id would also be good but if someone started the tree with themself and they are living then the user would only see the "private" This might be confusing to a new visitor to the site.

Now I am getting another error message when I log in to admin.

The first admin page is fine and the links show up to work with config, import and user. When I click configuration the next page opens with the following error listed  beside the logout.

ERROR:No Database Selected
SQL:SELECT * FROM pgv_users WHERE u_username='my username'

The database is listed in the config file and the site seems to be working fine so I'm not sure which file this query is coming from. If you let me know I will work on changing the string.

Steve

[Steve Lowmaster]

I haven't been able to clear the SQL error and now I,m locked from creating any new users.

When going to the user administration page the following errors are displayed.

1-In the upper left corner is:
ERROR:No Database Selected
SQL:SELECT * FROM pgv_users WHERE u_username='user name is here'

2-below that is:
Warning: Cannot modify header information - headers already sent by (output started at /home/dns/public_html/MySQL/functions.php:93) in /home/dns/public_html/MySQL/useradmin.php on line 36

3-Below #2 is:
Warning: Cannot modify header information - headers already sent by (output started at /home/dns/public_html/MySQL/functions.php:93) in /home/dns/public_html/MySQL/functions.php on line 717

4-Again beside the LOGOUT is:
ERROR:No Database Selected
SQL:SELECT * FROM pgv_users WHERE u_username='user name is here'

In the current user section the following error is displayed:
Warning: Invalid argument supplied for foreach() in /home/dns/public_html/MySQL/useradmin.php on line 144

There are no users listed in this section.
No new users can be created due to "No Database Selected" error.

This is on athe following system:
Apache version  1.3.27 (Unix)
PHP version  4.3.1
MySQL version  4.0.12

Steve