#1880 (4.1.3) SQLite Error .

closed-fixed
None
9
2008-01-16
2008-01-15
JAS
No

http://srnec.ic.cz
mySQL
PGV ver. 4.1.3

ERROR:-1 DB Error: unknown error
SQL:1 ** SELECT d_gid, i_gedcom, 'INDI', d_type, d_day, d_month, d_year, d_fact FROM pgv_dates, pgv_individuals WHERE d_type='@#DHEBREW@' AND d_day<=1 AND (d_mon=6 AND MOD(7*d_year+1,19)<7) AND d_year<=5768 AND d_fact NOT IN ('CHAN','BAPL','SLGC','SLGS','ENDL','CENS','RESI','NOTE','ADDR','OBJE','SOUR','PAGE','DATA','TEXT') AND d_file=1 AND d_gid=i_id AND d_file=i_file ORDER BY d_day ASC, d_year DESC [nativecode=no such function: MOD]

Fatal error: Call to undefined function: fetchrow() in /home/free/ic.cz/s/srnec/root/www/includes/functions_db.php on line 2990

Discussion

  • JAS

    JAS - 2008-01-15
    • summary: Error. --> (4.1.3) mySQL Error .
     
  • JAS

    JAS - 2008-01-15
    • priority: 5 --> 9
     
  • JAS

    JAS - 2008-01-15
    • assigned_to: nobody --> yalnifj
     
  • Anonymous - 2008-01-15

    Logged In: YES
    user_id=1910459
    Originator: NO

    In your summary you say your database is mySQL - but on your site (http://srnec.ic.cz) it shows 'sqlite' (found by hover over PGV icon at bottomm of page). So perhaps your config for the datbase type is wrong.

     
  • JAS

    JAS - 2008-01-16
    • assigned_to: yalnifj --> nobody
     
  • JAS

    JAS - 2008-01-16
    • summary: (4.1.3) mySQL Error . --> (4.1.3) SQLite Error .
    • labels: 503773 -->
     
  • JAS

    JAS - 2008-01-16

    Logged In: YES
    user_id=1981934
    Originator: YES

    No mySQL database SQLite. My error.

     
  • Greg Roach

    Greg Roach - 2008-01-16

    Logged In: YES
    user_id=1466942
    Originator: NO

    Someone raised this on the help forum last year. I coded a fix for it, but nobody confirmed that it worked, so I didn't commit the fix to SVN.

    If you can test (preferably against SVN), let me know.

    Greg

     
  • JAS

    JAS - 2008-01-16

    Logged In: YES
    user_id=1981934
    Originator: YES

    Dear user,

    Can you please test the provided solution and let us know if this
    solved your issue? We can then either continue working on your
    bug or close it.

    With kind regards,

    The PGV Team

     
  • JAS

    JAS - 2008-01-16

    Logged In: YES
    user_id=1981934
    Originator: YES

    TO fisharebest.
    I will try cooperate, I need description.
    I don't know much English, perhaps it resolution.
    John

     
  • JAS

    JAS - 2008-01-16
    • status: open --> wont-fix
     
  • Greg Roach

    Greg Roach - 2008-01-16

    Patch for v4.1.3

     
  • Greg Roach

    Greg Roach - 2008-01-16

    Logged In: YES
    user_id=1466942
    Originator: NO

    Fixed in SVN2470.

    Attached is a patch for 4.1.3
    File Added: functions_db.php

     
  • Greg Roach

    Greg Roach - 2008-01-16
    • milestone: 352717 -->
    • assigned_to: nobody --> fisharebest
    • status: wont-fix --> closed-fixed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks