Square WebPay support thread.

[gernot]

My apologies, I mistakenly thought I should par the log down to the last part. Here the full entry:

[21-May-2023 15:29:33 Asia/Tokyo] Request URI: /shop/index.php?main_page=checkout_process, IP address: 192.168.1.3
#1  trigger_error() called at [/home/hase/Public/html/shop/includes/classes/db/mysql/query_factory.php:171]
#2  queryFactory->show_error() called at [/home/hase/Public/html/shop/includes/classes/db/mysql/query_factory.php:143]
#3  queryFactory->set_error() called at [/home/hase/Public/html/shop/includes/classes/db/mysql/query_factory.php:270]
#4  queryFactory->Execute() called at [/home/hase/Public/html/shop/includes/functions/functions_general.php:952]
#5  zen_db_perform() called at [/home/hase/Public/html/shop/includes/modules/payment/square_webPay.php:512]
#6  square_webPay->after_process() called at [/home/hase/Public/html/shop/includes/classes/payment.php:254]
#7  payment->after_process() called at [/home/hase/Public/html/shop/includes/modules/pages/checkout_process/header_php.php:17]
#8  require(/home/hase/Public/html/shop/includes/modules/pages/checkout_process/header_php.php) called at [/home/hase/Public/html/shop/index.php:36]
--> PHP Fatal error: 1364:Field 'transaction_id' doesn't have a default value :: INSERT INTO square_payments (order_id, location_id, payment_id, sq_order, created_at) VALUES ('171', 'Q5F86K1K1WMS9', '7BCuB7lE1Gz7rsvNayHoyV0hd9HZY', 'yeyuuReM6B3qnxe42yZCTrtBdQJZY', now()) ==> (as called by) /home/hase/Public/html/shop/includes/functions/functions_general.php on line 952 <== in /home/hase/Public/html/shop/includes/classes/db/mysql/query_factory.php on line 171.

[lat9]

Thanks, @gernot. It'll take me a while (as always), since I don't have any clients who use that payment method, to be able to review the payment method's handling and see why (in this case) the transaction_id was missing.

What version of Square WebPay are you using?

[gernot]

Hello @lat9,
Thank you very much. I am using v1.0.4 (the current latest). For the (non-Web) Square module I have v1.5 installed, but it is disabled.
I will try to see what I can do on my own, I'm just not sure if the "default transaction ID" is something that should be available and is not being picked up, or whether it is something that needs to be created from inside the plugin.

[carlwhat]

Hello @lat9,
Thank you very much. I am using v1.0.4 (the current latest). For the (non-Web) Square module I have v1.5 installed, but it is disabled.
I will try to see what I can do on my own, I'm just not sure if the "default transaction ID" is something that should be available and is not being picked up, or whether it is something that needs to be created from inside the plugin.

omg! there is documentation in the code! who knew:

        /**
         * Check and fix table structure if appropriate
         *
         * Note: The tender_id and transaction_id fields are no longer populated; but are left behind in older installs for lookup of history
         */ 

the error that you are no receiving is due to the version of mysql you are running. you need to alter the table to allow null for transaction_id. see here:

https://stackoverflow.com/questions/...-to-allow-null

you can go into phpmyadmin or use mysql via the command line and need to run a command like:

ALTER TABLE square_payments MODIFY transaction_id  null;

or something like that.

best.

[gernot]

Hello @carlwhat
Many thanks! I could change the table to accept Null as a valid value with

ALTER TABLE square_payments MODIFY transaction_id varchar(255);

since varchar(255) by default accepts NULL.

Hello @lat9
Thank you for the recommendation, I will test further and attempt to install this plugin for better debugging.

[lat9]

Hello @lat9,
Thank you very much. I am using v1.0.4 (the current latest). For the (non-Web) Square module I have v1.5 installed, but it is disabled.
I will try to see what I can do on my own, I'm just not sure if the "default transaction ID" is something that should be available and is not being picked up, or whether it is something that needs to be created from inside the plugin.

It would help to see if there are additional PHP Notices being logged at the time of the error. Since you're running zc156c, you can install Report All Errors (https://www.zen-cart.com/downloads.php?do=file&id=1792) and set the storefront setting to IgnoreDups.

P.S. Thanks, @carlwhat, your post came in while I was distracted in my response!