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

[Phpgedview-talk] Media Upload out of control

[Waller R. S <rsw...@us...>]

Hi,

I've been using PGV for awhile now..It is great!

However, I recently started using the media options. Whenever I go to  
Add a new media item to a fact or to the individual directly, I see a  
common issue and I don't know how to resolve it.

For instance.. inside the Fact, I click Add Media, another window  
opens and I select the file to upload from my computer, I leave the  
directory as the default which is showing ./media in that window  
(which I have specified in the configuration file as ./media). I fill  
in the rest of the fields and click save...

The file uploads and takes me back to the fact that I was working on  
with the media M### filled in now in the proper field.

When I click save on the fact, the page refreshes as it should, but I  
am unable to view the media item..
I looked at the database to see what it was showing and it appears  
that when the upload occurs, it puts in an additional media/ in the  
m_file field of pgv_media table. e.g. instead of just ./media/ 
filename.jpg, or just filename.jpg, it has this in the field: ./media/ 
media/filename.jpg

When I look at the server's file structure, it shows multiple  
subdirectories of media, inside media, inside media etc.. with the  
respective thumbnail directories..

It is like the upload panel is out of control or looses touch with  
where things should be....

Any thoughts on what I could be doing wrong here? Is there a way to  
prevent these multiple subdirectories from being created and the  
issues with the table entries? Some files are being put in these  
subdirectories on upload as well????

Help!!!
Thanks,
Rick

[Phpgedview-talk] Statistics Plot Issues

[Waller R. S <rsw...@us...>]

Hi,

I have jpgraph installed.. Running PHP 5.1.2

I'm getting an error when I run the Statisitics charts..

General PHP Error: no prefix specified - Possible Security hazard

This stops the graph and nothing continues..

Has anyone seen this or have any ideas??

Thanks
Rick

Re: [Phpgedview-talk] config.php file writable/read-only

[David C. <Da...@co...>]

I find filezilla works very well. Once connected to your site highlight the
file (or files) whose permissions you want to change, right click, select
"file attributes" and off you go...

Dave

-----Original Message-----
From: php...@li...
[mailto:php...@li...] On Behalf Of dennis
Sent: 23 July 2006 02:46
To: php...@li...
Subject: [Phpgedview-talk] config.php file writable/read-only

Sorry I didn't make myself clearer. In Administration the screen says "Your
config.php file is still writable. For security, you should set the
permissions of this file back to read-only when you have finished
configuring your site" I couldn't find a way to make it read-only in my FTP
program, widows explorer or front page. So I downloaded it to my computer &
changed the properties to read-only then uploaded back to my website.

Can you recommend a cheap or free FTP program that will let me change the
file permission? I use EFTP & if I am doing this right I keep getting this
error:
error encountered 500'SITE CHMOD 777 / command not understood error
encountered 500'SITE CHMOD 755 / command not understood

Thanks
Dennis

At 05:40 PM 7/22/2006, Shag wrote:
>As for your config.php problem. I've never heard of making a file 
>read-only, and then tranfering it to another system.  You need to 
>change it on the system that PGV resides.  Couple ways of doing that, 
>most FTP programs will allow you to chmod a file, depending on the host 
>your using, almost all have some kind of file manger that will allow 
>you to change your file permissions.  If your using cpanel, the 
>capability is there.  One thing to keep in mind is sometimes it takes a 
>couple of minutes for a change to filter through the system, this is 
>especially true in a cluster setup.
>
>john


--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.394 / Virus Database: 268.10.3/395 - Release Date: 7/21/2006



-------------------------------------------------------------------------
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] config.php file writable/read-only

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

EFTP should work.  That's what I use. :-)  Actually, sorry, I was wrong about not being able to make a file 
read-only on one system and then copying it to another.  Windows is famous for that issue...  I've had 
issues before where I wasn't able to change file permissions, and then a couple of hours later, I was able.  
That may be your problem, sometimes it takes a busy server a little time to make changes.  I'm assuming 
you have access to some kind of panel through your host that allows you to make changes i.e., add 
subdomains, MySQL databases, e-mail accounts...  Been awhile since I used cpanel (common panel in 
use), login and see if you have a file manager or such.  Allows you to delete, move, edit files.  See if you 
can't change your file permissions there.  

john


On 22 Jul 2006 at 18:46, dennis wrote:

> Sorry I didn't make myself clearer. In Administration the screen says "Your 
> config.php file is still writable. For security, you should set the 
> permissions of this file back to read-only when you have finished 
> configuring your site" I couldn't find a way to make it read-only in my FTP 
> program, widows explorer or front page. So I downloaded it to my computer & 
> changed the properties to read-only then uploaded back to my website.
> 
> Can you recommend a cheap or free FTP program that will let me change the 
> file permission? I use EFTP & if I am doing this right I keep getting this 
> error:
> error encountered 500'SITE CHMOD 777 / command not understood
> error encountered 500'SITE CHMOD 755 / command not understood
> 
> Thanks
> Dennis
> 
> At 05:40 PM 7/22/2006, Shag wrote:
> >As for your config.php problem. I've never heard of making a file
> >read-only, and then tranfering it to another system.  You need to change 
> >it on the system that
> >PGV resides.  Couple ways of doing that, most FTP programs will allow you 
> >to chmod a file,
> >depending on the host your using, almost all have some kind of file manger 
> >that will allow you
> >to change your file permissions.  If your using cpanel, the capability is 
> >there.  One thing to
> >keep in mind is sometimes it takes a couple of minutes for a change to 
> >filter through the
> >system, this is especially true in a cluster setup.
> >
> >john
> 
> 
> -- 
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.1.394 / Virus Database: 268.10.3/395 - Release Date: 7/21/2006
> 
> 
> 
> -------------------------------------------------------------------------
> 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] config.php file writable/read-only

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

Sorry I didn't make myself clearer. In Administration the screen says "Your 
config.php file is still writable. For security, you should set the 
permissions of this file back to read-only when you have finished 
configuring your site" I couldn't find a way to make it read-only in my FTP 
program, widows explorer or front page. So I downloaded it to my computer & 
changed the properties to read-only then uploaded back to my website.

Can you recommend a cheap or free FTP program that will let me change the 
file permission? I use EFTP & if I am doing this right I keep getting this 
error:
error encountered 500'SITE CHMOD 777 / command not understood
error encountered 500'SITE CHMOD 755 / command not understood

Thanks
Dennis

At 05:40 PM 7/22/2006, Shag wrote:
>As for your config.php problem. I've never heard of making a file
>read-only, and then tranfering it to another system.  You need to change 
>it on the system that
>PGV resides.  Couple ways of doing that, most FTP programs will allow you 
>to chmod a file,
>depending on the host your using, almost all have some kind of file manger 
>that will allow you
>to change your file permissions.  If your using cpanel, the capability is 
>there.  One thing to
>keep in mind is sometimes it takes a couple of minutes for a change to 
>filter through the
>system, this is especially true in a cluster setup.
>
>john


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.394 / Virus Database: 268.10.3/395 - Release Date: 7/21/2006

Re: [Phpgedview-talk] MySql & multiple databases

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

Can't help much with the picture problem, as I use another program.  But you might want to 
make sure that your media directory and files within are all chmod to 777.  I think that might 
fix your picture problem.  As for your config.php problem. I've never heard of making a file 
read-only, and then tranfering it to another system.  You need to change it on the system that 
PGV resides.  Couple ways of doing that, most FTP programs will allow you to chmod a file, 
depending on the host your using, almost all have some kind of file manger that will allow you 
to change your file permissions.  If your using cpanel, the capability is there.  One thing to 
keep in mind is sometimes it takes a couple of minutes for a change to filter through the 
system, this is especially true in a cluster setup.

john

On 22 Jul 2006 at 15:33, dennis wrote:

> I went ahead & set it up (1 copy of PGV and multi-gedcom files). I guess 
> MySQL was what I needed because the search is accessing both gedcoms.
> 
> The 2 things I need to figure out now is how to make config.php read-only 
> (I never did that in the past) & figure out why Legacy V.6 & PGV aren't 
> quite shaking hands when it comes to my default pictures. I don't think my 
> server allows me to change config.php to read-only online (?), when I 
> download the file change it to read-only then upload it I get a big error. 
> As far as the pictures I think it has something to do with the "_PRIM Y" in 
> the gedcom, as far as I can tell all the pictures have a _PRIM Y. I'm 
> trying to get the pictures I want to appear in the pedigree chart
> 
> Thank you
> Dennis
> 
> At 02:21 PM 7/22/2006, you wrote:
> >You can use the same database, but you need to give each database a 
> >different prefix.  This is if
> >you plan to have *9* separate running copies of PGV.  If you are going to 
> >have *one* running
> >copy of PV, you can upload as many gedcom files as you can handle.  With 
> >one copy of PGV
> >and multi-gedcom files, everyone may have access to each gedcom file.  It 
> >depends on how you
> >set it up.  Which are you planning to do?
> >
> >john
> 
> 
> -- 
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.1.394 / Virus Database: 268.10.3/395 - Release Date: 7/21/2006
> 
> 
> 
> -------------------------------------------------------------------------
> 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] MySql & multiple databases

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

I went ahead & set it up (1 copy of PGV and multi-gedcom files). I guess 
MySQL was what I needed because the search is accessing both gedcoms.

The 2 things I need to figure out now is how to make config.php read-only 
(I never did that in the past) & figure out why Legacy V.6 & PGV aren't 
quite shaking hands when it comes to my default pictures. I don't think my 
server allows me to change config.php to read-only online (?), when I 
download the file change it to read-only then upload it I get a big error. 
As far as the pictures I think it has something to do with the "_PRIM Y" in 
the gedcom, as far as I can tell all the pictures have a _PRIM Y. I'm 
trying to get the pictures I want to appear in the pedigree chart

Thank you
Dennis

At 02:21 PM 7/22/2006, you wrote:
>You can use the same database, but you need to give each database a 
>different prefix.  This is if
>you plan to have *9* separate running copies of PGV.  If you are going to 
>have *one* running
>copy of PV, you can upload as many gedcom files as you can handle.  With 
>one copy of PGV
>and multi-gedcom files, everyone may have access to each gedcom file.  It 
>depends on how you
>set it up.  Which are you planning to do?
>
>john


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.394 / Virus Database: 268.10.3/395 - Release Date: 7/21/2006

Re: [Phpgedview-talk] MySql & multiple databases

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

You can use the same database, but you need to give each database a different prefix.  This is if 
you plan to have *9* separate running copies of PGV.  If you are going to have *one* running 
copy of PV, you can upload as many gedcom files as you can handle.  With one copy of PGV 
and multi-gedcom files, everyone may have access to each gedcom file.  It depends on how you 
set it up.  Which are you planning to do?

john 

On 20 Jul 2006 at 19:39, dennis wrote:

> Just about ready to upload PHPGedView but have a question about MySql & 
> multiple databases. Do you need a separate MySql databases for each gedcom 
> or will they all go into 1? For my package I only get one & 1 MySql 
> databases, and I am planning on putting 9 gedcoms online (about 2.9 meg). I 
> help a lot of family members.
> 
> Also when I had ver. 3.3.3(?) up I think you were supposedly able to be 
> able to search multiple databases, but in index mode I was only search the 
> database I was in. Will ver. 4 search all the databases in index mode?
> 
> Dennis
> 
> 
> -- 
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.1.394 / Virus Database: 268.10.3/394 - Release Date: 7/20/2006
> 
> 
> 
> -------------------------------------------------------------------------
> 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] MySql & multiple databases

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

Just about ready to upload PHPGedView but have a question about MySql & 
multiple databases. Do you need a separate MySql databases for each gedcom 
or will they all go into 1? For my package I only get one & 1 MySql 
databases, and I am planning on putting 9 gedcoms online (about 2.9 meg). I 
help a lot of family members.

Also when I had ver. 3.3.3(?) up I think you were supposedly able to be 
able to search multiple databases, but in index mode I was only search the 
database I was in. Will ver. 4 search all the databases in index mode?

Dennis


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.394 / Virus Database: 268.10.3/394 - Release Date: 7/20/2006

[Phpgedview-talk] Question about language help

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

I setup an user to use Spanish, and I noticed that none of the help was in 
Spanish.  Is this because the help files haven't been translated or am I 
doing something wrong?

john

Re: [Phpgedview-talk] Has anyone had problems with hackers?

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

Dennis,
=20
MySQL is slightly more secure than index mode because you are not =
reading in so many files.  But the biggest reason to switch to a DB =
backend is for speed and stability.
=20
You can disable the option for visiters to request user accounts in the =
configuration.
=20
--John

________________________________

From: php...@li... on behalf of dennis
Sent: Wed 7/12/2006 7:48 PM
To: php...@li...
Subject: [Phpgedview-talk] Has anyone had problems with hackers?



I am getting real tired of my plain html webpage & want to go back to
PHPGenView but was wondering if anyone has had anymore hackers? It was =
back
in early 2006 & I was using an old 3.x version in index mode(?). Will =
using
MySQL help keep hackers out? I belive I was hacked with SAMARINDAHACK

Also I don't want to have others trying to request a user account, is =
there
a way to keep the login off the main page?

I really like what people have done with the ver 4.x !!!

Thanks for any help
Dennis


--

No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.394 / Virus Database: 268.9.10/386 - Release Date: =
7/12/2006




-------------------------------------------------------------------------=

Using Tomcat but need to do more? Need to support web services, =
security?
Get stuff done quickly with pre-integrated technology to make your job =
easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache =
Geronimo
http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=3D=
121642
_______________________________________________
Phpgedview-talk mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpgedview-talk

Re: [Phpgedview-talk] Has anyone had problems with hackers?

[Heike El-A. - T. <hei...@ya...>]

Hi Dennis,
   
  yes, I had problems with hackers.
  Since two days ago again. Two times a user has been added, fortunately
  without verification, so I assume no dammage has been done.
  I was told MySQL will keep hackers out, just haven't found time yet
  to switch from Index to SQL...
   
  Regards,
  Heike

dennis <den...@ur...> schrieb:
  I am getting real tired of my plain html webpage & want to go back to 
PHPGenView but was wondering if anyone has had anymore hackers? It was back 
in early 2006 & I was using an old 3.x version in index mode(?). Will using 
MySQL help keep hackers out? I belive I was hacked with SAMARINDAHACK

Also I don't want to have others trying to request a user account, is there 
a way to keep the login off the main page?

I really like what people have done with the ver 4.x !!!

Thanks for any help
Dennis


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.394 / Virus Database: 268.9.10/386 - Release Date: 7/12/2006




-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Phpgedview-talk mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpgedview-talk


 		
---------------------------------
Jetzt Mails schnell in einem Vorschaufenster überfliegen. Dies und viel mehr bietet das  neue Yahoo! Mail .

[Phpgedview-talk] Has anyone had problems with hackers?

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

I am getting real tired of my plain html webpage & want to go back to 
PHPGenView but was wondering if anyone has had anymore hackers? It was back 
in early 2006 & I was using an old 3.x version in index mode(?). Will using 
MySQL help keep hackers out? I belive I was hacked with SAMARINDAHACK

Also I don't want to have others trying to request a user account, is there 
a way to keep the login off the main page?

I really like what people have done with the ver 4.x !!!

Thanks for any help
Dennis


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.394 / Virus Database: 268.9.10/386 - Release Date: 7/12/2006

Re: [Phpgedview-talk] V4 import w postgresql

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

there is a time limit on how long a script can run as well as a time limit on how long a http connection can last... i 
forget exactly where it is, but in the config for the ged that you are importing, there is a setting for how long the 
script can run... on many of mine, i have to set it really high (ie: 20+ minutes) to get all the import stuffs done... 
after that, i generally set it back to something more normal for general operation...

vincebr549 wrote:
> Tnx for your input...
> I'm running this on php-4.3.11-2.8
> 
> I saw a bunch of memory shortages earlier when I first started
> trying to  do the instal.  When that happened it told me with a message
> indicating how much it had and how much it wanted, (I have the option
> to report php errors turned on).
> 
> It was running out at 32M, I bumpted it up to 48Mb,  the memory shortage
> messages stopped
> but still can't include married names.

-- 
        _\/
       (@@)                      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] Hello and suggested optimization

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

Me too...  My gedcom file is abt 5Mb running on a 750 Mhz 258Mb weber server
with little else running.
before your index, it took a good 30 minutes (not seconds) to see the
welcome page.
now it is down to 15 seconds for the welcome page.
tnx for your help.

Obviously, I could use some more tuning.
I'm looking into some kind of php - precompiling tho it appears beyond by
expertese.  See
http://www.linuxjournal.com/article/5661

Maybe it's already in there.
v


-- 
View this message in context: http://www.nabble.com/Hello-and-suggested-optimization-tf1733429.html#a5296120
Sent from the phpgedview-talk forum at Nabble.com.

Re: [Phpgedview-talk] external SQL updates - sync gedcom file

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

txn for your input.  So I guess you are saying there is an export function
which will create the gedcom file in a state that matches the database.
I'm assuming that if I updated the database without updating the "copy" of
the gedcom in
the gedview index, that bad things would happen.

-- 
View this message in context: http://www.nabble.com/external-SQL-updates---sync-gedcom-file-tf1926380.html#a5295940
Sent from the phpgedview-talk forum at Nabble.com.

Re: [Phpgedview-talk] external SQL updates - sync gedcom file

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

tnx for your input, but I apparently was not clear in my answer, see next
persons
reply which is closer to what I was looking for.

v

-- 
View this message in context: http://www.nabble.com/external-SQL-updates---sync-gedcom-file-tf1926380.html#a5295892
Sent from the phpgedview-talk forum at Nabble.com.

Re: [Phpgedview-talk] V4 import w postgresql

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

Tnx for your input...
I'm running this on php-4.3.11-2.8

I saw a bunch of memory shortages earlier when I first started
trying to  do the instal.  When that happened it told me with a message
indicating how much it had and how much it wanted, (I have the option
to report php errors turned on).

It was running out at 32M, I bumpted it up to 48Mb,  the memory shortage
messages stopped
but still can't include married names.

v

-- 
View this message in context: http://www.nabble.com/V4-import-w-postgresql-tf1926349.html#a5295843
Sent from the phpgedview-talk forum at Nabble.com.

Re: [Phpgedview-talk] V4 import w postgresql

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

PHP probably ran out of memory.  The default PHP setting is 8MB.  You
can try to increase this in your PGV configuration or in the php.ini
file.

It takes a lot of memory to run the married names because you have to
have all of the people loaded up and all of the families loaded up in
order to calculate what the married names should be.

--John

-----Original Message-----
From: php...@li...
[mailto:php...@li...] On Behalf Of
vincebr549
Sent: Tuesday, July 11, 2006 12:41 PM
To: php...@li...
Subject: [Phpgedview-talk] V4 import w postgresql


I'm trying to include the married names.  After the first part completes
I get a status bar for the 2nd part, it runs about 2% then stops
in the postgresql log I see.
Jul 11 13:50:51 web postgres[16959]: [4-1] LOG:  duration: 3380.199 ms=20
statemen
t: SELECT * FROM pgv_individuals WHERE i_file=3D'1' ORDER BY i_surname
Jul 11 13:51:15 web postgres[16959]: [5-1] LOG:  unexpected EOF on
client
connec
tion

Is this possibly because it timed out?
my import file is about 5Mb

--=20

Sent from the phpgedview-talk forum at Nabble.com.



------------------------------------------------------------------------
-
Using Tomcat but need to do more? Need to support web services,
security?
Get stuff done quickly with pre-integrated technology to make your job
easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache
Geronimo
http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=3D=
121642
_______________________________________________
Phpgedview-talk mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpgedview-talk

Re: [Phpgedview-talk] external SQL updates - sync gedcom file

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

Yes, you could alter the data in the SQL tables and then export the data
from PhpGedView back into the GEDCOM format.

Probably easier though to edit the GEDCOM file in a text editor with
regular expression capable search and replacing and then import the file
back into PGV again.

--John


-----Original Message-----
From: php...@li...
[mailto:php...@li...] On Behalf Of
vincebr549
Sent: Tuesday, July 11, 2006 12:45 PM
To: php...@li...
Subject: [Phpgedview-talk] external SQL updates - sync gedcom file


Im new to both geneology and phpgeview (v4)
I got a gedcom file of abt 5M from a relative.
It has a hugh number of obious errors in it that I would like to
correct.
eg some states are abriviated some not,
some names all caps some not.  I've built a list.

Is it possible to use sql to update the data base then somehow
put the gedcom file back in sync?

v


--=20

Sent from the phpgedview-talk forum at Nabble.com.



------------------------------------------------------------------------
-
Using Tomcat but need to do more? Need to support web services,
security?
Get stuff done quickly with pre-integrated technology to make your job
easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache
Geronimo
http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=3D=
121642
_______________________________________________
Phpgedview-talk mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpgedview-talk

Re: [Phpgedview-talk] external SQL updates - sync gedcom file

[Duncan L. <du...@li...>]

On Tue, 2006-07-11 at 11:45 -0700, vincebr549 wrote:
> Im new to both geneology and phpgeview (v4)
> I got a gedcom file of abt 5M from a relative.
> It has a hugh number of obious errors in it that I would like to correct.
> eg some states are abriviated some not,
> some names all caps some not.  I've built a list.
First of all I suggest that whatever you do is done together with
whoever made the file. If they've done so much work before, then you
want to keep working with them. If you run through the file 'fixing' it
and they disagree with what you've done then you'll have two seperate
databases. Bad bad bad thing to have.

If you can convince the other person that phpgedview online is a good
way to edit then you _together_ can make an agreement on what to change,
and do it together, on the same database.

>=20
> Is it possible to use sql to update the data base then somehow
> put the gedcom file back in sync?
I'm useless at SQL, but that sounds that the hard way to do it.

Duncan

--=20
Linux user: 372812 | GPG key ID: 21A8C63A | http://lithgow-schmidt.dk

[Phpgedview-talk] external SQL updates - sync gedcom file

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

Im new to both geneology and phpgeview (v4)
I got a gedcom file of abt 5M from a relative.
It has a hugh number of obious errors in it that I would like to correct.
eg some states are abriviated some not,
some names all caps some not.  I've built a list.

Is it possible to use sql to update the data base then somehow
put the gedcom file back in sync?

v


-- 
View this message in context: http://www.nabble.com/external-SQL-updates---sync-gedcom-file-tf1926380.html#a5275446
Sent from the phpgedview-talk forum at Nabble.com.

[Phpgedview-talk] V4 import w postgresql

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

I'm trying to include the married names.  After the first part completes
I get a status bar for the 2nd part, it runs about 2% then stops
in the postgresql log I see.
Jul 11 13:50:51 web postgres[16959]: [4-1] LOG:  duration: 3380.199 ms 
statemen
t: SELECT * FROM pgv_individuals WHERE i_file='1' ORDER BY i_surname
Jul 11 13:51:15 web postgres[16959]: [5-1] LOG:  unexpected EOF on client
connec
tion

Is this possibly because it timed out?
my import file is about 5Mb

-- 
View this message in context: http://www.nabble.com/V4-import-w-postgresql-tf1926349.html#a5275336
Sent from the phpgedview-talk forum at Nabble.com.

Re: [Phpgedview-talk] mysql config

[Duncan L. <du...@li...>]

On Wed, 2006-07-05 at 19:35 -0400, =3D?ISO-8859-1?B?lSA=3D?=3DMichael Weine=
r
wrote:
> On 7/5/06 4:55 PM, "Duncan Lithgow" <du...@li...> wrote:
>=20
> > Sorry about this easy question, but I can't find the answer anywhere.
> >=20
Well I was right about it being silly. I should have remembered that
file, I just hadn't looked at it for a few weeks.

All working nicely now, thanks.

Duncan
--=20
Linux user: 372812 | GPG key ID: 21A8C63A | http://lithgow-schmidt.dk

Re: [Phpgedview-talk] mysql config

[Michael W. <hu...@us...>]

On 7/5/06 4:55 PM, "Duncan Lithgow" <du...@li...> wrote:

> Sorry about this easy question, but I can't find the answer anywhere.
> 
> Which file do i edit to change the settings for connecting to mysql? The
> site is broken so I can't do anything through the site's interface.
> 
> Duncan

Duncan - 

THose settings are found in the config.php file in your phpgedview webroot
(i.e. /var/www/html/gallery2 is where its at on my unix server)

HTH
Michael Weiner