User:Nickj

From PGVWiki
Jump to navigation Jump to search

Install details

Currently running PHPGedView 4.1.5, for this site, and it's hosted at DreamHost.

Upgrade Problem for 4.2

Having difficulty upgrading to 4.2 through DreamHost's panel, which gives errors like this:

ERROR:-19 DB Error: no such field
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']

ERROR:-18 DB Error: no such table
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]

ERROR:-19 DB Error: no such field
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']

ERROR:-19 DB Error: no such field
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']

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

ERROR:-19 DB Error: no such field
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']

ERROR:-19 DB Error: no such field
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<=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']

Fatal error: Call to undefined method DB_Error::fetchRow() in /home/roubin_ged/familytree.roubin.com/includes/functions/functions_db.php on line 2528

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: A GEDCOM with this file name has already been imported into the database.

... 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!

Contacting

For reaching me, please use the wiki's email function.

-- All the best, Nick.