Topics

The error content displayed on the page is as follows:
There has been a critical error processing your request
Error: Table'./H100 /abc_online_customers' is marked as crashed and should be repaired
Error No: 145
DELETE FROM `abc_online_customers` WHERE `date_added`< (NOW()-INTERVAL 1 HOUR) in

In the same problem last week, I found the abc_online_customers form in Navicat and repaired it. At that time, the website was back to normal.

But the same error was reported today. What's more troublesome is that abc_online_customers is no longer found in Navicat. Where did it go? How to deal with it? Please help me, thanks!

Hello
My website was unable to log in to FTP this morning. After contacting the service provider to recover, the following error appeared on the website page.
Error: Table'./H1×0××7_×B/abc_online_customers' is marked as crashed and should be repaired
Error No: 145
DELETE FROM `abc_online_customers` WHERE `date_added`< (NOW()-INTERVAL 1 HOUR)

This seems to be a problem with the database? Please help me, thanks!

The system version is 1.2.12. Coupon has been set before and it can work normally.
Yesterday, a new coupon was set up, and customers reported that the discount code was invalid. After self-testing, this is indeed the case.
I tried to modify the Per Coupon, Total Amount, and login status, etc., and every test showed the same error.
I can't check the source of the problem now, help me! Thank you!

The version is upgraded from 1.2.6 to 1.2.12, jumping.
Everything else is debugged. However, the following error occurred when the test order was checked out. I tried a lot of ways. But it has not been resolved. can you help me?

2019-11-20 18:16:33 - database error: AbanteCart core v.1.2.12 Error: Unknown column 'sku' in 'field list'
Error No: 1054
INSERT INTO abc_order_products
SET order_id = '1663',
product_id = '272',
name = 'Dragon HDD Bay Hard Drive Cover Shell Replacement Faceplate for PS4 Console',
model = '',
sku = '',
price = '8.9',
total = '17.8',
tax = '0',
quantity = '2',
subtract = '1' in <b>/www/users/H10046687/core/database/mysql.php</b> on line <b>118</b>

For the site itself, I don't have any action, just create a new product, but I can't save it when I add a product category to "options".

I tried to modify the" options" section of the previous successful product, but I still can't save it.

Has anyone encountered this situation? How to solve it?

DOes the site iself have a database backup? What is the path?

How to avoid this happening again?