PhpGedView / Discussion / Help: Version 4.2.4 ERR_TOO_MANY

Graham Ellis - 2011-01-28

I have just upgraded from 4.2.2 to 4.2.4 and I cannot access my site at all. I get the following error: Error 310 (net::ERR_TOO_MANY_REDIRECTS): There were too many redirects. This is from Google chrome, and I get a similar message from Firefox, while IE just sits there going nowhere! Therefore I conclude this is not a browser issue.

I am running XP and version 4.2.2 was running ok on SqLite which I was going to use for 4.2.4 if I can get it going. The server is Linux using PHP 5.2.17. For details see: http://faq.oneandone.co.uk/server/managed/managed_server_settings/3.html

This looks very similar to a problem identified in 2006 where PHP isconfigured to run in CGI mode
rather than in module mode. See https://sourceforge.net/tracker/index.php?func=detail&aid=1466535&group_id=55456&atid=634867
and https://sourceforge.net/projects/phpgedview/forums/forum/185166/topic/1474442.

The relevant files from my config file are:-
$SERVER_URL='http://www.ellisfamilytree.info/PhpGedView/';
$LOGIN_URL='';
$PGV_SMTP_HELO='ellisfamilytree.info';
$PGV_SMTP_HOST='';
$CONFIGURED=true;

Any ideas before I give up and try going back to 4.2.2?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Stephen Arnold - 2011-01-29

Graham
I would not recommend SQLite for PGV 4.2.4, regardless of the size of your GEDCOM, and certainly not at all if larger than 1000 INDIs.
How much memory do you have assigned locally?
What is the length of time for script execution as defined in you php.ini?
Do you have a DNS or conf problem? Maybe a misspelled name in the address?

can’t open “'http://www.ellisfamilytree.info/” because the first character of its address is not valid.

-Stephen

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Stephen Arnold - 2011-01-29

Graham
Also, try saving your current config.php as a backup and installing a new CONFIG.PHP. Run through the entire configuration wizrd again and let it fill in all the blanks it wants to, rather than you making any entries or assumptions on URL's.
-Stephen

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Gerry Kroll - 2011-01-29

Graham:
If the server URL shown in your config.php file is correct, you should make it completely empty. PGV will fill in the correct value when you launch it.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Graham Ellis - 2011-01-30

To answer a few questions:-
I know SQLite is on the limit with my 1400 INDIs, but it worked in 4.2.2 and the one MySQL database I have in my package is being used for something else. It takes about 2 minutes to upload my gedcom file in bursts of 15 seconds.
The web address is ok. The ' is a part of the script which has a closing ' after the address.
I am not sure how a DNS or conf problem would show itself, but as I have not changed anything since 4.2.2 and I am using the backed up config file from 4.2.2, the only thing that has changed is the code contained in 4.2.4. Does 4.2.4 require other settings to be changed?

I have tried using the clean config file supplied in 4.2.4. This at least gets me into the configuration wizard, but as soon as I click on one of the ? help icons for help, I get the following error messages:-
Fatal error: Uncaught exception 'PDOException' with message 'No Connection Established' in /homepages/14/d227361292/htdocs/ellisfamilytree/PhpGedView/includes/classes/class_pgv_db.php:704 Stack trace: #0 /homepages/14/d227361292/htdocs/ellisfamilytree/PhpGedView/includes/functions/functions_db.php(2530): PGV_DB::prepare('SELECT setting_…') #1 /homepages/14/d227361292/htdocs/ellisfamilytree/PhpGedView/includes/functions/functions_print.php(478): get_gedcom_setting(0, 'title') #2 /homepages/14/d227361292/htdocs/ellisfamilytree/PhpGedView/includes/functions/functions_print.php(636): print_header('Configuration h…') #3 /homepages/14/d227361292/htdocs/ellisfamilytree/PhpGedView/editconfig_help.php(45): print_simple_header('Configuration h…') #4 {main} thrown in/homepages/14/d227361292/htdocs/ellisfamilytree/PhpGedView/includes/classes/class_pgv_db.php on line 704

I have also tried using my backed up config file and deleting the web address. As soon as I launch I get the following:-
exception 'PDOException' with message 'SQLSTATE: General error: 1 near "AUTOINCREMENT": syntax error' in /homepages/14/d227361292/htdocs/ellisfamilytree/PhpGedView/includes/classes/class_pgv_db.php:695 Stack trace: #0 /homepages/14/d227361292/htdocs/ellisfamilytree/PhpGedView/includes/classes/class_pgv_db.php(695): PDO->exec('CREATE TABLE pg…') #1 /homepages/14/d227361292/htdocs/ellisfamilytree/PhpGedView/includes/db_schema/db_schema_10_11.php(65): PGV_DB::exec('CREATE TABLE pg…') #2 /homepages/14/d227361292/htdocs/ellisfamilytree/PhpGedView/includes/classes/class_pgv_db.php(782): require('/homepages/14/d…') #3 /homepages/14/d227361292/htdocs/ellisfamilytree/PhpGedView/includes/session.php(325): PGV_DB::updateSchema('/homepages/14/d…', 'PGV_SCHEMA_VERS…', 14) #4 /homepages/14/d227361292/htdocs/ellisfamilytree/PhpGedView/config.php(80): require_once('/homepages/14/d…') #5 /homepages/14/d227361292/htdocs/ellisfamilytree/PhpGedView/index.php(29): require('/homepages/14/d…') #6 {main}

Is there any possibility that the recent hacking of Sourceforge could have corrupted the code for 4.2.4?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Gerry Kroll - 2011-01-30

Do you have the PDO extension to PHP properly installed and enabled on your server?

http://php.net/manual/en/book.pdo.php

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Graham Ellis - 2011-01-30

How would I know if the PDO extension is properly installed?
In the php info from the admin page it shows:_

PDO support enabled
PDO drivers sqlite, mysql, sqlite2

In the meantime I have just re-installed 4.2.2 and it is working fine.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Gerry Kroll - 2011-01-30

You say you're running SQLite. I understand that PGV version 4.2.4 hasn't been checked for proper functioning with SQLite, particularly in how it interacts with the PDO extension. MySQL is generally recommended. I think this is a bit short-sighted, but at the moment we don't have anybody who can take over development in the database arena.

Can you change to using MySQL?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Graham Ellis - 2011-01-30

At the moment the one MySQL database that I have in my package is being used for something else, however I am considering upgrading for other reasons to get more. (Which costs more!)

If I upgrade is there a way of migrating all my user info etc or do I have to do a new clean install and get all my users to re-apply for logins? (I don't have a problem uploading a fresh gedcom).

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Gerry Kroll - 2011-01-31

You can use the same database for more than one purpose. That's what the table name prefix is for. This prefix ensures that there will be no collision in table names between PhpGedView and your other systems.

You should be able to do a database dump from the sqlite database and then restore the tables to the mysql database.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Ralf Kleineisel - 2011-02-13

I've had the same problem when I upgraded to 4.2.4. I could work around it by doing a "Clear All History" in Firefox. It seems that I was still logged into phpgedview and the config.php didn't like that.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Graham Ellis - 2011-02-13

I had tried all the history and cache clearing, but that didn't work for me. I went back to 4.2.2 which worked ok. Since then, I have paid out to get more MySQL databases (I needed them for other things as well) and I have done a brand new install of 4.2.4 using MySQL. . Having got past the initial configuration screens it seems to be working fine.

However, doing the brand new install in the initial configuration screens, when clicking on the '?' help icons I got the same PDOException error messages I reported previously. I can only think that this is because the MySQL database has not been set up at that stage, and it is relying on PDO in SQLite to provide the help info, but this doesn't work (or has not been tested) in 4.2.4 - as per comment 8 above.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

mkosinski - 2011-02-22

Graham,

If you can, have a look at your .htaccess file(s) and see if there is anything in them that could cause a recursion issue. I've had that same error before with other php applications and the majority of the time it is either something in the .htaccess file(s) or in the virtual host configuration on the web server. This doesn't sound at all like a PDO error to me. I've been running PhpGedView for quite a long time in Linux\Apache\MySql and never have had issues with the database. I guess it's a matter of choice (preference)…

When you did you 4.2.4 install, were there any existing files in the root of where you installed? Sometimes it's best to copy the config.php, copy the index and media directories to a seperate location, delete everything remaining, untar the full distribution, delete the newly installed index, media directories and the config.php file, copy your old media, index directories and the old config.php file back into the root of your install. I've done this several times and always seem to get a good working installation.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

mkosinski - 2011-02-23

If it helps I am running the same exact version of php on CentOS: Here is the section on MySQL from phpinfo:

mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 5.0.91
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient

Directive Local Value Master Value
mysql.allow_persistent Off Off
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off

mysqli
MysqlI Support enabled
Client API library version 5.0.91
Client API header version 5.0.77
MYSQLI_SOCKET /var/lib/mysql/mysql.sock

Directive Local Value Master Value
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.reconnect Off Off

Here is my PDO section from phpinfo:

PDO
PDO support enabled
PDO drivers mysql, sqlite, sqlite2

pdo_mysql
PDO Driver for MySQL, client library version 5.0.91

The only difference you may see is I am running Percona MySQL instead of the stock one.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Version 4.2.4 ERR_TOO_MANY_REDIRECTS

Forums

Help

Version 4.2.4 ERR_TOO_MANY_REDIRECTS

Version 4.2.4 ERR_TOO_MANY_REDIRECTS

Forums

Help

Version 4.2.4 ERR_TOO_MANY_REDIRECTS document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

Version 4.2.4 ERR_TOO_MANY_REDIRECTS