vladislaw LiteCart Fan De Bulgaria Membro desde jan 2021 vladislaw 9 dez 2024 14:52 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 9 dez 2024 17:50 Do you have the full trace for this error? Seen in logs/errors.log Indeed the timestamp value is not right.
tim Founder De Sweden Membro desde mai 2013 tim 9 dez 2024 18:28 I managed to trace this being my update to the add-on Most Sold Products, Popular Countries, Cities that was missing a dash in the date. Grab the new update. https://www.litecart.net/en/addons/294/most-sold-viewed-products-and-most-popular-cities
vladislaw LiteCart Fan De Bulgaria Membro desde jan 2021 vladislaw 10 dez 2024 08:18 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 11 dez 2024 09:16 It could be me not wrapping up the zip contents properly. Happens when I'm speeding. I uploaded it again.