Problem Installing Oscar

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Problem Installing Oscar

smoothie
I am installing the latest 15-80~748. I have tried other versions such as
80~745 and 76~714 and still get the same messages. Please help:

Selecting previously unselected package oscar-emr.
(Reading database ... 250722 files and directories currently installed.)
Preparing to unpack .../oscar_emr15-80_748.deb ...
Unpacking oscar-emr (15-80~748) ...
Setting up oscar-emr (15-80~748) ...
Setting initial defaults for areacode 604 in BC
 [x] Checking the MySQL password  success
 [x] Determining locale  success
 [x] Creating the new oscar_15 database  success
 [x] Populating database with BC data  success
 [x] Patching database to early oscar schema with patch1 success
 [x] Patching database to very latest schema with patch *****failed*****

 [i] Showing the last 8 lines from the logfile
(/usr/share/oscar-emr/Oscar15install.log)...
oscar_15.formONAREnhancedRecordExt2 does not exist.  Unable to add idIndex
 3054's retcode: 0
success
 [x] Patching database to very latest schema with patch ERROR 1146 (42S02)
at line 220: Table 'oscar_15.frm_labreq_preset' doesn't exist
CreateIndexMessage
oscar_15.frm_labreq_preset does not exist.  Unable to add
lab_type_prop_name_prop_value
 3852's retcode: 1
*****failed*****
dpkg: error processing package oscar-emr (--install):
 subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
 oscar-emr




--
Sent from: http://oscarmcmaster.16.x6.nabble.com/oscarmcmaster-devel-f3244825.html

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel
Reply | Threaded
Open this post in threaded view
|

Re: Problem Installing Oscar

Earl Wertheimer
No time to research, but you can probably just create the missing table manually, then rerun the patch.sql script.

CREATE TABLE `frm_labreq_preset` (
  `preset_id` int(10) NOT NULL AUTO_INCREMENT,
  `lab_type` varchar(255) NOT NULL,
  `prop_name` varchar(255) NOT NULL,
  `prop_value` varchar(255) NOT NULL,
  `status` int(1) NOT NULL,
  PRIMARY KEY (`preset_id`),
  UNIQUE KEY `lab_type_prop_name_prop_value` (`lab_type`,`prop_name`,`prop_value`)
) ENGINE=InnoDB AUTO_INCREMENT=194 DEFAULT CHARSET=utf8




On Tue, Mar 6, 2018 at 3:40 AM, smoothie <[hidden email]> wrote:
I am installing the latest 15-80~748. I have tried other versions such as
80~745 and 76~714 and still get the same messages. Please help:

Selecting previously unselected package oscar-emr.
(Reading database ... 250722 files and directories currently installed.)
Preparing to unpack .../oscar_emr15-80_748.deb ...
Unpacking oscar-emr (15-80~748) ...
Setting up oscar-emr (15-80~748) ...
Setting initial defaults for areacode 604 in BC
 [x] Checking the MySQL password  success
 [x] Determining locale  success
 [x] Creating the new oscar_15 database  success
 [x] Populating database with BC data  success
 [x] Patching database to early oscar schema with patch1 success
 [x] Patching database to very latest schema with patch *****failed*****

 [i] Showing the last 8 lines from the logfile
(/usr/share/oscar-emr/Oscar15install.log)...
oscar_15.formONAREnhancedRecordExt2 does not exist.  Unable to add idIndex
 3054's retcode: 0
success
 [x] Patching database to very latest schema with patch ERROR 1146 (42S02)
at line 220: Table 'oscar_15.frm_labreq_preset' doesn't exist
CreateIndexMessage
oscar_15.frm_labreq_preset does not exist.  Unable to add
lab_type_prop_name_prop_value
 3852's retcode: 1
*****failed*****
dpkg: error processing package oscar-emr (--install):
 subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
 oscar-emr




--
Sent from: http://oscarmcmaster.16.x6.nabble.com/oscarmcmaster-devel-f3244825.html

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel
Reply | Threaded
Open this post in threaded view
|

Re: Problem Installing Oscar

Earl Wertheimer
It looks like the table definition is missing from OscarBC15.sql

You can fix it by unpacking the .deb, updating OscarBC15.sql and repacking it.
..or just run the missing code...
It's at the end of the installation, but I don't know/remember what run s after the patch1/patch scripts...

The Ontario version, OscarON15.sql has the following:

--
-- Dumping data for table `form_hsfo2_visit`
--


-- --------------------------------------------------------

--
-- Table structure for table `frm_labreq_preset`
--

CREATE TABLE IF NOT EXISTS `frm_labreq_preset` (
  `preset_id` int(10) NOT NULL AUTO_INCREMENT,
  `lab_type` varchar(255) NOT NULL,
  `prop_name` varchar(255) NOT NULL,
  `prop_value` varchar(255) NOT NULL,
  `status` int(1) NOT NULL,
  PRIMARY KEY (`preset_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=193 ;

--
-- Dumping data for table `frm_labreq_preset`
--

INSERT INTO `frm_labreq_preset` (`preset_id`, `lab_type`, `prop_name`, `prop_value`, `status`) VALUES
(1, 'DM', 'b_glucose', 'checked', 1),
(2, 'DM', 'b_glucose_fasting', 'checked', 1),
(3, 'DM', 'b_hba1c', 'checked', 1),
(4, 'DM', 'b_creatinine', 'checked', 1),
(5, 'DM', 'b_uricAcid', 'checked', 1),
(6, 'DM', 'b_alt', 'checked', 1),
(7, 'DM', 'b_alkPhosphatase', 'checked', 1),
(8, 'DM', 'b_lipidAssessment', 'checked', 1),
(9, 'DM', 'aci', '\n Fast for 12 hours', 1),
(10, 'AnteNatal', 'b_urinalysis', 'checked', 1),
(11, 'AnteNatal', 'h_cbc', 'checked', 1),
(12, 'AnteNatal', 'i_rubella', 'checked', 1),
(13, 'AnteNatal', 'i_prenatal', 'checked', 1),
(14, 'AnteNatal', 'm_urine', 'checked', 1),
(15, 'AnteNatal', 'o_otherTests1', 'Hep B s Ag', 1),
(16, 'AnteNatal', 'o_otherTests2', 'VDRL', 1),
(17, 'AnteNatal', 'o_otherTests3', 'HIV', 1),
(18, 'AnteNatal', 'o_otherTests4', 'Varicella titre', 1),
(19, 'AnteNatal', 'o_otherTests5', 'Ferritin', 1),
(20, 'AR', 'b_urinalysis', 'checked', 1),
(21, 'AR', 'h_bloodFilmExam', 'checked', 1),
(22, 'AR', 'h_hemoglobin', 'checked', 1),
(23, 'AR', 'h_wcbCount', 'checked', 1),
(24, 'AR', 'h_hematocrit', 'checked', 1),
(25, 'AR', 'i_heterophile', 'checked', 1),
(26, 'AR', 'i_rubella', 'checked', 1),
(27, 'AR', 'i_prenatal', 'checked', 1),
(28, 'AR', 'i_prenatalHepatitisB', 'checked', 1),
(29, 'AR', 'i_vdrl', 'checked', 1),
(30, 'AR', 'm_urine', 'checked', 1),
(31, 'AR', 'otherTest', 'HIV \n\nVaricella titre', 1),
(32, 'Acne', 'b_creatinine', 'checked', 1),
(33, 'Acne', 'b_alt', 'checked', 1),
(34, 'Acne', 'b_alkPhosphatase', 'checked', 1),
(35, 'Acne', 'b_bilirubin', 'checked', 1),
(36, 'Acne', 'b_lipidAssessment', 'checked', 1),
(37, 'Acne', 'h_cbc', 'checked', 1),
(38, 'AHEf', 'b_glucose', 'checked', 1),
(39, 'AHEf', 'h_cbc', 'checked', 1),
(40, 'AHEf', 'i_rubella', 'checked', 1),
(41, 'AHEf', 'o_otherTests1', 'pap', 1),
(42, 'AHEf', 'm_chlamydia', 'pap', 1),
(43, 'AHEf', 'm_chlamydiaSource', 'cerv', 1),
(44, 'AHEf', 'm_gc', 'checked', 1),
(45, 'AHEf', 'm_gcSource', 'cerv', 1),
(46, 'AHEf', 'm_vaginal', 'checked', 1),
(47, 'AHEm', 'b_glucose', 'checked', 1),
(48, 'AHEm', 'h_cbc', 'checked', 1),
(49, 'Anemia', 'h_cbc', 'checked', 1),
(50, 'Anemia', 'b_ferritin', 'checked', 1),
(51, 'Anemia', 'o_otherTests1', 'reticulocyte ct', 1),
(52, 'Bp', 'b_glucose', 'checked', 1),
(53, 'Bp', 'b_tsh', 'checked', 1),
(54, 'Bp', 'b_creatinine', 'checked', 1),
(55, 'Bp', 'b_sodium', 'checked', 1),
(56, 'Bp', 'b_potassium', 'checked', 1),
(57, 'Bp', 'b_chloride', 'checked', 1),
(58, 'Bp', 'b_lipidAssessment', 'checked', 1),
(59, 'Bp', 'h_cbc', 'checked', 1),
(60, 'Bp', 'o_otherTests1', 'urine, routine', 1),
(61, 'Bp', 'o_otherTests2', 'urine, micro', 1),
(62, 'Chol', 'b_glucose', 'checked', 1),
(63, 'Chol', 'b_tsh', 'checked', 1),
(64, 'Chol', 'b_alt', 'checked', 1),
(65, 'Chol', 'b_alkPhosphatase', 'checked', 1),
(66, 'Chol', 'b_bilirubin', 'checked', 1),
(67, 'Chol', 'b_lipidAssessment', 'checked', 1),
(68, 'Chol', 'h_cbc', 'checked', 1),
(69, 'Ed', 'b_glucose', 'checked', 1),
(70, 'Ed', 'b_creatinine', 'checked', 1),
(71, 'Ed', 'b_tsh', 'checked', 1),
(72, 'Ed', 'b_alt', 'checked', 1),
(73, 'Ed', 'b_alkPhosphatase', 'checked', 1),
(74, 'Ed', 'b_bilirubin', 'checked', 1),
(75, 'Ed', 'h_cbc', 'checked', 1),
(76, 'Ed', 'o_otherTests1', 'lh', 1),
(77, 'Ed', 'o_otherTests2', 'fsh', 1),
(78, 'Ed', 'o_otherTests3', 'prolactin', 1),
(79, 'Ed', 'o_otherTests4', 'testosterone', 1),
(80, 'Ed', 'o_otherTests5', 'testosterone,free', 1),
(81, 'Fatigue', 'b_glucose', 'checked', 1),
(82, 'Fatigue', 'b_tsh', 'checked', 1),
(83, 'Fatigue', 'b_creatinine', 'checked', 1),
(84, 'Fatigue', 'b_alt', 'checked', 1),
(85, 'Fatigue', 'b_alkPhosphatase', 'checked', 1),
(86, 'Fatigue', 'b_bilirubin', 'checked', 1),
(87, 'Fatigue', 'b_vitaminB12', 'checked', 1),
(88, 'Fatigue', 'b_ferritin', 'checked', 1),
(89, 'Fatigue', 'h_cbc', 'checked', 1),
(90, 'Fatigue', 'i_mononucleosisScreen', 'checked', 1),
(91, 'Fatigue', 'o_otherTests1', 'urine, routine', 1),
(92, 'Fatigue', 'o_otherTests1', 'urine, micro', 1),
(93, 'Fulstdf', 'm_vaginal', 'checked', 1),
(94, 'Fulstdf', 'm_chlamydia', 'checked', 1),
(95, 'Fulstdf', 'm_chlamydiaSource', 'cervical', 1),
(96, 'Fulstdf', 'm_gc', 'checked', 1),
(97, 'Fulstdf', 'm_gcSource', 'cerv', 1),
(98, 'Fulstdf', 'v_immuneStatus', 'checked', 1),
(99, 'Fulstdf', 'v_immune_HepatitisB', 'checked', 1),
(100, 'Fulstdf', 'v_immune_HepatitisC', 'checked', 1),
(101, 'Fulstdf', 'o_otherTests1', 'hiv-ab', 1),
(102, 'Fulstdf', 'o_otherTests2', 'hep b surf antigen', 1),
(103, 'Fulstdf', 'o_otherTests3', 'VDRL', 1),
(104, 'Fulstdm', 'm_chlamydia', 'checked', 1),
(105, 'Fulstdm', 'm_chlamydiaSource', 'urine', 1),
(106, 'Fulstdm', 'm_gc', 'checked', 1),
(107, 'Fulstdm', 'm_gcSource', 'urine', 1),
(108, 'Fulstdm', 'v_immuneStatus', 'checked', 1),
(109, 'Fulstdm', 'v_immune_HepatitisB', 'checked', 1),
(110, 'Fulstdm', 'v_immune_HepatitisC', 'checked', 1),
(111, 'Fulstdm', 'o_otherTests1', 'hiv-ab', 1),
(112, 'Fulstdm', 'o_otherTests2', 'hep b surf antigen', 1),
(113, 'Fulstdm', 'o_otherTests3', 'vdrl', 1),
(114, 'Gastro', 'o_otherTests1', 'stool c+s x1', 1),
(115, 'Gastro', 'o_otherTests2', 'stool c+p x1', 1),
(116, 'Gstdm', 'm_chlamydia', 'checked', 1),
(117, 'Gstdm', 'm_chlamydiaSource', 'urine', 1),
(118, 'Gstdm', 'm_gc', 'checked', 1),
(119, 'Gstdm', 'm_gcSource', 'urine', 1),
(120, 'Gstdm', 'v_immuneStatus', 'checked', 1),
(121, 'Gstdm', 'v_immune_HepatitisA', 'checked', 1),
(122, 'Gstdm', 'v_immune_HepatitisB', 'checked', 1),
(123, 'Gstdm', 'v_immune_HepatitisC', 'checked', 1),
(124, 'Gstdm', 'o_otherTests1', 'hiv-ab', 1),
(125, 'Gstdm', 'o_otherTests2', 'vdrl', 1),
(126, 'Gstdm', 'o_otherTests3', 'rectal - gc/chlam', 1),
(127, 'Gyne', 'o_otherTests1', 'pap', 1),
(128, 'Gyne', 'm_chlamydia', 'checked', 1),
(129, 'Gyne', 'm_chlamydiaSource', 'cerv', 1),
(130, 'Gyne', 'm_gc', 'checked', 1),
(131, 'Gyne', 'm_gcSource', 'cerv', 1),
(132, 'Gyne', 'm_vaginal', 'checked', 1),
(133, 'HIV', 'o_otherTests1', 'hiv-ab', 1),
(134, 'Ibs', 'h_cbc', 'checked', 1),
(135, 'Ibs', 'b_tsh', 'checked', 1),
(136, 'Ibs', 'o_otherTests1', 'stool c+s x1', 1),
(137, 'Ibs', 'o_otherTests2', 'stool c+s x1', 1),
(138, 'Mono', 'h_cbc', 'checked', 1),
(139, 'Mono', 'i_mononucleosisScreen', 'checked', 1),
(140, 'Pcod', 'b_tsh', 'checked', 1),
(141, 'Pcod', 'o_otherTests1', 'prolactin', 1),
(142, 'Pcod', 'o_otherTests2', 'lh', 1),
(143, 'Pcod', 'o_otherTests3', 'fsh', 1),
(144, 'Pcod', 'o_otherTests4', '17-hydroxy-progest', 1),
(145, 'Pcod', 'o_otherTests5', 'testosterone', 1),
(146, 'Stdf', 'm_chlamydia', 'checked', 1),
(147, 'Stdf', 'm_chlamydiaSource', 'cerv', 1),
(148, 'Stdf', 'm_gc', 'checked', 1),
(149, 'Stdf', 'm_gcSource', 'cerv', 1),
(150, 'Stdf', 'm_vaginal', 'checked', 1),
(151, 'Stdms', 'm_chlamydia', 'checked', 1),
(152, 'Stdms', 'm_chlamydiaSource', 'urine', 1),
(153, 'Stdms', 'm_gc', 'checked', 1),
(154, 'Stdms', 'm_gcSource', 'urine', 1),
(155, 'Stdms', 'm_urine', 'checked', 1),
(156, 'Stdms', 'o_otherTests1', 'urine - microscopic', 1),
(157, 'Stdma', 'm_chlamydia', 'checked', 1),
(158, 'Stdma', 'm_chlamydiaSource', 'urine', 1),
(159, 'Stdma', 'm_gc', 'checked', 1),
(160, 'Stdma', 'm_gcSource', 'urine', 1),
(161, 'Thyroid', 'b_tsh', 'checked', 1),
(162, 'Thyroid', 'o_otherTests1', 'free t4', 1),
(163, 'Urticaria', 'b_creatinine', 'checked', 1),
(164, 'Urticaria', 'h_cbc', 'checked', 1),
(165, 'Urticaria', 'i_mononucleosisScreen', 'checked', 1),
(166, 'Urticaria', 'i_rubella', 'checked', 1),
(167, 'Urticaria', 'v_acuteHepatitis', 'checked', 1),
(168, 'Urticaria', 'o_otherTests1', 'Urinalysis (routine)', 1),
(169, 'Uti', 'm_urine', 'checked', 1),
(170, 'Uti', 'o_otherTests1', 'urine, routine', 1),
(171, 'Uti', 'o_otherTests2', 'urine, micro', 1),
(172, 'Vaginitis', 'o_otherTests1', 'swab vaginal c+s', 1),
(173, 'AntiPsychotic', 'b_creatinine', 'checked', 1),
(174, 'AntiPsychotic', 'b_sodium', 'checked', 1),
(175, 'AntiPsychotic', 'b_potassium', 'checked', 1),
(176, 'AntiPsychotic', 'b_alt', 'checked', 1),
(177, 'AntiPsychotic', 'b_alkPhosphatase', 'checked', 1),
(178, 'AntiPsychotic', 'b_lipidAssessment', 'checked', 1),
(179, 'AntiPsychotic', 'h_cbc', 'checked', 1),
(180, 'AntiPsychotic', 'o_otherTests1', 'AST', 1),
(181, 'AntiPsychotic', 'o_otherTests2', 'Prolactin', 1),
(182, 'AntiPsychotic', 'o_otherTests3', 'ECG', 1),
(183, 'PreLithium', 'b_tsh', 'checked', 1),
(184, 'PreLithium', 'b_creatinine', 'checked', 1),
(185, 'PreLithium', 'b_alt', 'checked', 1),
(186, 'PreLithium', 'b_alkPhosphatase', 'checked', 1),
(187, 'PreLithium', 'b_bilirubin', 'checked', 1),
(188, 'PreLithium', 'b_albumin', 'checked', 1),
(189, 'PreLithium', 'b_urinalysis', 'checked', 1),
(190, 'PreLithium', 'h_cbc', 'checked', 1),
(191, 'PreLithium', 'o_otherTests1', 'GGT', 1),
(192, 'PreLithium', 'o_otherTests2', 'ECG', 1);

-- --------------------------------------------------------

--
-- Table structure for table `FunctionalCentre`
--


On Tue, Mar 6, 2018 at 10:09 AM, Earl Wertheimer <[hidden email]> wrote:
No time to research, but you can probably just create the missing table manually, then rerun the patch.sql script.

CREATE TABLE `frm_labreq_preset` (
  `preset_id` int(10) NOT NULL AUTO_INCREMENT,
  `lab_type` varchar(255) NOT NULL,
  `prop_name` varchar(255) NOT NULL,
  `prop_value` varchar(255) NOT NULL,
  `status` int(1) NOT NULL,
  PRIMARY KEY (`preset_id`),
  UNIQUE KEY `lab_type_prop_name_prop_value` (`lab_type`,`prop_name`,`prop_value`)
) ENGINE=InnoDB AUTO_INCREMENT=194 DEFAULT CHARSET=utf8




On Tue, Mar 6, 2018 at 3:40 AM, smoothie <[hidden email]> wrote:
I am installing the latest 15-80~748. I have tried other versions such as
80~745 and 76~714 and still get the same messages. Please help:

Selecting previously unselected package oscar-emr.
(Reading database ... 250722 files and directories currently installed.)
Preparing to unpack .../oscar_emr15-80_748.deb ...
Unpacking oscar-emr (15-80~748) ...
Setting up oscar-emr (15-80~748) ...
Setting initial defaults for areacode 604 in BC
 [x] Checking the MySQL password  success
 [x] Determining locale  success
 [x] Creating the new oscar_15 database  success
 [x] Populating database with BC data  success
 [x] Patching database to early oscar schema with patch1 success
 [x] Patching database to very latest schema with patch *****failed*****

 [i] Showing the last 8 lines from the logfile
(/usr/share/oscar-emr/Oscar15install.log)...
oscar_15.formONAREnhancedRecordExt2 does not exist.  Unable to add idIndex
 3054's retcode: 0
success
 [x] Patching database to very latest schema with patch ERROR 1146 (42S02)
at line 220: Table 'oscar_15.frm_labreq_preset' doesn't exist
CreateIndexMessage
oscar_15.frm_labreq_preset does not exist.  Unable to add
lab_type_prop_name_prop_value
 3852's retcode: 1
*****failed*****
dpkg: error processing package oscar-emr (--install):
 subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
 oscar-emr




--
Sent from: http://oscarmcmaster.16.x6.nabble.com/oscarmcmaster-devel-f3244825.html

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel