DB Error 19 after upgrading to 4.2

[Ashwin K]

I just upgraded PHPGedView to 4.2 and see the following error at all times. Login screen, Internal pages, etc...

==============================================
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']
==============================================

Cannot view the Gedcom.
Under Gedcom file it mentions: This GEDCOM has not yet been imported.
But when I select Import, I get "A GEDCOM with this file name has already been imported into the database."

What needs to be done? Please help.

[Stephen Arnold]

IMPORT your gedcom. You can not upgrade without a re-import of your gedcom. It is kindly warning you that the DB contains you most recent copy and - ARE YOU SURE - you wish to erase the GEDCOM tables in SQL and replace them with those in your GEDCOM text file upon re-import.  Are you using the most recent version? If not, EXPORT or DOWNLOAD it from SQL, then BACKUP your SQL, then re-import.  The upgrade added several new fields in several tables and PGV needs these to function in v4.2
-Stephen