couldn't retive entered patient data through registration screen

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Registration -> search with name -> select the record from list -->
Showing error
2. If entered new record then it is working untill database is not closed.
3. When reopen the database next day the problem is happening.

What is the expected output? What do you see instead?

What version of the product are you using? On what operating system?

238
Please provide any additional information below.

500 Internal error

The server encountered an unexpected condition which prevented it from
fulfilling the request.

Page handler: <function _wrapper at 0x2aaaaaac3cf8>
Traceback (most recent call last):
  File
"/usr/lib/python2.4/site-packages/CherryPy-2.2.1-py2.4.egg/cherrypy/_cphttptools
.py",
line 105, in _run
    self.main()
  File
"/usr/lib/python2.4/site-packages/CherryPy-2.2.1-py2.4.egg/cherrypy/_cphttptools
.py",
line 254, in main
    body = page_handler(*virtual_path, **self.params)
  File
"/usr/lib/python2.4/site-packages/TurboGears-1.0b2-py2.4.egg/turbogears/identity
/conditions.py",
line 275, in _wrapper
    return fn( *args, **kw )
  File "<string>", line 3, in RegistrationPage1
  File
"/usr/lib/python2.4/site-packages/TurboGears-1.0b2-py2.4.egg/turbogears/controll
ers.py",
line 334, in expose
    output = database.run_with_transaction(
  File "<string>", line 5, in run_with_transaction
  File
"/usr/lib/python2.4/site-packages/TurboGears-1.0b2-py2.4.egg/turbogears/database
.py",
line 245, in so_rwt
    retval = func(*args, **kw)
  File "<string>", line 5, in _expose
  File
"/usr/lib/python2.4/site-packages/TurboGears-1.0b2-py2.4.egg/turbogears/controll
ers.py",
line 351, in <lambda>
    mapping, fragment, args, kw)))
  File
"/usr/lib/python2.4/site-packages/TurboGears-1.0b2-py2.4.egg/turbogears/controll
ers.py",
line 378, in _execute_func
    output = errorhandling.try_call(func, *args, **kw)
  File
"/usr/lib/python2.4/site-packages/TurboGears-1.0b2-py2.4.egg/turbogears/errorhan
dling.py",
line 71, in try_call
    return func(self, *args, **kw)
  File "/home/me/svn/turbocare/turbocare/controllers_registration.py", line
516, in RegistrationPage1
    return self.RegistrationPatientLoad(PatientID, CustomerID)
  File "/home/me/svn/turbocare/turbocare/controllers_registration.py", line
382, in RegistrationPatientLoad
    elif (encounter.EncounterClassNr.Name == 'Inpatient') and (not
encounter.IsDischarged):
  File "<string>", line 1, in <lambda>
  File
"/usr/lib/python2.4/site-packages/SQLObject-0.7.2-py2.4.egg/sqlobject/main.py",
line 1181, in _SO_foreignKey
    return joinClass.get(id)
  File
"/usr/lib/python2.4/site-packages/SQLObject-0.7.2-py2.4.egg/sqlobject/main.py",
line 918, in get
    val._init(id, connection, selectResults)
  File
"/usr/lib/python2.4/site-packages/SQLObject-0.7.2-py2.4.egg/sqlobject/main.py",
line 963, in _init
    raise SQLObjectNotFound, "The object %s by the ID %s does not exist" %
(self.__class__.__name__, self.id)
SQLObjectNotFound: The object ClassEncounter by the ID 2 does not exist

Original issue reported on code.google.com by tushar.c...@gmail.com on 13 Apr 2007 at 8:56

[GoogleCodeExporter]

It looks like one of your tables is missing data in one of your tables the 
second
time around.

Try initializing your data with help in from this page:
http://code.google.com/p/turbocare/wiki/InitializingData

Only execute the following command (not the second command):

mysql --user=root --password=123 turbocare < care2x_preload_data.sql

Original comment by umpen...@gmail.com on 14 Apr 2007 at 5:09

• Changed state: Started

[GoogleCodeExporter]

Revision 242 should force any missing entries for this particular problem.  If 
the
data is missing, the program will fill it in.  After updating the code, when the
server starts, it should check if this particular table has the required 
entries.

Original comment by umpen...@gmail.com on 16 Apr 2007 at 10:18

• Changed state: Fixed