[Loris-dev] Loris issues with updating some SQL tables (dealing with instruments)

[Krisanne Litinas]

Hi all,

I'm working on configuring a Loris instance using the newly-released
14.12.1 package.  For right now I'm trying mostly to get instruments set up
and then able to be queried via the DQT.  I am running into a few issues
mainly in regards to SQL update statements - I'm wondering if they are
related and may point to some other issue in my system configuration:


   - For any instrument that I've tried, I have no issues seeing and
   interacting with the form on the front end.  But then when I click the Save
   Data button it gives me the error that the Update statement could not
   execute successfully.  However, when I look at the update statement it's
   attempting (I have showDatabaseQueries set to 1), nothing looks out of
   order and I can actually execute it just fine via command line.  I'm having
   this problem with instruments created from the instrument builder as well
   as from scratch.  My apache logs are giving warnings about
   CertificationInstruments and CertificationProject variables not being
   defined in NDB_BVL_Instrument.class.inc, but I don't know if that's related
   or not.

   - Sidestepping the first issue for now, I also was trying to execute the
   data_dictionary_builder.php script on an instrument to send it to the DQT.
   Again I get an error when it tries to do an SQL insert... yet I can execute
   that insert statement just fine via terminal.  It does update the
   parameter_type_category table as expected, but errors out when it gets to
   the point of writing to parameter_type.


Wondering if anyone can think of anything obvious to check?  I'd appreciate
any ideas.

Thanks,
-Krisanne
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.bic.mni.mcgill.ca/pipermail/loris-dev/attachments/20150311/877980bc/attachment.html>