Menu ▾ ▴

PHP MYSQL error

Help
Anonymous
2010-12-16
2013-05-30

  • Anonymous

    Anonymous - 2010-12-16

    Hi
    There were some problems on my hosted server yesterday and my PHPGEDView installation is playing up.

    The support team at the hosting company are wondering which table(s) is/are causing the following errors:

    Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE: Column not found: 1054 Unknown column 'id' in 'where clause'' in /home/thehogan/public_html/geneology/includes/classes/class_pgv_db.php:838 Stack trace: #0 /home/thehogan/public_html/geneology/includes/classes/class_pgv_db.php(838): PDOStatement->execute() #1 /home/thehogan/public_html/geneology/includes/classes/class_pgv_db.php(853): PGV_DBStatement->__call(Array, Array) #2 /home/thehogan/public_html/geneology/includes/classes/class_pgv_db.php(853): PGV_DBStatement->execute('execute', Array) #3 /home/thehogan/public_html/geneology/includes/classes/class_stats.php(3442): PGV_DBStatement->__call() #4 /home/thehogan/public_html/geneology/includes/classes/class_stats.php(3442): PGV_DBStatement->fetchAll('fetchAll', Array) #5 /home/thehogan/public_html/geneology/includes/classes/class_stats.php(2946): stats::_runSQL(2) #6 /home/thehogan/public_html/geneology/includes/classes/class_stats.php(2974): stats->_topTenGrandFamilyQuery(' SELECT COUNT(*…', in /home/thehogan/public_html/geneology/includes/classes/class_pgv_db.php on line 838

    Any suggestions?

    Thanks

    Feargal

     

  • ggpauly

    ggpauly - 2010-12-16

    Hi Feargal,

    When is the most recent backup?  If there have not been many changes since the last backup it might be easiest to restore the site from the backup.

    Otherwise, what do you see when you connect to the database with phpMyAdmin?

    George
    ancestortree.net

     

Log in to post a comment.