#2827 Fatal error: Uncaught exception 'PDOException'

v4.3.0
closed-fixed
nobody
None
5
2010-09-14
2010-09-12
Otmar
No

In august 2010 I did import an GEDCOM (31MB) with ca 67.700 individuals. All works fine, but if I call the function "family lists", then I get this error message:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or
access violation: 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and
use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay' in
/var/www/xxxx/html/pgv/includes/classes/class_pgv_db.php:830 Stack trace: #0
/var/www/xxxx/html/pgv/includes/classes/class_pgv_db.php(830): PDOStatement->execute() #1
[internal function]: PGV_DBStatement->__call(Array, Array) #2
/var/www/xxxx/html/pgv/includes/classes/class_pgv_db.php(897):
PGV_DBStatement->execute('execute', Array) #3
/var/www/xxxx/html/pgv/includes/functions/functions_db.php(280):
PGV_DBStatement->fetchOneColumn() #4 /var/www/wxxxx/html/pgv/famlist.php(86):
get_indilist_salpha() #5 {main} thrown in
/var/xxxx/html/pgv/includes/classes/class_pgv_db.php on line 830

Today I made an import of a second GEDCOM (ca. 380 individuals) in the same database. With this data the function "family lists" works fine.

I've also a second database. Here I#ve no problems:
p.e. http://www.verwandten.info/public/famlist.php?ged=adel.GED&surname=WELSPERG
(this link works fine)

What can be the reason for this problem? Since today I hadn't this error message.

Discussion

  • Greg Roach

    Greg Roach - 2010-09-12

    I have not used PGV for a long time, and cannot test this, but here is a suggestion:

    In the file includes/classes/class_pgv_db.php, at line 131

    change

    SET NAMES 'utf8'

    to

    SET NAMES 'utf8', SQL_BIG_SELECTS=1

     
  • Otmar

    Otmar - 2010-09-12

    Thank for the helping. PGV works again with this new file.

    Otmar

     
  • Stephen Arnold

    Stephen Arnold - 2010-09-14

    Otmar
    Can you now close this bug report, as FIXED in SVN. It would be appreciated.
    Stephen

     
  • Otmar

    Otmar - 2010-09-14
    • status: open --> closed-fixed
     
  • Otmar

    Otmar - 2010-09-14

    This problem has been fixed in SVN.

    Please can you check that the fix works for you.

    If you agree that the problem is fixed, you should change the bug status to "Closed".

    If you think the problem is not fixed, please provide further information.

    Regards,

    The PGV Team

     

Log in to post a comment.