|
Richard Teachout
|
August 12, 2014 at 12:35 am
I purged EE3/EE4 from my site, deleted tables, removed fields from options table, and did a fresh install – which worked just fine [I had to downgrade, as I need ticketing for Sept/Oct, and it’s not ready yet with EE4]..
I got my organization / events all setup, and enabled my authorize.net AIM (which looks setup right but isn’t processing due to error below I believe), and it errors out trying to complete an order.
I enabled WP_DEBUG and a debug plugin, and I get the following error:
SELECT ac.cost, ac.quantity, dc.coupon_code_price, dc.use_percentage FROM wp_events_attendee a JOIN EVENTS_ATTENDEE_COST_TABLE ac ON a.id=ac.attendee_id LEFT JOIN wp_events_discount_codes dc ON a.coupon_code=dc.coupon_code WHERE a.attendee_session='RANDOMSESSIONSTRINGHERE' ORDER BY a.id ASC
Table 'my_db.EVENTS_ATTENDEE_COST_TABLE' doesn't exist
I can’t seem to exactly see where this code is coming from or why it’s erroring (I’ve tried numerous grep’s), however, I think it’s in the gateways/process_payments.php or somewhere similar/related.. bit
EVENTS_ATTENDEE_COST_TABLE looks deprecated and unused, so it’s even more baffling.
I’m hoping you can help me track down why I am getting this error and help me get it fixed.
Thanks!
|
|
Dean
|
August 12, 2014 at 3:25 am
Hi Richard,
That code comes from here /wp-content/plugins/event-espresso/gateways/usaepay_onsite/DoDirectPayment.php whihc is the USA ePay (onsite) gateway.
Are you using that gateway? Is it active?
The only reason that I can think of is that somehow that file got edited. Do you have any modified gateways in your wp-content/uploads/espresso/gateways directory?
|
|
Richard Teachout
|
August 12, 2014 at 11:05 am
No, I wasn’t using epay – but DUH.. Newer EE3 version than I had before, and I didn’t redo the gateways folder..
LIFESAVER!
When I purged everything, I didn’t remove my old gateways… Purging and re-copying that folder solved it for me..
THANKS Dean for the fast response!
|
|
Tony
|
August 12, 2014 at 11:25 am
Hi Richard,
I’m glad this is working for you now.
However a quick question, the Gateways directory you mention, are you copying all of the EE gateways within wp-content/plugins/event-espresso/gateways/ to wp-content/uploads/espresso/gateways/?
If so unless you are editing the gateways there is no need to do this. The uploads/espresso/gateways/ directory is provided so you can place modified gateways there to keep them ‘update safe’, if you are not editing the gateways they will just default back to event-espresso/gateways/
|
