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

Re: [Phpgedview-talk] Chinese Characters in PDF report

[Bin Z. <bzh...@gm...>]

Thanks John.

We are working on the Chinese translation right now, and adding simplified
Chinese.  I will let you know when we are done.

Looking forward to hearing from you soon

Bin Zhang


On 1/23/07, John Finlay <Joh...@ne...> wrote:
>
>  Hi Bin,
>
>
>
> Sorry for the delay in responding to you.  I see that Chinese isn't
> working in the reports.  Thanks for letting us know.  I will work on it to
> see if I can figure out why it isn't working.  I will get back to you in a
> couple of days.
>
>
>
> The Chinese translation is also horribly out of date.  Hopefully someone
> will be able to finish the translation and share it with the community.
>
>
>
> Thanks,
>
> --John
>
>
>
>
>   ------------------------------
>
> *From:* php...@li... [mailto:
> php...@li...] *On Behalf Of *Bin Zhang
> *Sent:* Friday, January 12, 2007 9:47 AM
> *To:* php...@li...
> *Subject:* [Phpgedview-talk] Chinese Characters in PDF report
>
>
>
> Hi,
>
> I am setting up a Chinese genealogy site with PGV.  One problem I am
> experierincing is that Chinese characters do not show in any of the PDF
> reports, nor do they display in the circle chart.  I have filed a bug
> report, but so far have not heard anything, no action has been taken.
>
> I hope someone on this list can give me some hints as to how I can fix
> it.  Do I have to specify a special font, or something else?  I have tried
> it on different servers, all with the same result (Windows, Mac OS X, Linux,
> FreeBSD, etc.)
>
> I would really appreciate any help that you may provide.
>
> Here is the link to the bug report:
>
>
> http://sourceforge.net/tracker/index.php?func=detail&aid=1625495&group_id=55456&atid=477079
>
> Bin
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>
> _______________________________________________
> Phpgedview-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpgedview-talk
>
>
>

Re: [Phpgedview-talk] Chinese Characters in PDF report

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

Hi Bin,

=20

Sorry for the delay in responding to you.  I see that Chinese isn't
working in the reports.  Thanks for letting us know.  I will work on it
to see if I can figure out why it isn't working.  I will get back to you
in a couple of days.

=20

The Chinese translation is also horribly out of date.  Hopefully someone
will be able to finish the translation and share it with the community.

=20

Thanks,

--John

=20

=20

________________________________

From: php...@li...
[mailto:php...@li...] On Behalf Of Bin
Zhang
Sent: Friday, January 12, 2007 9:47 AM
To: php...@li...
Subject: [Phpgedview-talk] Chinese Characters in PDF report

=20

Hi,

I am setting up a Chinese genealogy site with PGV.  One problem I am
experierincing is that Chinese characters do not show in any of the PDF
reports, nor do they display in the circle chart.  I have filed a bug
report, but so far have not heard anything, no action has been taken.=20

I hope someone on this list can give me some hints as to how I can fix
it.  Do I have to specify a special font, or something else?  I have
tried it on different servers, all with the same result (Windows, Mac OS
X, Linux, FreeBSD, etc.)=20

I would really appreciate any help that you may provide.

Here is the link to the bug report:

http://sourceforge.net/tracker/index.php?func=3Ddetail&aid=3D1625495&grou=
p_i
d=3D55456&atid=3D477079

Bin

[Phpgedview-talk] SQL info not in sync with main.ged?

[Jiffy S. L. B. <se...@ji...>]

HI,

We are having trouble with our PHP install.

We keep getting this error.
"ERROR 4: Could not find gedcom record with xref:I11938 Line 149."

It seems that in some way the main.ged file and the records in the
MySQL databas are not in sync.

Would someone please tell me what is wrong?

We are also in the process of moving to a new server and when I did
there were aproximately 5,000 names missing.

What I did during the move was download a backup and then upload it to
the new server.


Any ideas?

Thanks,


-- 
Leonard Burton, N9URK
http://www.jiffyslides.com
se...@ji...
leo...@gm...

"The prolonged evacuation would have dramatically affected the
survivability of the occupants."

Re: [Phpgedview-talk] Postnuke integration missing ?

[Jim C. <ji...@ca...>]

Hi,

The new version of the Postnuke / phpGedView interface has been tested
by another user and is in production in his site. You can also see it at
http://carey.id.au (cant give out a login but can assure you that if you
are logged in to the main postnuke site it logs in / creates user in
gedview).

Now this has been tested with PostNuke  .764 and phpGedView 4.02 =
(don=92t
know if it will work on earlier releases)=20

Is there anyone else that has say PostNuke .762 that would also be able
to test it ?

Jim

-----Original Message-----
From: Jim Carey [mailto:ji...@ca...]=20
Sent: Friday, 12 January 2007 4:54 PM
To: 'All About PhpGedView'
Subject: Re: [Phpgedview-talk] Postnuke integration missing ?


Hi,

I have just finished a full rewrite of this - someone else is testing it
for me.=20

It works with PostNuke .764 and phpGedView 4.02 (probably woud work with
.762 as well but not tested)

It is setup as a proper postnuke module - uses initialise, activate and
admin etc.

Should be able to post as soon as the testing comes back from the other
tester

Cheers

Jim

-----Original Message-----
From: Christopher X. Candreva [mailto:ch...@we...]=20
Sent: Friday, 12 January 2007 4:28 PM
To: All About PhpGedView
Subject: Re: [Phpgedview-talk] Postnuke integration missing ?


On Fri, 12 Jan 2007, J=F6rg H Knapp wrote:

> Maybe this information may be useful?
>=20
> Just download phpGedView, there is a simplistic interface for PostNuke
>=20
> ./pgvnuke

Ah, thank you.

Someone might want to update the link on the web site then.

> > < http://www.phpgedview.net/modules.php >


=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=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D
Chris Candreva  -- ch...@we... -- (914) 948-3162
WestNet Internet Services of Westchester http://www.westnet.com/

------------------------------------------------------------------------
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share
your opinions on IT & business topics through brief surveys - and earn
cash
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
_______________________________________________
Phpgedview-talk mailing list Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpgedview-talk



------------------------------------------------------------------------
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share
your opinions on IT & business topics through brief surveys - and earn
cash
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
_______________________________________________
Phpgedview-talk mailing list Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpgedview-talk

[Phpgedview-talk] Chinese Characters in PDF report

[Bin Z. <bzh...@gm...>]

Hi,

I am setting up a Chinese genealogy site with PGV.  One problem I am
experierincing is that Chinese characters do not show in any of the PDF
reports, nor do they display in the circle chart.  I have filed a bug
report, but so far have not heard anything, no action has been taken.

I hope someone on this list can give me some hints as to how I can fix it.
Do I have to specify a special font, or something else?  I have tried it on
different servers, all with the same result (Windows, Mac OS X, Linux,
FreeBSD, etc.)

I would really appreciate any help that you may provide.

Here is the link to the bug report:

http://sourceforge.net/tracker/index.php?func=detail&aid=1625495&group_id=55456&atid=477079

Bin

Re: [Phpgedview-talk] Postnuke integration missing ?

[Jim C. <ji...@ca...>]

Hi,

I have just finished a full rewrite of this - someone else is testing it
for me.=20

It works with PostNuke .764 and phpGedView 4.02 (probably woud work with
.762 as well but not tested)

It is setup as a proper postnuke module - uses initialise, activate and
admin etc.

Should be able to post as soon as the testing comes back from the other
tester

Cheers

Jim

-----Original Message-----
From: Christopher X. Candreva [mailto:ch...@we...]=20
Sent: Friday, 12 January 2007 4:28 PM
To: All About PhpGedView
Subject: Re: [Phpgedview-talk] Postnuke integration missing ?


On Fri, 12 Jan 2007, J=F6rg H Knapp wrote:

> Maybe this information may be useful?
>=20
> Just download phpGedView, there is a simplistic interface for PostNuke
>=20
> ./pgvnuke

Ah, thank you.

Someone might want to update the link on the web site then.

> > < http://www.phpgedview.net/modules.php >


=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=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D
Chris Candreva  -- ch...@we... -- (914) 948-3162
WestNet Internet Services of Westchester http://www.westnet.com/

------------------------------------------------------------------------
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share
your opinions on IT & business topics through brief surveys - and earn
cash
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
_______________________________________________
Phpgedview-talk mailing list Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpgedview-talk

Re: [Phpgedview-talk] Postnuke integration missing ?

[Christopher X. C. <ch...@we...>]

On Fri, 12 Jan 2007, J=F6rg H Knapp wrote:

> Maybe this information may be useful?
>=20
> Just download phpGedView, there is a simplistic interface for PostNuke
>=20
> ./pgvnuke

Ah, thank you.

Someone might want to update the link on the web site then.

> > < http://www.phpgedview.net/modules.php >


=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=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D
Chris Candreva  -- ch...@we... -- (914) 948-3162
WestNet Internet Services of Westchester
http://www.westnet.com/

Re: [Phpgedview-talk] Postnuke integration missing ?

[<jk...@ao...>]

Maybe this information may be useful?

Just download phpGedView, there is a simplistic interface for PostNuke

./pgvnuke


Best regards

Jörg H Knapp


Christopher X. Candreva schrieb:
> I just came across PhpGedView while searching for a geneology module for 
> PostNuke.  However, the link on the web site for the PostNuke module files
> 
> < http://www.phpgedview.net/modules.php >
> 
> brings up an empty file list at Sourceforge. Have they moved, or is this 
> just no longer available ?
> 
> This is the Sourceforge link on the above page, that doesn't bring up any 
> files:
> https://sourceforge.net/project/showfiles.php?group_id=55456&package_id=88140&release_id=253056
> 
> 
> ==========================================================
> Chris Candreva  -- ch...@we... -- (914) 948-3162
> WestNet Internet Services of Westchester
> http://www.westnet.com/
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Phpgedview-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpgedview-talk
> 
> 
> 

[Phpgedview-talk] Postnuke integration missing ?

[Christopher X. C. <ch...@we...>]

I just came across PhpGedView while searching for a geneology module for 
PostNuke.  However, the link on the web site for the PostNuke module files

< http://www.phpgedview.net/modules.php >

brings up an empty file list at Sourceforge. Have they moved, or is this 
just no longer available ?

This is the Sourceforge link on the above page, that doesn't bring up any 
files:
https://sourceforge.net/project/showfiles.php?group_id=55456&package_id=88140&release_id=253056


==========================================================
Chris Candreva  -- ch...@we... -- (914) 948-3162
WestNet Internet Services of Westchester
http://www.westnet.com/

Re: [Phpgedview-talk] install issue: thumbnails replaced by generic icon + dir errors

[peter <pet...@hc...>]

May be it's interesting for you, I have pgv 4.0.2 running with mysql at
a provider server.
I made the mistake and upload my images without an extension, when I
change the random fotonames to person fotonames I forgotten something.
After that upload there are no problems, only the second step to create
the coupling with persons its goes all wrong. It's also easy to do this
mistake because there is a extension selection field in the window that
seems pgv do this for you.

I must cleanup the media directory en recover the database mysql at my
providers website.
After that and upload images with the correct extensions, its run all oke.

Peter Al


=James Birkholz= schreef:
> I'm trying to help a novice get her 4.0.2 install working. Her son set 
> things up for her.
> It's on a hosted server. The install is in a directory "family", which is 
> set up to be a pseudo-server. That is, the address of the site is:
>    http://family.pdiamond.com
> and that is the value of the "PhpGedView URL" setting in her config file.
> The value of the "Index file directory" setting in the config file is blank.
> 
> (on my install, the address is: "http://mysite.com/Trees" and the Index 
> file directory setting is "/index/")
> 
> I'm hampered by not being able to see her directory structure, so far.
> 
> She's getting error messages that indicate config or permission problems. 
> In the admin page:
> 
> ERROR 2: readdir(): supplied argument is not a valid Directory resource
> 0 Error occurred on in function readdir
> 1 called from line 54 of file admin.php
> 
> Warning: readdir(): supplied argument is not a valid Directory resource in 
> /home/pdiamon/public_html/family/admin.php on line 54
> 
> ERROR 2: closedir(): supplied argument is not a valid Directory resource
> 0 Error occurred on in function closedir
> 1 called from line 58 of file admin.php
> 
> Warning: closedir(): supplied argument is not a valid Directory resource in 
> /home/pdiamon/public_html/family/admin.php on line 58
> 
> She's able to view and edit the data, but these errors are generated in a 
> couple of places, and the media upload/display is buggy.
> 
> I've asked her to temporarily set all the folders to full world read/write, 
> but I don't think she knows how to do it, I can't view her /includes/ 
> directory, for example.
> 
> =============
> 2nd issue is that all of the images that she's been able to upload 
> successfully, show up with the thumbnails replaced by a generic media icon. 
> Ideas?
> 
> 
> James Birkholz 
> 
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Phpgedview-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpgedview-talk
> 
> 

[Phpgedview-talk] install issue: thumbnails replaced by generic icon + dir errors

[=James B. <ja...@bi...>]

I'm trying to help a novice get her 4.0.2 install working. Her son set 
things up for her.
It's on a hosted server. The install is in a directory "family", which is 
set up to be a pseudo-server. That is, the address of the site is:
   http://family.pdiamond.com
and that is the value of the "PhpGedView URL" setting in her config file.
The value of the "Index file directory" setting in the config file is blank.

(on my install, the address is: "http://mysite.com/Trees" and the Index 
file directory setting is "/index/")

I'm hampered by not being able to see her directory structure, so far.

She's getting error messages that indicate config or permission problems. 
In the admin page:

ERROR 2: readdir(): supplied argument is not a valid Directory resource
0 Error occurred on in function readdir
1 called from line 54 of file admin.php

Warning: readdir(): supplied argument is not a valid Directory resource in 
/home/pdiamon/public_html/family/admin.php on line 54

ERROR 2: closedir(): supplied argument is not a valid Directory resource
0 Error occurred on in function closedir
1 called from line 58 of file admin.php

Warning: closedir(): supplied argument is not a valid Directory resource in 
/home/pdiamon/public_html/family/admin.php on line 58

She's able to view and edit the data, but these errors are generated in a 
couple of places, and the media upload/display is buggy.

I've asked her to temporarily set all the folders to full world read/write, 
but I don't think she knows how to do it, I can't view her /includes/ 
directory, for example.

=============
2nd issue is that all of the images that she's been able to upload 
successfully, show up with the thumbnails replaced by a generic media icon. 
Ideas?


James Birkholz 

[Phpgedview-talk] Full Backup (gedcoms databases, users and media)

[Jeroen B. S. <Je...@su...>]

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi I have a question. <br>
I am using phpgedview 4.02 .(Hosted On Solaris 9 , SQL 4.015, external
server hosted by a provider)<br>
In the Software there is a backup functionality to backup gedcom data.<br>
Is it possible to make full backups ? (phpgedview software, data, mysql
datbases, media etc etc)<br>
My provider does not make backups and in case of data corruption I like
to do a full restore.<br>
<br>
<br>
regards jeroen bruins slot<br>
<br>
<div class="moz-signature">-- <br>
<meta content="text/html;" http-equiv="Content-Type">
<title></title>
&nbsp;<br>
<div class="moz-signature"><br>
</div>
</div>
</body>
</html>

[Phpgedview-talk] missing descendant icon

[peter <pet...@hc...>]

I have a small problem with the descendant icon of the submenu of the
reports options.

The descendant icon does not appear in the pull-down submenu of the
reports options.
I try to change the icon-name in the xml report to change from descend
to descendant so it is written in the theme.php, but no result.
Also in other themes is the icon not visible. And at other websites
with pgv402 you can see the same problem.

Regards Peter Al

[Phpgedview-talk] Mail Error

[dennis <den...@ur...>]

I get an error when people try & contact me. I am using PhpGedView 4.0.1. 
My preferred contact method is "Internal mail with email". And my Site 
Administration Configuration is set to "Use simple mail headers in external 
mails Yes". Am I forgetting anything?

I am getting the internal messages but no emails. Below is my error

Thanks for any help
Dennis
==============================
ERROR 2: mail(): SMTP server response: 550 not local host 
**************.com, not a gateway
0 Error occurred on in function mail
1 called from line 104 of file functions_mail.php in function pgvmail
2 called from line 1248 of file authentication.php in function addmessage
3 called from line 131 of file message.php

Warning: mail(): SMTP server response: 550 not local host 
*****************.com, not a gateway in 
*******************\includes\functions_mail.php on line 104

ERROR 2: mail(): SMTP server response: 550 not local host ureach.com, not a 
gateway
0 Error occurred on in function mail
1 called from line 104 of file functions_mail.php in function pgvmail
2 called from line 1260 of file authentication.php in function addmessage
3 called from line 131 of file message.php

Warning: mail(): SMTP server response: 550 not local host ***********.com, 
not a gateway in ****************************\includes\functions_mail.php 
on line 104
Message successfully sent to Dennis 


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.14.16/551 - Release Date: 11/25/2006 10:55 AM

Re: [Phpgedview-talk] Which SQL?

[Shag <sh...@jb...>]

I'd say MySQL, as that seems to be the SQL program of choice - almost 
everyone is using it.  :-)  There are some pretty detailed instruction on =
the 
wiki and enclosed with the program to upgrade from 3.x.  But, IMO I'd just=
 
start from scratch, backup the old version, install 4.x and reinstall the 
GEDCOM file and then copy over all the media files and such.  



On 24 Nov 2006 at 10:53, list owner wrote:

> Hi,
> 
> I am considering upgrading to PhpGedView 4.0.2, but I have a question.
> 
> My host currently has me on a server with PHP 4.4.4, but they say  
> they will upgrade me to PHP 5.0 on request-so, no problem there.
> 
> My question is about SQL. I have access to MySQL and PostgreSQL,  
> which would be better to use?
> 
> Lastly, are there any special instructions for migrating from a 3.3.8  
> installation that uses index files to  4.0.2?
> 
> Many thanks in advance!
> 
> And thanks again to John and all of the other developers!
> 
> Cheers,
> 
> Michael
> ------------------------------------------------------------------------=
-
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share =
your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDEV
> _______________________________________________
> Phpgedview-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpgedview-talk

[Phpgedview-talk] Which SQL?

[list o. <fa...@ca...>]

Hi,

I am considering upgrading to PhpGedView 4.0.2, but I have a question.

My host currently has me on a server with PHP 4.4.4, but they say =20
they will upgrade me to PHP 5.0 on request=97so, no problem there.

My question is about SQL. I have access to MySQL and PostgreSQL, =20
which would be better to use?

Lastly, are there any special instructions for migrating from a 3.3.8 =20=

installation that uses index files to  4.0.2?

Many thanks in advance!

And thanks again to John and all of the other developers!

Cheers,

Michael=

Re: [Phpgedview-talk] login screen takes a long time

[waldo k. <wki...@al...>]

yeah, i'm replying to myself ;)

waldo kitty wrote:

> i wonder how long it takes for your "on today" queries? on my system it takes a bit but i'm looking into another 
> multi-key index... possibly two or them to try to speed this up a lot more... it is not that slow, really on my system 
> but it does take an extra 20 seconds or more depending on the traffic...
> 
> FWIW: the database i'm playing with has the following stats
> 
> Individuals  	29023
> Total surnames 	1857
> Families 	10399
> Sources 	291
> Other Records 	118
> Total events 	55499
> 
> according to the stats at the bottom of the page, just opening the page as a not-logged-in user takes
> 
> Execution time: 75.516 sec. Total Database Queries: 338. Total privacy checks: 36.

the above was done after the addition of a multi-key index of (d_day, d_month, d_year)... i went back in and created 
another multi-key index of (d_day, d_mon, d_year) and again loaded my initial page with these results...

Execution time: 40.104 sec. Total Database Queries: 63. Total privacy checks: 36.

knocked 35 seconds off and really toned down the number of queries... from 338 to 63? yeah! 1/5th of what it was before...

note, again, that this is using a mysql database...

-- 
        _\/
       (@@)                      Waldo Kitty, Waldo's Place USA
__ooO_( )_Ooo_____________________ telnet://bbs.wpusa.dynip.com
_|_____|_____|_____|_____|_____|_____ http://www.wpusa.dynip.com
____|_____|_____|_____|_____|_____|_____ ftp://ftp.wpusa.dynip.com
_|_Eat_SPAM_to_email_me!_YUM!__|_____|_____ wkitty42 -at- alltel.net

Re: [Phpgedview-talk] login screen takes a long time

[waldo k. <wki...@al...>]

vincebr549 wrote:
> .
> .
> 
>> ermmm... won't that take just as long calculate the update when it happens?
> yes but only once per 'x' time frame

true enough...

>>> 2.  setup a dayly crontabe entry to re-fresh the row in this new table at
>>> some 'off hour'.
> 
>> sorry, i don't have a cron on that database server... in fact, i don't run
>> anything like a scheduler on that box since 
>> it is dedicated to nothing but database serving...
> 
>>> Anyhow, are there any thoughts on this?
> 
>> doesn't your install have that multi-key index in it? it should...
> 
> yes it does.

i wonder, then, if that first time you accessed it and it took 30 minutes, was that during the importation period or 
after? there's a built-in caching system in phpGedView that should also help to speed some of these queries up...

i wonder how long it takes for your "on today" queries? on my system it takes a bit but i'm looking into another 
multi-key index... possibly two or them to try to speed this up a lot more... it is not that slow, really on my system 
but it does take an extra 20 seconds or more depending on the traffic...

FWIW: the database i'm playing with has the following stats

Individuals  	29023
Total surnames 	1857
Families 	10399
Sources 	291
Other Records 	118
Total events 	55499

according to the stats at the bottom of the page, just opening the page as a not-logged-in user takes

Execution time: 75.516 sec. Total Database Queries: 338. Total privacy checks: 36.

that is a bit excessive, isn't it? ;)  and 338 queries? hunh? really??

> anyhow thanks for listening.

no problem... i'm as interested in speeding things up as you are... i just hope that we don't say things that others may 
misunderstand and take the wrong way...

-- 
        _\/
       (@@)                      Waldo Kitty, Waldo's Place USA
__ooO_( )_Ooo_____________________ telnet://bbs.wpusa.dynip.com
_|_____|_____|_____|_____|_____|_____ http://www.wpusa.dynip.com
____|_____|_____|_____|_____|_____|_____ ftp://ftp.wpusa.dynip.com
_|_Eat_SPAM_to_email_me!_YUM!__|_____|_____ wkitty42 -at- alltel.net

Re: [Phpgedview-talk] login screen takes a long time

[vincebr549 <vi...@pl...>]

.
.

>ermmm... won't that take just as long calculate the update when it happens?
yes but only once per 'x' time frame


> 2.  setup a dayly crontabe entry to re-fresh the row in this new table at
> some 'off hour'.

sorry, i don't have a cron on that database server... in fact, i don't run
anything like a scheduler on that box since 
it is dedicated to nothing but database serving...

>> Anyhow, are there any thoughts on this?

>doesn't your install have that multi-key index in it? it should...

yes it does.
anyhow thanks for listening.

the number to call is BR 549

-- 
View this message in context: http://www.nabble.com/login-screen-takes-a-long-time-tf2638295.html#a7371159
Sent from the phpgedview-talk mailing list archive at Nabble.com.

Re: [Phpgedview-talk] login screen takes a long time

[waldo k. <wki...@al...>]

vincebr549 wrote:
> running phpgedview v4.0.2 postgresql 8.0.? 512MB ram, 1.3Gh cpu.

i've got a lot less machine for my database server... only an old pentium 450mhz with 256meg and mysql v.something on it...

> I've setup the welcome screen to dislay GEDCOM Statistics and it seems
> that some significant performance gains could be made in this area.
> When I first installed v4.0.0 it took nearly 1/2 hour to display the login
> page.
> I found an entry in this forum that suggested adding an index would fix it
> and when I did it it improved for un-usable 1/2 hour to around 30 seconds or
> so.

i remember that discussion... i also note that i completely wiped my setup and installed the latest that was available a 
few months ago... when i access the database with phpmyadmin, i see that that index is included... in the old version i 
was running, yes, the stats stuff did take forever... but not in this version...

what does take some time, maybe 10 seconds or so, is the "on this day" query... it seems to me that possibly another 
multi-key index would speed this up in the same way as the above mentioned one... however, i'm unsure if it should be on 
  (d_day, d_mon, d_year) or on (d_day, d_month, d_year)... the first contains the month number whereas the second 
contains the three letter abbreviation of the month name... i suspect that d_month would be the better since the code 
appears to be doing a conversion to month number...

> Anyone think about why penalize the login making it calculate this
> interesting but still non-crutial data?  I thought about creating another table that
> contains only one row and has a column in it for each of the stats that are
> displayed. Then when someone logsin rather than re-calculating, which I imagine
> requires scanning many of the tables, for each login, just display that one record.
> Two possible ways of keeping it "update to date".
> 1. include a date/time stamp column in this new table and for each login
> that wishes to display the information, see if the data is older than 'x',
> if so re-calculate the data and update this new table.  Thus future users until
> 'x'  passes get the data virtually instantly.

ermmm... won't that take just as long calculate the update when it happens?

> 2.  setup a dayly crontabe entry to re-fresh the row in this new table at
> some 'off hour'.

sorry, i don't have a cron on that database server... in fact, i don't run anything like a scheduler on that box since 
it is dedicated to nothing but database serving...

> Anyhow, are there any thoughts on this?

doesn't your install have that multi-key index in it? it should...

-- 
        _\/
       (@@)                      Waldo Kitty, Waldo's Place USA
__ooO_( )_Ooo_____________________ telnet://bbs.wpusa.dynip.com
_|_____|_____|_____|_____|_____|_____ http://www.wpusa.dynip.com
____|_____|_____|_____|_____|_____|_____ ftp://ftp.wpusa.dynip.com
_|_Eat_SPAM_to_email_me!_YUM!__|_____|_____ wkitty42 -at- alltel.net

[Phpgedview-talk] login screen takes a long time

[vincebr549 <vi...@pl...>]

running phpgedview v4.0.2 postgresql 8.0.? 512MB ram, 1.3Gh cpu.
I've setup the welcome screen to dislay
GEDCOM Statistics
and it seems that some significant performance gains could be made in this
area.
When I first installed v4.0.0 it took nearly 1/2 hour to display the login
page.
I found an entry in this forum that suggested adding an index would fix it
and when I did it it improved for un-usable 1/2 hour to around 30 seconds or
so.

Anyone think about why penalize the login making it calculate this
interesting
but still non-crutial data?  I thought about creating another table that
contains
only one row and has a column in it for each of the stats that are
displayed.
Then when someone logsin rather than re-calculating, which I imagine
requires
scanning many of the tables, for each login, just display that one record.
Two possible ways of keeping it "update to date".
1. include a date/time stamp column in this new table and for each login
that wishes to display the information, see if the data is older than 'x',
if so
re-calculate the data and update this new table.  Thus future users until
'x'  passes get the data virtually instantly.

2.  setup a dayly crontabe entry to re-fresh the row in this new table at
some 'off hour'.

Anyhow, are there any thoughts on this?

As Junior says:
The number to call is BR 549

-- 
View this message in context: http://www.nabble.com/login-screen-takes-a-long-time-tf2638295.html#a7364451
Sent from the phpgedview-talk mailing list archive at Nabble.com.

[Phpgedview-talk] DB index selectivity and postgresql v4.0.2

[vincebr549 <vi...@pl...>]

I'm running 4.0.2 with postgresql v8.0.?
I recently attended a session given by Jay Pipes the North American MYSQL
manager and he started me
looking at some of the tables in phpgedview.

First I wrote a quick and dirty perl script to analyze the indexes for what
he called
selectivity.  The SQL statement is:
SELECT (COUNT(DISTINCT field) * 100)/COUNT(*) FROM table;
where 'field' is the name of a field for which there is an index (or you are
considering
building an index) within 'table'.
Unfortunately I'm a newby on sql and indexes and Jay didn't give any Rules
of Thumb (rot)
on what to do with this knowedge, so I thought I would share what I
found....
My data base has about 19K entries in it.  Here is the output of  running
the above sql on each of the
indexed fields:

 1      pgv_blocks with 24 rows keyed on b_id sel= 100%
 2      pgv_blocks with 24 rows keyed on b_username sel= 12%
 3      pgv_dates with 32018 rows keyed on d_datestamp sel= 16%
 4      pgv_dates with 32018 rows keyed on d_day sel= 0%
 5      pgv_dates with 32018 rows keyed on d_fact sel= 0%
 6      pgv_dates with 32018 rows keyed on d_file sel= 0%
 7      pgv_dates with 32018 rows keyed on d_gid sel= 77%
 8      pgv_dates with 32018 rows keyed on d_mon sel= 0%
 9      pgv_dates with 32018 rows keyed on d_month sel= 0%
10      pgv_dates with 32018 rows keyed on d_type sel= 0%
11      pgv_dates with 32018 rows keyed on d_year sel= 1%
12      pgv_families with 5873 rows keyed on f_file sel= 0%
13      pgv_families with 5873 rows keyed on f_id sel= 100%
14      pgv_favorites with 3 rows keyed on fv_id sel= 100%
15      pgv_favorites with 3 rows keyed on fv_username sel= 33%
16      pgv_individuals with 19623 rows keyed on i_file sel= 0%
17      pgv_individuals with 19623 rows keyed on i_id sel= 99%
18      pgv_individuals with 19623 rows keyed on i_letter sel= 0%
19      pgv_individuals with 19623 rows keyed on i_name sel= 92%
20      pgv_individuals with 19623 rows keyed on i_surname sel= 12%
21      pgv_media with 1 rows keyed on m_id sel= 100%
22      pgv_media with 1 rows keyed on m_media sel= 100%
23      Table pgv_media_mapping is empty
24      Table pgv_media_mapping is empty
25      Table pgv_media_mapping is empty
26      Table pgv_media_mapping is empty
27      pgv_messages with 4 rows keyed on m_id sel= 100%
28      pgv_messages with 4 rows keyed on m_to sel= 100%
29      pgv_names with 1 rows keyed on n_gid sel= 100%
30      pgv_names with 1 rows keyed on n_letter sel= 100%
31      pgv_names with 1 rows keyed on n_name sel= 100%
32      pgv_names with 1 rows keyed on n_surname sel= 100%
33      pgv_names with 1 rows keyed on n_type sel= 100%
34      pgv_news with 1 rows keyed on n_id sel= 100%
35      pgv_news with 1 rows keyed on n_username sel= 100%
36      pgv_other with 3 rows keyed on o_file sel= 33%
37      pgv_other with 3 rows keyed on o_id sel= 100%
38      pgv_placelinks with 93557 rows keyed on pl_file sel= 0%
39      pgv_placelinks with 93557 rows keyed on pl_gid sel= 22%
40      pgv_placelinks with 93557 rows keyed on pl_p_id sel= 2%
41      pgv_places with 2803 rows keyed on p_id sel= 100%
42      pgv_places with 2803 rows keyed on p_file sel= 0%
43      pgv_places with 2803 rows keyed on p_level sel= 0%
44      pgv_places with 2803 rows keyed on p_parent_id sel= 35%
45      pgv_places with 2803 rows keyed on p_place sel= 63%
46      Table pgv_remotelinks is empty
47      Table pgv_remotelinks is empty
48      Table pgv_sources is empty
49      Table pgv_sources is empty
50      Table pgv_sources is empty
51      pgv_users with 14 rows keyed on u_username sel= 100%
52      pgv_users with 14 rows keyed on u_username sel= 100%

I looked at some of the tables that had non trivial number of entries and
with a small selectivity (sel).
Item 12 above...
phpgedview=# select distinct f_file  from pgv_families;
 f_file
--------
      3
(1 row)

phpgedview=#  

Huh? is it just my particular data or what?  Why would one need an index on
a column that always has the
same value, well, why would one even need that column, if it is truly always
= 3.
Item #16 above 
phpgedview=# select distinct i_file from pgv_individuals;
 i_file
--------
      3
(1 row)

phpgedview=#
Here again, is it just my data or is this field truely always going to be =
3???
Item 18 above i_letter gave interesting results.  I found some corrections
that needed to be made
there were 34 entyries when I ran the same select distinct.  Surprising I
found
'(', '-',  '@',  'CH' , 'GY',  and 'TY' 
I'm guessing this field is used for soundex (I only support english in my
installation)???

item # 38 in the above list???
phpgedview=# select distinct pl_file from pgv_placelinks;
 pl_file
---------
       3
(1 row)

phpgedview=#    

same for p_file in pgv_places.

I've not yet run a study to see what postgresql is doing with any searches
involving these
indexes but,
It would seem to me that, at least in my system these indexes can be safely
be deleted.


For the other indexes does any one have a feel for a ROT?

Another thought, what about slow DB loads.  web searches strongly suggest
that
you disable indexes while doing a load and then turn them back on after. 
They
also caution that performance to access existing data while these indexes
are 
disabled may suffer, as always your milage may vary.
On my system
i've done several loads after running some large sed updates to correct and
clean up the data.
A load on my system takes on the order of 10 minutes or so.  I'm thinking on
trying a load with all the indexes removed to see what the difference is.

I'm looking into truning on logging to log "long" running commands and hope
to be
able to gain some information on how this stuff is working by using the
EXPLAIN command.

v

-- 
View this message in context: http://www.nabble.com/DB-index-selectivity-and-postgresql-v4.0.2-tf2638223.html#a7364249
Sent from the phpgedview-talk mailing list archive at Nabble.com.

[Phpgedview-talk] V4.0.2 postgresql bug

[vincebr549 <vi...@pl...>]

I'm running v4.0.2 with postgresql v8.0 with 512Mb 1.3Ghz scsi drives in raid
1 on
Fedora Core 5.

o when I updated to 4.0.2 I found a bug and BAD sql code.
./includes/functions_mediadb.php has 
  $sql .= " ORDER BY RAND()"
Postgresql doesn't support but instead uses RANDOM()
so this failed.

I replaced RAND with RANDOM and it fixed this problem.
I recently attended a presentation given by Jay Pipes the North American
manager for
MYSQL on performance.
He specificly mentioned how bad this particlar statement was because MYSQL
had to scan the entire table
to return the answer.  I guess the only saving grace is that , I'm guessing,
very few folks have
many MEDIA entries.

btw, I posted a problem record on sourceforge on this item.

Vince
-- 
View this message in context: http://www.nabble.com/V4.0.2-postgresql-bug-tf2638018.html#a7363569
Sent from the phpgedview-talk mailing list archive at Nabble.com.

[Phpgedview-talk] Windows to *nix system transfer

[Shag <sh...@jb...>]

I've transferred my PGV (v4.x) setup from a Windows system to a *nix 
system. Exported and than imported my database, copied over my 
directories.   Right now I'm having the following type errors.  Is this a 
permission problem, or do I just need to start from scratch and do a clean 
install?

error:

ERROR 2: mysql_errno(): supplied argument is not a valid MySQL-Link 
resource
0 Error occurred on in function mysql_errno
1 called from line 890 of file mysql.php in function mysqlraiseerror
2 called from line 324 of file mysql.php in function simplequery
3 called from line 1162 of file common.php in function query
4 called from line 1350 of file common.php in function getcol
5 called from line 2083 of file common.php in function getlistof
6 called from line 457 of file authentication.php in function checktableexists
7 called from line 404 of file authentication.php in function adminuserexists
8 called from line 43 of file editconfig.php


john

Re: [Phpgedview-talk] Fatal error in functions php

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

Hi Ray,

=20

It looks like it ran out of memory trying to generate a thumbnail for
one of the pictures.  Your host has the maximum memory set to 12MB, and
it may take more than that to generate a thumbnail of a large image
inside PGV.  You can ask your host to increase your memory limit in the
php.ini file, or you can manually generate the thumbnail for the file
your self and put it in the media/thumbs directory.  You can create the
thumbnail on your local computer with any image manipulation program you
want and then use FTP to upload it.

=20

--John

=20

=20

________________________________

From: php...@li...
[mailto:php...@li...] On Behalf Of
ra...@pl...
Sent: Wednesday, August 30, 2006 7:54 AM
To: php...@li...
Subject: [Phpgedview-talk] Fatal error in functions php

=20

Hello,

When i go to "Manage media" i get an error message:

Fatal error: Allowed memory size of 12582912 bytes exhausted (tried to
allocate 5100 bytes) in
/home/wijmane/domains/wijman-engelman.nl/public_html/includes/functions.
php on line 1110

this message started to appear after an unsuccesfull jpg upload

does anyone knows whats going on?

sorry for my english

Ray