phpgedview-talk — For installation, help, bugs, and suggestions for phpgedview

Re: [Phpgedview-talk] Scalability

[Hermit <klo...@ci...>]

Len Lundgren wrote:
> I am not sure it will be a good candidate in that it will only handle small data bases.
> I did get a 25meg to install, but it will not update it. My 25meg is only about 60K. I know several people that have 
> database 2-3 times as many has I have.

Well, that is my point.  I don't know how large a database any one install can 
be without choking on hardware or software.

Say I have ancestor x on my database and you have ancestor y.  Y could then be a 
hyperlink on my side and x would be a hyperlink on your side.


Ken



> 
> Len
> 
> On Thu, 27 Jan 2005 00:48:45 -0500, Hermit wrote:
> 
> 
>>Is there, or have you considered, a mechanism for linking PHPGedView 
>>installations when data crosses?  I am a fan of distributed processes and it 
>>seems like this would be the ultimate project to use it for in terms of scaling.
>>
>>Ken
>>
>>
>>-------------------------------------------------------
>>This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
>>Tool for open source databases. Create drag-&-drop reports. Save time
>>by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
>>Download a FREE copy at http://www.intelliview.com/go/osdn_nl
>>_______________________________________________
>>Phpgedview-talk mailing list
>>Php...@li...
>>https://lists.sourceforge.net/lists/listinfo/phpgedview-talk
> 
> 
> 
> Martin Sheen - "I love my country enough to risk its wrath and tell it when it's morally wrong."
> Liberals love America like O.J. loved Nicole.....
> (Ann Coulter)
> 
> 

Re: [Phpgedview-talk] Scalability

[Len L. <llu...@in...>]

I am not sure it will be a good candidate in that it will only handle small data bases.
I did get a 25meg to install, but it will not update it. My 25meg is only about 60K. I know several people that have 
database 2-3 times as many has I have.

Len

On Thu, 27 Jan 2005 00:48:45 -0500, Hermit wrote:

>Is there, or have you considered, a mechanism for linking PHPGedView 
>installations when data crosses?  I am a fan of distributed processes and it 
>seems like this would be the ultimate project to use it for in terms of scaling.
>
>Ken
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
>Tool for open source databases. Create drag-&-drop reports. Save time
>by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
>Download a FREE copy at http://www.intelliview.com/go/osdn_nl
>_______________________________________________
>Phpgedview-talk mailing list
>Php...@li...
>https://lists.sourceforge.net/lists/listinfo/phpgedview-talk


Martin Sheen - "I love my country enough to risk its wrath and tell it when it's morally wrong."
Liberals love America like O.J. loved Nicole.....
(Ann Coulter)

RE: [Phpgedview-talk] Scalability

[John F. <Joh...@by...>]

This discussion has come up a few times before and I have put a lot of
thought into it.  The idea of linking PGV installations has a lot of
merit but there are a lot of things that need to be considered before
this can be accomplished, such as caching, privacy, and remote
authentication.

See the following thread from the discussion forums for more information
on what will probably come in the future of PGV:
http://sourceforge.net/forum/forum.php?thread_id=3D1205879&forum_id=3D185=
166

--John

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D
John Finlay
PhpGedView Project Manager
http://www.phpgedview.net
ya...@us...
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D

-----Original Message-----
From: php...@li...
[mailto:php...@li...] On Behalf Of Hermit
Sent: Wednesday, January 26, 2005 10:49 PM
To: php...@li...
Subject: [Phpgedview-talk] Scalability

Is there, or have you considered, a mechanism for linking PHPGedView=20
installations when data crosses?  I am a fan of distributed processes
and it=20
seems like this would be the ultimate project to use it for in terms of
scaling.

Ken


-------------------------------------------------------
This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
Tool for open source databases. Create drag-&-drop reports. Save time
by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
Download a FREE copy at http://www.intelliview.com/go/osdn_nl
_______________________________________________
Phpgedview-talk mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpgedview-talk

[Phpgedview-talk] Scalability

[Hermit <klo...@ci...>]

Is there, or have you considered, a mechanism for linking PHPGedView 
installations when data crosses?  I am a fan of distributed processes and it 
seems like this would be the ultimate project to use it for in terms of scaling.

Ken

RE: [Phpgedview-talk] postgres?

[John F. <Joh...@by...>]

Hi Ken,

There was some recent discussion in the Open discussion forum about
getting PGV to work with Postgres:
http://sourceforge.net/forum/forum.php?thread_id=3D1195814&forum_id=3D185=
165

The short answer is the PGV v3.2 will not work with Postgres because
there are several MySQL specific database queries.

The long answer is that PGV uses the PEAR:DB database abstraction to
work with the databases and we are working to convert these MySQL
specific queries to support for other RDBMS like Postgres and SQLite in
v3.3.  You can get an alpha version of 3.3 with many of these changes
from the Source Forge project page:
http://sourceforge.net/projects/phpgedview/

Thanks,
--John

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
John Finlay
PhpGedView Project Managaer
http://www.phpgedview.net
ya...@us...
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D

-----Original Message-----
From: php...@li...
[mailto:php...@li...] On Behalf Of Hermit
Sent: Wednesday, January 26, 2005 10:48 AM
To: php...@li...
Subject: [Phpgedview-talk] postgres?

I see that there are some files for Postgresql available but when I try
to use=20
it I get:

Warning: main(functions_pgsql.php): failed to open stream: No such file
or=20
directory in /var/www/html/lowther/session.php on line 133

Fatal error: main(): Failed opening required 'functions_pgsql.php'=20
(include_path=3D'.:/usr/lib64/php/:/usr/share/pear/') in=20
/var/www/html/lowther/session.php on line 133

Google search turned up nothing so I am assuming it isn't a standard php
file of=20
some sort.  I tried downloading the cvs version and it isn't their
either.  I=20
checked some listings on the forum and it doesn't look like pgsql
support is in=20
yet but the db files are there so I'm a little confused.

Ken



-------------------------------------------------------
This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
Tool for open source databases. Create drag-&-drop reports. Save time
by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
Download a FREE copy at http://www.intelliview.com/go/osdn_nl
_______________________________________________
Phpgedview-talk mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpgedview-talk

[Phpgedview-talk] postgres?

[Hermit <klo...@ci...>]

I see that there are some files for Postgresql available but when I try to use 
it I get:

Warning: main(functions_pgsql.php): failed to open stream: No such file or 
directory in /var/www/html/lowther/session.php on line 133

Fatal error: main(): Failed opening required 'functions_pgsql.php' 
(include_path='.:/usr/lib64/php/:/usr/share/pear/') in 
/var/www/html/lowther/session.php on line 133

Google search turned up nothing so I am assuming it isn't a standard php file of 
some sort.  I tried downloading the cvs version and it isn't their either.  I 
checked some listings on the forum and it doesn't look like pgsql support is in 
yet but the db files are there so I'm a little confused.

Ken

[Phpgedview-talk] web site bug?

[Hermit <klo...@ci...>]

I couldn't find a contact for web site problems.  If it is there it isn't 
obvious.   I just registered my site and was dumped back to the previous page. 
I reloaded my browser to make the name show up and it was there twice.  I 
thought I'd reload it again, and now it is listed 3 times....

Lowther.  One listing is enough.  I really only did register once. Something 
must have been cached that kept resubmitting the info.  Sorry about that.

Ken

RE: [Phpgedview-talk] update gedcom

[John F. <Joh...@by...>]

In the php.ini file you should set:
max_execution_time =3D 120
memory_limit =3D 128M
=20
You will have to restart apache in order for these changes to take
affect.
On a decent machine (ie Pentium 3 > 1Ghz, 512 MB ram), these settings
should be sufficient to run your 30MB gedcom file.
=20
Something else you might try is to setup Apache and MySQL on your
computer at home where you will have more control and see if you can get
it running there.
=20
I know that PGV will work with a 30MB gedcom because I recently
installed one at www.PGVHosting.com <http://www.pgvhosting.com/> .=20
=20
Something else that has caused v3.2.1 to slow down is a problem in the
editgedcoms.php file.  See this forum thread for more information about
whether this could be the cause of some of your problems:
http://sourceforge.net/forum/forum.php?thread_id=3D1202168&forum_id=3D185=
166
=20
Good Luck,
--John
=20
=20
________________________________

From: php...@li...
[mailto:php...@li...] On Behalf Of Len
Lundgren
Sent: Thursday, January 20, 2005 12:57 PM
To: php...@li...
Cc: John Finlay
Subject: [Phpgedview-talk] update gedcom
=20

I created a small gedcom.
Everything worked just fine. The import time was very fast, under 5
second. Nothing has ever worked that fast before.
Now I will update it and try to update.

It asked if I wished to overwrite and did it and displayed pedigree.
works slick.

What can I do to make my regular one work? Where are the size limiting
variables located?

Len
e-mail -> llu...@in...
Web Page http://thelundgrens.us

On Tue, 4 Jan 2005 13:27:25 -0700, John Finlay wrote:

>Hi Len,
>
>I'm not sure why you are having the login troubles. They could be
>unrelated to the gedcom size. Have you tried testing it with a smaller
>gedcom to see if you still have some of these problems?
>
>There are two ways to update a gedcom that is already in the system.
>The first is to use the upload gedcom page and upload the gedcom again.
>Make sure that the new gedcom has the same file name as the old one.
>Then reimport the gedcom.
>The second way is to use FTP to upload the gedcom, replacing the old
>gedcom. Then reimport the gedcom by clicking on the import link in the
>mangage gedcoms and edit privacy page.
>
>Were you able to successfully import this gedcom the first time you
>uploaded it?
>
>Best Regards,
>--John
>
>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>John Finlay
>PhpGedView Project Manager
>http://www.phpgedview.net
>ya...@us...
>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>
>-----Original Message-----
>From: php...@li...
>[mailto:php...@li...] On Behalf Of Len
>Lundgren
>Sent: Monday, January 03, 2005 8:56 PM
>To: Stuart Phethean
>Cc: php...@li...
>Subject: [Phpgedview-talk] update gedcom
>
>I am trying to update my gedcom which is 30meg
>I extended the time to 7200 sec, both in php.ini and config.php
>I increased the memory allowance to 300meg
>I am using mysql
>
>the 1st clean up ran, but returned to the login page rather than to
step
>4
>went back to manage ged, import validate convert to ansi ran, retuned
to
>login.
>went back to manage ged, import validate convert to ansi did not
>convert.
>entered no clicked on continue.
>ran for maybe 5 min. estimated time to run, 2 hours. then returned to
>login screen
>
>I checked, gedcom did not update.
>
>Is the proper procedure to upload then import ?
>
>or do I need to uninstall phpgedview and start from scratch?
>
>
>
>Len
>e-mail -> llu...@in...
>Web Page http://thelundgrens.us
>Benjamin Franklin's admonition: "Make yourself sheep and the wolves
will
>eat you."
>
>
>
>
>-------------------------------------------------------
>The SF.Net email is sponsored by: Beat the post-holiday blues
>Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
>It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt
>_______________________________________________
>Phpgedview-talk mailing list
>Php...@li...
>https://lists.sourceforge.net/lists/listinfo/phpgedview-talk
>
>
>-------------------------------------------------------
>The SF.Net email is sponsored by: Beat the post-holiday blues
>Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
>It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt
>_______________________________________________
>Phpgedview-talk mailing list
>Php...@li...
>https://lists.sourceforge.net/lists/listinfo/phpgedview-talk


Len
e-mail -> llu...@in...
Web Page http://thelundgrens.us
Benjamin Franklin's admonition: "Make yourself sheep and the wolves will
eat you."



Len
e-mail -> llu...@in...
Web Page  http://thelundgrens.us
Benjamin Franklin's admonition: "Make yourself sheep and the wolves will
eat you."

[Phpgedview-talk] update gedcom

[Len L. <llu...@in...>]

I created a small gedcom.
Everything worked just fine. The import time was very fast, under 5 second. Nothing has ever 
worked that fast before.
Now I will update it and try to update.

It asked if I wished to overwrite and did it and displayed pedigree. works slick.

What can I do to make my regular one work? Where are the size limiting variables located?

Len
e-mail -> llu...@in...
Web Page  http://thelundgrens.us

On Tue, 4 Jan 2005 13:27:25 -0700, John Finlay wrote:

>Hi Len,
>
>I'm not sure why you are having the login troubles. They could be
>unrelated to the gedcom size. Have you tried testing it with a smaller
>gedcom to see if you still have some of these problems?
>
>There are two ways to update a gedcom that is already in the system.
>The first is to use the upload gedcom page and upload the gedcom again.
>Make sure that the new gedcom has the same file name as the old one.
>Then reimport the gedcom.
>The second way is to use FTP to upload the gedcom, replacing the old
>gedcom. Then reimport the gedcom by clicking on the import link in the
>mangage gedcoms and edit privacy page.
>
>Were you able to successfully import this gedcom the first time you
>uploaded it?
>
>Best Regards,
>--John
>
>==================================
>John Finlay
>PhpGedView Project Manager
>http://www.phpgedview.net
>ya...@us...
>==================================
>
>-----Original Message-----
>From: php...@li...
>[mailto:php...@li...] On Behalf Of Len
>Lundgren
>Sent: Monday, January 03, 2005 8:56 PM
>To: Stuart Phethean
>Cc: php...@li...
>Subject: [Phpgedview-talk] update gedcom
>
>I am trying to update my gedcom which is 30meg
>I extended the time to 7200 sec, both in php.ini and config.php
>I increased the memory allowance to 300meg
>I am using mysql
>
>the 1st clean up ran, but returned to the login page rather than to step
>4
>went back to manage ged, import validate convert to ansi ran, retuned to
>login.
>went back to manage ged, import validate convert to ansi did not
>convert.
>entered no clicked on continue.
>ran for maybe 5 min. estimated time to run, 2 hours. then returned to
>login screen
>
>I checked, gedcom did not update.
>
>Is the proper procedure to upload then import ?
>
>or do I need to uninstall phpgedview and start from scratch?
>
>
>
>Len
>e-mail -> llu...@in...
>Web Page http://thelundgrens.us
>Benjamin Franklin's admonition: "Make yourself sheep and the wolves will
>eat you."
>
>
>
>
>-------------------------------------------------------
>The SF.Net email is sponsored by: Beat the post-holiday blues
>Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
>It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt
>_______________________________________________
>Phpgedview-talk mailing list
>Php...@li...
>https://lists.sourceforge.net/lists/listinfo/phpgedview-talk
>
>
>-------------------------------------------------------
>The SF.Net email is sponsored by: Beat the post-holiday blues
>Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
>It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt
>_______________________________________________
>Phpgedview-talk mailing list
>Php...@li...
>https://lists.sourceforge.net/lists/listinfo/phpgedview-talk


Len
e-mail -> llu...@in...
Web Page  http://thelundgrens.us
Benjamin Franklin's admonition: "Make yourself sheep and the wolves will eat you."




Len
e-mail -> llu...@in...
Web Page  http://thelundgrens.us
Benjamin Franklin's admonition: "Make yourself sheep and the wolves will eat you."

RE: [Phpgedview-talk] update gedcom

[Len L. <llu...@in...>]

I had many problems the first time, but they were related to premature time outs.  I finally found all of the places to 
change the time limit and it loaded using MySQL. It never did work with the index option.
I uploaded it using a previous version.
I upgraded to the current version, and also upgraded to PHP 5, then because of severe performance problems (up 
to 2 minutes to just login) deleted php5 and reinstalled 4.  My login time dropped back to 12-13 seconds.

I have been lax in uploading the current genealogy file, but the online one is defiantly out dated.

I will try a small one.

Len

On Tue, 4 Jan 2005 13:27:25 -0700, John Finlay wrote:

>Hi Len,
>
>I'm not sure why you are having the login troubles.  They could be
>unrelated to the gedcom size.  Have you tried testing it with a smaller
>gedcom to see if you still have some of these problems?
>
>There are two ways to update a gedcom that is already in the system.
>The first is to use the upload gedcom page and upload the gedcom again.
>Make sure that the new gedcom has the same file name as the old one.
>Then reimport the gedcom.
>The second way is to use FTP to upload the gedcom, replacing the old
>gedcom.  Then reimport the gedcom by clicking on the import link in the
>mangage gedcoms and edit privacy page.
>
>Were you able to successfully import this gedcom the first time you
>uploaded it?
>
>Best Regards,
>--John
>
>==================================
>John Finlay
>PhpGedView Project Manager
>http://www.phpgedview.net
>ya...@us...
>==================================
>
>-----Original Message-----
>From: php...@li...
>[mailto:php...@li...] On Behalf Of Len
>Lundgren
>Sent: Monday, January 03, 2005 8:56 PM
>To: Stuart Phethean
>Cc: php...@li...
>Subject: [Phpgedview-talk] update gedcom
>
>I am trying to update my gedcom which is 30meg
>I extended the time to 7200 sec, both in php.ini and config.php
>I increased the memory allowance to 300meg
>I am using mysql
>
>the 1st clean up ran, but returned to the login page rather than to step
>4
>went back to manage ged, import validate convert to ansi ran, retuned to
>login.
>went back to manage ged, import validate convert to ansi did not
>convert.
>entered no clicked on continue.
>ran for maybe 5 min. estimated time to run, 2 hours. then returned to
>login screen
>
>I checked, gedcom did not update.
>
>Is the proper procedure to upload then import ?
>
>or do I need to uninstall phpgedview and start from scratch?
>
>
>
>Len
>e-mail -> llu...@in...
>Web Page  http://thelundgrens.us
>Benjamin Franklin's admonition: "Make yourself sheep and the wolves will
>eat you."
>
>
>
>
>-------------------------------------------------------
>The SF.Net email is sponsored by: Beat the post-holiday blues
>Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
>It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt
>_______________________________________________
>Phpgedview-talk mailing list
>Php...@li...
>https://lists.sourceforge.net/lists/listinfo/phpgedview-talk
>
>
>-------------------------------------------------------
>The SF.Net email is sponsored by: Beat the post-holiday blues
>Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
>It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt
>_______________________________________________
>Phpgedview-talk mailing list
>Php...@li...
>https://lists.sourceforge.net/lists/listinfo/phpgedview-talk



Len
e-mail -> llu...@in...
Web Page  http://thelundgrens.us
Benjamin Franklin's admonition: "Make yourself sheep and the wolves will eat you."

RE: [Phpgedview-talk] update gedcom

[Len L. <llu...@in...>]

I created a small gedcom.
Everything worked just fine. The import time was very fast, under 5 second.  Nothing has ever worked that fast 
before.
Now I will update it and try to update.

It asked if I wished to overwrite and did it and displayed pedigree. works slick.

What can I do to make my regular one work? Where are the size limiting variables located?

Len

On Tue, 4 Jan 2005 13:27:25 -0700, John Finlay wrote:

>Hi Len,
>
>I'm not sure why you are having the login troubles.  They could be
>unrelated to the gedcom size.  Have you tried testing it with a smaller
>gedcom to see if you still have some of these problems?
>
>There are two ways to update a gedcom that is already in the system.
>The first is to use the upload gedcom page and upload the gedcom again.
>Make sure that the new gedcom has the same file name as the old one.
>Then reimport the gedcom.
>The second way is to use FTP to upload the gedcom, replacing the old
>gedcom.  Then reimport the gedcom by clicking on the import link in the
>mangage gedcoms and edit privacy page.
>
>Were you able to successfully import this gedcom the first time you
>uploaded it?
>
>Best Regards,
>--John
>
>==================================
>John Finlay
>PhpGedView Project Manager
>http://www.phpgedview.net
>ya...@us...
>==================================
>
>-----Original Message-----
>From: php...@li...
>[mailto:php...@li...] On Behalf Of Len
>Lundgren
>Sent: Monday, January 03, 2005 8:56 PM
>To: Stuart Phethean
>Cc: php...@li...
>Subject: [Phpgedview-talk] update gedcom
>
>I am trying to update my gedcom which is 30meg
>I extended the time to 7200 sec, both in php.ini and config.php
>I increased the memory allowance to 300meg
>I am using mysql
>
>the 1st clean up ran, but returned to the login page rather than to step
>4
>went back to manage ged, import validate convert to ansi ran, retuned to
>login.
>went back to manage ged, import validate convert to ansi did not
>convert.
>entered no clicked on continue.
>ran for maybe 5 min. estimated time to run, 2 hours. then returned to
>login screen
>
>I checked, gedcom did not update.
>
>Is the proper procedure to upload then import ?
>
>or do I need to uninstall phpgedview and start from scratch?
>
>
>
>Len
>e-mail -> llu...@in...
>Web Page  http://thelundgrens.us
>Benjamin Franklin's admonition: "Make yourself sheep and the wolves will
>eat you."
>
>
>
>
>-------------------------------------------------------
>The SF.Net email is sponsored by: Beat the post-holiday blues
>Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
>It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt
>_______________________________________________
>Phpgedview-talk mailing list
>Php...@li...
>https://lists.sourceforge.net/lists/listinfo/phpgedview-talk
>
>
>-------------------------------------------------------
>The SF.Net email is sponsored by: Beat the post-holiday blues
>Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
>It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt
>_______________________________________________
>Phpgedview-talk mailing list
>Php...@li...
>https://lists.sourceforge.net/lists/listinfo/phpgedview-talk



Len
e-mail -> llu...@in...
Web Page  http://thelundgrens.us
Benjamin Franklin's admonition: "Make yourself sheep and the wolves will eat you."

RE: [Phpgedview-talk] update gedcom

[John F. <Joh...@by...>]

Hi Len,

I'm not sure why you are having the login troubles.  They could be
unrelated to the gedcom size.  Have you tried testing it with a smaller
gedcom to see if you still have some of these problems?

There are two ways to update a gedcom that is already in the system.
The first is to use the upload gedcom page and upload the gedcom again.
Make sure that the new gedcom has the same file name as the old one.
Then reimport the gedcom.
The second way is to use FTP to upload the gedcom, replacing the old
gedcom.  Then reimport the gedcom by clicking on the import link in the
mangage gedcoms and edit privacy page.

Were you able to successfully import this gedcom the first time you
uploaded it?

Best Regards,
--John

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
John Finlay
PhpGedView Project Manager
http://www.phpgedview.net
ya...@us...
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D

-----Original Message-----
From: php...@li...
[mailto:php...@li...] On Behalf Of Len
Lundgren
Sent: Monday, January 03, 2005 8:56 PM
To: Stuart Phethean
Cc: php...@li...
Subject: [Phpgedview-talk] update gedcom

I am trying to update my gedcom which is 30meg
I extended the time to 7200 sec, both in php.ini and config.php
I increased the memory allowance to 300meg
I am using mysql

the 1st clean up ran, but returned to the login page rather than to step
4
went back to manage ged, import validate convert to ansi ran, retuned to
login.
went back to manage ged, import validate convert to ansi did not
convert.
entered no clicked on continue.
ran for maybe 5 min. estimated time to run, 2 hours. then returned to
login screen

I checked, gedcom did not update.

Is the proper procedure to upload then import ?

or do I need to uninstall phpgedview and start from scratch?



Len
e-mail -> llu...@in...
Web Page  http://thelundgrens.us
Benjamin Franklin's admonition: "Make yourself sheep and the wolves will
eat you."




-------------------------------------------------------
The SF.Net email is sponsored by: Beat the post-holiday blues
Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt
_______________________________________________
Phpgedview-talk mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpgedview-talk

RE: [Phpgedview-talk] [Phpgedview-talk]Fan Chart Option in v3.2.1

[John F. <Joh...@by...>]

Hi Stuart,
=20
I responded to this in the help forum.
=20
Best Regards,
--John
=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D
John Finlay
PhpGedView Project Manager
http://www.phpgedview.net <http://www.phpgedview.net/>=20
ya...@us...
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D
=20
________________________________

From: php...@li...
[mailto:php...@li...] On Behalf Of stuart
Sent: Friday, December 31, 2004 9:12 AM
To: php...@li...
Subject: [Phpgedview-talk] [Phpgedview-talk]Fan Chart Option in v3.2.1
=20
My ISP has GD Version 2.0.17  installed on my server but the Fan Chart
Option does not display. It does work if I run fanchart.php manually but
when i do a print-preview it has the message :

"Font file not found on PHP server : ./fonts/Bitstream/Vera.ttf" =20
=20
Is this a default font for GD and if so, should I try to get my ISP to
install it, or can it be changed within fanchart.php?=20
=20
Regards,
=20
Stuart
=20
=20

=20

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.6.7 - Release Date: 30/12/2004

[Phpgedview-talk] update gedcom

[Len L. <llu...@in...>]

I am trying to update my gedcom which is 30meg
I extended the time to 7200 sec, both in php.ini and config.php
I increased the memory allowance to 300meg
I am using mysql

the 1st clean up ran, but returned to the login page rather than to step 4
went back to manage ged, import validate convert to ansi ran, retuned to login.
went back to manage ged, import validate convert to ansi did not convert.
entered no clicked on continue.
ran for maybe 5 min. estimated time to run, 2 hours. then returned to login screen

I checked, gedcom did not update.

Is the proper procedure to upload then import ?

or do I need to uninstall phpgedview and start from scratch?



Len
e-mail -> llu...@in...
Web Page  http://thelundgrens.us
Benjamin Franklin's admonition: "Make yourself sheep and the wolves will eat you."

[Phpgedview-talk] [Phpgedview-talk]Fan Chart Option in v3.2.1

[stuart <st...@ph...>]

My ISP has GD Version 2.0.17  installed on my server but the Fan Chart
Option does not display. It does work if I run fanchart.php manually but
when i do a print-preview it has the message :

"Font file not found on PHP server : ./fonts/Bitstream/Vera.ttf"  
 
Is this a default font for GD and if so, should I try to get my ISP to
install it, or can it be changed within fanchart.php? 
 
Regards,
 
Stuart
 
 

 

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.6.7 - Release Date: 30/12/2004
 

[Phpgedview-talk] RE: [Phpgedview-talk]Updating to ver 3.2.1

[Stuart P. <gen...@ph...>]

 Hi John

I have done some testing bewteeen 3.1 and 3.2 - I have loaded a new set of
MySQL tables for ver 3.2 (using the same GEDCOM file). Lists etc display at
more or less the same speed as with the old version, but if I run
editgedcoms.php there is a delay of at least a minute whilst the page tries
to refresh. Also, when trying to view pedegree or descendency charts, things
run VERY slow and the browser then seems to become unresponsive. I have
noticed that my default pedigree chart misses out the fourth geneartion on
version 3.2 for some reason. 

http://www.phethean.co.uk/test/pedigree.php  - newly installed version 3.2

http://www.phethean.co.uk/trees/pedigree.php - "live" version 3.1


I have tried this from XP SP2 using IE6 and FireFox 1.0

Regards,

Stuart


-----Original Message-----
From: php...@li...
[mailto:php...@li...] On Behalf Of John
Finlay
Sent: 20 December 2004 20:50
To: php...@li...
Subject: RE: [Phpgedview-talk] FW: [Phpgedview-talk]Updating to ver 3.2.1

Hi Stuart,

V3.2.x should be faster than 3.1.  3.2 does use the PEAR:DB library to
communicate with mysql instead of the built-in PHP functions, but this has
been faster for me.

--John

-----Original Message-----
From: php...@li...
[mailto:php...@li...] On Behalf Of Stuart
Phethean
Sent: Monday, December 20, 2004 1:42 PM
To: php...@li...
Subject: [Phpgedview-talk] FW: [Phpgedview-talk]Updating to ver 3.2.1

 Re my previous message - I have now removed ALL the files except config.php
and replaced them with version 3.2.1 files - it now runs without errors but
is VERY slow accessing any data from MySQL so I have reverted to 3.1 for the
time being. Any reason as to why data access should be a problem?

Stuart

_____________________________________
Stuart Phethean
Hampshire, UK
Family web Pages:
http://www.phethean.co.uk
_____________________________________
 
 

-----Original Message-----
From: Stuart Phethean [mailto:gen...@ph...]
Sent: 20 December 2004 17:50
To: 'php...@li...'
Subject: [Phpgedview-talk]Updating to ver 3.2.1

When I upload the new files for version 3.2.1, following the update
instructions in readme.txt I get the following errors. I have copied in my
original config.php and authentication_mysql.php and chmod these to 777.
I
have checked that the index file (relocated into
/files/home2/phethean/cgi-bin/index) is also chmod to 777. If I use the
original config files it all starts up ok, but I don't want to loose any
subscriber data in the mysql database!

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.6.2 - Release Date: 20/12/2004
 



-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now. 
http://productguide.itmanagersjournal.com/
_______________________________________________
Phpgedview-talk mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpgedview-talk


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now. 
http://productguide.itmanagersjournal.com/
_______________________________________________
Phpgedview-talk mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpgedview-talk

-- 
This email has been verified as Virus free
Virus Protection and more available at http://www.plus.net

-- 
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.6.2 - Release Date: 20/12/2004
 

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.6.2 - Release Date: 20/12/2004
 

RE: [Phpgedview-talk] FW: [Phpgedview-talk]Updating to ver 3.2.1

[Len L. <llu...@in...>]

HI 
I have used phpgedview for  a couple of years,
In hopes getting under 10 sec performance per screen I switched to php 5. What a Difference. I was able get 
responses on my internal 100mhz network as quick as 45 Sec. I switched back to php 4 and was able to get 10-30 
sec responses, much better. i have used 3.1 and 3.2 and could not tell any difference in speed. I do have a small 
gedcom database, not a multi million record one like lds.org or ancestor.com, with only 65K records.

I think the culprit is the PHP interpreter. I use gallery also and it runs about the same speed, although that 
performance is supposed to be because of the number of albums and pictures (500, 15,000).

if I could get a 50Ghz server with 50Ghz memory, then software speed would not matter.


Len Lundgren
http://thelundgrens.us


On Mon, 20 Dec 2004 13:49:53 -0700, John Finlay wrote:

>Hi Stuart,
>
>V3.2.x should be faster than 3.1.  3.2 does use the PEAR:DB library to
>communicate with mysql instead of the built-in PHP functions, but this
>has been faster for me.
>
>--John
>
>-----Original Message-----
>From: php...@li...
>[mailto:php...@li...] On Behalf Of Stuart
>Phethean
>Sent: Monday, December 20, 2004 1:42 PM
>To: php...@li...
>Subject: [Phpgedview-talk] FW: [Phpgedview-talk]Updating to ver 3.2.1
>
> Re my previous message - I have now removed ALL the files except
>config.php
>and replaced them with version 3.2.1 files - it now runs without errors
>but
>is VERY slow accessing any data from MySQL so I have reverted to 3.1 for
>the
>time being. Any reason as to why data access should be a problem?
>
>Stuart
>
>_____________________________________
>Stuart Phethean
>Hampshire, UK
>Family web Pages:
>http://www.phethean.co.uk
>_____________________________________
> 
> 
>
>-----Original Message-----
>From: Stuart Phethean [mailto:gen...@ph...] 
>Sent: 20 December 2004 17:50
>To: 'php...@li...'
>Subject: [Phpgedview-talk]Updating to ver 3.2.1
>
>When I upload the new files for version 3.2.1, following the update
>instructions in readme.txt I get the following errors. I have copied in
>my
>original config.php and authentication_mysql.php and chmod these to 777.
>I
>have checked that the index file (relocated into
>/files/home2/phethean/cgi-bin/index) is also chmod to 777. If I use the
>original config files it all starts up ok, but I don't want to loose any
>subscriber data in the mysql database!
>
>-- 
>No virus found in this outgoing message.
>Checked by AVG Anti-Virus.
>Version: 7.0.296 / Virus Database: 265.6.2 - Release Date: 20/12/2004
> 
>
>
>
>-------------------------------------------------------
>SF email is sponsored by - The IT Product Guide
>Read honest & candid reviews on hundreds of IT Products from real users.
>Discover which products truly live up to the hype. Start reading now. 
>http://productguide.itmanagersjournal.com/
>_______________________________________________
>Phpgedview-talk mailing list
>Php...@li...
>https://lists.sourceforge.net/lists/listinfo/phpgedview-talk
>
>
>-------------------------------------------------------
>SF email is sponsored by - The IT Product Guide
>Read honest & candid reviews on hundreds of IT Products from real users.
>Discover which products truly live up to the hype. Start reading now. 
>http://productguide.itmanagersjournal.com/
>_______________________________________________
>Phpgedview-talk mailing list
>Php...@li...
>https://lists.sourceforge.net/lists/listinfo/phpgedview-talk



Len
e-mail -> llu...@in...
Web Page  http://thelundgrens.us
Benjamin Franklin's admonition: "Make yourself sheep and the wolves will eat you."

RE: [Phpgedview-talk] FW: [Phpgedview-talk]Updating to ver 3.2.1

[John F. <Joh...@by...>]

Hi Stuart,

V3.2.x should be faster than 3.1.  3.2 does use the PEAR:DB library to
communicate with mysql instead of the built-in PHP functions, but this
has been faster for me.

--John

-----Original Message-----
From: php...@li...
[mailto:php...@li...] On Behalf Of Stuart
Phethean
Sent: Monday, December 20, 2004 1:42 PM
To: php...@li...
Subject: [Phpgedview-talk] FW: [Phpgedview-talk]Updating to ver 3.2.1

 Re my previous message - I have now removed ALL the files except
config.php
and replaced them with version 3.2.1 files - it now runs without errors
but
is VERY slow accessing any data from MySQL so I have reverted to 3.1 for
the
time being. Any reason as to why data access should be a problem?

Stuart

_____________________________________
Stuart Phethean
Hampshire, UK
Family web Pages:
http://www.phethean.co.uk
_____________________________________
=20
=20

-----Original Message-----
From: Stuart Phethean [mailto:gen...@ph...]=20
Sent: 20 December 2004 17:50
To: 'php...@li...'
Subject: [Phpgedview-talk]Updating to ver 3.2.1

When I upload the new files for version 3.2.1, following the update
instructions in readme.txt I get the following errors. I have copied in
my
original config.php and authentication_mysql.php and chmod these to 777.
I
have checked that the index file (relocated into
/files/home2/phethean/cgi-bin/index) is also chmod to 777. If I use the
original config files it all starts up ok, but I don't want to loose any
subscriber data in the mysql database!

--=20
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.6.2 - Release Date: 20/12/2004
=20



-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.=20
http://productguide.itmanagersjournal.com/
_______________________________________________
Phpgedview-talk mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpgedview-talk

[Phpgedview-talk] FW: [Phpgedview-talk]Updating to ver 3.2.1

[Stuart P. <gen...@ph...>]

 Re my previous message - I have now removed ALL the files except config.php
and replaced them with version 3.2.1 files - it now runs without errors but
is VERY slow accessing any data from MySQL so I have reverted to 3.1 for the
time being. Any reason as to why data access should be a problem?

Stuart

_____________________________________
Stuart Phethean
Hampshire, UK
Family web Pages:
http://www.phethean.co.uk
_____________________________________
 
 

-----Original Message-----
From: Stuart Phethean [mailto:gen...@ph...] 
Sent: 20 December 2004 17:50
To: 'php...@li...'
Subject: [Phpgedview-talk]Updating to ver 3.2.1

When I upload the new files for version 3.2.1, following the update
instructions in readme.txt I get the following errors. I have copied in my
original config.php and authentication_mysql.php and chmod these to 777. I
have checked that the index file (relocated into
/files/home2/phethean/cgi-bin/index) is also chmod to 777. If I use the
original config files it all starts up ok, but I don't want to loose any
subscriber data in the mysql database!

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.6.2 - Release Date: 20/12/2004
 

RE: [Phpgedview-talk] [Phpgedview-talk]Updating to ver 3.2.1

[John F. <Joh...@by...>]

Hi Stuart,

You need the new authentication_mysql.php file.  The readme instructions
should refer to the authenticate.php file which you will only have if
you are using Index mode.

--John


-----Original Message-----
From: php...@li...
[mailto:php...@li...] On Behalf Of Stuart
Phethean
Sent: Monday, December 20, 2004 10:50 AM
To: php...@li...
Subject: [Phpgedview-talk] [Phpgedview-talk]Updating to ver 3.2.1

When I upload the new files for version 3.2.1, following the update
instructions in readme.txt I get the following errors. I have copied in
my
original config.php and authentication_mysql.php and chmod these to 777.
I
have checked that the index file (relocated into
/files/home2/phethean/cgi-bin/index) is also chmod to 777. If I use the
original config files it all starts up ok, but I don't want to loose any
subscriber data in the mysql database!
=20
=20
________________________________________________________________________
____
____________________

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
resource in /files/home2/phethean/test/authentication_mysql.php on line
235
ERROR:DB Error: already exists=20
SQL:CREATE TABLE pgv_users (u_username VARCHAR(30) NOT NULL, u_password
VARCHAR(255), u_fullname VARCHAR(255), u_gedcomid TEXT, u_rootid TEXT,
u_canadmin ENUM('Y','N'), u_canedit TEXT, u_email TEXT, u_verified
VARCHAR(20), u_verified_by_admin VARCHAR(20), u_language VARCHAR(50),
u_pwrequested VARCHAR(20), u_reg_timestamp VARCHAR(50), u_reg_hashcode
VARCHAR(255), u_theme VARCHAR(50), u_loggedin ENUM('Y','N'),
u_sessiontime
INT(14), u_contactmethod VARCHAR(20), PRIMARY KEY(u_username))

ERROR:DB Error: already exists=20
SQL:CREATE TABLE pgv_messages (m_id INT NOT NULL auto_increment, m_from
VARCHAR(255), m_to VARCHAR(30), m_subject VARCHAR(255), m_body TEXT,
m_created VARCHAR(255), PRIMARY KEY(m_id))

ERROR:DB Error: already exists=20
SQL:CREATE TABLE pgv_favorites (fv_id INT NOT NULL auto_increment,
fv_username VARCHAR(30), fv_gid VARCHAR(10), fv_type VARCHAR(10),
fv_file
VARCHAR(100), PRIMARY KEY(fv_id))

ERROR:DB Error: already exists=20
SQL:CREATE TABLE pgv_blocks (b_id INT NOT NULL auto_increment,
b_username
VARCHAR(100), b_location VARCHAR(30), b_order INT, b_name VARCHAR(255),
PRIMARY KEY(b_id))

ERROR:DB Error: already exists=20
SQL:CREATE TABLE pgv_news (n_id INT NOT NULL auto_increment, n_username
VARCHAR(100), n_date INT, n_title VARCHAR(255), n_text TEXT, PRIMARY
KEY(n_id))


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
resource in /files/home2/phethean/test/authentication_mysql.php on line
210

Warning: Cannot modify header information - headers already sent by
(output
started at /files/home2/phethean/test/authentication_mysql.php:235) in
/files/home2/phethean/test/session.php on line 313=20




=20
=20
Best wishes,
=20
=20
Stuart
=20
 __________________________________
Stuart Phethean
Hampshire, UK
Family web Pages:
http://www.phethean.co.uk <http://www.phethean.co.uk/>=20
_____________________________________
=20
=20


--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.6.0 - Release Date: 17/12/2004



--=20
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.6.0 - Release Date: 17/12/2004
=20



-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.=20
http://productguide.itmanagersjournal.com/
_______________________________________________
Phpgedview-talk mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpgedview-talk

RE: [Phpgedview-talk] logfile error message

[John F. <Joh...@by...>]

Hi Stuart,
=20
This error means that somebody was trying to send a message and the
message they entered looked similar to an SQL command so the message was
not allowed.  This is a security check to make sure that SQL Injections
are not able to get through.  However the check is pretty liberal and as
you can see it sometimes messes up.  I have tightened up this check if
version 3.2.1 so it shouldn't happen as often as it did in 3.1.
=20
--John
=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D
John Finlay
PhpGedView Project Manager
www.phpgedview.net <http://www.phpgedview.net/>=20
ya...@us...
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D
=20
=20
________________________________

From: php...@li...
[mailto:php...@li...] On Behalf Of stuart
Sent: Sunday, December 19, 2004 4:21 AM
To: php...@li...
Subject: [Phpgedview-talk] logfile error message
=20
Hi there,
=20
=20
Was just checking through my phpGedView log file (not something I do
very often!) and notice this error message (real names removed):
=20
" 17.12.2004 23:52:29 - 68.154.64.65 - Possible SQL injection detected:
body=3D>My husband Derrick typed his name in a search engine on-line and
found our family tree. My mom is **** ****, now ****, Jack\'s daughter.
I\'m curious to know how long it has taken you to create this. I\'m very
impressed! I also have some updates that you might want to add. I look
forward to hearing from you. . Script terminated. "
=20
Now, I'm assuming that there was some sort of error in the
saving/sending of this message since I never actually recieved this
message. I have tried to reproduce conditions under which it may have
occurred but I always manage to send the message OK.
=20
phpGedView is V3.1 - I'm just about to apgrade when I get a chance.
=20
Any ideas?
=20
=20
Best wishes,
=20
=20
Stuart
=20
 __________________________________
Stuart Phethean
Hampshire, UK
Family web Pages:
http://www.phethean.co.uk <http://www.phethean.co.uk/>=20
_____________________________________
=20
=20

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.6.0 - Release Date: 17/12/2004

[Phpgedview-talk] [Phpgedview-talk]Updating to ver 3.2.1

[Stuart P. <gen...@ph...>]

When I upload the new files for version 3.2.1, following the update
instructions in readme.txt I get the following errors. I have copied in my
original config.php and authentication_mysql.php and chmod these to 777. I
have checked that the index file (relocated into
/files/home2/phethean/cgi-bin/index) is also chmod to 777. If I use the
original config files it all starts up ok, but I don't want to loose any
subscriber data in the mysql database!
 
 
____________________________________________________________________________
____________________

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
resource in /files/home2/phethean/test/authentication_mysql.php on line 235
ERROR:DB Error: already exists 
SQL:CREATE TABLE pgv_users (u_username VARCHAR(30) NOT NULL, u_password
VARCHAR(255), u_fullname VARCHAR(255), u_gedcomid TEXT, u_rootid TEXT,
u_canadmin ENUM('Y','N'), u_canedit TEXT, u_email TEXT, u_verified
VARCHAR(20), u_verified_by_admin VARCHAR(20), u_language VARCHAR(50),
u_pwrequested VARCHAR(20), u_reg_timestamp VARCHAR(50), u_reg_hashcode
VARCHAR(255), u_theme VARCHAR(50), u_loggedin ENUM('Y','N'), u_sessiontime
INT(14), u_contactmethod VARCHAR(20), PRIMARY KEY(u_username))

ERROR:DB Error: already exists 
SQL:CREATE TABLE pgv_messages (m_id INT NOT NULL auto_increment, m_from
VARCHAR(255), m_to VARCHAR(30), m_subject VARCHAR(255), m_body TEXT,
m_created VARCHAR(255), PRIMARY KEY(m_id))

ERROR:DB Error: already exists 
SQL:CREATE TABLE pgv_favorites (fv_id INT NOT NULL auto_increment,
fv_username VARCHAR(30), fv_gid VARCHAR(10), fv_type VARCHAR(10), fv_file
VARCHAR(100), PRIMARY KEY(fv_id))

ERROR:DB Error: already exists 
SQL:CREATE TABLE pgv_blocks (b_id INT NOT NULL auto_increment, b_username
VARCHAR(100), b_location VARCHAR(30), b_order INT, b_name VARCHAR(255),
PRIMARY KEY(b_id))

ERROR:DB Error: already exists 
SQL:CREATE TABLE pgv_news (n_id INT NOT NULL auto_increment, n_username
VARCHAR(100), n_date INT, n_title VARCHAR(255), n_text TEXT, PRIMARY
KEY(n_id))


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
resource in /files/home2/phethean/test/authentication_mysql.php on line 210

Warning: Cannot modify header information - headers already sent by (output
started at /files/home2/phethean/test/authentication_mysql.php:235) in
/files/home2/phethean/test/session.php on line 313 




 
 
Best wishes,
 
 
Stuart
 
 __________________________________
Stuart Phethean
Hampshire, UK
Family web Pages:
http://www.phethean.co.uk <http://www.phethean.co.uk/> 
_____________________________________
 
 


--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.6.0 - Release Date: 17/12/2004



-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.6.0 - Release Date: 17/12/2004
 

RE: [Phpgedview-talk] Two images not displaying

[Matthew S. <ws...@fa...>]

I've changed over from using *many* other programs to Fireworks, as
well.  I enjoy how easy it is to use, along with all of the
possibilities of the Adobe filters.

-- Matt Smith


----- Original message -----
From: "Rodney Hall" <rm...@rm...>
To: php...@li...
Date: Sun, 19 Dec 2004 13:53:43 -0000
Subject: RE: [Phpgedview-talk] Two images not displaying

Matthew,

Thanks for that. No, I didn't use lossless rotation, but I've retrieved
all
(some 120 in my last batch!) the corrupted jpg files by exporting from
PSP
to png files, importing those into FireWorks MX and then saving as jpg
files! I'll be using FireWorks from now on!

Regards
--
Rodney HALL 
Heywood, Lancashire

Suaviter sed fortiter
Agreeably but powerfully 
~~~~~~~~~~~~~~
rm...@rm...
http://rmhh.co.uk/
http://rmhh.org.uk/
~~~~~~~~~~~~~~~~~~~

> -----Original Message-----
> From: php...@li... 
> [mailto:php...@li...] On 
> Behalf Of Matthew Gates
> Sent: Sunday, December 19, 2004 12:50 PM
> To: php...@li...
> Subject: Re: [Phpgedview-talk] Two images not displaying
> 
> > I'm using PSP 9.0, which I've always
> > used in previous versions to create these images from a scanner. All
> > images on my site use this method. However, since I wrote 
> the query, I
> > find other .jpg files created this way also have a problem 
> on the web,
> > but not on the desktop. Older files are OK. Any ideas?
> 
> Did you use the "lossless rotation" option in PSP after scanning your 
> pictures?  I suspected PSP, so I looked on their forum site 
> and it seems 
> using this tool can cause corrupted image files.
> 
> My advice is to try using something like Gimp instead of PSP.  It's a 
> superb bit of software.  I've only ever used it on Linux, but 
> there is a 
> Windows version if you don't have access to a Linux box.   Here's a 
> link:
> 
> http://gimp-win.sourceforge.net/
> 
> >From the FAQ I see that there are two packages to install - 
> the "GTK+ 
> Runtime Environment" and "The Gimp installers".  I think you need to 
> install GTK+ before installing The Gimp.
> 
> Enjoy,
> -- 
> Matthew
> An Empty List is a Sorted List
> 
> >
> > Regards
> > --
> > Rodney HALL
> > Heywood, Lancashire
> >
> > Suaviter sed fortiter
> > Agreeably but powerfully
> > ~~~~~~~~~~~~~~
> > rm...@rm...
> > http://rmhh.co.uk/
> > http://rmhh.org.uk/
> > ~~~~~~~~~~~~~~~~~~~
> >
> > > -----Original Message-----
> > > From: php...@li...
> > > [mailto:php...@li...] On
> > > Behalf Of Matthew Gates
> > > Sent: Sunday, December 19, 2004 12:13 AM
> > > To: php...@li...
> > > Subject: Re: [Phpgedview-talk] Two images not displaying
> > >
> > > Hi,
> > >
> > > I managed download the image files using my browser, but I can't
> > > view them in any application - the image files look corrupt to me.
> > >
> > > If you have an MD5 checksummer, you could check the originals
> > > to see if
> > > they have been modified en-route:
> > >
> > > md5 checksums:
> > >
> > > Thumbnail of 114_31_210th_st_newyork_1956.jpg:
> > > af524c7db74f7892f602da71959b5e29
> > >
> > > Thumbnail of fresh_meadows_newyork_1962.jpg:
> > > c1bf55fd431039973ecab40f07155c47
> > >
> > > 114_31_210th_st_newyork_1956.jpg:
> > > 0389ec77b860fa7f3bb31f2754e9963f
> > >
> > > fresh_meadows_newyork_1962.jpg:
> > > 474d4c4a926d0970424833db0d1effe9
> > >
> > > I had a problem where some of my jpegs were not viewable in
> > > some apps.  I
> > > ran them through "jpegtran"
> > > (http://www.rt.com/man/jpegtran.1.html), and
> > > that solved the problem for my pictures.  However, I tried to
> > > run your
> > > images through it and it gave an error:
> > >
> > > "Sampling factors too large for interleaved scan"
> > >
> > > ...which to me just confirms that the images are corrupted
> > > somehow.  If
> > > you can view them in some application, try saving as some
> > > other format,
> > > then in a different application convert them back to jpegs.
> > > It could be
> > > that whatever program created these files has some bug in it that
> > > produces duff jpegs.
> > >
> > > Cheers,
> > > --
> > > Matthew
> > >
> > > P.S. your original mail seemed to have some viral attachment
> > > - at least
> > > my mail hosting service ID'd it as such...
> > >
> > > On Saturday 18 December 2004 23:23, Rodney Hall wrote:
> > > > Can some kind soul please tell me what's wrong with the last two
> > > > images in the Residence section of the following page please?
> > > > http://rmhh.co.uk/tree2/individual.php?pid=ID.1
> > > >
> > > > Both the thumbnail and full image are in the respective folders
> > > > with all the rest of the images and yet they do not display.
> > > >
> > > > --
> > > > Rodney HALL
> > > > Heywood, Lancashire
> > > >
> > > > Suaviter sed fortiter
> > > > Agreeably but powerfully
> > > > ~~~~~~~~~~~~
> > > > rm...@rm...
> > > > http://rmhh.co.uk/
> > > > http://rmhh.org.uk/
> > > > ~~~~~~~~~~~~~
> > >
> > > --
> > > Matthew Gates
> > >
> > >
> > > -------------------------------------------------------
> > > SF email is sponsored by - The IT Product Guide
> > > Read honest & candid reviews on hundreds of IT Products from
> > > real users.
> > > Discover which products truly live up to the hype. Start reading
> > > now. http://productguide.itmanagersjournal.com/
> > > _______________________________________________
> > > Phpgedview-talk mailing list
> > > Php...@li...
> > > https://lists.sourceforge.net/lists/listinfo/phpgedview-talk
> >
> > -------------------------------------------------------
> > SF email is sponsored by - The IT Product Guide
> > Read honest & candid reviews on hundreds of IT Products from real
> > users. Discover which products truly live up to the hype. Start
> > reading now. http://productguide.itmanagersjournal.com/
> > _______________________________________________
> > Phpgedview-talk mailing list
> > Php...@li...
> > https://lists.sourceforge.net/lists/listinfo/phpgedview-talk
> 
> -- 
> Matthew Gates
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from 
> real users.
> Discover which products truly live up to the hype. Start reading now. 
> http://productguide.itmanagersjournal.com/
> _______________________________________________
> Phpgedview-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpgedview-talk
> 




-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now. 
http://productguide.itmanagersjournal.com/
_______________________________________________
Phpgedview-talk mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpgedview-talk

RE: [Phpgedview-talk] Two images not displaying

[Rodney H. <rm...@rm...>]

Matthew,

Thanks for that. No, I didn't use lossless rotation, but I've retrieved all
(some 120 in my last batch!) the corrupted jpg files by exporting from PSP
to png files, importing those into FireWorks MX and then saving as jpg
files! I'll be using FireWorks from now on!

Regards
--
Rodney HALL 
Heywood, Lancashire

Suaviter sed fortiter
Agreeably but powerfully 
~~~~~~~~~~~~~~
rm...@rm...
http://rmhh.co.uk/
http://rmhh.org.uk/
~~~~~~~~~~~~~~~~~~~

> -----Original Message-----
> From: php...@li... 
> [mailto:php...@li...] On 
> Behalf Of Matthew Gates
> Sent: Sunday, December 19, 2004 12:50 PM
> To: php...@li...
> Subject: Re: [Phpgedview-talk] Two images not displaying
> 
> > I'm using PSP 9.0, which I've always
> > used in previous versions to create these images from a scanner. All
> > images on my site use this method. However, since I wrote 
> the query, I
> > find other .jpg files created this way also have a problem 
> on the web,
> > but not on the desktop. Older files are OK. Any ideas?
> 
> Did you use the "lossless rotation" option in PSP after scanning your 
> pictures?  I suspected PSP, so I looked on their forum site 
> and it seems 
> using this tool can cause corrupted image files.
> 
> My advice is to try using something like Gimp instead of PSP.  It's a 
> superb bit of software.  I've only ever used it on Linux, but 
> there is a 
> Windows version if you don't have access to a Linux box.   Here's a 
> link:
> 
> http://gimp-win.sourceforge.net/
> 
> >From the FAQ I see that there are two packages to install - 
> the "GTK+ 
> Runtime Environment" and "The Gimp installers".  I think you need to 
> install GTK+ before installing The Gimp.
> 
> Enjoy,
> -- 
> Matthew
> An Empty List is a Sorted List
> 
> >
> > Regards
> > --
> > Rodney HALL
> > Heywood, Lancashire
> >
> > Suaviter sed fortiter
> > Agreeably but powerfully
> > ~~~~~~~~~~~~~~
> > rm...@rm...
> > http://rmhh.co.uk/
> > http://rmhh.org.uk/
> > ~~~~~~~~~~~~~~~~~~~
> >
> > > -----Original Message-----
> > > From: php...@li...
> > > [mailto:php...@li...] On
> > > Behalf Of Matthew Gates
> > > Sent: Sunday, December 19, 2004 12:13 AM
> > > To: php...@li...
> > > Subject: Re: [Phpgedview-talk] Two images not displaying
> > >
> > > Hi,
> > >
> > > I managed download the image files using my browser, but I can't
> > > view them in any application - the image files look corrupt to me.
> > >
> > > If you have an MD5 checksummer, you could check the originals
> > > to see if
> > > they have been modified en-route:
> > >
> > > md5 checksums:
> > >
> > > Thumbnail of 114_31_210th_st_newyork_1956.jpg:
> > > af524c7db74f7892f602da71959b5e29
> > >
> > > Thumbnail of fresh_meadows_newyork_1962.jpg:
> > > c1bf55fd431039973ecab40f07155c47
> > >
> > > 114_31_210th_st_newyork_1956.jpg:
> > > 0389ec77b860fa7f3bb31f2754e9963f
> > >
> > > fresh_meadows_newyork_1962.jpg:
> > > 474d4c4a926d0970424833db0d1effe9
> > >
> > > I had a problem where some of my jpegs were not viewable in
> > > some apps.  I
> > > ran them through "jpegtran"
> > > (http://www.rt.com/man/jpegtran.1.html), and
> > > that solved the problem for my pictures.  However, I tried to
> > > run your
> > > images through it and it gave an error:
> > >
> > > "Sampling factors too large for interleaved scan"
> > >
> > > ...which to me just confirms that the images are corrupted
> > > somehow.  If
> > > you can view them in some application, try saving as some
> > > other format,
> > > then in a different application convert them back to jpegs.
> > > It could be
> > > that whatever program created these files has some bug in it that
> > > produces duff jpegs.
> > >
> > > Cheers,
> > > --
> > > Matthew
> > >
> > > P.S. your original mail seemed to have some viral attachment
> > > - at least
> > > my mail hosting service ID'd it as such...
> > >
> > > On Saturday 18 December 2004 23:23, Rodney Hall wrote:
> > > > Can some kind soul please tell me what's wrong with the last two
> > > > images in the Residence section of the following page please?
> > > > http://rmhh.co.uk/tree2/individual.php?pid=ID.1
> > > >
> > > > Both the thumbnail and full image are in the respective folders
> > > > with all the rest of the images and yet they do not display.
> > > >
> > > > --
> > > > Rodney HALL
> > > > Heywood, Lancashire
> > > >
> > > > Suaviter sed fortiter
> > > > Agreeably but powerfully
> > > > ~~~~~~~~~~~~
> > > > rm...@rm...
> > > > http://rmhh.co.uk/
> > > > http://rmhh.org.uk/
> > > > ~~~~~~~~~~~~~
> > >
> > > --
> > > Matthew Gates
> > >
> > >
> > > -------------------------------------------------------
> > > SF email is sponsored by - The IT Product Guide
> > > Read honest & candid reviews on hundreds of IT Products from
> > > real users.
> > > Discover which products truly live up to the hype. Start reading
> > > now. http://productguide.itmanagersjournal.com/
> > > _______________________________________________
> > > Phpgedview-talk mailing list
> > > Php...@li...
> > > https://lists.sourceforge.net/lists/listinfo/phpgedview-talk
> >
> > -------------------------------------------------------
> > SF email is sponsored by - The IT Product Guide
> > Read honest & candid reviews on hundreds of IT Products from real
> > users. Discover which products truly live up to the hype. Start
> > reading now. http://productguide.itmanagersjournal.com/
> > _______________________________________________
> > Phpgedview-talk mailing list
> > Php...@li...
> > https://lists.sourceforge.net/lists/listinfo/phpgedview-talk
> 
> -- 
> Matthew Gates
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from 
> real users.
> Discover which products truly live up to the hype. Start reading now. 
> http://productguide.itmanagersjournal.com/
> _______________________________________________
> Phpgedview-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpgedview-talk
> 

Re: [Phpgedview-talk] Two images not displaying

[Matthew G. <mat...@ya...>]

> I'm using PSP 9.0, which I've always
> used in previous versions to create these images from a scanner. All
> images on my site use this method. However, since I wrote the query, I
> find other .jpg files created this way also have a problem on the web,
> but not on the desktop. Older files are OK. Any ideas?

Did you use the "lossless rotation" option in PSP after scanning your=20
pictures?  I suspected PSP, so I looked on their forum site and it seems=20
using this tool can cause corrupted image files.

My advice is to try using something like Gimp instead of PSP.  It's a=20
superb bit of software.  I've only ever used it on Linux, but there is a=20
Windows version if you don't have access to a Linux box.   Here's a=20
link:

http://gimp-win.sourceforge.net/

=46rom the FAQ I see that there are two packages to install - the "GTK+=20
Runtime Environment" and "The Gimp installers".  I think you need to=20
install GTK+ before installing The Gimp.

Enjoy,
=2D-=20
Matthew
An Empty List is a Sorted List

>
> Regards
> --
> Rodney HALL
> Heywood, Lancashire
>
> Suaviter sed fortiter
> Agreeably but powerfully
> ~~~~~~~~~~~~~~
> rm...@rm...
> http://rmhh.co.uk/
> http://rmhh.org.uk/
> ~~~~~~~~~~~~~~~~~~~
>
> > -----Original Message-----
> > From: php...@li...
> > [mailto:php...@li...] On
> > Behalf Of Matthew Gates
> > Sent: Sunday, December 19, 2004 12:13 AM
> > To: php...@li...
> > Subject: Re: [Phpgedview-talk] Two images not displaying
> >
> > Hi,
> >
> > I managed download the image files using my browser, but I can't
> > view them in any application - the image files look corrupt to me.
> >
> > If you have an MD5 checksummer, you could check the originals
> > to see if
> > they have been modified en-route:
> >
> > md5 checksums:
> >
> > Thumbnail of 114_31_210th_st_newyork_1956.jpg:
> > af524c7db74f7892f602da71959b5e29
> >
> > Thumbnail of fresh_meadows_newyork_1962.jpg:
> > c1bf55fd431039973ecab40f07155c47
> >
> > 114_31_210th_st_newyork_1956.jpg:
> > 0389ec77b860fa7f3bb31f2754e9963f
> >
> > fresh_meadows_newyork_1962.jpg:
> > 474d4c4a926d0970424833db0d1effe9
> >
> > I had a problem where some of my jpegs were not viewable in
> > some apps.  I
> > ran them through "jpegtran"
> > (http://www.rt.com/man/jpegtran.1.html), and
> > that solved the problem for my pictures.  However, I tried to
> > run your
> > images through it and it gave an error:
> >
> > "Sampling factors too large for interleaved scan"
> >
> > ...which to me just confirms that the images are corrupted
> > somehow.  If
> > you can view them in some application, try saving as some
> > other format,
> > then in a different application convert them back to jpegs.
> > It could be
> > that whatever program created these files has some bug in it that
> > produces duff jpegs.
> >
> > Cheers,
> > --
> > Matthew
> >
> > P.S. your original mail seemed to have some viral attachment
> > - at least
> > my mail hosting service ID'd it as such...
> >
> > On Saturday 18 December 2004 23:23, Rodney Hall wrote:
> > > Can some kind soul please tell me what's wrong with the last two
> > > images in the Residence section of the following page please?
> > > http://rmhh.co.uk/tree2/individual.php?pid=3DID.1
> > >
> > > Both the thumbnail and full image are in the respective folders
> > > with all the rest of the images and yet they do not display.
> > >
> > > --
> > > Rodney HALL
> > > Heywood, Lancashire
> > >
> > > Suaviter sed fortiter
> > > Agreeably but powerfully
> > > ~~~~~~~~~~~~
> > > rm...@rm...
> > > http://rmhh.co.uk/
> > > http://rmhh.org.uk/
> > > ~~~~~~~~~~~~~
> >
> > --
> > Matthew Gates
> >
> >
> > -------------------------------------------------------
> > SF email is sponsored by - The IT Product Guide
> > Read honest & candid reviews on hundreds of IT Products from
> > real users.
> > Discover which products truly live up to the hype. Start reading
> > now. http://productguide.itmanagersjournal.com/
> > _______________________________________________
> > Phpgedview-talk mailing list
> > Php...@li...
> > https://lists.sourceforge.net/lists/listinfo/phpgedview-talk
>
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real
> users. Discover which products truly live up to the hype. Start
> reading now. http://productguide.itmanagersjournal.com/
> _______________________________________________
> Phpgedview-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpgedview-talk

=2D-=20
Matthew Gates