[Loris-dev] Fwd: data dictionary

[Tom Beaudry]

Hi,

So Rathi sees that this my problem for not getting the data_dictionary to
poluate:

select ParameterTypeID from parameter_type_category_rel where
ParameterTypeCategoryID in ()<br>
*PHP Fatal error:  Uncaught exception 'Exception' with message 'Invalid
SELECT statement, select ParameterTypeID from parameter_type_category_rel
where ParameterTypeCategoryID in ()*

See suggested that I:
*Can you check if the table parameter_type_category has all the columns
especially of type Instrument? I have a feeling that you don't have a
parameter category Instrument defined hence its failing.*

Does anyone know what this means?  what is type of instrument, and how do I
add it?  I've included a screen shot of my parameter table.

Thanks!
Tom

Rathi

On Fri, Feb 13, 2015 at 8:35 PM, Tom Beaudry <waveflux at gmail.com> wrote:

> Hi Rathi,
>
> So i copied this version of the data_dictionary script (
> https://github.com/aces/Loris/blob/master/tools/data_dictionary_builder.php
> )
>
> commented out the autoload line,
>
> added:  require_once __DIR__ . "/../php/libraries/NDB_Client.class.inc";
>
>
> and I get this error:
>
> [lorisadmin at canadachina tools]$ php data_dictionary_builder.php
> canadachina: SELECT cs.ID as ParentID, child.ID as ChildID,
>                         cs.AllowMultiple, child.Name
>                 FROM ConfigSettings cs
>                     LEFT JOIN ConfigSettings child ON (child.Parent=cs.ID)
>                 WHERE cs.Name=:showPearErrors<br>
> canadachina: SELECT Value FROM Config WHERE ConfigID=:34 LIMIT 1<br>
> canadachina: Select Name, ParameterTypeID from parameter_type<br>
> canadachina: select ParameterTypeCategoryID from parameter_type_category
> where Type = 'Instrument'<br>
> PHP Warning:  implode(): Invalid arguments passed in
> /var/www/loris/tools/data_dictionary_builder.php on line 57
> canadachina: select ParameterTypeID from parameter_type_category_rel where
> ParameterTypeCategoryID in ()<br>
> PHP Fatal error:  Uncaught exception 'Exception' with message 'Invalid
> SELECT statement, select ParameterTypeID from parameter_type_category_rel
> where ParameterTypeCategoryID in ()' in
> /var/www/loris/php/libraries/Database.class.inc:458
> Stack trace:
> #0 /var/www/loris/tools/data_dictionary_builder.php(239):
> Database->select('select Paramete...', Array)
> #1 /var/www/loris/tools/data_dictionary_builder.php(60): getColumn('select
> Paramete...', Object(Database), NULL)
> #2 {main}
>   thrown in /var/www/loris/php/libraries/Database.class.inc on line 458
> [lorisadmin at canadachina tools]$
>
>
> Any ideas?  Note that I am still using the first public release of LORIS.
>
> thanks,
> Tom
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.bic.mni.mcgill.ca/pipermail/loris-dev/attachments/20150216/d9f0a114/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screen Shot 2015-02-16 at 12.07.13 PM.png
Type: image/png
Size: 41773 bytes
Desc: not available
URL: <http://www.bic.mni.mcgill.ca/pipermail/loris-dev/attachments/20150216/d9f0a114/attachment-0001.png>