#2688 Running report gives DB unknown error

v4.2.1
closed-rejected
nobody
None
5
2009-10-07
2009-10-07
boatersteve
No

Hello, my ISP does not provide PDO/MySQL, so I have installed v4.2.1 onto my site. All is well, except that when running a report i get the following error message:
ERROR:-1 DB Error: unknown error
SQL:1 ** SELECT i_gedcom FROM pgv_individuals WHERE i_id LIKE '$pid' ESCAPE '@' AND i_file=3 UNION ALL SELECT f_gedcom FROM pgv_families WHERE f_id LIKE '$pid' ESCAPE '@' AND f_file=3 UNION ALL SELECT s_gedcom FROM pgv_sources WHERE s_id LIKE '$pid' ESCAPE '@' AND s_file=3 UNION ALL SELECT m_gedrec FROM pgv_media WHERE m_media LIKE '$pid' ESCAPE '@' AND m_gedfile=3 UNION ALL SELECT o_gedcom FROM pgv_other WHERE o_id LIKE '$pid' ESCAPE '@' AND o_file=3 [nativecode=sqlite_query() [function.sqlite-query]: near "ESCAPE": syntax error]

Fatal error: Call to undefined method DB_Error::fetchRow() in /services2/webpages/p/y/pyrfordbasin.co.uk/public/PhpGedview/includes/functions/functions_db.php on line 1319

I have tried all sorts! A similar thing happened when trying to add facts. This happens whether logged in or not.
Can you help? What is wrong?

The web address is http://www.dbh.org.uk

Thanks in anticipation.

Regards
Steve

Discussion

  • Greg Roach

    Greg Roach - 2009-10-07

    Your server is running sqlite2. PGV4.2 requires features that are only available in sqlite3.

    This is part of the reason for the change to PDO. It provides sqlite3, whereas the old Pear::DB interface used by PGV4.2.1 provides only sqlite2.

    PGV4.2.1 will work happily using MySQL (using Pear::DB). If your host offers MySQL, and you need help configuring this, then please ask on the help forum.

    If not, then there is little we can do to help :-(

    Sorry.

     
  • Greg Roach

    Greg Roach - 2009-10-07
    • status: open --> closed-rejected
     

Log in to post a comment.