Re: [Phpgedview-talk] Errors when importing GEDCOM

[Douglas H. <ob...@ho...>]

Well, without having an install of my own, I can at least tell you that 
the errors are due to the values being enclosed in double quotes " " 
instead of single quotes ' '. Postgres assumes " " encase a column
NAME, not a column VALUE.

Sam Anderson wrote:
>
> I followed the installation instructions from the WIKI as best I 
> could, but upon importing my GEDCOM, I got PAGES of SQL Insert errors, 
> finally terminating in a memory exhausted error. It looks like it 
> can’t insert the places into my places table.
>
> Any ideas?
>
> Thanks in advance,
>
> SAM
>
>
> *ERROR:-19 DB Error: no such field
> SQL:INSERT* INTO pgv_places (p_id, p_place, p_level, p_parent_id, 
> p_file) VALUES(2517, "Of Roch Castle", 2, 2516, 1) [nativecode=1054 ** 
> Unknown column 'Of Roch Castle' in 'field list']
>
> *ERROR:-19 DB Error: no such field
> SQL:INSERT* INTO pgv_places (p_id, p_place, p_level, p_parent_id, 
> p_file) VALUES(2518, "Maine", 2, 732, 1) [nativecode=1054 ** Unknown 
> column 'Maine' in 'field list']
>
> *ERROR:-19 DB Error: no such field
> SQL:INSERT* INTO pgv_places (p_id, p_place, p_level, p_parent_id, 
> p_file) VALUES(2519, "Of Luce Near", 3, 2518, 1) [nativecode=1054 ** 
> Unknown column 'Of Luce Near' in 'field list']
>
>
> *Fatal error*: Allowed memory size of 33554432 bytes exhausted (tried 
> to allocate 941 bytes) in 
> */var/www/html/whiteeyebrows.com/familyhistory/includes/functions_import.php* 
> on line *1458*
>
> ------------------------------------------------------------------------
>
> -------------------------------------------------------------------------
> 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
>