Menu

v2.51.3 probs importing records into database

Help
Anonymous
2003-10-07
2003-10-07
  • Anonymous

    Anonymous - 2003-10-07

    Everything was going quite smoothly until I started importing the gedcom records into database (the MySQL version). After processing the file for 53 seconds it stopped with a Continue Adding button, followed by this warning:
    Warning: fclose(): 30 is not a valid stream resource in .../phpGedView/importgedcom.php on line 189

    On clicking button, import is completed. Although the Individual List is fine, the charts don't work and show mesages like:
    Notice: Undefined offset: 1 in .../phpGedView/index.php on line 197

    Please help - new at this!

    Adrian

     
    • John Finlay

      John Finlay - 2003-10-07

      Hi Adrian,

      You ran into the problem that your gedcom is too big to import all at once in only 60 seconds.  The first thing to try is increasing your time limit.  To do this you need to do is log in as the Admin and edit your gedcom configuration (follow the Admin->Manage Gedcoms->Edit links) and set the Time Limit to 120.  Then try to import again. 

      If you get a timeout error, or still don't finish, you can download an updated importgedcom.php script that will work after you click the "Continue Adding" button here:
      http://sourceforge.net/tracker/download.php?group_id=55456&atid=477082&file_id=63701&aid=784659

      --John

       
      • Anonymous

        Anonymous - 2003-10-07

        John,

        I increased the time limit to 120... same problem... then tried 240 and it worked! Strangely, it said it took 97 seconds - don't know why it didn't work with time limit at 120.

        Thanks - very pleased - looks great.

        Adrian

         

Log in to post a comment.