[Demelerlab] Canada databases

[Bird, Sophia]

[cid:e608a457-bd98-429e-9454-eedcdca4e4b5]
I am back on the cch database; however, this error appears when I open data acquisition.

-Sophia
________________________________
From: Demelerlab <demelerlab-bounces at biophysics.uleth.ca> on behalf of Alexey Savelyev via Demelerlab <demelerlab at biophysics.uleth.ca>
Sent: 25 October 2025 14:48
To: Emre Brookes <emre.brookes at mso.umt.edu>; Borries Demeler <demeler at gmail.com>; demelerlab at biophysics.uleth.ca <demelerlab at biophysics.uleth.ca>
Subject: Re: [Demelerlab] Canada databases

Yes, that change is required for the dataDisk Pseudoabsorbance type to
operate via GMP framework..

There is a PR#20 for SQL repo.

Alexey

On 10/25/25 13:54, Emre Brookes wrote:
> CCH and AUCCANADA have been moved back to demeler9.
> Users should be able to resume normal work, albeit on the correct
> servers now.
>
> Alexey - noted a sql difference on CCH on NRCH.
> uslims3_CCH : differences dataSource enum in in autoflow &
> autoflowHistory
> <   `dataSource`
> enum('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance') NOT NULL
> DEFAULT 'INSTRUMENT',
> ---
> >   `dataSource`
> enum('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance','dataDiskAUC:PseudoAbsorbance')
> NOT NULL DEFAULT 'INSTRUMENT',
>
> I made the equivalent uncommitted local change on
> demeler9:~us3/lims/database/sql
> $ git diff
> diff --git a/us3.sql b/us3.sql
> index 4706095..1f8be0a 100644
> --- a/us3.sql
> +++ b/us3.sql
> @@ -117,7 +117,7 @@ CREATE  TABLE IF NOT EXISTS autoflow (
>    devRecord   enum('NO', 'YES', 'Processed') NOT NULL,
>    gmpReviewID int(11) NULL,
>    expType enum('VELOCITY','ABDE') NOT NULL,
> -  dataSource enum
> ('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance') NOT NULL DEFAULT
> 'INSTRUMENT',
> +  dataSource enum
> ('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance','dataDiskAUC:PseudoAbsorbance')
> NOT NULL DEFAULT 'INSTRUMENT',
>    opticsFailedType varchar(300) NULL,
>
>    PRIMARY KEY (ID) )
> @@ -159,7 +159,7 @@ CREATE  TABLE IF NOT EXISTS autoflowHistory (
>    devRecord   enum('NO', 'YES', 'Processed') NOT NULL,
>    gmpReviewID int(11) NULL,
>    expType enum('VELOCITY','ABDE') NOT NULL,
> -  dataSource enum
> ('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance') NOT NULL DEFAULT
> 'INSTRUMENT',
> +  dataSource enum
> ('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance','dataDiskAUC:PseudoAbsorbance')
> NOT NULL DEFAULT 'INSTRUMENT',
>    opticsFailedType varchar(300) NULL,
>
>    PRIMARY KEY (ID) )
>
>
>
>
> Borries Demeler wrote:
>> Everyone:
>> Now that we have our server back online thanks to Saeed's tireless
>> efforts, I want to move the databases back to our server in Canada
>> and disable the CCH and AUCCANADA databases on the NRCH server, so we
>> can move them  back to the demeler9 server. I asked Emre to do that,
>> and perhaps send us a short notice when he plans to do it. During
>> this time please do not use the server on either server until we have
>> the green light from Emre to use the server back in Canada again.
>> Thanks! -Borries
>
_______________________________________________
Demelerlab mailing list
Demelerlab at biophysics.uleth.ca
https://www.biophysics.uleth.ca/mailman/listinfo/demelerlab
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.biophysics.uleth.ca/pipermail/demelerlab/attachments/20251025/aed133b3/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 131452 bytes
Desc: image.png
URL: <http://www.biophysics.uleth.ca/pipermail/demelerlab/attachments/20251025/aed133b3/attachment-0001.png>