Product not added to the cart

Hi,

That error message "Product not added to the cart" is quite rare.
It means that something cancelled the add to cart process without any error message and thus HikaShop displays a generic message.
In the HikaShop add to cart process, as far as I know, there is always an error message provided when it needs to cancel the add to cart process. The message is usually different based on what cancels it. If it's a limit for example, the message would be "Limit reached. You can't add more than XX items for the product YY." This normally allows us (and usually the merchant/customer) to know what caused the add to cart to fail.
Now, any plugin of the group hikashop or system can potentially cancel an add to cart for one reason or another, and if it doesn't provide an error message, then, HikaShop will display that generic message.
So I'm thinking it might be the case here. Do you have any custom plugin integrating with the add to cart process ? Or third party extensions integrating with HikaShop, like AWOCoupon ? I see you had HikaAuction and HikaMarket but your subscriptions expire. So if you still have them on the website, it would mean you have old versions of them and it might be related to that.
If you have a doubt on a plugin, try deactivating it and see if it helps. If it does, then you'll know it's linked to it.
If all of this bears no result, then we would need a FTP access to do some debugging to find out what is cancelling the add to cart process.

Hi,

It seems to be an issue with the database.
I've added some debug in administrator/components/com_hikashop/helpers/helper.php in the save function which handles adding and updating elements to the database.

I've made it so that it logs any insert MySQL query (for new elements, like a new cart), then, logs the result of the MySQL query, and finally logs the id resulting.
So the code is basically like this:

			hikashop_writeToLog($query);
			$this->database->setQuery($query);
			$status = $this->database->execute();
			hikashop_writeToLog($status);
...
			$id = $this->database->insertid();
			hikashop_writeToLog('last id:'.$id);

<h3>01.05.23 15:17:45</h3>
INSERT IGNORE INTO `#__hikashop_cart` ( `user_id`,`session_id`,`cart_currency_id`,`cart_params`,`cart_share`,`cart_type`,`cart_current`,`cart_modified` ) VALUES ( '0','d414eb9a9651a1b8955de04281319d85','4','{}','nobody','cart','1','1672931865' ) 
<h3>01.05.23 15:17:45</h3>
1
<h3>01.05.23 15:17:45</h3>
last id:0

Hi,

I don't see how the paypal plugin could automatically confirm the order without adding the transaction id to the history of the order.

You did provide a FTP access previously, but not a backend access. I would need a backend access to check the situation there first.
Could you provide that ?