tks. that did work.
On Aug 1, 3:01 pm, Rob LaRubbio <[email protected]> wrote:
> 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-pay...
> > 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
-~----------~----~----~----~------~----~------~--~---
