It looks like you may have added more to your install then you need. If you do not need to pull order information out to a seperate database, then there is no need for getpaid.report. I think if you remove that extra package things should work fine.
-Rob On Sat, Aug 1, 2009 at 8:48 AM, Katharine Chartrand < [email protected]> wrote: > > we installed getpaid, but i think we did something wrong. > > when we create a standard payment form and submit a test entry, plone > returns an error saying that that getpaid can't find the "order > table" [full error below]. > > 2009/08/01 10:42:07.200 GMT-5 > User Name (User Id) admin (admin) > Request URL > http://cint.newmexicoconsortium.org/registration-form/credit-card-payment/fg_base_view_p3 > Exception Type OperationalError > Exception Value (OperationalError) no such table: orders u'SELECT > orders.order_id AS orders_order_id, orders.order_zid AS > orders_order_zid, orders.billing_id AS orders_billing_id, > orders.ship_id AS orders_ship_id, orders.customer_id AS > orders_customer_id, orders.creation_date AS orders_creation_date, > orders.finance_status AS orders_finance_status, > orders.fulfillment_status AS orders_fulfillment_status \nFROM orders > \nWHERE orders.order_zid = ? \n LIMIT 1 OFFSET 0' ['72230492'] > > Traceback (innermost last): > > * Module ZPublisher.Publish, line 119, in publish > * Module ZPublisher.mapply, line 88, in mapply > * Module ZPublisher.Publish, line 42, in call_object > * Module Products.CMFFormController.FSControllerPageTemplate, line > 90, in __call__ > * Module Products.CMFFormController.BaseControllerPageTemplate, > line 26, in _call > * Module Products.CMFFormController.FormController, line 384, in > validate > * Module ZPublisher.mapply, line 88, in mapply > * Module ZPublisher.Publish, line 42, in call_object > * Module Products.CMFFormController.FSControllerValidator, line > 58, in __call__ > * Module Products.CMFFormController.Script, line 145, in __call__ > * Module Products.CMFCore.FSPythonScript, line 140, in __call__ > * Module Shared.DC.Scripts.Bindings, line 313, in __call__ > * Module Shared.DC.Scripts.Bindings, line 350, in _bindAndExec > * Module Products.CMFCore.FSPythonScript, line 196, in _exec > * Module None, line 20, in fgvalidate_base > <FSControllerValidator at /cint/fgvalidate_base used for /cint/ > registration-form/credit-card-payment> > Line 20 > * Module Products.PloneFormGen.content.form, line 592, in > fgvalidate > * Module Products.PloneFormGen.content.form, line 628, in > fgProcessActionAdapters > * Module getpaid.formgen.content.getpaidpfgadapter, line 403, in > onSuccess > * Module getpaid.formgen.content.getpaidpfgadapter, line 323, in > _one_page_checkout_success > * Module getpaid.formgen.content.checkout, line 94, in __call__ > * Module zope.event, line 23, in notify > * Module zope.component.event, line 26, in dispatch > * Module zope.component._api, line 130, in subscribers > * Module zope.component.registry, line 290, in subscribers > * Module zope.interface.adapter, line 535, in subscribers > * Module zope.component.event, line 33, in objectEventNotify > * Module zope.component._api, line 130, in subscribers > * Module zope.component.registry, line 290, in subscribers > * Module zope.interface.adapter, line 535, in subscribers > * Module getpaid.core.order, line 463, in > startOrderFulfillmentWorkflow > * Module hurry.workflow.workflow, line 238, in fireTransition > * Module zope.event, line 23, in notify > * Module zope.component.event, line 26, in dispatch > * Module zope.component._api, line 130, in subscribers > * Module zope.component.registry, line 290, in subscribers > * Module zope.interface.adapter, line 535, in subscribers > * Module zope.component.event, line 33, in objectEventNotify > * Module zope.component._api, line 130, in subscribers > * Module zope.component.registry, line 290, in subscribers > * Module zope.interface.adapter, line 535, in subscribers > * Module getpaid.report.subscriber, line 83, in > handleOrderTransition > * Module getpaid.report.subscriber, line 99, in _interact > * Module getpaid.report.subscriber, line 77, in _ > * Module sqlalchemy.orm.query, line 1231, in first > * Module sqlalchemy.orm.query, line 1152, in __getitem__ > * Module sqlalchemy.orm.query, line 1292, in __iter__ > * Module sqlalchemy.orm.query, line 1295, in > _execute_and_instances > * Module sqlalchemy.orm.session, line 754, in execute > * Module sqlalchemy.engine.base, line 824, in execute > * Module sqlalchemy.engine.base, line 874, in > _execute_clauseelement > * Module sqlalchemy.engine.base, line 896, in __execute_context > * Module sqlalchemy.engine.base, line 950, in _cursor_execute > * Module sqlalchemy.engine.base, line 931, in > _handle_dbapi_exception > > OperationalError: (OperationalError) no such table: orders u'SELECT > orders.order_id AS orders_order_id, orders.order_zid AS > orders_order_zid, orders.billing_id AS orders_billing_id, > orders.ship_id AS orders_ship_id, orders.customer_id AS > orders_customer_id, orders.creation_date AS orders_creation_date, > orders.finance_status AS orders_finance_status, > orders.fulfillment_status AS orders_fulfillment_status \nFROM orders > \nWHERE orders.order_zid = ? \n LIMIT 1 OFFSET 0' ['72230492'] > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "getpaid-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/getpaid-dev?hl=en -~----------~----~----~----~------~----~------~--~---
