davidray

CREATE FUNCTION
psql:/opt/csi/trisano-dw/warehouse/warehouse_init.sql:237: ERROR:  could not load library "/opt/csi/trisano-postgres/lib/postgresql/plperl.so": libperl.so: cannot open shared object file: No such file or directory
CONTEXT:  SQL statement "CREATE LANGUAGE plperl"
PL/pgSQL function "addlang" line 4 at EXECUTE statement
psql:/opt/csi/trisano-dw/warehouse/warehouse_init.sql:250: ERROR:  current transaction is aborted, commands ignored until end of transaction block

davidray

trisano_126=# select * from codes;
 id |   code_name   | the_code |         code_description          | sort_order 
----+---------------+----------+-----------------------------------+------------
  1 | investigation | UNK      | Unknown                           |          1
  2 | investigation | NYO      | Not Yet Open                      |          5
  3 | investigation | O        | Open                              |         10
  4 | investigation | C        | Closed                            |         15
  5 | placetype     | H        | Hospital / ICP                    |          5
  6 | placetype     | J        | Jurisdiction                      |         10
  7 | placetype     | L        | Laboratory                        |         15

davidray

SELECT * FROM ( SELECT DISTINCT
 events.id AS id, events.type AS type, events.deleted_at AS deleted_at,
 events.record_number AS record_number, events.workflow_state AS workflow_state,
 people.last_name AS last_name, people.first_name AS first_name,
 people.middle_name AS middle_name, people.birth_date AS birth_date,
 people_gender.code_description AS birth_gender, people.vector AS vector,
 diseases.disease_name AS disease_name,
 addresses.city AS city, counties_addresses.code_description AS county,
 places.short_name AS jurisdiction, disease_events.disease_onset_date AS onset_date
 FROM events

davidray

def index

    # Queries are here for clarity purposes in this demo
    # It's of course a better idea to create a method in your model

    users = User.find(:all) do
      if params[:_search] == "true"
        pseudo    =~ "%#{params[:pseudo]}%" if params[:pseudo].present?
        firstname =~ "%#{params[:firstname]}%" if params[:firstname].present?
        lastname  =~ "%#{params[:lastname]}%" if params[:lastname].present?                

davidray

[2009-08-11 10:59:49] [FATAL] 
ActiveRecord::StatementInvalid (ActiveRecord::ActiveRecordError: ERROR: duplicate key value violates unique constraint "index_form_references_on_event_id_and_template_id": INSERT INTO "form_references" ("event_id", "form_id", "template_id") VALUES(20117, 175, 174)):
  /usr/local/tomcat6/webapps/utnedss/WEB-INF/gems/gems/activerecord-jdbc-adapter-0.9.1/lib/active_record/connection_adapters/jdbc_adapter.rb:560:in `execute'
  /usr/local/tomcat6/webapps/utnedss/WEB-INF/gems/gems/activerecord-jdbc-adapter-0.9.1/lib/jdbc_adapter/jdbc_postgre.rb:225:in `insert'


[2009-08-11 10:59:50] [INFO ] 

Processing EventsController#auto_complete_for_treatment (for 168.179.120.50 at 2009-08-11 10:59:50) [GET]
[2009-08-11 10:59:50] [INFO ]   Parameters: {"treatment"=>"Doxycycline 100 mg PO BID"}

davidray

7041a1939d048adf6aa898677d364cc02194ad75 Fix problems handling JDBC connections
ed1090114807bbd0754ac71620e4b7450f459392 Add explanatory note
a6845e861553ee0f67875eb5618710d1793ccdda Population import fixes
8c98c237942d511130b4733a65ca52a565ea9037 Fix return values: null iff there's an 
331a411b5288f24c8e14fa19bbcf03db6796ae97 Not finding a population table doesn't 
b172829a800d15de3556d75f2c0f4d36d6abcbd0 Move age group calculation into a funct
beaef8687a62cc28ac61f48404963af780b74216 Refactor to allow running on existing w
ee52cf36fff37a8de5f0f1d235daeb37c806d8a1 Change population code to use multiple 
54f86c8ca7a11c76d3360449de4ef617b1d902fa Supporting commit for people management
fe1f9eb0ff53aede637f99009ef1c77750b22323 Renamed web-api-client to client-web-ap

davidray

# Copyright (C) 2007, 2008, 2009 The Collaborative Software Foundation
#
# This file is part of TriSano.
#
# TriSano is free software: you can redistribute it and/or modify it under the
# terms of the GNU Affero General Public License as published by the
# Free Software Foundation, either version 3 of the License,
# or (at your option) any later version.
#
# TriSano is distributed in the hope that it will be useful, but

davidray

HTTP Status 401 - Bad credentials

type Status report

message Bad credentials

description This request requires HTTP authentication (Bad credentials).
Apache Tomcat/5.5.26

davidray

Before I click on more choices:

<span class="horiz">
<label for="morbidity_event_labs_attributes_3_lab_results_attributes_1_test_type">Test type</label>
<select id="morbidity_event_labs_attributes_3_lab_results_attributes_1_test_type_id" onchange="get_test_type_options(this);" name="morbidity_event[labs_attributes][3][lab_results_attributes][1][test_type_id]">
<option value=""/>
<option selected="selected" value="4">Bonk on the head</option>
<option value="0">More choices...</option>
</select>
</span>

davidray

id |   common_name    |         created_at         |         updated_at         
----+------------------+----------------------------+----------------------------
  1 | Blood Test       | 2009-08-05 12:08:40.129372 | 2009-08-05 12:08:40.129372
  2 | Urine Sample     | 2009-08-05 12:08:55.351432 | 2009-08-05 12:08:55.351432
  3 | Stool Sample     | 2009-08-05 12:11:35.674407 | 2009-08-05 12:11:35.674407
  4 | Bonk on the head | 2009-08-05 12:35:36.767818 | 2009-08-05 12:35:36.767818
(4 rows)