getpaid error
|
View:
New views
3 Messages
—
Rating Filter:
Alert me
|
 |
getpaid error
by Katharine Chartrand
::
Rate this Message:
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 getpaid-dev@... To unsubscribe from this group, send email to getpaid-dev+unsubscribe@... For more options, visit this group at http://groups.google.com/group/getpaid-dev?hl=en -~----------~----~----~----~------~----~------~--~--- |
|
|
Re: getpaid error
by Rob LaRubbio-2
::
Rate this Message:
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 <katharinechartrand@...> wrote:
--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "getpaid-dev" group. To post to this group, send email to getpaid-dev@... To unsubscribe from this group, send email to getpaid-dev+unsubscribe@... For more options, visit this group at http://groups.google.com/group/getpaid-dev?hl=en -~----------~----~----~----~------~----~------~--~--- |
|
|
Re: getpaid error
by Katharine Chartrand
::
Rate this Message:
tks. that did work. On Aug 1, 3:01 pm, Rob LaRubbio <larub...@...> 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 < > > katharinechartr...@...> 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 getpaid-dev@... To unsubscribe from this group, send email to getpaid-dev+unsubscribe@... For more options, visit this group at http://groups.google.com/group/getpaid-dev?hl=en -~----------~----~----~----~------~----~------~--~--- |
| Free embeddable forum powered by Nabble | Forum Help |
