Stripe Payment

Error when updating orders - Stripe Payment

Error when updating orders

by lecarlb » Wed Jun 30, 2021 9:15 am

I'm on version 1.0.8.4 and received this error when updating an order status:
Attachments
CE Phoenix Admin (2).png
lecarlb
VIP Member
VIP Member
Posts: 304
Joined: Mon Oct 26, 2020 5:26 pm
Contact:

Re: Error when updating orders

by raiwa » Wed Jun 30, 2021 9:43 am

Which PHP version?
Public Phoenix Change Log Cheat Set on Google Sheets
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Need Help?viewtopic.php?f=10&t=27
raiwa
PhoenixCart Developer
PhoenixCart Developer
Posts: 1184
Joined: Sat Dec 21, 2019 8:08 am
Contact:

Re: Error when updating orders

by lecarlb » Wed Jun 30, 2021 9:53 am

raiwa wrote:Which PHP version?
7.3.28 (Zend 3.3.28)
lecarlb
VIP Member
VIP Member
Posts: 304
Joined: Mon Oct 26, 2020 5:26 pm
Contact:

Re: Error when updating orders

by raiwa » Wed Jun 30, 2021 10:06 am

I'll have a look when I find time.

For now to get the page working, just remove the hook:
- includes/hooks/admin/siteWide/deleteStripeOrders.php

and delete the unconfirmed orders manually like before.
Public Phoenix Change Log Cheat Set on Google Sheets
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Need Help?viewtopic.php?f=10&t=27
raiwa
PhoenixCart Developer
PhoenixCart Developer
Posts: 1184
Joined: Sat Dec 21, 2019 8:08 am
Contact:

Re: Error when updating orders

by raiwa » Wed Jun 30, 2021 2:03 pm

Hi @lecarlb,

It works on my teststore error free.
However maybe your database is a different version and requires some additional code.
I changed all instances in the queries from " WHERE orders_id IN (%s)" to " WHERE orders_id IN ('%s')". (Added single quotes)

Please try this hook version:
includes.zip
(1.31 KiB) Downloaded 82 times
Public Phoenix Change Log Cheat Set on Google Sheets
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Need Help?viewtopic.php?f=10&t=27
raiwa
PhoenixCart Developer
PhoenixCart Developer
Posts: 1184
Joined: Sat Dec 21, 2019 8:08 am
Contact:

Re: Error when updating orders

by lecarlb » Fri Jul 02, 2021 6:07 am

Yes that worked. I believe there are some database issues. I have 2 websites set up on identical servers. One is an initial install at Phoenix version 1.0.7.18 and the other was updated from 1.0.7.6 to 1.0.8.4.
lecarlb
VIP Member
VIP Member
Posts: 304
Joined: Mon Oct 26, 2020 5:26 pm
Contact:

Re: Error when updating orders

by raiwa » Fri Jul 02, 2021 6:24 am

Thanks, I'll update it.
Public Phoenix Change Log Cheat Set on Google Sheets
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Need Help?viewtopic.php?f=10&t=27
raiwa
PhoenixCart Developer
PhoenixCart Developer
Posts: 1184
Joined: Sat Dec 21, 2019 8:08 am
Contact: