Square WebPay support thread.

[carlwhat]

I know this is a simple update, but are there update instructions available?

sorry no. i should have included something.

it’s a simple file replacement. but nothing in the sdk has changed.

you can copy all of the files without the need to copy the directory:

for_upload/includes/modules/payment/square_webPay

hope that helps!

[dbltoe]

Those of you who were already using Square prior to carlwhat's update to WebPay may want to check your ADMIN >> Customers >> Orders for orders made in late March or earlier that have square under the Payment/Shipping header versus square_webPay.

We (myzencarthostDOTcom) updated several of our customers while some did 1.0.0 and 1.0.1 on their own. Both groups have shown cases where the Payment/Shipping was not changed to square_webPay on orders made with the old square.

If you are using WebPay and the Payment/Shipping shows square, you will not be able to access the full details for the order. IOW, you will not see anything AFTER the payment method. A partial blank screen with no log created and no way to see comments on the order.

NOTE: Some sites with Edit Orders are able to access the data with that mod. Still, the fix needs to be made.

Somehow, the upgrades did not modify the orders table in the database for any existing square orders. Specifically, the payment_module_code field. Some sites had a DB prefix and others did not so, I don't think that's the problem.

There's a quick fix if you find this happening. Go to ADMIN >> Tools >> Install SQL Patcches (it shows up as SQL Query Executor on the page).

Please read the instructions on that page that are in RED.

Enter the following code.

UPDATE orders
SET payment_module_code = 'square_webPay'
WHERE payment_module_code = 'square';

Then click on send.

You'll be good to go

[brittainmark]

Those of you who were already using Square prior to carlwhat's update to WebPay may want to check your ADMIN >> Customers >> Orders for orders made in late March or earlier that have square under the Payment/Shipping header versus square_webPay.

We (myzencarthostDOTcom) updated several of our customers while some did 1.0.0 and 1.0.1 on their own. Both groups have shown cases where the Payment/Shipping was not changed to square_webPay on orders made with the old square.

If you are using WebPay and the Payment/Shipping shows square, you will not be able to access the full details for the order. IOW, you will not see anything AFTER the payment method. A partial blank screen with no log created and no way to see comments on the order.

NOTE: Some sites with Edit Orders are able to access the data with that mod. Still, the fix needs to be made.

Somehow, the upgrades did not modify the orders table in the database for any existing square orders. Specifically, the payment_module_code field. Some sites had a DB prefix and others did not so, I don't think that's the problem.

There's a quick fix if you find this happening. Go to ADMIN >> Tools >> Install SQL Patcches (it shows up as SQL Query Executor on the page).

Please read the instructions on that page that are in RED.

Enter the following code.

UPDATE orders
SET payment_module_code = 'square_webPay'
WHERE payment_module_code = 'square';

Then click on send.

You'll be good to go

Thanks for this. I did have a prefix, and they were not changed. I have run the code and all good now. Thanks again

[carlwhat]

this is a big that i noticed and documented with regards to the original square module. not square_webPay.

by running that sql statement you are not losing visibility into how that order was originally charged. if you are ok with that, great. but it is NOT how i would do it. nor is it what i would recommend doing.

i would look into changing the square code as opposed to changing all of one’s data.

do at your own peril.

“to err is human… but to really mess things up you need a computer…. and to mess things up royally you need sql…”

old shakesperean saying.

[mvstudio]

I'm experiencing the same happening, partial blank page after payment on order details page, but I'm getting this in the logs:

PHP Warning: require(/includes/modules/payment/square_support/square_admin_notification.php): failed to open stream: No such file or directory in /includes/modules/payment/square_webPay.php on line 505.

[31-May-2022 17:01:24 America/Detroit] PHP Fatal error: require(): Failed opening required '/includes/modules/payment/square_support/square_admin_notification.php' (include_path='.:/opt/cpanel/ea-php74/root/usr/share/pear') in /includes/modules/payment/square_webPay.php on line 505

I ran the update above (post #131) but error log continues (updated to webPay over the weekend).

Doing a search I found includes/modules/payment/square_webPay.php has this line of code in it require(DIR_FS_CATALOG . DIR_WS_MODULES . 'payment/square_support/square_admin_notification.php');

Checking the square_webPay folder doesn't contain anything remotely similar to this file in it. Should I modify the file by deleting the line/commenting it or is there another line that should replace it?

[carlwhat]

that file is part of the base v157 zc install. you should track that file down and upload it to your server.

do not modify the code.

best

[mvstudio]

that file is part of the base v157 zc install. you should track that file down and upload it to your server.

do not modify the code.

best

Thanks. Yeah, that file is on the deprecated Square plugin which according to the Square WebPay instructions should be removed. Makes no sense to have a plugin that won't work installed so another one could work, unless I'm missing something?

Perhaps an update to the Square WebPay is in order to include that or any other files needed for this new version to work

[wtfbbq]

Those of you who were already using Square prior to carlwhat's update to WebPay may want to check your ADMIN >> Customers >> Orders for orders made in late March or earlier that have square under the Payment/Shipping header versus square_webPay.

We (myzencarthostDOTcom) updated several of our customers while some did 1.0.0 and 1.0.1 on their own. Both groups have shown cases where the Payment/Shipping was not changed to square_webPay on orders made with the old square.

If you are using WebPay and the Payment/Shipping shows square, you will not be able to access the full details for the order. IOW, you will not see anything AFTER the payment method. A partial blank screen with no log created and no way to see comments on the order.

NOTE: Some sites with Edit Orders are able to access the data with that mod. Still, the fix needs to be made.

Somehow, the upgrades did not modify the orders table in the database for any existing square orders. Specifically, the payment_module_code field. Some sites had a DB prefix and others did not so, I don't think that's the problem.

There's a quick fix if you find this happening. Go to ADMIN >> Tools >> Install SQL Patcches (it shows up as SQL Query Executor on the page).

Please read the instructions on that page that are in RED.

Enter the following code.

UPDATE orders
SET payment_module_code = 'square_webPay'
WHERE payment_module_code = 'square';

Then click on send.

You'll be good to go

Is this still the method to fix the order details not showing up? Tried it and doesn't work.

[wtfbbq]

solved. had to login and set the credentials for oauth again for it to work.

[barco57]

So why does the token expire even when there have been multiple orders processed in the last week?