Re: Double payment records inside SO_PAYMENT when I use SQUARE_WEBPAY
i installed on zen version 210
i do i fix this
--> PHP Fatal error: MySQL error 1292: Incorrect datetime value: '' for column `c1JNSWOKIEE`.`so_payments`.`last_modified` at row 1 :: INSERT INTO so_payments (orders_id, payment_number, payment_name, payment_amount, payment_type, date_posted, last_modified) VALUES ('11390', '11390-XXXXXX0015', 'James Warren', '107.2268', 'MasterCard', '2025-03-02 19:07:04', '') ==> (as called by) /includes/functions/database.php on line 134 <== in /includes/classes/db/mysql/query_factory.php on line 733.
Re: Double payment records inside SO_PAYMENT when I use SQUARE_WEBPAY
Quote:
Originally Posted by
jimmie
i installed on zen version 210
i do i fix this
--> PHP Fatal error: MySQL error 1292: Incorrect datetime value: '' for column `c1JNSWOKIEE`.`so_payments`.`last_modified` at row 1 :: INSERT INTO so_payments (orders_id, payment_number, payment_name, payment_amount, payment_type, date_posted, last_modified) VALUES ('11390', '11390-XXXXXX0015', 'James Warren', '107.2268', 'MasterCard', '2025-03-02 19:07:04', '') ==> (as called by) /includes/functions/database.php on line 134 <== in /includes/classes/db/mysql/query_factory.php on line 733.
fixed
thanks to zenexpert
in includes/classes/super_order.php on line 735
from
$auto_payment['last_modified'] = $item['last_modified'];
to
$auto_payment['last_modified'] = 'now()';
working in zen 210
Re: Double payment records inside SO_PAYMENT when I use SQUARE_WEBPAY
Hi Jimmie,
It would be great if you would share your code to get this plugin working in 2.1.0.
Thanks!!!
Re: Super Orders v4.0 Support Thread (for ZC v1.5.x)
I was able to get Torvista's Batch Order Update to work with 2.1.0 if anyone is interested.
Re: Super Orders v4.0 Support Thread (for ZC v1.5.x)
VERSION 210 php 8.3 getting this error when deleting a payment
Code:
[17-Apr-2025 22:53:32 UTC] Request URI: /admin/index.php?cmd=super_payments&oID=11504&payment_mode=payment&index=175&action=delete, IP address: 35.139.226.29
--> PHP Fatal error: Uncaught TypeError: sizeof(): Argument #1 ($value) must be of type Countable|array, false given in /admin/super_payments.php:456
Stack trace:
#0 /admin/index.php(16): require()
#1 {main}
thrown in /admin/super_payments.php on line 456.
[17-Apr-2025 22:53:32 UTC] Request URI: /admin/index.php?cmd=super_payments&oID=11504&payment_mode=payment&index=175&action=delete, IP address: 35.139.226.29
--> PHP Fatal error: Uncaught TypeError: sizeof(): Argument #1 ($value) must be of type Countable|array, false given in /admin/super_payments.php:456
Stack trace:
#0 /admin/index.php(16): require()
#1 {main}
thrown in /admin/super_payments.php on line 456.
how would i fix this