Hi, recently I can't access the carts page in the backoffice of a TB shop. It just loads and loads and eventually timeouts.
I suspected database problems and it seems I'm on the right track but I don't know what to do about it.
In the phpMyAdmin database status I can see the corresponding sql statement
SELECT COUNT(*) AS `tb_cart` FROM `tb_cart` a LEFT JOIN tb_customer c ON (c.id_customer = a.id_customer) LEFT JOIN tb_currency cu ON (cu.id_currency = a.id_currency) LEFT JOIN tb_carrier ca ON (ca.id_carrier = a.id_carrier) LEFT JOIN tb_orders o ON (o.id_cart = a.id_cart) LEFT JOIN `tb_connections` co ON (a.id_guest = co.id_guest AND TIME_TO_SEC(TIMEDIFF('2025-03-04 14:28:00', co.`date_add`)) < 1800) WHERE 1 LIMIT 1
with the status "Storing result in query cache" and the time going up without any change. If I put the request in the sql field directly, the same happens: infinite loading and timeout. No error message whatsoever.
Does anyone have an idea what to do about it?
TB. 1.2.0
PHP 7.4
Habt ihr auch das Problem, dass mit dem Modul in den Bestellungen die Transaktionsnummern nicht unter Zahlungsart angezeigt werden?
irgendwo scheint es diese nicht richtig zu übergeben, obwohl sie in der Datenbank in der tb_paypal_order Tabelle drin sind.
Hi,
I think I found a bug. If you have an order with VAT exemption and you do a partial refund the credit slip then calculates the prices as if there was taxes in them and also shows a line with tax amount. I tried this on 1.2 and 1.4 (community default theme)
To reproduce:
- have TB with VAT Exemption module installed and configured
- create a customer, address in different EU country with company name and valid VAT Number
- create order
- in bo make a partial refund for a product
- download credit slip and see the taxes on there
Is there any way to have a correct credit note?
Thank you!
Hallo,
das wird wohl nun relevanter, da Paypal die Gebühren anhebt, wenn man kein Paypal Checkout benutzt.
Gibt es eine Möglichkeit, das in ThirtyBees zu integrieren? Funktioniert eventuell das offizielle Prestashop Modul?
Hi,
does anyone know an easy way to keep the "Add to Cart" button always visible on product lists?
Mainly fo the mobile version it would be great not to have the hover function but have the button shown up all the time.
Is that possible with an CSS insert maybe?
I'm on TB 1.3.0 with community default theme.
Hi,
I'm using this old thread to report that something doesn't seem to work right anymore with the module.
In one shop taxes were deduced from customers that have random stuff in the VAT ID address field and then I saw those errors in the logs:
VAT number [xxxx] could not get validated due to a validation web service outage (Server error: `POST http://ec.europa.eu/taxation_customs/vies/services/checkVatService` resulted in a `500 Internal Server Error` response: Error 500--Internal Server Error
Maybe the module can be updated as described here: https://stackoverflow.com/questions/73443655/why-does-this-vat-number-validation-script-return-an-error
Cheers!
Thanks for the tip, but there is only one cart block module installed. So unfortunately that's also not it.
As mentioned, I suspect something in @datakick's Chex module, because if i deactivate it, the cart is ok.