Incorrect TIMESTAMP value in query

LiteCart Fan
De Bulgaria
Membro desde jan 2021

Hello, I moved to a new hosting, but when I try to log in to the admin panel, I get

Fatal error: 1525 - Incorrect TIMESTAMP value: '2023-1209 15:41:02'
SELECT `shipping_city`, `shipping_zone_code`, `shipping_country_code`, COUNT(`shipping_city`) AS `most_frequent`
FROM `popravime`.`lc_orders`
WHERE date_created > '2023-1209 15:41:02'
AND order_status_id in ( select id from lc_order_statuses where is_sale )
GROUP BY `shipping_city`
ORDER BY `most_frequent` DESC, `shipping_country_code` ASC, `shipping_zone_code` ASC, `shipping_city` ASC
LIMIT 11;
in ~/includes/library/lib_database.inc.php (Line 177)

I've tried everything, but I can't manage it.

tim
Founder
De Sweden
Membro desde mai 2013
tim

Do you have the full trace for this error? Seen in logs/errors.log
Indeed the timestamp value is not right.

LiteCart Fan
De Bulgaria
Membro desde jan 2021

Now:

[10-Dec-2024 09:33:16 Europe/Sofia] Fatal error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC, o.shipping_city
    ORDER BY num_orders DESC, o.shipping_country_code ASC, ' at line 8
SELECT o.shipping_city, o.shipping_zone_code, o.shipping_country_code, COUNT(o.id) AS num_orders, sum(o.payment_due) AS total_sales
FROM lc_orders o
WHERE o.date_created > '2023-12-10 09:33:16'
AND o.order_status_id in (
select id from lc_order_statuses
where is_sale
)
GROUP BY o.shipping_country_code, o.shipping_zone_code ASC, o.shipping_city
ORDER BY num_orders DESC, o.shipping_country_code ASC, o.shipping_zone_code ASC, o.shipping_city ASC
LIMIT 15;
 in ~/includes/library/lib_database.inc.php (Line 177)
 ← ~/admin/most_visited_products.widget/most_visited_products.inc.php (Line 31) in query()
 ← ~/admin/index.php (Line 87) in include()

I download the files and replace them in the folder but it still gives this error. I am using Apache2 and MySQL80

Sorry - Server version: 10.6.20-MariaDB - MariaDB Server

tim
Founder
De Sweden
Membro desde mai 2013
tim

It could be me not wrapping up the zip contents properly. Happens when I'm speeding. I uploaded it again.

Tu
This website uses no cookies and no third party tracking technology. We think we can do better than others and really think about your privacy.