stock transfer - stock item

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Inventory-Hospital site - stock transfer - Press on stock item.
2. Not showing any list 
3.

What is the expected output? What do you see instead?
It should display some stock items. Showing error-SQLObjectNotFound: The
object InvStockItem by the ID 3960 does not exist

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

270, Ubuntu
Please provide any additional information below.
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 StockTransfersEditorStockItemSelect
  File
"/usr/lib/python2.4/site-packages/TurboGears-1.0b2-py2.4.egg/turbogears/controll
ers.py",
line 173, in validate
    return errorhandling.run_with_errors(errors, func, *args, **kw)
  File
"/usr/lib/python2.4/site-packages/TurboGears-1.0b2-py2.4.egg/turbogears/errorhan
dling.py",
line 106, in run_with_errors
    return func(self, *args, **kw)
  File "<string>", line 3, in StockTransfersEditorStockItemSelect
  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 "<string>", line 3, in StockTransfersEditorStockItemSelect
  File
"/usr/lib/python2.4/site-packages/TurboGears-1.0b2-py2.4.egg/turbogears/identity
/conditions.py",
line 235, in require
    return fn(self, *args, **kwargs)
  File "/home/me/svn/turbocare/turbocare/controllers_store.py", line 3067,
in StockTransfersEditorStockItemSelect
    results.append(dict(id=item.StockItemID, text='%d of %s' %
(item.Quantity, item.StockItem.Name),
linkurl="StockItemsEditor?StockItemID=%d" % item.StockItemID))
  File "<string>", line 1, in <lambda>
  File
"/usr/lib/python2.4/site-packages/SQLObject-0.7.2-py2.4.egg/sqlobject/main.py",
line 1179, in _SO_foreignKey
    return joinClass.get(id, connection=self._connection)
  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 InvStockItem by the ID 3960 does not exist
Request Headers:
  COOKIE: TurboCare=f7e783bd46b8f5448a6d7adc87513cedf115215c;
session_id=ae9fb92f12e310a1cf7f51d4c7de60829083ed1d
  Content-Length: 27
  ACCEPT-CHARSET: ISO-8859-1,utf-8;q=0.7,*;q=0.7
  USER-AGENT: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.8)
Gecko/20061025 Firefox/1.5.0.8
  CONNECTION: keep-alive
  PRAGMA: no-cache
  CONTENT-LENGTH: 27
  HOST: 192.168.1.203:8080
  CACHE-CONTROL: no-cache
  CONTENT-TYPE: application/x-www-form-urlencoded
  ACCEPT:
text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,
image/png,*/*;q=0.5
  Remote-Addr: 192.168.1.54
  ACCEPT-LANGUAGE: en-us,en;q=0.5
  Content-Type: application/x-www-form-urlencoded
  Remote-Host: 192.168.1.54
  ACCEPT-ENCODING: gzip,deflate
  KEEP-ALIVE: 300
192.168.1.54 - tushar "POST
/hospital_site_store/StockTransfersEditorStockItemSelect HTTP/1.1" 500 3894
"" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.8)
Gecko/20061025 Firefox/1.5.0.8"

Original issue reported on code.google.com by tushar.c...@gmail.com on 10 Jul 2007 at 10:38

[GoogleCodeExporter]

The problem seems to be that you have inventory stock at a location
(inv_stock_location) which are linked to the Stock header (inv_stock_item), but 
the
Stock header entry (that is, the record in inv_stock_item) is missing!!!

It seems that some stock items were deleted.

Currently, the program is now issuing debug statements indicating this error.  
The
program will run, as if there are no errors, but if you look at the log, you 
will see
which items are causing the error.

Original comment by umpen...@gmail.com on 10 Jul 2007 at 10:36

• Changed state: Fixed

[GoogleCodeExporter]

Revision 276 is committed.

Original comment by umpen...@gmail.com on 10 Jul 2007 at 10:37