ERROR:Unknown column 'i_isdead'

Brought to you by: canajun2eh, yalnifj

ERROR:Unknown column 'i_isdead'

Forum: Help

Creator: Steve Lowmaster

Created: 2003-06-20

Updated: 2003-06-20

Steve Lowmaster - 2003-06-20

I get the following error message when I open the web page for the MYSQL version and no one is logged in.

ERROR:Unknown column 'i_isdead' in 'field list'
SQL:SELECT i_isdead FROM pgv_individuals WHERE i_id='I521493818' AND i_file='ober.ged' (Bright Red)

Below that the following error message appears.

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/dns/public_html/phpGedView/functions.php on line 117 (Black)

It goes away as soon as you login. This is showing up on ped. des and ind. listing.

Any idea what needs rest ??

Thanks Steve

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Steve Lowmaster - 2003-06-20
  
  I reloaded the gedcom files and the error went away.
  
  The program seems to be running great at this point.
  
  Steve
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- John Finlay - 2003-06-20
  
  I changed the pgv_individuals table in version 2.11 to include an i_isdead column. Version 2.11 precalculates if a person is dead or not during import to try and speed up the pages. It slightly increases performance.
  
  So with v2.11 you will need to destroy your tables and reimport your gedcoms.
  
  --John
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.