StudyModal value too long

Hi,

I am running conquest versions 1.4.17d and 1.4.15 and I have started getting the following error when receiving images. We use postgres version 9 with Redhat 7.

Quote

***Unable to update record
***SQL: UPDATE DICOMStudies SET StudyInsta = '1.2.841.113619.6.95.31.0.3.4.1.1109.13.2242784', StudyDate = '20150205', StudyTime = '114246.328000', StudyID = '2402784', StudyDescr = 'My Scan', AccessionN = 'C2232784', ReferPhysi = 'JONES^ GRAEME', PatientsAg = '021Y', StudyModal = 'CT\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\NM', PatientNam = 'SOMEONE^BLAH^^MR^', PatientBir = '19631021', PatientSex = 'M', PatientID = '4056834', AccessTime = 1423523232 WHERE StudyInsta = '1.2.840.113619.6.95.31.0.4.4.1.1109.14.2202784'
***Error: ERROR: value too long for type character varying(64)

***Error saving to SQL: 4056834/1.2.840.113619.6.95.31.0.2.4.1.1109.13.2202784/1.3.12.2.1107.5.6.1.69214.20000015020422533493700000315/1.3.12.3.1107.5.6.1.69214.30000015020422533493700000372.dcm
Server Command := 0001
Message ID := 0f7e
FreeStore Left 455543 on /research/conquest
*** ERROR: value too long for type character varying(64)

Display More

I have confirmed that the problem is with the StudyModal field and I have tried to alter the column width to accomodate, but I still get the same type of error, but with the larger field size.

ALTER TABLE DICOMStudies ALTER COLUMN StudyModal TYPE varchar(128);

ALTER TABLE DICOMStudies ALTER COLUMN StudyModal TYPE varchar(256);

The only reason I can think of why there might be a problem is that we recently upgraded to Redhat 7

Thank you for the reply. I've check dicom.ini

DoubleBackSlashToDB	 = 1

The postgresql version was 8 and we upgraded to version 9.

I updated the ini file to

DoubleBackSlashToDB    = 0

I deleted the patient and resent. It's all good Backslashes don't seem to be expanding as before.