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

[Justin Kat]

Hi Krisanne,

My initial guess would be to check that you are logging into mysql from the
command line using the same user as the one you have specified in your
config.xml file. It seems to me like you are running into issues at points
where you need to issue UPDATE and INSERT statements, and therefore I am
inclined to believe that it may be a mysql user privilege issue so I would
check that the user is properly granted sufficient privileges.

Justin

On Wed, Mar 11, 2015 at 1:25 PM, Krisanne Litinas <klitinas at umich.edu>
wrote:

> 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
>
> _______________________________________________
> Loris-dev mailing list
> Loris-dev at bic.mni.mcgill.ca
> http://www.bic.mni.mcgill.ca/mailman/listinfo/loris-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.bic.mni.mcgill.ca/pipermail/loris-dev/attachments/20150311/5a18a2d4/attachment.html>