https://wiki.phpgedview.net/en/index.php?action=history&feed=atom&title=User%3ANickj 2026-05-26T10:50:41Z Revision history for this page on the wiki MediaWiki 1.34.2 https://wiki.phpgedview.net/en/index.php?title=User:Nickj&diff=11969&oldid=prev 2010-01-08T07:58:36Z

<p>Add info about why I am here and what version of PHPGedView I am running, and contact details.</p> <p><b>New page</b></p><div>== Install details ==<br /> <br /> Currently running PHPGedView 4.1.5, for [http://familytree.roubin.com/ this site], and it's [[web hosting|hosted]] at DreamHost.<br /> <br /> == Upgrade Problem for 4.2 == <br /> <br /> Having difficulty upgrading to 4.2 through DreamHost's panel, which gives errors like this:<br /> <br /> &lt;pre&gt;<br /> ERROR:-19 DB Error: no such field<br /> SQL:SELECT 'INDI' AS type, i_id AS xref, 1 AS ged_id, i_gedcom AS gedrec, i_isdead, i_sex FROM pgv_individuals WHERE i_id='' AND i_file=1 [nativecode=1054 ** Unknown column 'i_sex' in 'field list']<br /> <br /> ERROR:-18 DB Error: no such table<br /> SQL:SELECT COUNT( DISTINCT n_surn) AS tot FROM pgv_name WHERE n_file=1 [nativecode=1146 ** Table 'roubin_ged.pgv_name' doesn't exist]<br /> <br /> ERROR:-19 DB Error: no such field<br /> SQL:SELECT 'INDI' AS type, i_id AS xref, 1 AS ged_id, i_gedcom AS gedrec, i_isdead, i_sex FROM pgv_individuals WHERE i_id='I157' AND i_file=1 [nativecode=1054 ** Unknown column 'i_sex' in 'field list']<br /> <br /> ERROR:-19 DB Error: no such field<br /> SQL:SELECT 'INDI' AS type, i_id AS xref, 1 AS ged_id, i_gedcom AS gedrec, i_isdead, i_sex FROM pgv_individuals WHERE i_id='I157' AND i_file=1 [nativecode=1054 ** Unknown column 'i_sex' in 'field list']<br /> <br /> Fatal error: Call to a member function format_list() on a non-object in /home/roubin_ged/familytree.roubin.com/includes/classes/class_stats.php on line 956<br /> <br /> ERROR:-19 DB Error: no such field<br /> SQL:SELECT 'INDI' AS type, i_id AS xref, 1 AS ged_id, i_gedcom AS gedrec, i_isdead, i_sex FROM pgv_individuals WHERE i_id='I241' AND i_file=1 [nativecode=1054 ** Unknown column 'i_sex' in 'field list']<br /> <br /> ERROR:-19 DB Error: no such field<br /> SQL:SELECT DISTINCT 'INDI' AS type, i_id AS xref, i_file AS ged_id, i_gedcom AS gedrec, i_isdead, i_sex, d_type, d_day, d_month, d_year, d_fact, d_type FROM pgv_dates, pgv_individuals WHERE d_type='@#DGREGORIAN@' AND d_day=3 AND d_mon=1 AND d_year&lt;=2010 AND d_fact NOT IN ('CHAN','BAPL','SLGC','SLGS','ENDL','CENS','RESI','NOTE','ADDR','OBJE','SOUR','PAGE','DATA','TEXT','_TODO') AND d_file=1 AND d_gid=i_id AND d_file=i_file ORDER BY d_day ASC, d_year DESC [nativecode=1054 ** Unknown column 'i_sex' in 'field list']<br /> <br /> Fatal error: Call to undefined method DB_Error::fetchRow() in /home/roubin_ged/familytree.roubin.com/includes/functions/functions_db.php on line 2528<br /> &lt;/pre&gt;<br /> <br /> Then tried to follow the manual instructions on the [[upgrading]] page, but got stuck at the instruction for re-importing the GEDCOM file: Shows the error: &lt;font color=red&gt;A GEDCOM with this file name has already been imported into the database.&lt;/font&gt;<br /> <br /> ... and at this point, I am stuck with an install that gives PHP and SQL errors, and which won't let me re-import my data to try to fix those errors!<br /> <br /> == Contacting ==<br /> <br /> For reaching me, please use the wiki's [[Special:EmailUser/Nickj|email function]].<br /> <br /> -- All the best,<br /> Nick.</div>

Nickj