Duplicated orders

  • Posts: 360
  • Thank you received: 19
  • Hikashop Business
1 day 18 hours ago #367171

-- HikaShop version -- : 5.1.6
-- Joomla version -- : 4
-- PHP version -- : 8.2

There is something seriously wrong with the orders.
There are duplicate orders and some do not even have an order number.
Credit card payments are not processed in these cases. There are no errors in the payment log for this period.
Only error I have
PHP Warning: Undefined array key "HTTP_USER_AGENT" in public_html/administrator/components/com_hikashop/classes/file.php on line 538

Attachments:
Last edit: 1 day 18 hours ago by mojweb.

Please Log in or Create an account to join the conversation.

  • Posts: 83824
  • Thank you received: 13571
  • MODERATOR
1 day 7 hours ago #367172

Hi,

Indeed, it looks like there is something really wrong.
This indicates that either:
- you must have made some kind of migration of the database, and the primary key on the order_id of the hikashop_order table has been removed, allowing orders to be created without an order_id or with the same order_id as an existing one. The "check database" button of the HikaShop configuration page will detect the problem and try to fix it if possible.
- you've changed the "order number format" setting of the HikaShop configuration page in a way which makes it non unique and potentially empty in some cases:
www.hikashop.com/support/documentation/5...nfig.html#main_order

Please Log in or Create an account to join the conversation.

  • Posts: 360
  • Thank you received: 19
  • Hikashop Business
1 day 2 hours ago #367182

The database has not changed for years. Primary key is there.
Database check shows no errors and everything is ok.
The order number format has never been changed.

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 83824
  • Thank you received: 13571
  • MODERATOR
1 day 22 minutes ago #367183

What did you configure in the "order number format" setting ?

Please Log in or Create an account to join the conversation.

  • Posts: 360
  • Thank you received: 19
  • Hikashop Business
23 hours 44 minutes ago #367187

Order number format

{id size="5"}{date format="y"}

Please Log in or Create an account to join the conversation.

  • Posts: 83824
  • Thank you received: 13571
  • MODERATOR
19 hours 52 minutes ago #367189

Hi,

For the duplicated orders, I think it's normal. It's probably the user going back and forth between your checkout and the payment gateway for one reason or another.
That's because each time the user clicks on "finish" at the end of the checkout, the order corresponding to the cart is created.
And if the user goes back to the checkout from the payment gateway (after clicking on the cancel button of the payment gateway), the user will see the checkout again with his cart, he can potentially change things, and then click on "finish" again. So we need to create a new order as things might have changed in the meantime.

For the order without a number, I can only think that the order number has been erased, either via PHPMyAdmin, or via a mass action after it was created with the order number properly set.

Please Log in or Create an account to join the conversation.

  • Posts: 360
  • Thank you received: 19
  • Hikashop Business
2 hours 28 minutes ago #367204

For four customers to do the same thing one after the other is a bit unusual or almost impossible.
In the case of credit cards, this would be theoretically possible. In the case of COD (on delivery), however, it is not, since the customer cannot return to the checkout after the purchase is complete.
Only I have access to the database and in this case I would know about the deletion. Massaction is not set up to do this either.

Please Log in or Create an account to join the conversation.

Time to create page: 0.057 seconds
Powered by Kunena Forum