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

[Krisanne Litinas]

Hi Justin,

Thanks for the quick response.  That was my first thought as well, but it
is the same user.  And it seems that via the front end /
data_dictionary_builder.php script I can update some tables but not others
and it is not apparent to me why this could be.

-Krisanne

On Wed, Mar 11, 2015 at 1:42 PM, Justin Kat <justinkat at gmail.com> wrote:

> 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/a8fcb970/attachment-0001.html>