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.
yeah I tried, but I'm sure that has nothing to to with image sizes, because in the sourcecode it's doubled in the cart with different IDs and one time with size attributes and one time without
URL would be https://www.thesinisterflame.com/shop/
To reproduce: add product to cart, click on proceed to checkout and check the flyout cart on the next page
Hi there,
I just updated to TB 1.3 and still have this problem!
Is there any way somebody could check out what's up there? Does nobody else experience this problem?
Thanks!
Hi, this problem is still persistent.
When I tested now, again all products in the flyout cart on the checkout page were doubled.
Does anybody have insights on this?
For this I will have to register the whole site to Cloudflare aswell, all with DNS servers and such right (I did this already for other sites and could possibly try this)?
Yes, I changed it for accounting reasons and now can't change it back. But as I said it's also not possible for unchanged countries.
Maybe I could change it in the database?
Hi,
in a 1.2.0 store since we activated Geolocation it seems people from Greece can't order properly anymore in the shop (one customer reported it workes in Firefox, but in Chrome he got the message "You cannot place a new order from your country. GR"). So I supposed it has something to do with Greece's ISO Code in the shop being "EL" and not "GR" and the Maxmind database using the latter. When I tried to change it in the localisation settings in the shop it didn't work. I always get the message that the ISO code I entered is already in use and two countries can't have the same one. The odd thing is though that no other country has the same code. I also tried with a different country, changing the code to something not in use with the same result.
Is it a bug? Can you reproduce?
Would it be safe to just change the ISO code via database as a temporal workaorund?
Thanks for the help in advance!
Regards!