Package: ctn Version: 3.0.6-4 Severity: important I experienced a problem using CTN with MySQL Version 5.0 (but because of the nature of the problem I assume it also affects using CTN with MySQL Version 4.1)
I was unable to receive images. Thus, I ran the archive server in verbose mode and got following message: Perm file name: /daten/DICOM/0007220079/1.3.12.2.1107.5.2.4.7495.20050906141628000003/MR.6768.1 170162 DB specific error (mySQL:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Mod , SerNum , SerInsUID , ProNam , SerDes , BodParExa , ViePos , NumSerRelIma ' at line 1) Since I experienced the same problems importing the MySQL dump I had generated using MySQL 4.0. I am pretty sure that the problem is caused by the columns Mod in the tables SeriesLevel and StudyCmpTable, because Mod is a keyword and replacing Mod by `Mod` in my dump solved the problem. -- System Information: Debian Release: testing/unstable APT prefers testing APT policy: (500, 'testing') Architecture: amd64 (x86_64) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.8-11-amd64-generic Locale: [EMAIL PROTECTED], [EMAIL PROTECTED] (charmap=UTF-8) -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
