<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<img size="131452" style="width: 254.664px; height: 198px; max-width: 391px;" height="198" width="254" id="image_0" data-outlook-trace="F:1|T:1" src="cid:e608a457-bd98-429e-9454-eedcdca4e4b5"></div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
I am back on the cch database; however, this error appears when I open data acquisition.</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
-Sophia</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Demelerlab <demelerlab-bounces@biophysics.uleth.ca> on behalf of Alexey Savelyev via Demelerlab <demelerlab@biophysics.uleth.ca><br>
<b>Sent:</b> 25 October 2025 14:48<br>
<b>To:</b> Emre Brookes <emre.brookes@mso.umt.edu>; Borries Demeler <demeler@gmail.com>; demelerlab@biophysics.uleth.ca <demelerlab@biophysics.uleth.ca><br>
<b>Subject:</b> Re: [Demelerlab] Canada databases</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt;">
<div class="PlainText">Yes, that change is required for the dataDisk Pseudoabsorbance type to
<br>
operate via GMP framework..<br>
<br>
There is a PR#20 for SQL repo.<br>
<br>
Alexey<br>
<br>
On 10/25/25 13:54, Emre Brookes wrote:<br>
> CCH and AUCCANADA have been moved back to demeler9.<br>
> Users should be able to resume normal work, albeit on the correct <br>
> servers now.<br>
><br>
> Alexey - noted a sql difference on CCH on NRCH.<br>
> uslims3_CCH : differences dataSource enum in in autoflow & <br>
> autoflowHistory<br>
> < `dataSource` <br>
> enum('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance') NOT NULL <br>
> DEFAULT 'INSTRUMENT',<br>
> ---<br>
> > `dataSource` <br>
> enum('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance','dataDiskAUC:PseudoAbsorbance')
<br>
> NOT NULL DEFAULT 'INSTRUMENT',<br>
><br>
> I made the equivalent uncommitted local change on <br>
> demeler9:~us3/lims/database/sql<br>
> $ git diff<br>
> diff --git a/us3.sql b/us3.sql<br>
> index 4706095..1f8be0a 100644<br>
> --- a/us3.sql<br>
> +++ b/us3.sql<br>
> @@ -117,7 +117,7 @@ CREATE TABLE IF NOT EXISTS autoflow (<br>
> devRecord enum('NO', 'YES', 'Processed') NOT NULL,<br>
> gmpReviewID int(11) NULL,<br>
> expType enum('VELOCITY','ABDE') NOT NULL,<br>
> - dataSource enum <br>
> ('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance') NOT NULL DEFAULT <br>
> 'INSTRUMENT',<br>
> + dataSource enum <br>
> ('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance','dataDiskAUC:PseudoAbsorbance')
<br>
> NOT NULL DEFAULT 'INSTRUMENT',<br>
> opticsFailedType varchar(300) NULL,<br>
><br>
> PRIMARY KEY (ID) )<br>
> @@ -159,7 +159,7 @@ CREATE TABLE IF NOT EXISTS autoflowHistory (<br>
> devRecord enum('NO', 'YES', 'Processed') NOT NULL,<br>
> gmpReviewID int(11) NULL,<br>
> expType enum('VELOCITY','ABDE') NOT NULL,<br>
> - dataSource enum <br>
> ('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance') NOT NULL DEFAULT <br>
> 'INSTRUMENT',<br>
> + dataSource enum <br>
> ('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance','dataDiskAUC:PseudoAbsorbance')
<br>
> NOT NULL DEFAULT 'INSTRUMENT',<br>
> opticsFailedType varchar(300) NULL,<br>
><br>
> PRIMARY KEY (ID) )<br>
><br>
><br>
><br>
><br>
> Borries Demeler wrote:<br>
>> Everyone:<br>
>> Now that we have our server back online thanks to Saeed's tireless <br>
>> efforts, I want to move the databases back to our server in Canada <br>
>> and disable the CCH and AUCCANADA databases on the NRCH server, so we <br>
>> can move them back to the demeler9 server. I asked Emre to do that, <br>
>> and perhaps send us a short notice when he plans to do it. During <br>
>> this time please do not use the server on either server until we have <br>
>> the green light from Emre to use the server back in Canada again.<br>
>> Thanks! -Borries<br>
><br>
_______________________________________________<br>
Demelerlab mailing list<br>
Demelerlab@biophysics.uleth.ca<br>
<a href="https://www.biophysics.uleth.ca/mailman/listinfo/demelerlab">https://www.biophysics.uleth.ca/mailman/listinfo/demelerlab</a><br>
</div>
</span></font></div>
</body>
</html>