Am on 1.5.8a, just had an order this morning that was duplicated in the system. Payment was paypal express.
The first order was logged, but only contains one of the 4 items the customer ordered, with incorrect totals, see below (condensed for readability):
15 x 3mm blue flickering flame LED $0.20 $3.00
Sub-Total: $12.00
Large letter flat box rate. $5.00
Total: $17.00
Now, that order, which was the first to be logged, is not only incomplete but also contains no paypal transaction data, yet it logged as payment ok in the shop.
Immediately after that order, the correct order was also logged, with everything correct.
Probably some sort of weird comms error between paypal and the shop, but odd that it was logged incomplete like that.
There are warning logs associated with that error, and also an error log, copied below (IP removed). The connection refused may have been my server spacing out temporarily, it's not a top level hosting package:
[31-Jan-2024 16:16:41 UTC] Request URI: /index.php?main_page=checkout_process, IP address: x.x.x.x, Language id 1
#1 trigger_error() called at [/includes/classes/db/mysql/query_factory.php:667]
#2 queryFactory->show_error() called at [/includes/classes/db/mysql/query_factory.php:634]
#3 queryFactory->set_error() called at [/includes/classes/db/mysql/query_factory.php:110]
#4 queryFactory->connect() called at [/includes/classes/db/mysql/query_factory.php:161]
#5 queryFactory->runQuery() called at [/includes/classes/db/mysql/query_factory.php:234]
#6 queryFactory->Execute() called at [/includes/classes/db/mysql/query_factory.php:302]
#7 queryFactory->ExecuteNoCache() called at [/includes/classes/order.php:1038]
#8 order->create_add_products() called at [/includes/modules/checkout_process.php:106]
#9 require(/includes/modules/checkout_process.php) called at [/includes/modules/pages/checkout_process/header_php.php:13]
#10 require(/includes/modules/pages/checkout_process/header_php.php) called at [/index.php:35]
--> PHP Fatal error: 2002:Connection refused :: SELECT * FROM 6d6_products WHERE products_id = 2566 LIMIT 1 ==> (as called by) /includes/classes/order.php on line 1038 <== in /includes/classes/db/mysql/query_factory.php on line 667.
So, anyway, maybe not really a bug, but possibly an error situation that needs to be captured?
Bookmarks