DB error when indexing fedora objects into fe

Help
Paul Pound
2007-06-27
2012-10-29
  • Paul Pound

    Paul Pound - 2007-06-27

    We have used fedora-batch-ingest to ingest pdfs into fedora. We can see the items in fez as unindexed and we would now like to make the objects available in Fez. When we try to index them we get the error:
    Array
    (
    [0] => DB Error: no such field
    [1] => INSERT INTO
    fez.record_matching_field
    (
    rmf_rec_pid,
    rmf_rec_pid_num,
    rmf_dsid,
    rmf_xsdmf_id,
    rmf_int
    ) VALUES (
    'upei:batch1-115',
    batch1-115,
    '',
    3673,'191') [nativecode=1054 ** Unknown column 'batch1' in 'field list']
    )

    include/class.record.php 757
    Backtrace:

    We have generated our own pids similar to upei:batch1-100. It looks like Fez expects a number after the namespace and nothing else. Is that correct?

    Thanks,
    Paul

     
    • Christiaan

      Christiaan - 2007-06-27

      Hi Paul

      Yes this is correct. It seems to be an oversight on our part as another person has enquired about this. The fix will be removing the rec_pid_num column and associated php/sql code to only look at the full varchar pid. You could modify the code to stop the sql trying to insert teh rec_pid_num and this would solve your problem.

      We are developing Fez 1.4 with non-numeric pid extensions in mind.

      Cheers,
      Christiaan

       

Log in to post a comment.

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

Sign up for the SourceForge newsletter:





No, thanks