Can't access carts in backoffice - SQL timeout

[RabbitZzZ]

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
 

[nickz]

Are you on a shared server?

If yes check your mysql/mariadb/phpmyadmin versions

[RabbitZzZ]

Yes, it's a shared server. phpMyAdmin says the version 10.11.8-MariaDB-0ubuntu0.24.04.1-log - Ubuntu 24.04
Should be fine I guess?

[Yabber]

Clean up the tb_guest and tb_connections database tables (data in these tables is unnecessary). These tables store millions of records and on cheap shared hosting (with many different limits) the SQL query is not able to execute.

[RabbitZzZ]

Indeed that did the trick! Thanks a lot!

[DRMasterChief]

interesting, i have a look into the database and  tb_guest   has nothing in it ,  tb_connections has 1 line from years ago.  Is there anything changed in the core so there are no contents anymore?

[the.rampage.rado]

Nope, they should be filling gradually.