Error 500
(IntegrityError) insert or update on table "cartitem" violates foreign key constraint "fk_product"
DETAIL: Key (item_manufacturer,item_item_code)=(Vantec,LPC-501-BK) is not present in table "product".
Traceback (most recent call last):
File "/usr/lib/python2.5/site-packages/CherryPy-2.3.0-py2.5.egg/cherrypy/_cphttptools.py", line 121, in _run
self.main()
File "/usr/lib/python2.5/site-packages/CherryPy-2.3.0-py2.5.egg/cherrypy/_cphttptools.py", line 264, in main
body = page_handler(*virtual_path, **self.params)
File "<string>", line 3, in addToCart
File "/usr/lib/python2.5/site-packages/TurboGears-1.1b1-py2.5.egg/turbogears/controllers.py", line 345, in expose
*args, **kw)
File "<generated code>", line 0, in run_with_transaction
File "/usr/lib/python2.5/site-packages/PEAK_Rules-0.5a1.dev_r2582-py2.5.egg/peak/rules/core.py", line 153, in __call__
return self.body(*args, **kw)
File "/usr/lib/python2.5/site-packages/TurboGears-1.1b1-py2.5.egg/turbogears/database.py", line 435, in sa_rwt
session.commit()
File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.0rc4-py2.5.egg/sqlalchemy/orm/scoping.py", line 121, in do
return getattr(self.registry(), name)(*args, **kwargs)
File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.0rc4-py2.5.egg/sqlalchemy/orm/session.py", line 670, in commit
self.transaction.commit()
File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.0rc4-py2.5.egg/sqlalchemy/orm/session.py", line 379, in commit
t[1].commit()
File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.0rc4-py2.5.egg/sqlalchemy/engine/base.py", line 1009, in commit
self._do_commit()
File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.0rc4-py2.5.egg/sqlalchemy/engine/base.py", line 1033, in _do_commit
self.connection._commit_impl()
File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.0rc4-py2.5.egg/sqlalchemy/engine/base.py", line 732, in _commit_impl
self._handle_dbapi_exception(e, None, None, None)
File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.0rc4-py2.5.egg/sqlalchemy/engine/base.py", line 909, in _handle_dbapi_exception
raise exc.DBAPIError.instance(statement, parameters, e, connection_invalidated=is_disconnect)
IntegrityError: ('(IntegrityError) insert or update on table "cartitem" violates foreign key constraint "fk_product"\nDETAIL: Key (item_manufacturer,item_item_code)=(Vantec,LPC-501-BK) is not present in table "product".\n', <bound method Root.addToCart of <dollarshops.controllers.Root object at 0x8cf3ecc>>) None None